Changeset: eb6f2fab4d27 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=eb6f2fab4d27
Modified Files:
sql/backends/monet5/generator/Tests/generator01.sql
sql/backends/monet5/generator/Tests/generator01.stable.err
sql/backends/monet5/generator/Tests/generator03.sql
sql/backends/monet5/generator/Tests/generator03.stable.out
Branch: generator
Log Message:
Added a corner case test.
diffs (83 lines):
diff --git a/sql/backends/monet5/generator/Tests/generator01.sql
b/sql/backends/monet5/generator/Tests/generator01.sql
--- a/sql/backends/monet5/generator/Tests/generator01.sql
+++ b/sql/backends/monet5/generator/Tests/generator01.sql
@@ -5,6 +5,8 @@ select * from generate_series(10,2,2);
select * from generate_series(0,10,0) ;
select * from generate_series(0,10,null) ;
+select * from generate_series(null,10,1) ;
+select * from generate_series(10,null,1) ;
select * from generate_series(0,10,-2) as v
where value <7 and value >3;
diff --git a/sql/backends/monet5/generator/Tests/generator01.stable.err
b/sql/backends/monet5/generator/Tests/generator01.stable.err
--- a/sql/backends/monet5/generator/Tests/generator01.stable.err
+++ b/sql/backends/monet5/generator/Tests/generator01.stable.err
@@ -29,19 +29,25 @@ stderr of test 'generator01` in director
# 12:42:21 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-23485" "--port=37579"
# 12:42:21 >
-MAPI = (monetdb) /var/tmp/mtest-13429/.s.monetdb.33058
+MAPI = (monetdb) /var/tmp/mtest-20683/.s.monetdb.37951
QUERY = select * from generate_series(0,10,-2);
ERROR = !Illegal generator range
-MAPI = (monetdb) /var/tmp/mtest-13429/.s.monetdb.33058
+MAPI = (monetdb) /var/tmp/mtest-20683/.s.monetdb.37951
QUERY = select * from generate_series(10,2,2);
ERROR = !Illegal generator range
-MAPI = (monetdb) /var/tmp/mtest-13429/.s.monetdb.33058
+MAPI = (monetdb) /var/tmp/mtest-20683/.s.monetdb.37951
QUERY = select * from generate_series(0,10,0) ;
ERROR = !zero step size not allowed
-MAPI = (monetdb) /var/tmp/mtest-13429/.s.monetdb.33058
+MAPI = (monetdb) /var/tmp/mtest-20683/.s.monetdb.37951
QUERY = select * from generate_series(0,10,null) ;
ERROR = !null step size not allowed
-MAPI = (monetdb) /var/tmp/mtest-13429/.s.monetdb.33058
+MAPI = (monetdb) /var/tmp/mtest-20683/.s.monetdb.37951
+QUERY = select * from generate_series(null,10,1) ;
+ERROR = !types tinyint(8,0) and timestamp(7,0) are not equal for column 'L2'
+MAPI = (monetdb) /var/tmp/mtest-20683/.s.monetdb.37951
+QUERY = select * from generate_series(10,null,1) ;
+ERROR = !Illegal generator range
+MAPI = (monetdb) /var/tmp/mtest-20683/.s.monetdb.37951
QUERY = select * from generate_series(0,10,-2) as v
where value <7 and value >3;
ERROR = !Illegal generator range
diff --git a/sql/backends/monet5/generator/Tests/generator03.sql
b/sql/backends/monet5/generator/Tests/generator03.sql
--- a/sql/backends/monet5/generator/Tests/generator03.sql
+++ b/sql/backends/monet5/generator/Tests/generator03.sql
@@ -23,6 +23,12 @@ select * from generate_series(
where value < timestamp '2008-03-03 00:00';
select * from generate_series(
+ timestamp '2008-03-04 12:00',
+ timestamp '2008-03-01 00:00',
+ cast( '-10' as interval hour))
+where value < timestamp '2008-03-02 00:00';
+
+select * from generate_series(
timestamp '2008-03-01 00:00',
timestamp '2008-03-04 12:00',
cast( '10' as interval hour))
diff --git a/sql/backends/monet5/generator/Tests/generator03.stable.out
b/sql/backends/monet5/generator/Tests/generator03.stable.out
--- a/sql/backends/monet5/generator/Tests/generator03.stable.out
+++ b/sql/backends/monet5/generator/Tests/generator03.stable.out
@@ -89,6 +89,17 @@ Ready.
[ 2008-03-02 06:00:00.000000 ]
[ 2008-03-02 16:00:00.000000 ]
#select * from generate_series(
+# timestamp '2008-03-04 12:00',
+# timestamp '2008-03-01 00:00',
+# cast( '-10' as interval hour))
+#where value < timestamp '2008-03-02 00:00';
+% . # table_name
+% value # name
+% timestamp # type
+% 26 # length
+[ 2008-03-02 00:00:00.000000 ]
+[ 2008-03-01 14:00:00.000000 ]
+#select * from generate_series(
# timestamp '2008-03-01 00:00',
# timestamp '2008-03-04 12:00',
# cast( '10' as interval hour))
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
