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 20:12:13.080617900 +0200sqlitelogictest-algebra-join-not-in.Bug-6519.test.out.FILTERED 2019-09-20 20:12:13.080617900 +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 # 69 lines, 443 words, 2317 chars in all lines 4
5 5 5 5
..................
# L4 # name
46 % 1 # length 46 43 % 1 # length 43
47 [ NULL ] 47 ! 44 [ 0 ] 44
48 #SELECT CAST ( SUM ( DISTINCT 23 ) * - COUNT ( DISTINCT + - col1 ) AS BIGINT ) FROM tab2 AS cor0 WHERE NULL; --NULL 48 45 #SELECT CAST ( SUM ( DISTINCT 23 ) * - COUNT ( DISTINCT + - col1 ) AS BIGINT ) FROM tab2 AS cor0 WHERE NULL; --NULL 45
..................
# L4 # name
55 % 1 # length 55 51 % 1 # length 51
56 [ NULL ] 56 ! 52 [ 0 ] 52
57 #SELECT DISTINCT CAST ( SUM ( DISTINCT 23 ) * - COUNT ( DISTINCT + - col1 ) AS BIGINT ) FROM tab2 AS cor0 WHERE NOT ( NULL ) IS NULL; --NULL 57 53 #SELECT DISTINCT CAST ( SUM ( DISTINCT 23 ) * - COUNT ( DISTINCT + - col1 ) AS BIGINT ) FROM tab2 AS cor0 WHERE NOT ( NULL ) IS NULL; --NULL 53
..................
# L4 # name
63 % 1 # length 63 59 % 1 # length 59
64 [ NULL ] 64 ! 60 [ 0 ] 60
65 #SELECT ALL + + MIN ( DISTINCT - - 14 ) AS col1, CAST ( - SUM ( DISTINCT 74 ) AS BIGINT ) col0 FROM tab2 AS cor0 65 61 #SELECT ALL + + MIN ( DISTINCT - - 14 ) AS col1, CAST ( - SUM ( DISTINCT 74 ) AS BIGINT ) col0 FROM tab2 AS cor0 61
..................
# .L3, .L6 # table_name
70 % tinyint, bigint # type 70 66 % tinyint, bigint # type 66
71 % 1, 1 # length 71 ! 67 % 2, 1 # length 67
72 [ NULL, NULL ] 72 ! 68 [ 14, NULL ] 68
73 #DROP TABLE tab2; 73 69 #DROP TABLE tab2; 69