Test Result : SubquerySuite

0 failures (±0) , 1 skipped (±0)
71 tests (±0)
Took 1 min 20 sec.

All Tests

Test nameDurationStatus
Cannot remove sort for floating-point order-sensitive aggregates from subquery0.49 secPassed
Correlated subqueries in LATERAL VIEW0.4 secPassed
Correlated subqueries in outer joins79 msPassed
EXISTS predicate subquery0.66 secPassed
EXISTS predicate subquery within OR0.87 secPassed
IN predicate subquery1.4 secPassed
IN predicate subquery within OR0.92 secPassed
ListQuery and Exists should work even no correlated references0.68 secPassed
NOT EXISTS predicate subquery0.54 secPassed
NOT IN predicate subquery1.6 secPassed
SPARK-14791: scalar subquery inside broadcast join10 secPassed
SPARK-15370: COUNT bug in Aggregate1.5 secPassed
SPARK-15370: COUNT bug in HAVING clause (Filter)1 secPassed
SPARK-15370: COUNT bug in SELECT clause (Project)0.6 secPassed
SPARK-15370: COUNT bug in WHERE clause (Filter)1.9 secPassed
SPARK-15370: COUNT bug in subquery in subquery in subquery0.75 secPassed
SPARK-15370: COUNT bug negative examples2.4 secPassed
SPARK-15370: COUNT bug with attribute ref in subquery input and output0.68 secPassed
SPARK-15370: COUNT bug with nasty predicate expr0.72 secPassed
SPARK-15677: Queries against local relations with scalar subquery in Select list2.1 secPassed
SPARK-15791: rdd deserialization does not crash0.17 secPassed
SPARK-15832: Test embedded existential predicate sub-queries5.7 secPassed
SPARK-16804: Correlated subqueries containing LIMIT - 10.43 secPassed
SPARK-16804: Correlated subqueries containing LIMIT - 20.31 secPassed
SPARK-17337: Incorrect column resolution leads to incorrect results0.25 secPassed
SPARK-17348: Correlated subqueries with non-equality predicate (error case)0.15 secPassed
SPARK-17348: Correlated subqueries with non-equality predicate (good case)0.6 secPassed
SPARK-18504 extra GROUP BY column in correlated scalar subquery is not permitted0.14 secPassed
SPARK-18854 numberedTreeString for subquery15 msPassed
SPARK-19933 Do not eliminate top-level aliases in sub-queries0.44 secPassed
SPARK-20688: correctly check analysis for scalar sub-queries46 msPassed
SPARK-21835: Join in correlated subquery should be duplicateResolved: case 10.41 secPassed
SPARK-21835: Join in correlated subquery should be duplicateResolved: case 21.4 secPassed
SPARK-21835: Join in correlated subquery should be duplicateResolved: case 380 msPassed
SPARK-23316: AnalysisException after max iteration reached for IN query0.14 secPassed
SPARK-23957 Remove redundant sort from subquery plan(exists subquery)0.46 secPassed
SPARK-23957 Remove redundant sort from subquery plan(in subquery)0.63 secPassed
SPARK-23957 Remove redundant sort from subquery plan(scalar subquery)-1 msSkipped
SPARK-24085 scalar subquery in partitioning expression0.58 secPassed
SPARK-25482: Forbid pushdown to datasources of filters containing subqueries72 msPassed
SPARK-26078: deduplicate fake self joins for IN subqueries1.2 secPassed
SPARK-26893: Allow pushdown of partition pruning subquery filters to file source0.85 secPassed
SPARK-27279: Reuse Subquery0.25 secPassed
SPARK-28441: COUNT bug in Aggregate with PythonUDF1.8 secPassed
SPARK-28441: COUNT bug in HAVING clause (Filter) with PythonUDF1.5 secPassed
SPARK-28441: COUNT bug in SELECT clause (Project) with PythonUDF1 secPassed
SPARK-28441: COUNT bug in WHERE clause (Filter) with PythonUDF10 secPassed
SPARK-28441: COUNT bug in nested subquery with PythonUDF1.4 secPassed
SPARK-28441: COUNT bug in nested subquery with non-foldable expr0.74 secPassed
SPARK-28441: COUNT bug negative examples with PythonUDF2.8 secPassed
SPARK-28441: COUNT bug with attribute ref in subquery input and output with PythonUDF0.83 secPassed
SPARK-28441: COUNT bug with nasty predicate expr with PythonUDF1 secPassed
SPARK-28441: COUNT bug with non-foldable expression1.8 secPassed
SPARK-28441: COUNT bug with non-foldable expression in Filter condition1.1 secPassed
Scalar subquery name should start with scalar-subquery#80 msPassed
complex IN predicate subquery0.74 secPassed
correlated scalar subquery in aggregate1.4 secPassed
correlated scalar subquery in select0.62 secPassed
correlated scalar subquery in select (null safe)0.76 secPassed
correlated scalar subquery in where0.65 secPassed
define CTE in CTE subquery1 secPassed
disjunctive correlated scalar subquery0.76 secPassed
having with function in subquery1 secPassed
non-aggregated correlated scalar subquery46 msPassed
non-equal correlated scalar subquery30 msPassed
runtime error when the number of rows is greater than 10.11 secPassed
same column in subquery and outer table0.66 secPassed
simple uncorrelated scalar subquery0.97 secPassed
uncorrelated scalar subquery in CTE0.4 secPassed
uncorrelated scalar subquery on a DataFrame generated query1.6 secPassed
uncorrelated scalar subquery should return null if there is 0 rows0.17 secPassed