wangyum commented on a change in pull request #25891: [SPARK-29203][SQL][TESTS] Reduce shuffle partitions in SQLQueryTestSuite URL: https://github.com/apache/spark/pull/25891#discussion_r326925253
########## File path: sql/core/src/test/resources/sql-tests/results/subquery/in-subquery/in-joins.sql.out ########## @@ -106,8 +106,8 @@ ORDER BY t1a DESC, t3b DESC -- !query 4 schema struct<count(DISTINCT t1a):bigint,t1b:smallint,t3a:string,t3b:smallint,t3c:int> -- !query 4 output -1 10 val3b 8 NULL 1 10 val1b 8 16 +1 10 val3b 8 NULL Review comment: Yes. ``` [info] - subquery/in-subquery/in-joins.sql *** FAILED *** (15 seconds, 359 milliseconds) [info] subquery/in-subquery/in-joins.sql [info] Expected "1 10 val[3b 8 NULL [info] 1 10 val1b 8 16] [info] 1 10 val3a 6 12 [info] 1 8...", but got "1 10 val[1b 8 16 [info] 1 10 val3b 8 NULL] [info] 1 10 val3a 6 12 [info] 1 8..." Result did not match for query #4 [info] SELECT Count(DISTINCT(t1a)), [info] t1b, [info] t3a, [info] t3b, [info] t3c [info] FROM t1 natural left JOIN t3 [info] WHERE t1a IN [info] ( [info] SELECT t2a [info] FROM t2 [info] WHERE t1d = t2d) [info] AND t1b > t3b [info] GROUP BY t1a, [info] t1b, [info] t3a, [info] t3b, [info] t3c [info] ORDER BY t1a DESC, t3b DESC (SQLQueryTestSuite.scala:383) [info] org.scalatest.exceptions.TestFailedException: ``` ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
