AMashenkov commented on code in PR #3559: URL: https://github.com/apache/ignite-3/pull/3559#discussion_r1554048350
########## modules/sql-engine/src/integrationTest/sql/union/basic_union.test: ########## @@ -0,0 +1,80 @@ +# description: Basic union tests + +statement ok +CREATE TABLE a(i INTEGER); + +statement ok +INSERT INTO a(i) VALUES (100), (NULL); + +query I +SELECT 123 UNION DISTINCT SELECT 123 UNION ALL SELECT 123; +---- +123 +123 + +query I +SELECT 123 UNION ALL SELECT 123 UNION ALL SELECT 123; +---- +123 +123 +123 + +query I +SELECT x FROM table(system_range(123, 123)) UNION DISTINCT SELECT x FROM table(system_range(123, 123)) UNION ALL SELECT 123; +---- +123 +123 + +query I +SELECT x FROM table(system_range(123, 123)) UNION ALL SELECT x FROM table(system_range(123, 123)) UNION ALL SELECT 123; +---- +123 +123 +123 + +query I +SELECT NULL UNION DISTINCT SELECT NULL +---- +NULL + +query I +SELECT NULL UNION ALL SELECT NULL +---- +NULL +NULL + +query I +SELECT 'a' UNION DISTINCT SELECT NULL +---- +a +NULL + +query II +SELECT NULL, NULL UNION DISTINCT SELECT NULL, NULL FROM a +---- +NULL NULL + +query II +SELECT NULL, NULL UNION ALL SELECT NULL, NULL FROM a +---- +NULL NULL +NULL NULL +NULL NULL + +query II rowsort +SELECT 1, 2 UNION DISTINCT SELECT i, i FROM a +---- +NULL NULL +100 100 +1 2 + +query II rowsort +SELECT 1, 2 UNION ALL SELECT i, i FROM a +---- +NULL NULL +100 100 +1 2 + + + + Review Comment: ```suggestion ``` -- 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]
