Test sqlitelogictest-having-not-null-not-in.Bug-6557.sql (id ae96662f93e6) (err)
sqlitelogictest-having-not-null-not-in.Bug-6557.stable.out.FILTERED 2019-09-10 00:03:24.982300900 +0200sqlitelogictest-having-not-null-not-in.Bug-6557.test.out.FILTERED 2019-09-10 00:03:24.982300900 +0200
1 Statistics about stdout of test 'sqlitelogictest-having-not-null-not-in.Bug-6557` in directory 'sql/test/BugTracker-2018`: 1 1 Statistics about stdout of test 'sqlitelogictest-having-not-null-not-in.Bug-6557` in directory 'sql/test/BugTracker-2018`: 1
2 43 lines, 199 words, 961 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 33 lines, 142 words, 577 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 43 lines, 199 words, 961 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 33 lines, 142 words, 577 chars in lines not matching '^$|^(\| |)#` 3
4 # 92 lines, 512 words, 3023 chars in all lines 4 ! 4 # 76 lines, 416 words, 2294 chars in all lines 4
5 5 5 5
..................
# L2 # name
69 % 1 # length 69 67 % 1 # length 67
70 [ 0 ] 70 ! 68 [ 2 ] 68
71 #SELECT CAST(- COUNT(*) * - - 61 + + + ( + COUNT(*) ) AS BIGINT) FROM tab0 WHERE NOT col0 + + 10 BETWEEN NULL AND NULL; 71 69 #SELECT CAST(- COUNT(*) * - - 61 + + + ( + COUNT(*) ) AS BIGINT) FROM tab0 WHERE NOT col0 + + 10 BETWEEN NULL AND NULL; 69
..................
# L4 # name
76 % bigint # type 76 74 % bigint # type 74
77 % 1 # length 77 ! 75 % 4 # length 75
78 [ 0 ] 78 ! 76 [ -180 ] 76
79 #debug SELECT CAST(SUM(col0) AS BIGINT) FROM tab0 WHERE + + col0 NOT BETWEEN NULL AND + col2; 79 -
80 mdb>#X_2=0@0:void := querylog.define("debug select cast(sum(col0) as bigint) from tab0 where + + col0 not between null and + col2;", "default_pipe", 24:int); 80 -
81 mdb>#barrier X_139=false := language.dataflow(); 81 -
82 mdb>#X_5=0 := sql.mvc(); 82 -
83 mdb>#X_94=nil:bat[:int] := sql.bind(X_5=0, "sys", "tab0", "col0", 0:int, 0:int, 3:int); 83 -
84 % sys. # table_name 84 -
85 # sys.L3 # table_name 85 -
86 % L # name 86 -
87 # L3 # name 87 -
88 % bigint # type 88 -
89 % 3 # length 89 -
90 [ 126 ] 90 -
91 mdb>#EOD 91 -
92 #DROP TABLE tab0; 92 -
93 93 77 77