Test sqlancer04.sql (id 9fb2b731c9eb) (err)
sqlancer04.stable.out.FILTERED 2020-07-31 23:52:01.463884147 +0200sqlancer04.test.out.FILTERED 2020-07-31 23:52:01.469884179 +0200
1 Statistics about stdout of test 'sqlancer04` in directory 'sql/test/SQLancer`: 1 1 Statistics about stdout of test 'sqlancer04` in directory 'sql/test/SQLancer`: 1
2 20 lines, 81 words, 302 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 11 lines, 46 words, 186 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 20 lines, 81 words, 302 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 11 lines, 46 words, 186 chars in lines not matching '^$|^(\| |)#` 3
4 # 74 lines, 377 words, 2723 chars in all lines 4 ! 4 # 59 lines, 292 words, 2323 chars in all lines 4
5 5 5 5
..................
# %2 # name
40 #ROLLBACK; 40 40 #ROLLBACK; 40
41 #SELECT covar_samp(1, - (COALESCE(1, 2)||5)); --error on default, covar_samp between integer and string not possible 41 -
42 % . # table_name 42 -
43 # .%1 # table_name 43 -
44 % % # name 44 -
45 # %1 # name 45 -
46 % double # type 46 -
47 % 24 # length 47 -
48 [ NULL ] 48 -
49 #START TRANSACTION; 49 41 #START TRANSACTION; 41
..................
#START TRANSACTION;
53 #CREATE TABLE "sys"."t0" ("c0" INTERVAL SECOND NOT NULL); 53 45 #CREATE TABLE "sys"."t0" ("c0" INTERVAL SECOND NOT NULL); 45
54 #SELECT CASE '5'^3 WHEN COUNT(TRUE) THEN 1 END FROM t0 GROUP BY 2 IN ((CAST(INTERVAL '-2' SECOND AS INT))%2); 54 -
55 % . # table_name 55 -
56 # .%7 # table_name 56 -
57 % % # name 57 -
58 # %7 # name 58 -
59 % tinyint # type 59 -
60 % 1 # length 60 -
61 #ROLLBACK; 61 46 #ROLLBACK; 46