Test sqlancer04.sql (id 90b5cb418b8e) (out)
sqlancer04.stable.err.FILTERED 2020-08-01 02:54:57.380993300 +0200sqlancer04.test.err.FILTERED 2020-08-01 02:54:57.380993300 +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 31 lines, 424 words, 2710 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 46 lines, 645 words, 4396 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 31 lines, 424 words, 2710 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 46 lines, 645 words, 4396 chars in lines not matching '^$|^(\| |)#` 3
4 # 50 lines, 492 words, 3351 chars in all lines 4 ! 4 # 70 lines, 725 words, 4939 chars in all lines 4
5 5 5 5
..................
#~ MAPI = (monetdb) /var/tmp/mtest-2177
50 CODE = 42000 50 50 CODE = 42000 50
51 51 ! 51 #~ MAPI = monetdb@LAB03:31091 51
52 # 09:44:50 > 52 ! 52 QUERY = select 1 from t0 natural join (select 4 from t0) as sub0; --error, no columns of tables 't0' and 'sub0' match 52
53 # 09:44:50 > "Done." 53 ! 53 ERROR = !JOIN: no columns of tables 't0' and '%4' match 53
54 # 09:44:50 > 54 ! 54 CODE = 42000 54
+ 55 #~ MAPI = monetdb@LAB03:31091 55
+ 56 QUERY = select t1.c0 from t0 natural join t1; --t1.c0 must be found 56
+ 57 ERROR = !SELECT: no such column 't1.c0' 57
+ 58 CODE = 42S22 58
+ 59 #~ MAPI = monetdb@LAB03:31091 59
+ 60 QUERY = SELECT CASE WHEN DATE '1970-01-04' IS NULL THEN CAST(CASE t1.c0 WHEN t1.c0 THEN TIME '11:33:56' END AS VARCHAR(524)) ELSE '0.6' END FROM t1; 60
+ 61 ERROR = !TypeException:user.main[19]:'bat.replace' undefined in: bat.replace(X_4166:bat[:str], X_4175:bat[:oid], X_4179:bat[:daytime], true:bit); 61
+ 62 #~ MAPI = monetdb@LAB03:31091 62
+ 63 QUERY = SELECT ALL MAX(ALL CASE WHEN (DATE '1970-01-04') IS NULL THEN CAST(CASE t1.c0 WHEN t1.c0 THEN TIME '11:33:56' END AS VARCHAR(524)) ELSE sql_max(r'iDfwsFjp藖1J洅ៅR-?0OT^.', r'0.6') END) FROM t1 63
+ 64 JOIN (SELECT ALL t0.c0, greatest(CAST(INTERVAL '6' SECOND AS TIME), TIME '10:25:00') FROM t1, t0) AS sub0 ON (COALESCE(-3, -6, 3)) NOT IN (CASE WHEN TRUE THEN -3 END, ((-4)&(-5)), - (6)) 64
+ 65 WHERE ((r'%')ILIKE(r'6')) GROUP BY COALESCE(CAST(least(0.4, 0.7) AS VARCHAR(506)), CAST(nullif(TIME '14:14:35', TIME '02:49:23') AS VARCHAR(388))), abs(0.6); 65
+ 66 ERROR = !TypeException:user.main[80]:'bat.replace' undefined in: bat.replace(X_4331:bat[:str], X_4340:bat[:oid], X_4344:bat[:daytime], true:bit); 66
+ 67 #~ MAPI = monetdb@LAB03:31091 67
+ 68 QUERY = SELECT ALL AVG(ALL CASE COALESCE(CAST(v0.c0 AS REAL), atan(v0.c0, v0.c0)) WHEN abs(0.7471649) THEN INTERVAL '1865286244' MONTH END) FROM v0 GROUP BY COALESCE(((((v0.c0)+(v0.c0)))&(v0.c0)), v0.c0, CAST("second"(TIME '01:32:22') AS INT)); 68
+ 69 ERROR = !Error in optimizer multiplex: TypeException:user.main[53]:'mmath.atan2' undefined in: mmath.atan2(X_4762:dbl, X_4764:dbl, nil:BAT, nil:BAT); 69
+ 70 CODE = 42000 70
+ 71 71
+ 72 # 02:54:57 > 72
+ 73 # 02:54:57 > "Done." 73
+ 74 # 02:54:57 > 74
55 55 75 75