Changeset: 1eda68f65b69 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1eda68f65b69 Modified Files: sql/backends/monet5/generator/Tests/generator00.sql sql/backends/monet5/generator/Tests/generator00.stable.out Branch: Oct2014 Log Message:
Add a missing case test diffs (55 lines): diff --git a/sql/backends/monet5/generator/Tests/generator00.sql b/sql/backends/monet5/generator/Tests/generator00.sql --- a/sql/backends/monet5/generator/Tests/generator00.sql +++ b/sql/backends/monet5/generator/Tests/generator00.sql @@ -8,6 +8,8 @@ select * from generate_series(0,10,2) wh select * from generate_series(0,10,2) where value =4; +select * from generate_series(0,10,2) where value <>4; + select * from generate_series(0,10,2) as v where value <7 and value >3; select * from generate_series(0,10,2) as v where value <7 and value >3 and value <=6 and value >=4; @@ -22,6 +24,8 @@ select * from generate_series(10,0,-2) w select * from generate_series(10,0,-2) where value = 6; +select * from generate_series(10,0,-2) where value <> 6; + select * from generate_series(10,0,-2) as v where value <7 and value >3; select * from generate_series(10,0,-2) as v where value <7 and value >3 and value <=6 and value >=4; diff --git a/sql/backends/monet5/generator/Tests/generator00.stable.out b/sql/backends/monet5/generator/Tests/generator00.stable.out --- a/sql/backends/monet5/generator/Tests/generator00.stable.out +++ b/sql/backends/monet5/generator/Tests/generator00.stable.out @@ -101,6 +101,15 @@ Ready. % tinyint # type % 1 # length [ 4 ] +#select * from generate_series(0,10,2) where value <>4; +% . # table_name +% value # name +% tinyint # type +% 1 # length +[ 0 ] +[ 2 ] +[ 6 ] +[ 8 ] #select * from generate_series(0,10,2) as v where value <7 and value >3; % .v # table_name % value # name @@ -164,6 +173,14 @@ Ready. % tinyint # type % 1 # length [ 6 ] +#select * from generate_series(10,0,-2) where value <> 6; +% . # table_name +% value # name +% tinyint # type +% 1 # length +[ 8 ] +[ 4 ] +[ 2 ] #select * from generate_series(10,0,-2) as v where value <7 and value >3; % .v # table_name % value # name _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
