Test sqlitelogictest-having-not-null-not-in.Bug-6557.sql (id fe8055a86502) (err)
sqlitelogictest-having-not-null-not-in.Bug-6557.stable.out.FILTERED 2019-09-12 13:12:03.365123000 +0200sqlitelogictest-having-not-null-not-in.Bug-6557.test.out.FILTERED 2019-09-12 13:12:03.380723000 +0200
..................
# L4 # name
64 #debug SELECT CAST(SUM(col0) AS BIGINT) FROM tab0 WHERE + + col0 NOT BETWEEN NULL AND + col2; 64 63 #debug SELECT CAST(SUM(col0) AS BIGINT) FROM tab0 WHERE + + col0 NOT BETWEEN NULL AND + col2; 63
65 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); 65 ! 64 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", 23:int); 64
66 mdb>#barrier X_137=false := language.dataflow(); 66 ! 65 mdb>#barrier X_136=false := language.dataflow(); 65
67 mdb>#X_5=0 := sql.mvc(); 67 66 mdb>#X_5=0 := sql.mvc(); 66
68 mdb>#X_92=nil:bat[:int] := sql.bind(X_5=0, "sys", "tab0", "col0", 0:int, 0:int, 3:int); 68 ! 67 mdb>#X_91=nil:bat[:int] := sql.bind(X_5=0, "sys", "tab0", "col0", 0:int, 0:int, 3:int); 67
69 % sys. # table_name 69 68 % sys. # table_name 68