weishiuntsai commented on code in PR #17861: URL: https://github.com/apache/druid/pull/17861#discussion_r2059408677
########## quidem-ut/src/test/quidem/org.apache.druid.quidem.QTest/qaAggFuncs/array_agg_double_test001.all.iq: ########## @@ -0,0 +1,537 @@ +!set dartQueryId 00000000-0000-0000-0000-000000000000 +!set useApproximateCountDistinct false +!use druidtest://?componentSupplier=AllDruidEnginesComponentSupplier&datasets=sql/src/test/quidem/qatests/qaAggFuncs +!set outputformat mysql +SELECT count(*) cnt +FROM test_agg_funcs; ++-----+ +| cnt | ++-----+ +| 18 | ++-----+ +(1 row) + +!ok + +#------------------------------------------------------------------------- +# TESTCASE: test001 TEST_ID: A01 TYPE: POSITIVE TEST +#------------------------------------------------------------------------- +SELECT count(*) cnt +FROM + (SELECT array_agg(111.1111111) AS col) +WHERE NOT array_contains(col, 99999) + OR col IS NULL; ++-----+ +| cnt | ++-----+ +| 1 | ++-----+ +(1 row) + +!ok + +#------------------------------------------------------------------------- +# TESTCASE: test001 TEST_ID: A02 TYPE: POSITIVE TEST Review Comment: It just makes it easier to tell from the comment whether this is a positive or negative test. But if you don't like this style, I'll remove them. -- 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. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
