Changeset: 875857ac3502 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/875857ac3502
Modified Files:
sql/test/nested/Tests/array.test
Branch: nested
Log Message:
Addpts nested/array test for proper unnest() output
diffs (195 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,35 +21,39 @@ select * from (values (array[10, 11]), (
{10,11}
{20,21}
-query I nosort
+query I nosort unnest_elements
+select elements from (select array[10, 11] a), unnest(a)
+----
+10
+11
+
+query I nosort unnest_elements
select u.elements from (select array[10, 11] a) sq, unnest(sq.a) u
----
10
11
+query III nosort
+select u.* 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
@@ -57,22 +61,6 @@ select sq.* from (select array[10, 11] a
{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[])
@@ -88,26 +76,38 @@ select * from flent_arr
----
{10,11}
-query III nosort
-select u.* from flent_arr fa, unnest(fa.n) u
+query TI nosort table_unnest_all
+select * from flent_arr, unnest(flent_arr.n)
+----
+{10,11}
+10
+{10,11}
+11
+
+query I nosort
+select elements from flent_arr, unnest(flent_arr.n)
----
10
-1
-1
+11
+
+query I nosort
+select u.* from flent_arr, unnest(flent_arr.n) u
+----
+10
11
-1
-2
-query IIIT nosort
+query I nosort
+select u.elements from flent_arr, unnest(flent_arr.n) u
+----
+10
+11
+
+query IT nosort
select u.*, fa.* from flent_arr fa, unnest(fa.n) u
----
10
-1
-1
{10,11}
11
-1
-2
{10,11}
query TIII nosort unnest_all
@@ -115,12 +115,8 @@ select fa.*, u.* from flent_arr fa, unne
----
{10,11}
10
-1
-1
{10,11}
11
-1
-2
query T nosort
select fa.* from flent_arr fa, unnest(fa.n) u
@@ -128,30 +124,21 @@ select fa.* from flent_arr fa, unnest(fa
{10,11}
{10,11}
-query TIII nosort unnest_all
+query TI nosort unnest_all
select * from flent_arr fa, unnest(fa.n) u
----
{10,11}
10
-1
-1
{10,11}
11
-1
-2
--- no aliases
-query TIII nosort unnest_all
+query TI nosort unnest_all
select * from flent_arr, unnest(flent_arr.n)
----
{10,11}
10
-1
-1
{10,11}
11
-1
-2
statement ok
insert into flent_arr values (array[20, 21])
@@ -188,6 +175,23 @@ select * from flent_arr
{60}
{70,71}
+## ambiguous col elements (table vs unnest())
+
+statement ok
+create table amb (elements int[])
+
+statement ok
+insert into amb values (array[10, 11]), (array[20, 21])
+
+statement error SELECT: identifier 'elements' ambiguous
+select elements from amb, unnest(elements)
+
+query T nosort
+select elements from amb, unnest(elements) u
+----
+{10,11}
+{20,21}
+
## variable-length type array
statement ok
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
