Test remote-table-where-is-null.Bug-6601.py (id 3c6cbe78e1fe) (err)
remote-table-where-is-null.Bug-6601.stable.out.FILTERED 2019-09-08 13:24:00.877790700 +0200remote-table-where-is-null.Bug-6601.test.out.FILTERED 2019-09-08 13:24:00.877790700 +0200
1 Statistics about stdout of test 'remote-table-where-is-null.Bug-6601` in directory 'sql/test/BugTracker-2018`: 1 1 Statistics about stdout of test 'remote-table-where-is-null.Bug-6601` in directory 'sql/test/BugTracker-2018`: 1
2 7 lines, 36 words, 246 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 7 lines, 36 words, 254 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 7 lines, 36 words, 246 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 7 lines, 36 words, 254 chars in lines not matching '^$|^(\| |)#` 3
4 # 133 lines, 721 words, 5051 chars in all lines 4 ! 4 # 113 lines, 601 words, 4075 chars in all lines 4
5 5 5 5
..................
# node1: INSERT INTO tbl (id) VALUES (3)
17 # node1: SELECT * FROM tbl 17 17 # node1: SELECT * FROM tbl 17
18 [(1, '1'), (2, '2'), (3, None)] 18 + 18 [(1, u'1'), (2, u'2'), (3, None)] 18
19 # node1: SELECT * FROM tbl WHERE NAME IS NULL 19 19 # node1: SELECT * FROM tbl WHERE NAME IS NULL 19
..................
# node1: SELECT * FROM tbl WHERE NAME IS
21 # node1: SELECT * FROM tbl 21 21 # node1: SELECT * FROM tbl 21
22 [(1, '1'), (2, '2'), (3, None)] 22 + 22 [(1, u'1'), (2, u'2'), (3, None)] 22
23 # node2: CREATE REMOTE TABLE tbl (id INT, name TEXT) on 'mapi:monetdb://localhost:37187/node1/sys/tbl' 23 ! 23 # node2: CREATE REMOTE TABLE tbl (id INT, name TEXT) on 'mapi:monetdb://localhost:56130/node1/sys/tbl' 23
24 # node2: SELECT * FROM tbl 24 24 # node2: SELECT * FROM tbl 24
25 [(1, '1'), (2, '2'), (3, None)] 25 + 25 [(1, u'1'), (2, u'2'), (3, None)] 25
26 # node2: SELECT * FROM tbl WHERE NAME IS NULL 26 26 # node2: SELECT * FROM tbl WHERE NAME IS NULL 26
..................
# node2: SELECT * FROM tbl WHERE NAME IS
28 # node2: SELECT * FROM tbl 28 28 # node2: SELECT * FROM tbl 28
29 [(1, '1'), (2, '2'), (3, None)] 29 + 29 [(1, u'1'), (2, u'2'), (3, None)] 29
30 # MonetDB 5 server v11.34.0 (hg id: f48604e1e938) 30 ! 30 # MonetDB 5 server v11.36.0 30
31 # This is an unreleased version 31 31 # This is an unreleased version 31