Changeset: 28a4f476f022 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/28a4f476f022
Modified Files:
sql/test/nested/Tests/simple.test
Branch: nested
Log Message:
more nested output testing
diffs (37 lines):
diff --git a/sql/test/nested/Tests/simple.test
b/sql/test/nested/Tests/simple.test
--- a/sql/test/nested/Tests/simple.test
+++ b/sql/test/nested/Tests/simple.test
@@ -69,6 +69,16 @@ 3
l1
r1
+query IT
+select * from tpv;
+----
+1
+("left", "right")
+2
+("left", "right")
+3
+("l1", "r1")
+
statement ok
create table tpsv( i integer, p pair[2])
@@ -94,6 +104,16 @@ 3
l3
r3
+query IT
+select * from tpsv
+----
+1
+{("left", "right"),("l2", "r2")}
+2
+{("left", "right"),("l2", "r2")}
+3
+{("l3", "r3")}
+
query ITT nosort
select i, up.key, up.value from tpsv cross join unnest(p) up where i = 1
----
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
