Test local_replica_table_not_detected.Bug-6620.py (id 0f951a98884e) (err)
local_replica_table_not_detected.Bug-6620.stable.out.FILTERED 2018-07-11 23:31:55.172278800 +0200local_replica_table_not_detected.Bug-6620.test.out.FILTERED 2018-07-11 23:31:55.187832000 +0200
1 Statistics about stdout of test 'local_replica_table_not_detected.Bug-6620` in directory 'sql/test/BugTracker-2018`: 1 1 Statistics about stdout of test 'local_replica_table_not_detected.Bug-6620` in directory 'sql/test/BugTracker-2018`: 1
2 38 lines, 236 words, 1243 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 42 lines, 282 words, 1478 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 38 lines, 236 words, 1243 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 42 lines, 282 words, 1478 chars in lines not matching '^$|^(\| |)#` 3
4 # 51 lines, 274 words, 1610 chars in all lines 4 ! 4 # 137 lines, 764 words, 4986 chars in all lines 4
5 5 5 5
..................
#create remote table t1 (s varchar(10))
30 project ( 30 30 project ( 30
31 | table(sys.s2) [ "s2"."i" as "reps"."i"] COUNT 31 ! 31 | table 31
+ 32 | | REMOTE(sys.s1) [ "s1"."i" as "reps"."i", "s1"."%TID%" NOT NULL as "reps"."%TID%" ] REMOTE sys.s1 [ "reps"."i", "reps"."%TID%" NOT NULL ] 32
32 ) [ "reps"."i" ] 32 33 ) [ "reps"."i" ] 33
..................
#create remote table t1 (s varchar(10))
34 union ( 34 35 union ( 35
35 | table 35 ! 36 | project ( 36
36 | | project ( 36 ! 37 | | crossproduct ( 37
37 | | | crossproduct ( 37 ! 38 | | | table 38
38 | | | | REMOTE(sys.s1) [ "s1"."i" as "reps"."i", "s1"."%TID%" NOT NULL as "reps"."%TID%" ], 38 ! 39 | | | | REMOTE(sys.s1) [ "s1"."i" as "reps"."i", "s1"."%TID%" NOT NULL as "reps"."%TID%" ] REMOTE sys.s1 [ "reps"."i", "reps"."%TID%" NOT NULL ], 39
+ 40 | | | table 40
39 | | | | project ( 39 41 | | | | project ( 41
40 | | | | | REMOTE(sys.t1) [ "t1"."s" as "mrgt"."s" ] COUNT 40 42 | | | | | REMOTE(sys.t1) [ "t1"."s" as "mrgt"."s" ] COUNT 42
41 | | | | ) [ "mrgt"."s" ] 41 ! 43 | | | | ) [ "mrgt"."s" ] REMOTE sys.t1 [ "mrgt"."s" ] 43
42 | | | ) [ ] 42 ! 44 | | ) [ ] 44
43 | | ) [ "reps"."i", "mrgt"."s" ] REMOTE mapi:monetdb://localhost:57465/node1 [ "reps"."i", "mrgt"."s" ], 43 ! 45 | ) [ "reps"."i", "mrgt"."s" ], 45
44 | project ( 44 46 | project ( 46
45 | | crossproduct ( 45 47 | | crossproduct ( 47
46 | | | | table(sys.s2) [ "s2"."i" as "reps"."i"] COUNT , 46 ! 48 | | | table 48
+ 49 | | | | REMOTE(sys.s1) [ "s1"."i" as "reps"."i", "s1"."%TID%" NOT NULL as "reps"."%TID%" ] REMOTE sys.s1 [ "reps"."i", "reps"."%TID%" NOT NULL ], 49
+ 50 | | | project ( 50
47 | | | | table(sys.t2) [ "t2"."s" as "mrgt"."s" ] COUNT 47 51 | | | | table(sys.t2) [ "t2"."s" as "mrgt"."s" ] COUNT 51