Changeset: 577923f15711 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=577923f15711 Modified Files: sql/backends/monet5/generator/Tests/generator01.stable.err Branch: resultset Log Message:
approved output diffs (106 lines): 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,48 +29,88 @@ 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-2974/.s.monetdb.36607 +MAPI = (monetdb) /var/tmp/mtest-11408/.s.monetdb.36300 QUERY = select * from generate_series(0,10,-2); ERROR = !Illegal generator range -MAPI = (monetdb) /var/tmp/mtest-2974/.s.monetdb.36607 +MAPI = (monetdb) /var/tmp/mtest-11408/.s.monetdb.36300 QUERY = select * from generate_series(10,2,2); ERROR = !Illegal generator range -MAPI = (monetdb) /var/tmp/mtest-2974/.s.monetdb.36607 +MAPI = (monetdb) /var/tmp/mtest-11408/.s.monetdb.36300 QUERY = select * from generate_series(0,10,0) ; ERROR = !zero step size not allowed -MAPI = (monetdb) /var/tmp/mtest-2974/.s.monetdb.36607 +MAPI = (monetdb) /var/tmp/mtest-11408/.s.monetdb.36300 QUERY = select * from generate_series(0,10,null) ; ERROR = !null step size not allowed -MAPI = (monetdb) /var/tmp/mtest-2974/.s.monetdb.36607 +MAPI = (monetdb) /var/tmp/mtest-11408/.s.monetdb.36300 +QUERY = select * from generate_series(null,10,1) ; +ERROR = !Illegal generator range +MAPI = (monetdb) /var/tmp/mtest-11408/.s.monetdb.36300 QUERY = select * from generate_series(cast(null as tinyint),10,1) ; ERROR = !Illegal generator range -MAPI = (monetdb) /var/tmp/mtest-2974/.s.monetdb.36607 +MAPI = (monetdb) /var/tmp/mtest-11408/.s.monetdb.36300 +QUERY = select * from generate_series(null,cast(10 as tinyint),cast(1 as tinyint)) ; +ERROR = !Illegal generator range +MAPI = (monetdb) /var/tmp/mtest-11408/.s.monetdb.36300 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-2974/.s.monetdb.36607 +MAPI = (monetdb) /var/tmp/mtest-11408/.s.monetdb.36300 QUERY = select * from generate_series(cast(null as smallint),10,1) ; ERROR = !Illegal generator range -MAPI = (monetdb) /var/tmp/mtest-2974/.s.monetdb.36607 +MAPI = (monetdb) /var/tmp/mtest-11408/.s.monetdb.36300 +QUERY = select * from generate_series(null,cast(10 as smallint),cast(1 as smallint)) ; +ERROR = !Illegal generator range +MAPI = (monetdb) /var/tmp/mtest-11408/.s.monetdb.36300 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-2974/.s.monetdb.36607 +MAPI = (monetdb) /var/tmp/mtest-11408/.s.monetdb.36300 QUERY = select * from generate_series(cast(null as integer),10,1) ; ERROR = !Illegal generator range -MAPI = (monetdb) /var/tmp/mtest-2974/.s.monetdb.36607 +MAPI = (monetdb) /var/tmp/mtest-11408/.s.monetdb.36300 +QUERY = select * from generate_series(null,cast(10 as integer),cast(1 as integer)) ; +ERROR = !Illegal generator range +MAPI = (monetdb) /var/tmp/mtest-11408/.s.monetdb.36300 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-2974/.s.monetdb.36607 +MAPI = (monetdb) /var/tmp/mtest-11408/.s.monetdb.36300 QUERY = select * from generate_series(cast(null as bigint),10,1) ; ERROR = !Illegal generator range -MAPI = (monetdb) /var/tmp/mtest-2974/.s.monetdb.36607 +MAPI = (monetdb) /var/tmp/mtest-11408/.s.monetdb.36300 +QUERY = select * from generate_series(null,cast(10 as bigint),cast(1 as bigint)) ; +ERROR = !Illegal generator range +MAPI = (monetdb) /var/tmp/mtest-11408/.s.monetdb.36300 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-2974/.s.monetdb.36607 +MAPI = (monetdb) /var/tmp/mtest-11408/.s.monetdb.36300 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-2974/.s.monetdb.36607 +MAPI = (monetdb) /var/tmp/mtest-11408/.s.monetdb.36300 +QUERY = select * from generate_series(cast(null as timestamp),10,1) ; +ERROR = !types tinyint(8,0) and timestamp(7,0) are not equal for column 'L2' +MAPI = (monetdb) /var/tmp/mtest-11408/.s.monetdb.36300 +QUERY = select * from generate_series(null,cast(10 as timestamp),cast(1 as interval second)) ; +ERROR = !types tinyint(8,0) and timestamp(7,0) are not equal +MAPI = (monetdb) /var/tmp/mtest-11408/.s.monetdb.36300 QUERY = select * from generate_series(cast(null as timestamp),cast(10 as timestamp),cast(1 as interval second)) ; ERROR = !types tinyint(8,0) and timestamp(7,0) are not equal +MAPI = (monetdb) /var/tmp/mtest-11408/.s.monetdb.36300 +QUERY = select * from generate_series(10,null,1) ; +ERROR = !Illegal generator range +MAPI = (monetdb) /var/tmp/mtest-11408/.s.monetdb.36300 +QUERY = select * from generate_series(null,10) ; +ERROR = !Illegal generator range +MAPI = (monetdb) /var/tmp/mtest-11408/.s.monetdb.36300 +QUERY = select * from generate_series(10,null) ; +ERROR = !Illegal generator range +MAPI = (monetdb) /var/tmp/mtest-11408/.s.monetdb.36300 +QUERY = select * from generate_series(null,-1) ; +ERROR = !Illegal generator range +MAPI = (monetdb) /var/tmp/mtest-11408/.s.monetdb.36300 +QUERY = select * from generate_series(-1,null) ; +ERROR = !Illegal generator range +MAPI = (monetdb) /var/tmp/mtest-11408/.s.monetdb.36300 +QUERY = select * from generate_series(0,10,-2) as v + where value <7 and value >3; +ERROR = !Illegal generator range # 12:42:21 > # 12:42:21 > "Done." _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list