Test sqlancer04.sql (id 9fb2b731c9eb) (out)
sqlancer04.stable.err.FILTERED 2020-08-01 00:01:59.259454500 +0200sqlancer04.test.err.FILTERED 2020-08-01 00:01:59.275084800 +0200
1 Statistics about stderr of test 'sqlancer04` in directory 'sql/test/SQLancer`: 1 1 Statistics about stderr of test 'sqlancer04` in directory 'sql/test/SQLancer`: 1
2 21 lines, 318 words, 1979 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 41 lines, 542 words, 3387 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 21 lines, 318 words, 1979 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 41 lines, 542 words, 3387 chars in lines not matching '^$|^(\| |)#` 3
4 # 37 lines, 371 words, 2446 chars in all lines 4 ! 4 # 62 lines, 610 words, 3887 chars in all lines 4
5 5 5 5
..................
# 37 lines, 371 words,
8 8 8 8
9 # 09:44:50 > 9 ! 9 # 00:01:59 > 9
10 # 09:44:50 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-36890" "--port=30177" 10 ! 10 # 00:01:59 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=WIN2K12R2" "--port=34681" 10
11 # 09:44:50 > 11 ! 11 # 00:01:59 > 11
12 12 ! 12 12
13 #~ MAPI = (monetdb) /var/tmp/mtest-297969/.s.monetdb.30789 13 ! 13 #~ MAPI = monetdb@WIN2K12R2:34681 13
+ 14 QUERY = SELECT covar_samp(1, - (COALESCE(1, 2)||5)); --error on default, covar_samp between integer and string not possible 14
+ 15 ERROR = !types sec_interval(0,0) and tinyint(8,0) are not equal 15
+ 16 CODE = 42000 16
+ 17 #~ MAPI = monetdb@WIN2K12R2:34681 17
14 QUERY = select case covar_samp(all - (coalesce (cast(-5 as int), coalesce (((cast(0.4 as int))-(coalesce (5, 5))), + 14 18 QUERY = select case covar_samp(all - (coalesce (cast(-5 as int), coalesce (((cast(0.4 as int))-(coalesce (5, 5))), + 18
..................
#~ MAPI = (monetdb) /var/tmp/mtest-2979
19 when interval '-3' month then 0.3 end as interval second) end then coalesce (abs(0.6), 19 23 when interval '-3' month then 0.3 end as interval second) end then coalesce (abs(0.6), 23
20 ERROR = !SELECT: cannot use non GROUP BY column 't0.c0' in query results without an aggregate function 20 ! 24 ERROR = !types sec_interval(0,0) and tinyint(8,0) are not equal 24
+ 25 CODE = 42000 25
+ 26 #~ MAPI = monetdb@WIN2K12R2:34681 26
+ 27 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 27
+ 28 ERROR = !types sec_interval(13,0) and int(32,0) are not equal 28
21 CODE = 42000 21 29 CODE = 42000 29
22 #~ MAPI = (monetdb) /var/tmp/mtest-32314/.s.monetdb.31414 22 ! 30 #~ MAPI = monetdb@WIN2K12R2:34681 30
+ 31 QUERY = SELECT 1 FROM t1 LEFT OUTER JOIN t0 ON TRUE 31
+ 32 LEFT OUTER JOIN (SELECT 1 FROM t0) AS sub0 ON TRUE 32
+ 33 WHERE (TIME '00:25:07') IN (TIME '07:29:34', CASE 2 WHEN 2 THEN TIME '17:23:46' ELSE TIME '05:14:30' END); 33
+ 34 ERROR = !TypeException:user.main[78]:'algebra.projection' undefined in: algebra.projection(X_391:bat[:bit], X_382:bat[:daytime]); 34
+ 35 #~ MAPI = monetdb@WIN2K12R2:34681 35
+ 36 QUERY = SELECT 1 FROM t1 LEFT OUTER JOIN t0 ON TRUE 36
+ 37 LEFT OUTER JOIN (SELECT 1 FROM t0) AS sub0 ON TRUE 37
+ 38 WHERE t0.c0 <= t0.c0 AND (TIME '00:25:07') IN (TIME '07:29:34', CASE 2 WHEN 2 THEN TIME '17:23:46' ELSE TIME '05:14:30' END); 38
+ 39 ERROR = !Scalar value expected 39
+ 40 #~ MAPI = monetdb@WIN2K12R2:34681 40
+ 41 QUERY = SELECT ALL COUNT(TIME '06:32:50') FROM t1 LEFT OUTER JOIN t0 ON TRUE 41
+ 42 LEFT OUTER JOIN (SELECT t1.c1, t0.c1, 0.43 FROM t0, t1) AS sub0 ON TRUE 42
+ 43 WHERE ((NOT ((TIME '00:25:07') IN (TIME '07:29:34', TIME '05:21:58', CASE 0.54 WHEN 0.65 THEN TIME '17:23:46' ELSE TIME '05:14:30' END)))) 43
+ 44 GROUP BY TIMESTAMP '1969-12-08 01:47:58'; 44
+ 45 ERROR = !Current transaction is aborted (please ROLLBACK) 45
+ 46 CODE = 25005 46
+ 47 #~ MAPI = monetdb@WIN2K12R2:34681 47
23 QUERY = CREATE TABLE t1(c0 CHAR(222), FOREIGN KEY (c0) REFERENCES t0(c0) MATCH FULL, PRIMARY KEY(c0)); --error, foreign key from char to time not allowed 23 48 QUERY = CREATE TABLE t1(c0 CHAR(222), FOREIGN KEY (c0) REFERENCES t0(c0) MATCH FULL, PRIMARY KEY(c0)); --error, foreign key from char to time not allowed 48