Test Result : SubquerySuite

0 failures (±0) , 1 skipped (+1)
71 tests (+16)
Took 1 min 13 sec.

All Tests

Test nameDurationStatus
Cannot remove sort for floating-point order-sensitive aggregates from subquery0.57 secPassed
Correlated subqueries in LATERAL VIEW0.46 secPassed
Correlated subqueries in outer joins0.12 secPassed
EXISTS predicate subquery0.63 secPassed
EXISTS predicate subquery within OR0.55 secPassed
IN predicate subquery0.83 secPassed
IN predicate subquery within OR0.32 secPassed
ListQuery and Exists should work even no correlated references0.88 secPassed
NOT EXISTS predicate subquery0.55 secPassed
NOT IN predicate subquery1 secPassed
SPARK-14791: scalar subquery inside broadcast join8.2 secPassed
SPARK-15370: COUNT bug in Aggregate1.3 secPassed
SPARK-15370: COUNT bug in HAVING clause (Filter)1.2 secPassed
SPARK-15370: COUNT bug in SELECT clause (Project)0.57 secPassed
SPARK-15370: COUNT bug in WHERE clause (Filter)1.8 secPassed
SPARK-15370: COUNT bug in subquery in subquery in subquery0.61 secPassed
SPARK-15370: COUNT bug negative examples1.6 secPassed
SPARK-15370: COUNT bug with attribute ref in subquery input and output0.56 secPassed
SPARK-15370: COUNT bug with nasty predicate expr0.54 secPassed
SPARK-15677: Queries against local relations with scalar subquery in Select list1.6 secPassed
SPARK-15791: rdd deserialization does not crash0.11 secPassed
SPARK-15832: Test embedded existential predicate sub-queries6.3 secPassed
SPARK-16804: Correlated subqueries containing LIMIT - 10.57 secPassed
SPARK-16804: Correlated subqueries containing LIMIT - 20.38 secPassed
SPARK-17337: Incorrect column resolution leads to incorrect results0.43 secPassed
SPARK-17348: Correlated subqueries with non-equality predicate (error case)0.13 secPassed
SPARK-17348: Correlated subqueries with non-equality predicate (good case)0.64 secPassed
SPARK-18504 extra GROUP BY column in correlated scalar subquery is not permitted40 msPassed
SPARK-18854 numberedTreeString for subquery13 msPassed
SPARK-19933 Do not eliminate top-level aliases in sub-queries0.55 secPassed
SPARK-20688: correctly check analysis for scalar sub-queries61 msPassed
SPARK-21835: Join in correlated subquery should be duplicateResolved: case 10.32 secPassed
SPARK-21835: Join in correlated subquery should be duplicateResolved: case 20.92 secPassed
SPARK-21835: Join in correlated subquery should be duplicateResolved: case 390 msPassed
SPARK-23316: AnalysisException after max iteration reached for IN query0.28 secPassed
SPARK-23957 Remove redundant sort from subquery plan(exists subquery)0.54 secPassed
SPARK-23957 Remove redundant sort from subquery plan(in subquery)0.65 secPassed
SPARK-23957 Remove redundant sort from subquery plan(scalar subquery)-1 msSkipped
SPARK-24085 scalar subquery in partitioning expression0.67 secPassed
SPARK-25482: Forbid pushdown to datasources of filters containing subqueries0.17 secPassed
SPARK-26078: deduplicate fake self joins for IN subqueries1.6 secPassed
SPARK-26893: Allow pushdown of partition pruning subquery filters to file source1.9 secPassed
SPARK-27279: Reuse Subquery0.44 secPassed
SPARK-28441: COUNT bug in Aggregate with PythonUDF3.7 secPassed
SPARK-28441: COUNT bug in HAVING clause (Filter) with PythonUDF1.6 secPassed
SPARK-28441: COUNT bug in SELECT clause (Project) with PythonUDF0.95 secPassed
SPARK-28441: COUNT bug in WHERE clause (Filter) with PythonUDF4.9 secPassed
SPARK-28441: COUNT bug in nested subquery with PythonUDF1.1 secPassed
SPARK-28441: COUNT bug in nested subquery with non-foldable expr0.7 secPassed
SPARK-28441: COUNT bug negative examples with PythonUDF3.7 secPassed
SPARK-28441: COUNT bug with attribute ref in subquery input and output with PythonUDF0.92 secPassed
SPARK-28441: COUNT bug with nasty predicate expr with PythonUDF1.1 secPassed
SPARK-28441: COUNT bug with non-foldable expression1.8 secPassed
SPARK-28441: COUNT bug with non-foldable expression in Filter condition0.97 secPassed
Scalar subquery name should start with scalar-subquery#0.21 secPassed
complex IN predicate subquery0.54 secPassed
correlated scalar subquery in aggregate0.84 secPassed
correlated scalar subquery in select0.66 secPassed
correlated scalar subquery in select (null safe)0.74 secPassed
correlated scalar subquery in where1.8 secPassed
define CTE in CTE subquery0.82 secPassed
disjunctive correlated scalar subquery0.71 secPassed
having with function in subquery0.61 secPassed
non-aggregated correlated scalar subquery18 msPassed
non-equal correlated scalar subquery11 msPassed
runtime error when the number of rows is greater than 10.12 secPassed
same column in subquery and outer table0.45 secPassed
simple uncorrelated scalar subquery0.76 secPassed
uncorrelated scalar subquery in CTE0.28 secPassed
uncorrelated scalar subquery on a DataFrame generated query1.9 secPassed
uncorrelated scalar subquery should return null if there is 0 rows0.11 secPassed