Test Result : SubquerySuite

0 failures (±0) , 1 skipped (±0)
72 tests (±0)
Took 39 sec.

All Tests

Test nameDurationStatus
Cannot remove sort for floating-point order-sensitive aggregates from subquery0.16 secPassed
Correlated subqueries in LATERAL VIEW0.19 secPassed
Correlated subqueries in outer joins65 msPassed
EXISTS predicate subquery0.4 secPassed
EXISTS predicate subquery within OR0.39 secPassed
IN predicate subquery0.48 secPassed
IN predicate subquery within OR0.26 secPassed
ListQuery and Exists should work even no correlated references0.57 secPassed
NOT EXISTS predicate subquery0.47 secPassed
NOT IN predicate subquery0.74 secPassed
SPARK-14791: scalar subquery inside broadcast join4 secPassed
SPARK-15370: COUNT bug in Aggregate0.71 secPassed
SPARK-15370: COUNT bug in HAVING clause (Filter)0.57 secPassed
SPARK-15370: COUNT bug in SELECT clause (Project)0.39 secPassed
SPARK-15370: COUNT bug in WHERE clause (Filter)1 secPassed
SPARK-15370: COUNT bug in subquery in subquery in subquery0.39 secPassed
SPARK-15370: COUNT bug negative examples0.97 secPassed
SPARK-15370: COUNT bug with attribute ref in subquery input and output0.38 secPassed
SPARK-15370: COUNT bug with nasty predicate expr0.35 secPassed
SPARK-15677: Queries against local relations with scalar subquery in Select list1.6 secPassed
SPARK-15791: rdd deserialization does not crash94 msPassed
SPARK-15832: Test embedded existential predicate sub-queries3.4 secPassed
SPARK-16804: Correlated subqueries containing LIMIT - 10.23 secPassed
SPARK-16804: Correlated subqueries containing LIMIT - 20.31 secPassed
SPARK-17337: Incorrect column resolution leads to incorrect results0.24 secPassed
SPARK-17348: Correlated subqueries with non-equality predicate (error case)0.25 secPassed
SPARK-17348: Correlated subqueries with non-equality predicate (good case)0.39 secPassed
SPARK-18504 extra GROUP BY column in correlated scalar subquery is not permitted42 msPassed
SPARK-18854 numberedTreeString for subquery12 msPassed
SPARK-19933 Do not eliminate top-level aliases in sub-queries0.36 secPassed
SPARK-20688: correctly check analysis for scalar sub-queries45 msPassed
SPARK-21835: Join in correlated subquery should be duplicateResolved: case 10.36 secPassed
SPARK-21835: Join in correlated subquery should be duplicateResolved: case 20.75 secPassed
SPARK-21835: Join in correlated subquery should be duplicateResolved: case 353 msPassed
SPARK-23316: AnalysisException after max iteration reached for IN query0.13 secPassed
SPARK-23957 Remove redundant sort from subquery plan(exists subquery)0.15 secPassed
SPARK-23957 Remove redundant sort from subquery plan(in subquery)0.3 secPassed
SPARK-23957 Remove redundant sort from subquery plan(scalar subquery)0 msSkipped
SPARK-24085 scalar subquery in partitioning expression0.43 secPassed
SPARK-25482: Forbid pushdown to datasources of filters containing subqueries25 msPassed
SPARK-26078: deduplicate fake self joins for IN subqueries1.1 secPassed
SPARK-26893: Allow pushdown of partition pruning subquery filters to file source1.1 secPassed
SPARK-27279: Reuse Subquery80 msPassed
SPARK-28441: COUNT bug in Aggregate with PythonUDF0.96 secPassed
SPARK-28441: COUNT bug in HAVING clause (Filter) with PythonUDF0.85 secPassed
SPARK-28441: COUNT bug in SELECT clause (Project) with PythonUDF0.56 secPassed
SPARK-28441: COUNT bug in WHERE clause (Filter) with PythonUDF2 secPassed
SPARK-28441: COUNT bug in nested subquery with PythonUDF0.65 secPassed
SPARK-28441: COUNT bug in nested subquery with non-foldable expr0.51 secPassed
SPARK-28441: COUNT bug negative examples with PythonUDF1.6 secPassed
SPARK-28441: COUNT bug with attribute ref in subquery input and output with PythonUDF0.48 secPassed
SPARK-28441: COUNT bug with nasty predicate expr with PythonUDF0.56 secPassed
SPARK-28441: COUNT bug with non-foldable expression1 secPassed
SPARK-28441: COUNT bug with non-foldable expression in Filter condition0.68 secPassed
SPARK-35080: correlated equality predicates contain only outer references0.31 secPassed
Scalar subquery name should start with scalar-subquery#24 msPassed
complex IN predicate subquery0.36 secPassed
correlated scalar subquery in aggregate0.45 secPassed
correlated scalar subquery in select0.26 secPassed
correlated scalar subquery in select (null safe)0.3 secPassed
correlated scalar subquery in where0.33 secPassed
define CTE in CTE subquery0.55 secPassed
disjunctive correlated scalar subquery0.34 secPassed
having with function in subquery0.4 secPassed
non-aggregated correlated scalar subquery18 msPassed
non-equal correlated scalar subquery9 msPassed
runtime error when the number of rows is greater than 142 msPassed
same column in subquery and outer table0.36 secPassed
simple uncorrelated scalar subquery0.57 secPassed
uncorrelated scalar subquery in CTE0.16 secPassed
uncorrelated scalar subquery on a DataFrame generated query0.84 secPassed
uncorrelated scalar subquery should return null if there is 0 rows0.14 secPassed