Changeset: 1d68d6e8052a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1d68d6e8052a Modified Files: sql/test/SQLancer/Tests/sqlancer03.stable.out sql/test/SQLancer/Tests/sqlancer04.stable.err sql/test/SQLancer/Tests/sqlancer04.stable.out Branch: default Log Message:
Approved output diffs (66 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer03.stable.out b/sql/test/SQLancer/Tests/sqlancer03.stable.out --- a/sql/test/SQLancer/Tests/sqlancer03.stable.out +++ b/sql/test/SQLancer/Tests/sqlancer03.stable.out @@ -637,7 +637,7 @@ stdout of test 'sqlancer03` in directory #0.369 [ 8 ] #SELECT ALL CASE t0.c0 WHEN VAR_POP(ALL t0.c0) THEN (t0.c0) BETWEEN SYMMETRIC (t0.c0) AND (t0.c0) END FROM t0 GROUP BY t0.c0; -% sys.%2 # table_name +% .%2 # table_name % %2 # name % boolean # type % 5 # length diff --git a/sql/test/SQLancer/Tests/sqlancer04.stable.err b/sql/test/SQLancer/Tests/sqlancer04.stable.err --- a/sql/test/SQLancer/Tests/sqlancer04.stable.err +++ b/sql/test/SQLancer/Tests/sqlancer04.stable.err @@ -5,14 +5,22 @@ stderr of test 'sqlancer04` in directory # 09:44:50 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-36890" "--port=30177" # 09:44:50 > -MAPI = (monetdb) /var/tmp/mtest-297969/.s.monetdb.30789 +MAPI = (monetdb) /var/tmp/mtest-394778/.s.monetdb.37947 +QUERY = SELECT covar_samp(1, - (COALESCE(1, 2)||5)); --error on default, covar_samp between integer and string not possible +ERROR = !types sec_interval(0,0) and tinyint(8,0) are not equal +CODE = 42000 +MAPI = (monetdb) /var/tmp/mtest-394778/.s.monetdb.37947 QUERY = select case covar_samp(all - (coalesce (cast(-5 as int), coalesce (((cast(0.4 as int))-(coalesce (5, 5))), + (case -3 when 0.5 then 5 else 3 end)))), - (- (((coalesce (cast(0.2 as int), coalesce (5, 3, -747176383), ((6)%(3)), ((-2)<<(3))))||(-5))))) when case t0.c0 when case coalesce (coalesce (0.2, 0.3, 0.7), 0.5, cast(t0.c2 as decimal)) when cast(interval '-4' month as interval second) then cast(case 0.3 when t0.c1 then 0.6 when interval '-3' month then 0.3 end as interval second) end then coalesce (abs(0.6), -ERROR = !SELECT: cannot use non GROUP BY column 't0.c0' in query results without an aggregate function +ERROR = !types sec_interval(0,0) and tinyint(8,0) are not equal +CODE = 42000 +MAPI = (monetdb) /var/tmp/mtest-394778/.s.monetdb.37947 +QUERY = SELECT CASE '5'^3 WHEN COUNT(TRUE) THEN 1 END FROM t0 GROUP BY 2 IN ((CAST(INTERVAL '-2' SECOND AS INT))%2); --error on default: types sec_interval(13,0) and int(32,0) are not equal +ERROR = !types sec_interval(13,0) and int(32,0) are not equal CODE = 42000 # 09:44:50 > diff --git a/sql/test/SQLancer/Tests/sqlancer04.stable.out b/sql/test/SQLancer/Tests/sqlancer04.stable.out --- a/sql/test/SQLancer/Tests/sqlancer04.stable.out +++ b/sql/test/SQLancer/Tests/sqlancer04.stable.out @@ -29,22 +29,11 @@ stdout of test 'sqlancer04` in directory % double # type % 24 # length #ROLLBACK; -#SELECT covar_samp(1, - (COALESCE(1, 2)||5)); --error on default, covar_samp between integer and string not possible -% .%1 # table_name -% %1 # name -% double # type -% 24 # length -[ NULL ] #START TRANSACTION; #CREATE TABLE "sys"."t0"("c0" DATE, "c1" DATE, "c2" INTERVAL SECOND NOT NULL,"c3" TIME NOT NULL); #ROLLBACK; #START TRANSACTION; #CREATE TABLE "sys"."t0" ("c0" INTERVAL SECOND NOT NULL); -#SELECT CASE '5'^3 WHEN COUNT(TRUE) THEN 1 END FROM t0 GROUP BY 2 IN ((CAST(INTERVAL '-2' SECOND AS INT))%2); -% .%7 # table_name -% %7 # name -% tinyint # type -% 1 # length #ROLLBACK; # 09:44:50 > _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list