Changeset: 16e83a891ec0 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/16e83a891ec0
Modified Files:
sql/test/nested/Tests/simple.test
Branch: nested
Log Message:
approved output
diffs (154 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
@@ -7,7 +7,7 @@ create table foo(p pair)
statement ok
insert into foo values (('left', 'right')), (('left', 'right'))
-query TT
+query TT nosort
select p.key, p.value from foo
----
left
@@ -15,7 +15,7 @@ right
left
right
-query I
+query I nosort
select count(*) from foo
----
2
@@ -26,7 +26,7 @@ create table bar(p pair[])
statement ok
insert into bar values (array[('left', 'right'), ('left', 'right')])
-query TT
+query TT nosort
select p.key, p.value from bar, unnest(p)
----
left
@@ -34,7 +34,7 @@ right
left
right
-query I
+query I nosort
select count(*) from bar, unnest(p)
----
2
@@ -45,7 +45,7 @@ create table tpv( i integer, p pair)
statement ok
insert into tpv values (1, ('left','right')), (2, ('left','right')), (3,
('l1', 'r1'))
-query ITT
+query ITT nosort
select i, p.key, p.value from tpv
----
1
@@ -64,64 +64,86 @@ create table tpsv( i integer, p pair[2])
statement ok
insert into tpsv values (1, array [ ('left','right'), ('l2','r2') ]), (2,
array [ ('left','right'), ('l2','r2') ]), (3, array [ ('l3', 'r3') ])
-
-query ITT
+query ITT nosort
select i, p.key, p.value from tpsv cross join unnest(p)
----
+1
+left
+right
+1
+left
+right
+2
+l2
+r2
+2
+l2
+r2
+3
+left
+right
-query ITT
+query ITT nosort
select i, up.key, up.value from tpsv cross join unnest(p) up where i = 1
----
+1
+left
+right
+1
+l2
+r2
-query ITT
+query ITT nosort
select i, up.key, up.value from tpsv cross join unnest(p) up where up.key =
'left'
----
+1
+left
+right
+2
+left
+right
-query II
+query II nosort
select i, count(*) from tpsv cross join unnest(p) up group by i
----
-
+1
+2
+2
+2
+3
+1
statement ok
insert into tpsv select i, p from tpsv
-
-query ITTII
+query IIIII nosort
select cast(json '[ { "pleft": "left", "pright": "right" }]' as pair[])
----
-
-query ITTII
+query IIIII nosort
select cast(json '[ { "pleft": "left", "pright": "right" }, { "pleft": "l1",
"pright": "r1" }]' as pair[])
----
-
statement ok
insert into tpsv select 1, cast(json '[ { "pleft": "left", "pright": "right"
}, { "pleft": "l1", "pright": "r1" }]' as pair[])
-
statement ok
create type npair as (ppair pair[], i integer)
-
statement ok
create table np (id integer, np npair[])
-
statement ok
insert into np values (1, array [ (array [ ('left','right'), ('l2','r2') ],
11), (array [], 12) ]), (2, array [ ( array [ ('l3', 'r3') ], 22) ])
-
statement ok
create type ipair AS (pleft varchar, pright integer)
-
-query TTIII
+query TTIII nosort
select cast(json '[ { "pleft": "left", "pright": "1" }]' as ipair[])
----
-
-query ITIII
+query ITIII nosort
select cast(json '[ { "pleft": "left", "pright": "1" }, { "pleft": "l1",
"pright": "2" }]' as ipair[])
----
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
