Changeset: 261ca4cae3e6 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=261ca4cae3e6 Added Files: sql/backends/monet5/generator/Tests/crash.Bug-3609.test sql/backends/monet5/generator/Tests/generator00.test sql/backends/monet5/generator/Tests/generator01.test sql/backends/monet5/generator/Tests/generator02.test sql/backends/monet5/generator/Tests/generator03.test sql/backends/monet5/generator/Tests/generator04.test sql/backends/monet5/generator/Tests/joins00.test sql/backends/monet5/generator/Tests/joins01.test sql/backends/monet5/generator/Tests/joins02.test sql/backends/monet5/generator/Tests/rangejoin.test sql/backends/monet5/generator/Tests/thetaselect00.test Branch: mtest Log Message:
Updated generator tests diffs (truncated from 955 to 300 lines): diff --git a/sql/backends/monet5/generator/Tests/crash.Bug-3609.test b/sql/backends/monet5/generator/Tests/crash.Bug-3609.test new file mode 100644 --- /dev/null +++ b/sql/backends/monet5/generator/Tests/crash.Bug-3609.test @@ -0,0 +1,4 @@ +statement error +select generate_series(0,2,1) + + diff --git a/sql/backends/monet5/generator/Tests/generator00.test b/sql/backends/monet5/generator/Tests/generator00.test new file mode 100644 --- /dev/null +++ b/sql/backends/monet5/generator/Tests/generator00.test @@ -0,0 +1,122 @@ +query I rowsort +select * from generate_series(0,10) +---- +10 values hashing to e20b902b49a98b1a05ed62804c757f94 + +query I rowsort +select * from generate_series(0,10,2) +---- +0 +2 +4 +6 +8 + +query I rowsort +select * from generate_series(0,10) where value <5 +---- +0 +1 +2 +3 +4 + +query I rowsort +select * from generate_series(0,10,2) where value <5 +---- +0 +2 +4 + +query I rowsort +select * from generate_series(0,10,2) where value =4 +---- +4 + +query I rowsort +select * from generate_series(0,10,2) where value <>4 +---- +0 +2 +6 +8 + +query I rowsort +select * from generate_series(0,10,2) as v where value <7 and value >3 +---- +4 +6 + +query I rowsort +select * from generate_series(0,10,2) as v where value <7 and value >3 and value <=6 and value >=4 +---- +4 +6 + +query I rowsort +select * from generate_series(10,0) +---- +10 values hashing to ff2650590d3f27ea6644b5573ccc37ba + +query I rowsort +select * from generate_series(10,0,-2) +---- +10 +2 +4 +6 +8 + +query I rowsort +select * from generate_series(10,0) where value <5 +---- +1 +2 +3 +4 + +query I rowsort +select * from generate_series(10,0,-2) where value <5 +---- +2 +4 + +query I rowsort +select * from generate_series(10,0,-2) where value = 6 +---- +6 + +query I rowsort +select * from generate_series(10,0,-2) where value <> 6 +---- +10 +2 +4 +8 + +query I rowsort +select * from generate_series(10,0,-2) as v where value <7 and value >3 +---- +4 +6 + +query I rowsort +select * from generate_series(10,0,-2) as v where value <7 and value >3 and value <=6 and value >=4 +---- +4 +6 + +query I rowsort +select * from generate_series(-2,8,2) +---- +-2 +0 +2 +4 +6 + +query I rowsort +select * from generate_series(0,0,2) +---- + + diff --git a/sql/backends/monet5/generator/Tests/generator01.test b/sql/backends/monet5/generator/Tests/generator01.test new file mode 100644 --- /dev/null +++ b/sql/backends/monet5/generator/Tests/generator01.test @@ -0,0 +1,83 @@ +statement error +select * from generate_series(0,10,-2) + +statement error +select * from generate_series(10,2,2) + +statement error +select * from generate_series(0,10,0) + +statement error +select * from generate_series(0,10,null) + +statement error +select * from generate_series(null,10,1) + +statement error +select * from generate_series(cast(null as tinyint),10,1) + +statement error +select * from generate_series(null,cast(10 as tinyint),cast(1 as tinyint)) + +statement error +select * from generate_series(cast(null as tinyint),cast(10 as tinyint),cast(1 as tinyint)) + +statement error +select * from generate_series(cast(null as smallint),10,1) + +statement error +select * from generate_series(null,cast(10 as smallint),cast(1 as smallint)) + +statement error +select * from generate_series(cast(null as smallint),cast(10 as smallint),cast(1 as smallint)) + +statement error +select * from generate_series(cast(null as integer),10,1) + +statement error +select * from generate_series(null,cast(10 as integer),cast(1 as integer)) + +statement error +select * from generate_series(cast(null as integer),cast(10 as integer),cast(1 as integer)) + +statement error +select * from generate_series(cast(null as bigint),10,1) + +statement error +select * from generate_series(null,cast(10 as bigint),cast(1 as bigint)) + +statement error +select * from generate_series(cast(null as bigint),cast(10 as bigint),cast(1 as bigint)) + +statement error +select * from generate_series(cast(null as tinyint),cast(10 as smallint),cast(1 as bigint)) + +statement error +select * from generate_series(cast(null as timestamp),10,1) + +statement error +select * from generate_series(null,cast(10 as timestamp),cast(1 as interval second)) + +statement error +select * from generate_series(cast(null as timestamp),cast(10 as timestamp),cast(1 as interval second)) + +statement error +select * from generate_series(10,null,1) + +statement error +select * from generate_series(null,10) + +statement error +select * from generate_series(10,null) + +statement error +select * from generate_series(null,-1) + +statement error +select * from generate_series(-1,null) + +statement error +select * from generate_series(0,10,-2) as v +where value <7 and value >3 + + diff --git a/sql/backends/monet5/generator/Tests/generator02.test b/sql/backends/monet5/generator/Tests/generator02.test new file mode 100644 --- /dev/null +++ b/sql/backends/monet5/generator/Tests/generator02.test @@ -0,0 +1,138 @@ +query R rowsort +select * from generate_series(0.0,10.0,1.6) +---- +0.000 +1.600 +3.200 +4.800 +6.400 +8.000 +9.600 + +query R rowsort +select * from generate_series(cast(0.0 as real),cast(10.0 as real),cast(1.6 as real)) +---- +0.000 +1.600 +3.200 +4.800 +6.400 +8.000 +9.600 + +query R rowsort +select * from generate_series(cast(0.0 as double),cast(10.0 as double),cast(1.6 as double)) +---- +0.000 +1.600 +3.200 +4.800 +6.400 +8.000 +9.600 + +query R rowsort +select * from generate_series(cast(0.0 as decimal(10,2)),cast(10.0 as decimal(10,2)),cast(1.6 as decimal(10,2))) +---- +0.000 +1.600 +3.200 +4.800 +6.400 +8.000 +9.600 + +query R rowsort +select * from generate_series(0.1,10.0,1.77) +where value <5.0 +---- +0.100 +1.870 +3.640 + +query R rowsort +select * from generate_series(cast(0.1 as real),cast(10.0 as real),cast(1.77 as real)) +where value <5.0 +---- +0.100 +1.870 +3.640 + +query R rowsort +select * from generate_series(cast(0.1 as double),cast(10.0 as double),cast(1.77 as double)) +where value <5.0 +---- +0.100 +1.870 +3.640 + +query R rowsort +select * from generate_series(cast(0.1 as decimal(10,2)),cast(10.0 as decimal(10,2)),cast(1.77 as decimal(10,2))) +where value <5.0 _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
