Test wlr70.py (id 3c6cbe78e1fe) (err)
wlr70.stable.out.FILTERED 2019-09-08 12:32:56.581418400 +0200wlr70.test.out.FILTERED 2019-09-08 12:32:56.581418400 +0200
1 Statistics about stdout of test 'wlr70` in directory 'sql/test/wlcr`: 1 1 Statistics about stdout of test 'wlr70` in directory 'sql/test/wlcr`: 1
2 22 lines, 67 words, 1526 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 12 lines, 19 words, 1292 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 22 lines, 67 words, 1526 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 12 lines, 19 words, 1292 chars in lines not matching '^$|^(\| |)#` 3
4 # 121 lines, 465 words, 5353 chars in all lines 4 ! 4 # 100 lines, 358 words, 4644 chars in all lines 4
5 5 5 5
..................
# MonetDB/GIS module loaded
24 # MonetDB/SQL module loaded 24 23 # MonetDB/SQL module loaded 23
25 #now 2017-05-02T13:16:47.000 tlimit 2017-05-02 11:16:47.000 25 -
26 #call replicate(now()); 26 24 #call replicate(now()); 24
27 #Waiting for replay scheduler to stop 27 ! 25 #time limit 2019-09-08 10:32:56.440 25
28 #time limit 2017-05-02 11:16:47.000 28 ! 26 C:\monettesting\3c6cbe78e1fe-8-1-1\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc.config 26
29 #select * from tmp70; 29 ! 27 #logs=C:\monettesting\3c6cbe78e1fe-8-1-1\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\ 27
30 % sys.tmp70, sys.tmp70 # table_name 30 -
31 % i, s # name 31 -
32 % int, clob # type 32 -
33 % 1, 0 # length 33 -
34 #call replicate(); 34 -
35 #Waiting for replay scheduler to stop 35 -
36 #Waiting for replay scheduler to stop 36 -
37 #Waiting for replay scheduler to stop 37 -
38 #Waiting for replay scheduler to stop 38 -
39 #Waiting for replay scheduler to stop 39 -
40 #select * from tmp70; 40 -
41 % sys.tmp70, sys.tmp70 # table_name 41 -
42 % i, s # name 42 -
43 % int, clob # type 43 -
44 % 1, 5 # length 44 -
45 [ 1, "hello" ] 45 -
46 [ 2, "world" ] 46 -
47 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc.config 47 -
48 #logs=/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/ 48 -
49 #id=10 49 28 #id=10 28
..................
#beat=0
54 # 54 33 # 33
55 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000008 55 ! 34 C:\monettesting\3c6cbe78e1fe-8-1-1\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000000 34
56 # wlr.transaction(8:lng, "2019-08-14T12:11:30.000":str, "monetdb":str); 56 ! 35 # wlr.transaction(0:lng, "2019-09-09T02:32:37.000":str, "monetdb":str); 35
57 # wlr.catalog("create table tmp70(i int, s string);":str); 57 - 36 # wlr.catalog("create table tmp(i int, s string);":str); 36
58 # wlr.commit(); 58 37 # wlr.commit(); 37
59 # 59 38 # 38
60 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000004 60 ! 39 C:\monettesting\3c6cbe78e1fe-8-1-1\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000001 39
61 # wlr.transaction(4:lng, "2019-08-14T12:11:24.000":str, "monetdb":str); 61 ! 40 # wlr.transaction(1:lng, "2019-09-09T02:32:37.000":str, "monetdb":str); 40
62 # wlr.action("update tmp set i = 3 where i = 1;":str); 62 ! 41 # wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str); 41
63 # wlr.update("sys":str, "tmp":str, "i":str, 0@0:oid, 3:int); 63 ! 42 # wlr.append("sys":str, "tmp":str, "i":str, 1:int, 2:int); 42
+ 43 # wlr.append("sys":str, "tmp":str, "s":str, "hello":str, "world":str); 43
64 # wlr.commit(); 64 44 # wlr.commit(); 44
65 # 65 45 # 45
66 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000003 66 ! 46 C:\monettesting\3c6cbe78e1fe-8-1-1\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000002 46
67 # wlr.transaction(3:lng, "2019-08-14T12:11:21.000":str, "monetdb":str); 67 ! 47 # wlr.transaction(2:lng, "2019-09-09T02:32:39.000":str, "monetdb":str); 47
+ 48 # wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str); 48
+ 49 # wlr.append("sys":str, "tmp":str, "i":str, 3:int, 4:int); 49
+ 50 # wlr.append("sys":str, "tmp":str, "s":str, "blah":str, "bloh":str); 50
+ 51 # wlr.commit(); 51
+ 52 # 52
+ 53 C:\monettesting\3c6cbe78e1fe-8-1-1\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000003 53
+ 54 # wlr.transaction(3:lng, "2019-09-09T02:32:41.000":str, "monetdb":str); 54
68 # wlr.action("insert into tmp values(5,\\'red\\'),(6,\\'fox\\');":str); 68 55 # wlr.action("insert into tmp values(5,\\'red\\'),(6,\\'fox\\');":str); 55
..................
# wlr.commit();
72 # 72 59 # 59
73 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000009 73 ! 60 C:\monettesting\3c6cbe78e1fe-8-1-1\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000004 60
74 # wlr.transaction(9:lng, "2019-08-14T12:11:30.000":str, "monetdb":str); 74 ! 61 # wlr.transaction(4:lng, "2019-09-09T02:32:42.000":str, "monetdb":str); 61
75 # wlr.action("insert into tmp70 values(1,\\'hello\\'), (2,\\'world\\');":str); 75 ! 62 # wlr.action("update tmp set i = 3 where i = 1;":str); 62
76 # wlr.append("sys":str, "tmp70":str, "i":str, 1:int, 2:int); 76 ! 63 # wlr.update("sys":str, "tmp":str, "i":str, 0@0:oid, 3:int); 63
77 # wlr.append("sys":str, "tmp70":str, "s":str, "hello":str, "world":str); 77 -
78 # wlr.commit(); 78 -
79 # 79 -
80 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000007 80 -
81 # wlr.transaction(7:lng, "2019-08-14T12:11:28.000":str, "monetdb":str); 81 -
82 # wlr.action("delete from tmp;":str); 82 -
83 # wlr.clear_table("sys":str, "tmp":str); 83 -
84 # wlr.commit(); 84 -
85 # 85 -
86 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000001 86 -
87 # wlr.transaction(1:lng, "2019-08-14T12:11:18.000":str, "monetdb":str); 87 -
88 # wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str); 88 -
89 # wlr.append("sys":str, "tmp":str, "i":str, 1:int, 2:int); 89 -
90 # wlr.append("sys":str, "tmp":str, "s":str, "hello":str, "world":str); 90 -
91 # wlr.commit(); 91 64 # wlr.commit(); 64
92 # 92 65 # 65
93 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000005 93 ! 66 C:\monettesting\3c6cbe78e1fe-8-1-1\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000005 66
94 # wlr.transaction(5:lng, "2019-08-14T12:11:24.000":str, "monetdb":str); 94 ! 67 # wlr.transaction(5:lng, "2019-09-09T02:32:43.000":str, "monetdb":str); 67
95 # wlr.action("update tmp set s = \\'blah\\';":str); 95 68 # wlr.action("update tmp set s = \\'blah\\';":str); 68
..................
# wlr.commit();
103 # 103 76 # 76
104 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000006 104 ! 77 C:\monettesting\3c6cbe78e1fe-8-1-1\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000006 77
105 # wlr.transaction(6:lng, "2019-08-14T12:11:26.000":str, "monetdb":str); 105 ! 78 # wlr.transaction(6:lng, "2019-09-09T02:32:45.000":str, "monetdb":str); 78
106 # wlr.action("delete from tmp where i < 4;":str); 106 79 # wlr.action("delete from tmp where i < 4;":str); 79
..................
# wlr.commit();
109 # 109 82 # 82
110 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000002 110 ! 83 C:\monettesting\3c6cbe78e1fe-8-1-1\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000007 83
111 # wlr.transaction(2:lng, "2019-08-14T12:11:19.000":str, "monetdb":str); 111 ! 84 # wlr.transaction(7:lng, "2019-09-09T02:32:47.000":str, "monetdb":str); 84
112 # wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str); 112 ! 85 # wlr.action("delete from tmp;":str); 85
113 # wlr.append("sys":str, "tmp":str, "i":str, 3:int, 4:int); 113 ! 86 # wlr.clear_table("sys":str, "tmp":str); 86
114 # wlr.append("sys":str, "tmp":str, "s":str, "blah":str, "bloh":str); 114 -
115 # wlr.commit(); 115 87 # wlr.commit(); 87
116 # 116 88 # 88
117 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000000 117 ! 89 C:\monettesting\3c6cbe78e1fe-8-1-1\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000008 89
118 # wlr.transaction(0:lng, "2019-08-14T12:11:18.000":str, "monetdb":str); 118 ! 90 # wlr.transaction(8:lng, "2019-09-09T02:32:52.000":str, "monetdb":str); 90
119 # wlr.catalog("create table tmp(i int, s string);":str); 119 + 91 # wlr.catalog("create table tmp70(i int, s string);":str); 91
+ 92 # wlr.commit(); 92
+ 93 # 93
+ 94 C:\monettesting\3c6cbe78e1fe-8-1-1\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000009 94
+ 95 # wlr.transaction(9:lng, "2019-09-09T02:32:53.000":str, "monetdb":str); 95
+ 96 # wlr.action("insert into tmp70 values(1,\\'hello\\'), (2,\\'world\\');":str); 96
+ 97 # wlr.append("sys":str, "tmp70":str, "i":str, 1:int, 2:int); 97
+ 98 # wlr.append("sys":str, "tmp70":str, "s":str, "hello":str, "world":str); 98
120 # wlr.commit(); 120 99 # wlr.commit(); 99