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