Test wlc40.py (id 3c6cbe78e1fe) (err)
wlc40.stable.out.FILTERED 2019-09-08 14:00:01.317777300 +0200wlc40.test.out.FILTERED 2019-09-08 14:00:01.333377300 +0200
1 Statistics about stdout of test 'wlc40` in directory 'sql/test/wlcr`: 1 1 Statistics about stdout of test 'wlc40` in directory 'sql/test/wlcr`: 1
2 27 lines, 95 words, 1255 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 27 lines, 95 words, 1223 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 27 lines, 95 words, 1255 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 27 lines, 95 words, 1223 chars in lines not matching '^$|^(\| |)#` 3
4 # 102 lines, 398 words, 4135 chars in all lines 4 ! 4 # 101 lines, 390 words, 3966 chars in all lines 4
5 5 5 5
..................
#select * from tmp;
45 [ 6, "blah" ] 45 44 [ 6, "blah" ] 44
46 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc.config 46 ! 45 C:\monettesting\3c6cbe78e1fe-3-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc.config 45
47 #logs=/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/ 47 ! 46 #logs=C:\monettesting\3c6cbe78e1fe-3-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\ 46
48 #id=7 48 47 #id=7 47
..................
#beat=0
53 # 53 52 # 52
54 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000004 54 ! 53 C:\monettesting\3c6cbe78e1fe-3-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000000 53
55 # wlr.transaction(4:lng, "2019-08-14T10:03:35.000":str, "monetdb":str); 55 ! 54 # wlr.transaction(0:lng, "2019-09-09T02:59:53.000":str, "monetdb":str); 54
56 # wlr.action("update tmp set i = 3 where i = 1;":str); 56 ! 55 # wlr.catalog("create table tmp(i int, s string);":str); 55
57 # wlr.update("sys":str, "tmp":str, "i":str, 0@0:oid, 3:int); 57 -
58 # wlr.commit(); 58 56 # wlr.commit(); 56
59 # 59 57 # 57
60 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000003 60 ! 58 C:\monettesting\3c6cbe78e1fe-3-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000001 58
61 # wlr.transaction(3:lng, "2019-08-14T10:03:34.000":str, "monetdb":str); 61 ! 59 # wlr.transaction(1:lng, "2019-09-09T02:59:53.000":str, "monetdb":str); 59
+ 60 # wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str); 60
+ 61 # wlr.append("sys":str, "tmp":str, "i":str, 1:int, 2:int); 61
+ 62 # wlr.append("sys":str, "tmp":str, "s":str, "hello":str, "world":str); 62
+ 63 # wlr.commit(); 63
+ 64 # 64
+ 65 C:\monettesting\3c6cbe78e1fe-3-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000002 65
+ 66 # wlr.transaction(2:lng, "2019-09-09T02:59:54.000":str, "monetdb":str); 66
+ 67 # wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str); 67
+ 68 # wlr.append("sys":str, "tmp":str, "i":str, 3:int, 4:int); 68
+ 69 # wlr.append("sys":str, "tmp":str, "s":str, "blah":str, "bloh":str); 69
+ 70 # wlr.commit(); 70
+ 71 # 71
+ 72 C:\monettesting\3c6cbe78e1fe-3-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000003 72
+ 73 # wlr.transaction(3:lng, "2019-09-09T02:59:56.000":str, "monetdb":str); 73
62 # wlr.action("insert into tmp values(5,\\'red\\'),(6,\\'fox\\');":str); 62 74 # wlr.action("insert into tmp values(5,\\'red\\'),(6,\\'fox\\');":str); 74
..................
# wlr.commit();
66 # 66 78 # 78
67 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000001 67 ! 79 C:\monettesting\3c6cbe78e1fe-3-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000004 79
68 # wlr.transaction(1:lng, "2019-08-14T10:03:32.000":str, "monetdb":str); 68 ! 80 # wlr.transaction(4:lng, "2019-09-09T02:59:58.000":str, "monetdb":str); 80
69 # wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str); 69 ! 81 # wlr.action("update tmp set i = 3 where i = 1;":str); 81
70 # wlr.append("sys":str, "tmp":str, "i":str, 1:int, 2:int); 70 ! 82 # wlr.update("sys":str, "tmp":str, "i":str, 0@0:oid, 3:int); 82
71 # wlr.append("sys":str, "tmp":str, "s":str, "hello":str, "world":str); 71 -
72 # wlr.commit(); 72 83 # wlr.commit(); 83
73 # 73 84 # 84
74 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000005 74 ! 85 C:\monettesting\3c6cbe78e1fe-3-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000005 85
75 # wlr.transaction(5:lng, "2019-08-14T10:03:35.000":str, "monetdb":str); 75 ! 86 # wlr.transaction(5:lng, "2019-09-09T02:59:58.000":str, "monetdb":str); 86
76 # wlr.action("update tmp set s = \\'blah\\';":str); 76 87 # wlr.action("update tmp set s = \\'blah\\';":str); 87
..................
# wlr.commit();
84 # 84 95 # 95
85 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000006 85 ! 96 C:\monettesting\3c6cbe78e1fe-3-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000006 96
86 # wlr.transaction(6:lng, "2019-08-14T10:03:36.000":str, "monetdb":str); 86 ! 97 # wlr.transaction(6:lng, "2019-09-09T02:00:00.000":str, "monetdb":str); 97
87 # wlr.action("delete from tmp where i < 4;":str); 87 98 # wlr.action("delete from tmp where i < 4;":str); 98
..................
# wlr.commit();
90 # 90 101 # 101
91 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000002 91 -
92 # wlr.transaction(2:lng, "2019-08-14T10:03:32.000":str, "monetdb":str); 92 -
93 # wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str); 93 -
94 # wlr.append("sys":str, "tmp":str, "i":str, 3:int, 4:int); 94 -
95 # wlr.append("sys":str, "tmp":str, "s":str, "blah":str, "bloh":str); 95 -
96 # wlr.commit(); 96 -
97 # 97 -
98 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000000 98 -
99 # wlr.transaction(0:lng, "2019-08-14T10:03:32.000":str, "monetdb":str); 99 -
100 # wlr.catalog("create table tmp(i int, s string);":str); 100 -
101 # wlr.commit(); 101 -
102 # 102 -
103 103 102 102