Test wlc100.py (id 3c6cbe78e1fe) (err)
wlc100.stable.out.FILTERED 2019-09-08 13:51:31.147321000 +0200wlc100.test.out.FILTERED 2019-09-08 13:51:31.147321000 +0200
1 Statistics about stdout of test 'wlc100` in directory 'sql/test/wlcr`: 1 1 Statistics about stdout of test 'wlc100` in directory 'sql/test/wlcr`: 1
2 18 lines, 48 words, 1449 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 18 lines, 48 words, 1405 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 18 lines, 48 words, 1449 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 18 lines, 48 words, 1405 chars in lines not matching '^$|^(\| |)#` 3
4 # 107 lines, 399 words, 4939 chars in all lines 4 ! 4 # 106 lines, 391 words, 4765 chars in all lines 4
5 5 5 5
..................
#select * from tmp;
32 [ 40, "after being stopped" ] 32 31 [ 40, "after being stopped" ] 31
33 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc.config 33 ! 32 C:\monettesting\3c6cbe78e1fe-8-2-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc.config 32
34 #logs=/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/ 34 ! 33 #logs=C:\monettesting\3c6cbe78e1fe-8-2-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\ 33
35 #id=10 35 34 #id=10 34
..................
#beat=0
40 # 40 39 # 39
41 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000008 41 ! 40 C:\monettesting\3c6cbe78e1fe-8-2-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000000 40
42 # wlr.transaction(8:lng, "2019-08-14T10:05:49.000":str, "monetdb":str); 42 ! 41 # wlr.transaction(0:lng, "2019-09-09T02:51:15.000":str, "monetdb":str); 41
43 # wlr.catalog("create table tmp70(i int, s string);":str); 43 - 42 # wlr.catalog("create table tmp(i int, s string);":str); 42
44 # wlr.commit(); 44 43 # wlr.commit(); 43
45 # 45 44 # 44
46 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000004 46 ! 45 C:\monettesting\3c6cbe78e1fe-8-2-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000001 45
47 # wlr.transaction(4:lng, "2019-08-14T10:05:44.000":str, "monetdb":str); 47 ! 46 # wlr.transaction(1:lng, "2019-09-09T02:51:16.000":str, "monetdb":str); 46
48 # wlr.action("update tmp set i = 3 where i = 1;":str); 48 ! 47 # wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str); 47
49 # wlr.update("sys":str, "tmp":str, "i":str, 0@0:oid, 3:int); 49 ! 48 # wlr.append("sys":str, "tmp":str, "i":str, 1:int, 2:int); 48
+ 49 # wlr.append("sys":str, "tmp":str, "s":str, "hello":str, "world":str); 49
50 # wlr.commit(); 50 50 # wlr.commit(); 50
51 # 51 51 # 51
52 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000003 52 ! 52 C:\monettesting\3c6cbe78e1fe-8-2-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000002 52
53 # wlr.transaction(3:lng, "2019-08-14T10:05:41.000":str, "monetdb":str); 53 ! 53 # wlr.transaction(2:lng, "2019-09-09T02:51:16.000":str, "monetdb":str); 53
+ 54 # wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str); 54
+ 55 # wlr.append("sys":str, "tmp":str, "i":str, 3:int, 4:int); 55
+ 56 # wlr.append("sys":str, "tmp":str, "s":str, "blah":str, "bloh":str); 56
+ 57 # wlr.commit(); 57
+ 58 # 58
+ 59 C:\monettesting\3c6cbe78e1fe-8-2-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000003 59
+ 60 # wlr.transaction(3:lng, "2019-09-09T02:51:18.000":str, "monetdb":str); 60
54 # wlr.action("insert into tmp values(5,\\'red\\'),(6,\\'fox\\');":str); 54 61 # wlr.action("insert into tmp values(5,\\'red\\'),(6,\\'fox\\');":str); 61
..................
# wlr.commit();
58 # 58 65 # 65
59 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000009 59 ! 66 C:\monettesting\3c6cbe78e1fe-8-2-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000004 66
60 # wlr.transaction(9:lng, "2019-08-14T10:05:49.000":str, "monetdb":str); 60 ! 67 # wlr.transaction(4:lng, "2019-09-09T02:51:20.000":str, "monetdb":str); 67
61 # wlr.action("insert into tmp70 values(1,\\'hello\\'), (2,\\'world\\');":str); 61 ! 68 # wlr.action("update tmp set i = 3 where i = 1;":str); 68
62 # wlr.append("sys":str, "tmp70":str, "i":str, 1:int, 2:int); 62 ! 69 # wlr.update("sys":str, "tmp":str, "i":str, 0@0:oid, 3:int); 69
63 # wlr.append("sys":str, "tmp70":str, "s":str, "hello":str, "world":str); 63 -
64 # wlr.commit(); 64 -
65 # 65 -
66 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000007 66 -
67 # wlr.transaction(7:lng, "2019-08-14T10:05:48.000":str, "monetdb":str); 67 -
68 # wlr.action("delete from tmp;":str); 68 -
69 # wlr.clear_table("sys":str, "tmp":str); 69 -
70 # wlr.commit(); 70 -
71 # 71 -
72 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000001 72 -
73 # wlr.transaction(1:lng, "2019-08-14T10:05:39.000":str, "monetdb":str); 73 -
74 # wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str); 74 -
75 # wlr.append("sys":str, "tmp":str, "i":str, 1:int, 2:int); 75 -
76 # wlr.append("sys":str, "tmp":str, "s":str, "hello":str, "world":str); 76 -
77 # wlr.commit(); 77 70 # wlr.commit(); 70
78 # 78 71 # 71
79 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000005 79 ! 72 C:\monettesting\3c6cbe78e1fe-8-2-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000005 72
80 # wlr.transaction(5:lng, "2019-08-14T10:05:44.000":str, "monetdb":str); 80 ! 73 # wlr.transaction(5:lng, "2019-09-09T02:51:20.000":str, "monetdb":str); 73
81 # wlr.action("update tmp set s = \\'blah\\';":str); 81 74 # wlr.action("update tmp set s = \\'blah\\';":str); 74
..................
# wlr.commit();
89 # 89 82 # 82
90 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000006 90 ! 83 C:\monettesting\3c6cbe78e1fe-8-2-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000006 83
91 # wlr.transaction(6:lng, "2019-08-14T10:05:46.000":str, "monetdb":str); 91 ! 84 # wlr.transaction(6:lng, "2019-09-09T02:51:21.000":str, "monetdb":str); 84
92 # wlr.action("delete from tmp where i < 4;":str); 92 85 # wlr.action("delete from tmp where i < 4;":str); 85
..................
# wlr.commit();
95 # 95 88 # 88
96 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000002 96 ! 89 C:\monettesting\3c6cbe78e1fe-8-2-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000007 89
97 # wlr.transaction(2:lng, "2019-08-14T10:05:40.000":str, "monetdb":str); 97 ! 90 # wlr.transaction(7:lng, "2019-09-09T02:51:23.000":str, "monetdb":str); 90
98 # wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str); 98 ! 91 # wlr.action("delete from tmp;":str); 91
99 # wlr.append("sys":str, "tmp":str, "i":str, 3:int, 4:int); 99 ! 92 # wlr.clear_table("sys":str, "tmp":str); 92
100 # wlr.append("sys":str, "tmp":str, "s":str, "blah":str, "bloh":str); 100 -
101 # wlr.commit(); 101 93 # wlr.commit(); 93
102 # 102 94 # 94
103 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000000 103 ! 95 C:\monettesting\3c6cbe78e1fe-8-2-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000008 95
104 # wlr.transaction(0:lng, "2019-08-14T10:05:39.000":str, "monetdb":str); 104 ! 96 # wlr.transaction(8:lng, "2019-09-09T02:51:27.000":str, "monetdb":str); 96
105 # wlr.catalog("create table tmp(i int, s string);":str); 105 + 97 # wlr.catalog("create table tmp70(i int, s string);":str); 97
+ 98 # wlr.commit(); 98
+ 99 # 99
+ 100 C:\monettesting\3c6cbe78e1fe-8-2-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000009 100
+ 101 # wlr.transaction(9:lng, "2019-09-09T02:51:27.000":str, "monetdb":str); 101
+ 102 # wlr.action("insert into tmp70 values(1,\\'hello\\'), (2,\\'world\\');":str); 102
+ 103 # wlr.append("sys":str, "tmp70":str, "i":str, 1:int, 2:int); 103
+ 104 # wlr.append("sys":str, "tmp70":str, "s":str, "hello":str, "world":str); 104
106 # wlr.commit(); 106 105 # wlr.commit(); 105