MonetDB: generator - Point selections for other types.

[Martin Kersten]

Changeset: e467802ef1f9 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e467802ef1f9
Modified Files:
        sql/backends/monet5/generator/Tests/generator00.sql
        sql/backends/monet5/generator/Tests/generator00.stable.out
Branch: generator
Log Message:

Point selections for other types.


diffs (53 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
@@ -2,6 +2,8 @@ select * from generate_series(0,10,2);
 
 select * from generate_series(0,10,2) where value <5;
 
+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;
@@ -10,6 +12,8 @@ select * from generate_series(10,0,-2);
 
 select * from generate_series(10,0,-2) where value <5;
 
+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
@@ -71,8 +71,13 @@ Ready.
 [ 0    ]
 [ 2    ]
 [ 4    ]
-#select * from generate_series(0,10,2) as v
-#where value <7 and value >3;
+#select * from generate_series(0,10,2) where value =4;
+% . # table_name
+% value # name
+% tinyint # type
+% 1 # length
+[ 4    ]
+#select * from generate_series(0,10,2) as v where value <7 and value >3;
 % .v # table_name
 % value # name
 % tinyint # type
@@ -105,6 +110,12 @@ Ready.
 % 1 # length
 [ 4    ]
 [ 2    ]
+#select * from generate_series(10,0,-2) where value = 6;
+% . # table_name
+% value # name
+% tinyint # type
+% 1 # length
+[ 6    ]
 #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