Changeset: 731db54b62e6 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/731db54b62e6
Modified Files:
sql/test/nested/Tests/array.test
Branch: nested
Log Message:
Adds tests for literal array unnest
diffs (62 lines):
diff --git a/sql/test/nested/Tests/array.test b/sql/test/nested/Tests/array.test
--- a/sql/test/nested/Tests/array.test
+++ b/sql/test/nested/Tests/array.test
@@ -21,6 +21,58 @@ select * from (values (array[10, 11]), (
{10,11}
{20,21}
+query I nosort
+select u.elements from (select array[10, 11] a) sq, unnest(sq.a) u
+----
+10
+11
+
+query TIII nosort unnest_all
+select * from (select array[10, 11] a) sq, unnest(sq.a) u
+----
+{10,11}
+10
+1
+1
+{10,11}
+11
+1
+2
+
+query TIII nosort unnest_all
+select sq.*, u.* from (select array[10, 11] a) sq, unnest(sq.a) u
+----
+{10,11}
+10
+1
+1
+{10,11}
+11
+1
+2
+
+query T nosort
+select sq.* from (select array[10, 11] a) sq, unnest(sq.a) u
+----
+{10,11}
+{10,11}
+
+query III nosort
+select u.* from (select array[10, 11] a) sq, unnest(sq.a) u
+----
+10
+1
+1
+11
+1
+2
+
+query I nosort
+select u.elements from (select array[10, 11] a) sq, unnest(sq.a) u
+----
+10
+11
+
statement ok
create table flent_arr (n int[])
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
