Test remote-table-where-not-equal.Bug-6621.py (id 3c6cbe78e1fe) (err)
remote-table-where-not-equal.Bug-6621.stable.out.FILTERED 2019-09-08 13:24:16.908849000 +0200remote-table-where-not-equal.Bug-6621.test.out.FILTERED 2019-09-08 13:24:16.924516200 +0200
1 Statistics about stdout of test 'remote-table-where-not-equal.Bug-6621` in directory 'sql/test/BugTracker-2018`: 1 1 Statistics about stdout of test 'remote-table-where-not-equal.Bug-6621` in directory 'sql/test/BugTracker-2018`: 1
2 17 lines, 107 words, 596 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 17 lines, 107 words, 611 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 17 lines, 107 words, 596 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 17 lines, 107 words, 611 chars in lines not matching '^$|^(\| |)#` 3
4 # 125 lines, 670 words, 4792 chars in all lines 4 ! 4 # 113 lines, 593 words, 4064 chars in all lines 4
5 5 5 5
..................
# 18:29:55 >
14 insert into t1 values (48, 'foo'), (29, 'bar'), (63, 'abc') 14 14 insert into t1 values (48, 'foo'), (29, 'bar'), (63, 'abc') 14
15 #create remote table t1 (i int, v varchar(10)) on 'mapi:monetdb://localhost:61212/node1'; 15 ! 15 #create remote table t1 (i int, v varchar(10)) on 'mapi:monetdb://localhost:56157/node1'; 15
16 select * from t1 16 16 select * from t1 16
17 [(48, 'foo'), (29, 'bar'), (63, 'abc')] 17 + 17 [(48, u'foo'), (29, u'bar'), (63, u'abc')] 17
18 select * from t1 where i < 50 18 18 select * from t1 where i < 50 18
19 [(48, 'foo'), (29, 'bar')] 19 + 19 [(48, u'foo'), (29, u'bar')] 19
20 select * from t1 where i > 50 20 20 select * from t1 where i > 50 20
21 [(63, 'abc')] 21 + 21 [(63, u'abc')] 21
22 select * from t1 where i <> 50 22 22 select * from t1 where i <> 50 22
23 [(48, 'foo'), (29, 'bar'), (63, 'abc')] 23 + 23 [(48, u'foo'), (29, u'bar'), (63, u'abc')] 23
24 select * from t1 where v = 'foo' 24 24 select * from t1 where v = 'foo' 24
25 [(48, 'foo')] 25 + 25 [(48, u'foo')] 25
26 select * from t1 where v <> 'foo' 26 26 select * from t1 where v <> 'foo' 26
27 [(29, 'bar'), (63, 'abc')] 27 + 27 [(29, u'bar'), (63, u'abc')] 27
28 select * from t1 where v <> 'bla' 28 28 select * from t1 where v <> 'bla' 28
29 [(48, 'foo'), (29, 'bar'), (63, 'abc')] 29 + 29 [(48, u'foo'), (29, u'bar'), (63, u'abc')] 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