Test sqlitelogictest-algebra-join-not-in.Bug-6519.sql (id 0177627dc2e1) (err)
sqlitelogictest-algebra-join-not-in.Bug-6519.stable.out.FILTERED 2019-09-20 19:26:29.981707006 +0200sqlitelogictest-algebra-join-not-in.Bug-6519.test.out.FILTERED 2019-09-20 19:26:29.982706996 +0200
1 Statistics about stdout of test 'sqlitelogictest-algebra-join-not-in.Bug-6519` in directory 'sql/test/BugTracker-2018`: 1 1 Statistics about stdout of test 'sqlitelogictest-algebra-join-not-in.Bug-6519` in directory 'sql/test/BugTracker-2018`: 1
2 26 lines, 116 words, 496 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 26 lines, 116 words, 485 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 26 lines, 116 words, 496 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 26 lines, 116 words, 485 chars in lines not matching '^$|^(\| |)#` 3
4 # 73 lines, 464 words, 2562 chars in all lines 4 ! 4 # 70 lines, 459 words, 2592 chars in all lines 4
5 5 5 5
..................
# L4 # name
46 % 1 # length 46 44 % 1 # length 44
47 [ NULL ] 47 ! 45 [ 0 ] 45
48 #SELECT CAST ( SUM ( DISTINCT 23 ) * - COUNT ( DISTINCT + - col1 ) AS BIGINT ) FROM tab2 AS cor0 WHERE NULL; --NULL 48 46 #SELECT CAST ( SUM ( DISTINCT 23 ) * - COUNT ( DISTINCT + - col1 ) AS BIGINT ) FROM tab2 AS cor0 WHERE NULL; --NULL 46
..................
# L4 # name
55 % 1 # length 55 52 % 1 # length 52
56 [ NULL ] 56 ! 53 [ 0 ] 53
57 #SELECT DISTINCT CAST ( SUM ( DISTINCT 23 ) * - COUNT ( DISTINCT + - col1 ) AS BIGINT ) FROM tab2 AS cor0 WHERE NOT ( NULL ) IS NULL; --NULL 57 54 #SELECT DISTINCT CAST ( SUM ( DISTINCT 23 ) * - COUNT ( DISTINCT + - col1 ) AS BIGINT ) FROM tab2 AS cor0 WHERE NOT ( NULL ) IS NULL; --NULL 54
..................
# L4 # name
63 % 1 # length 63 60 % 1 # length 60
64 [ NULL ] 64 ! 61 [ 0 ] 61
65 #SELECT ALL + + MIN ( DISTINCT - - 14 ) AS col1, CAST ( - SUM ( DISTINCT 74 ) AS BIGINT ) col0 FROM tab2 AS cor0 65 62 #SELECT ALL + + MIN ( DISTINCT - - 14 ) AS col1, CAST ( - SUM ( DISTINCT 74 ) AS BIGINT ) col0 FROM tab2 AS cor0 62
..................
# .L3, .L6 # table_name
70 % tinyint, bigint # type 70 67 % tinyint, bigint # type 67
71 % 1, 1 # length 71 ! 68 % 2, 1 # length 68
72 [ NULL, NULL ] 72 ! 69 [ 14, NULL ] 69
73 #DROP TABLE tab2; 73 70 #DROP TABLE tab2; 70