Test Result : SubquerySuite

0 failures , 1 skipped
73 tests
Took 31 sec.

All Tests

Test nameDurationStatus
Cannot remove sort for floating-point order-sensitive aggregates from subquery0.14 secPassed
Correlated subqueries in LATERAL VIEW0.18 secPassed
Correlated subqueries in outer joins52 msPassed
EXISTS predicate subquery0.22 secPassed
EXISTS predicate subquery within OR0.21 secPassed
IN predicate subquery0.27 secPassed
IN predicate subquery within OR0.27 secPassed
ListQuery and Exists should work even no correlated references0.34 secPassed
NOT EXISTS predicate subquery0.2 secPassed
NOT IN predicate subquery0.37 secPassed
SPARK-14791: scalar subquery inside broadcast join1.9 secPassed
SPARK-15370: COUNT bug in Aggregate0.37 secPassed
SPARK-15370: COUNT bug in HAVING clause (Filter)0.37 secPassed
SPARK-15370: COUNT bug in SELECT clause (Project)0.17 secPassed
SPARK-15370: COUNT bug in WHERE clause (Filter)0.57 secPassed
SPARK-15370: COUNT bug in subquery in subquery in subquery0.22 secPassed
SPARK-15370: COUNT bug negative examples0.55 secPassed
SPARK-15370: COUNT bug with attribute ref in subquery input and output0.18 secPassed
SPARK-15370: COUNT bug with nasty predicate expr0.23 secPassed
SPARK-15677: Queries against local relations with scalar subquery in Select list0.59 secPassed
SPARK-15791: rdd deserialization does not crash58 msPassed
SPARK-15832: Test embedded existential predicate sub-queries1.9 secPassed
SPARK-16804: Correlated subqueries containing LIMIT - 10.15 secPassed
SPARK-16804: Correlated subqueries containing LIMIT - 20.1 secPassed
SPARK-17337: Incorrect column resolution leads to incorrect results0.12 secPassed
SPARK-17348: Correlated subqueries with non-equality predicate (error case)96 msPassed
SPARK-17348: Correlated subqueries with non-equality predicate (good case)0.25 secPassed
SPARK-18504 extra GROUP BY column in correlated scalar subquery is not permitted23 msPassed
SPARK-18854 numberedTreeString for subquery11 msPassed
SPARK-19933 Do not eliminate top-level aliases in sub-queries0.21 secPassed
SPARK-20688: correctly check analysis for scalar sub-queries36 msPassed
SPARK-21835: Join in correlated subquery should be duplicateResolved: case 10.17 secPassed
SPARK-21835: Join in correlated subquery should be duplicateResolved: case 20.5 secPassed
SPARK-21835: Join in correlated subquery should be duplicateResolved: case 318 msPassed
SPARK-23316: AnalysisException after max iteration reached for IN query0.1 secPassed
SPARK-23957 Remove redundant sort from subquery plan(exists subquery)0.14 secPassed
SPARK-23957 Remove redundant sort from subquery plan(in subquery)0.23 secPassed
SPARK-23957 Remove redundant sort from subquery plan(scalar subquery)0 msSkipped
SPARK-24085 scalar subquery in partitioning expression0.33 secPassed
SPARK-25482: Forbid pushdown to datasources of filters containing subqueries27 msPassed
SPARK-26078: deduplicate fake self joins for IN subqueries0.59 secPassed
SPARK-26893: Allow pushdown of partition pruning subquery filters to file source0.45 secPassed
SPARK-27279: Reuse Subquery50 msPassed
SPARK-28441: COUNT bug in Aggregate with PythonUDF0.65 secPassed
SPARK-28441: COUNT bug in HAVING clause (Filter) with PythonUDF0.64 secPassed
SPARK-28441: COUNT bug in SELECT clause (Project) with PythonUDF0.45 secPassed
SPARK-28441: COUNT bug in WHERE clause (Filter) with PythonUDF2.7 secPassed
SPARK-28441: COUNT bug in nested subquery with PythonUDF0.62 secPassed
SPARK-28441: COUNT bug in nested subquery with non-foldable expr0.23 secPassed
SPARK-28441: COUNT bug negative examples with PythonUDF1.4 secPassed
SPARK-28441: COUNT bug with attribute ref in subquery input and output with PythonUDF0.39 secPassed
SPARK-28441: COUNT bug with nasty predicate expr with PythonUDF0.51 secPassed
SPARK-28441: COUNT bug with non-foldable expression0.62 secPassed
SPARK-28441: COUNT bug with non-foldable expression in Filter condition0.39 secPassed
SPARK-32290: SingleColumn Null Aware Anti Join Optimize6.4 secPassed
SPARK-34269: correlated subquery with view in aggregate's grouping expression0.37 secPassed
Scalar subquery name should start with scalar-subquery#19 msPassed
complex IN predicate subquery0.19 secPassed
correlated scalar subquery in aggregate0.25 secPassed
correlated scalar subquery in select0.2 secPassed
correlated scalar subquery in select (null safe)0.24 secPassed
correlated scalar subquery in where0.22 secPassed
define CTE in CTE subquery0.32 secPassed
disjunctive correlated scalar subquery0.23 secPassed
having with function in subquery0.17 secPassed
non-aggregated correlated scalar subquery18 msPassed
non-equal correlated scalar subquery10 msPassed
runtime error when the number of rows is greater than 166 msPassed
same column in subquery and outer table0.2 secPassed
simple uncorrelated scalar subquery0.23 secPassed
uncorrelated scalar subquery in CTE0.1 secPassed
uncorrelated scalar subquery on a DataFrame generated query0.49 secPassed
uncorrelated scalar subquery should return null if there is 0 rows48 msPassed