Changeset: 67b1438c07ed for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=67b1438c07ed Modified Files: sql/backends/monet5/generator/Tests/generator01.sql sql/backends/monet5/generator/Tests/generator01.stable.err Branch: default Log Message:
generator01: corrected (expected) error message and extended test to show that the wrong error message is due to a SQL function / type matching problem with NULL !?? diffs (86 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 @@ -6,6 +6,22 @@ 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(cast(null as tinyint),10,1) ; +select * from generate_series(null,cast(10 as tinyint),cast(1 as tinyint)) ; +select * from generate_series(cast(null as tinyint),cast(10 as tinyint),cast(1 as tinyint)) ; +select * from generate_series(cast(null as smallint),10,1) ; +select * from generate_series(null,cast(10 as smallint),cast(1 as smallint)) ; +select * from generate_series(cast(null as smallint),cast(10 as smallint),cast(1 as smallint)) ; +select * from generate_series(cast(null as integer),10,1) ; +select * from generate_series(null,cast(10 as integer),cast(1 as integer)) ; +select * from generate_series(cast(null as integer),cast(10 as integer),cast(1 as integer)) ; +select * from generate_series(cast(null as bigint),10,1) ; +select * from generate_series(null,cast(10 as bigint),cast(1 as bigint)) ; +select * from generate_series(cast(null as bigint),cast(10 as bigint),cast(1 as bigint)) ; +select * from generate_series(cast(null as tinyint),cast(10 as smallint),cast(1 as bigint)) ; +select * from generate_series(cast(null as timestamp),10,1) ; +select * from generate_series(null,cast(10 as timestamp),cast(1 as interval second)) ; +select * from generate_series(cast(null as timestamp),cast(10 as timestamp),cast(1 as interval second)) ; select * from generate_series(10,null,1) ; select * from generate_series(null,10) ; 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 @@ -43,7 +43,55 @@ QUERY = select * from generate_series(0, ERROR = !null step size not allowed MAPI = (monetdb) /var/tmp/mtest-23026/.s.monetdb.39679 QUERY = select * from generate_series(null,10,1) ; -ERROR = !types tinyint(8,0) and timestamp(7,0) are not equal for column 'L2' +ERROR = !Illegal generator range +MAPI = (monetdb) /var/tmp/mtest-23026/.s.monetdb.39679 +QUERY = select * from generate_series(cast(null as tinyint),10,1) ; +ERROR = !Illegal generator range +MAPI = (monetdb) /var/tmp/mtest-23026/.s.monetdb.39679 +QUERY = select * from generate_series(null,cast(10 as tinyint),cast(1 as tinyint)) ; +ERROR = !Illegal generator range +MAPI = (monetdb) /var/tmp/mtest-23026/.s.monetdb.39679 +QUERY = select * from generate_series(cast(null as tinyint),cast(10 as tinyint),cast(1 as tinyint)) ; +ERROR = !Illegal generator range +MAPI = (monetdb) /var/tmp/mtest-23026/.s.monetdb.39679 +QUERY = select * from generate_series(cast(null as smallint),10,1) ; +ERROR = !Illegal generator range +MAPI = (monetdb) /var/tmp/mtest-23026/.s.monetdb.39679 +QUERY = select * from generate_series(null,cast(10 as smallint),cast(1 as smallint)) ; +ERROR = !Illegal generator range +MAPI = (monetdb) /var/tmp/mtest-23026/.s.monetdb.39679 +QUERY = select * from generate_series(cast(null as smallint),cast(10 as smallint),cast(1 as smallint)) ; +ERROR = !Illegal generator range +MAPI = (monetdb) /var/tmp/mtest-23026/.s.monetdb.39679 +QUERY = select * from generate_series(cast(null as integer),10,1) ; +ERROR = !Illegal generator range +MAPI = (monetdb) /var/tmp/mtest-23026/.s.monetdb.39679 +QUERY = select * from generate_series(null,cast(10 as integer),cast(1 as integer)) ; +ERROR = !Illegal generator range +MAPI = (monetdb) /var/tmp/mtest-23026/.s.monetdb.39679 +QUERY = select * from generate_series(cast(null as integer),cast(10 as integer),cast(1 as integer)) ; +ERROR = !Illegal generator range +MAPI = (monetdb) /var/tmp/mtest-23026/.s.monetdb.39679 +QUERY = select * from generate_series(cast(null as bigint),10,1) ; +ERROR = !Illegal generator range +MAPI = (monetdb) /var/tmp/mtest-23026/.s.monetdb.39679 +QUERY = select * from generate_series(null,cast(10 as bigint),cast(1 as bigint)) ; +ERROR = !Illegal generator range +MAPI = (monetdb) /var/tmp/mtest-23026/.s.monetdb.39679 +QUERY = select * from generate_series(cast(null as bigint),cast(10 as bigint),cast(1 as bigint)) ; +ERROR = !Illegal generator range +MAPI = (monetdb) /var/tmp/mtest-23026/.s.monetdb.39679 +QUERY = select * from generate_series(cast(null as tinyint),cast(10 as smallint),cast(1 as bigint)) ; +ERROR = !Illegal generator range +MAPI = (monetdb) /var/tmp/mtest-23026/.s.monetdb.39679 +QUERY = select * from generate_series(cast(null as timestamp),10,1) ; +ERROR = !Illegal generator range +MAPI = (monetdb) /var/tmp/mtest-23026/.s.monetdb.39679 +QUERY = select * from generate_series(null,cast(10 as timestamp),cast(1 as interval second)) ; +ERROR = !Illegal generator range +MAPI = (monetdb) /var/tmp/mtest-23026/.s.monetdb.39679 +QUERY = select * from generate_series(cast(null as timestamp),cast(10 as timestamp),cast(1 as interval second)) ; +ERROR = !Illegal generator range MAPI = (monetdb) /var/tmp/mtest-23026/.s.monetdb.39679 QUERY = select * from generate_series(10,null,1) ; ERROR = !Illegal generator range _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
