mihaibudiu commented on code in PR #5024: URL: https://github.com/apache/calcite/pull/5024#discussion_r3438184283
########## core/src/test/resources/sql/unnest.iq: ########## @@ -337,6 +337,276 @@ from unnest(array[(1, 'a'), (2, 'b'), (3, 'c')], array[10, 20]) as t(x, y, z); !ok +# [CALCITE-7583] UNNEST with multiple array arguments returns wrong result +# Three arrays of different lengths with ordinality: output has max(3,2,4)=4 rows. +select * +from unnest(array[10, 20, 30], array[1, 2], array['a', 'b', 'c', 'd']) +with ordinality as t(x, y, z, o); ++----+---+---+---+ +| X | Y | Z | O | ++----+---+---+---+ +| 10 | 1 | a | 1 | +| 20 | 2 | b | 2 | +| 30 | | c | 3 | +| | | d | 4 | ++----+---+---+---+ +(4 rows) + +!ok + +# Unnest a plain scalar array; default column name is EXPR$0. Review Comment: All subsequent tests were moved from JdbcTest -- 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]
