Changeset: 10d53d65d110 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/10d53d65d110 Modified Files: sql/test/Tests/limit_offset_fetchfirst.test Branch: default Log Message:
don't assume row order diffs (156 lines): diff --git a/sql/test/Tests/limit_offset_fetchfirst.test b/sql/test/Tests/limit_offset_fetchfirst.test --- a/sql/test/Tests/limit_offset_fetchfirst.test +++ b/sql/test/Tests/limit_offset_fetchfirst.test @@ -7,7 +7,7 @@ statement ok create table limittest as select * from "sys"."generate_series"(1, 221) query I nosort -select * from limittest LIMIT 5 +select * from limittest ORDER BY value LIMIT 5 ---- 1 2 @@ -33,8 +33,8 @@ select * from limittest LIMIT OFFSET 20, statement error select * from limittest OFFSET 20 LIMIT 50 -query I rowsort -select * from limittest LIMIT 5 OFFSET 20 +query I nosort +select * from limittest ORDER BY value LIMIT 5 OFFSET 20 ---- 21 22 @@ -57,19 +57,19 @@ select * from limittest OFFSET statement error select * from limittest OFFSET ROW -query I rowsort -select * from limittest OFFSET 218 +query I nosort +select * from limittest ORDER BY value OFFSET 218 ---- 219 220 -query I rowsort -select * from limittest OFFSET 219 ROW +query I nosort +select * from limittest ORDER BY value OFFSET 219 ROW ---- 220 -query I rowsort -select * from limittest OFFSET 218 ROWS +query I nosort +select * from limittest ORDER BY value OFFSET 218 ROWS ---- 219 220 @@ -86,66 +86,66 @@ select * from limittest FETCH ROWS ONLY statement error select * from limittest FETCH 0 ROWS ONLY -query I rowsort -select * from limittest FETCH NEXT ROW ONLY +query I nosort +select * from limittest ORDER BY value FETCH NEXT ROW ONLY ---- 1 -query I rowsort -select * from limittest FETCH FIRST 4 ROWS ONLY +query I nosort +select * from limittest ORDER BY value FETCH FIRST 4 ROWS ONLY ---- 1 2 3 4 -query I rowsort -select * from limittest OFFSET 5 FETCH FIRST 4 ROWS ONLY +query I nosort +select * from limittest ORDER BY value OFFSET 5 FETCH FIRST 4 ROWS ONLY ---- 6 7 8 9 -query I rowsort -select * from limittest OFFSET 5 FETCH NEXT 4 ROWS ONLY +query I nosort +select * from limittest ORDER BY value OFFSET 5 FETCH NEXT 4 ROWS ONLY ---- 6 7 8 9 -query I rowsort -select * from limittest FETCH FIRST ROW ONLY +query I nosort +select * from limittest ORDER BY value FETCH FIRST ROW ONLY ---- 1 -query I rowsort -select * from limittest FETCH FIRST 3 ROWS ONLY +query I nosort +select * from limittest ORDER BY value FETCH FIRST 3 ROWS ONLY ---- 1 2 3 -query I rowsort -select * from limittest OFFSET 10 FETCH FIRST 3 ROWS ONLY +query I nosort +select * from limittest ORDER BY value OFFSET 10 FETCH FIRST 3 ROWS ONLY ---- 11 12 13 -query I rowsort -select * from limittest OFFSET 218 +query I nosort +select * from limittest ORDER BY value OFFSET 218 ---- 219 220 -query I rowsort -select * from limittest OFFSET 220 +query I nosort +select * from limittest ORDER BY value OFFSET 220 ---- -query I rowsort -select * from limittest OFFSET 222 +query I nosort +select * from limittest ORDER BY value OFFSET 222 ---- @@ -161,15 +161,15 @@ select * from limittest FETCH NEXT 4 ROW statement error select * from limittest FETCH NEXT 4 ROWS ONLY OFFSET 5 -query I rowsort -select * from limittest FETCH FIRST 3 ROWS ONLY +query I nosort +select * from limittest ORDER BY value FETCH FIRST 3 ROWS ONLY ---- 1 2 3 -query I rowsort -select * from (select * from limittest OFFSET 50 ROWS FETCH FIRST 10 ROWS ONLY) t OFFSET 5 ROW FETCH FIRST 4 ROWS ONLY +query I nosort +select * from (select * from limittest ORDER BY value OFFSET 50 ROWS FETCH FIRST 10 ROWS ONLY) t ORDER BY value OFFSET 5 ROW FETCH FIRST 4 ROWS ONLY ---- 56 57 _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
