Test wlc50.py (id 3c6cbe78e1fe) (err)
wlc50.stable.out.FILTERED 2019-09-08 12:31:50.019496700 +0200wlc50.test.out.FILTERED 2019-09-08 12:31:50.019496700 +0200
1 Statistics about stdout of test 'wlc50` in directory 'sql/test/wlcr`: 1 1 Statistics about stdout of test 'wlc50` in directory 'sql/test/wlcr`: 1
2 15 lines, 40 words, 1180 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 15 lines, 40 words, 1144 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 15 lines, 40 words, 1180 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 15 lines, 40 words, 1144 chars in lines not matching '^$|^(\| |)#` 3
4 # 94 lines, 349 words, 4193 chars in all lines 4 ! 4 # 93 lines, 341 words, 4025 chars in all lines 4
5 5 5 5
..................
#select * from tmp;
31 % 1, 0 # length 31 30 % 1, 0 # length 30
32 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc.config 32 ! 31 C:\monettesting\3c6cbe78e1fe-8-2-1\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc.config 31
33 #logs=/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/ 33 ! 32 #logs=C:\monettesting\3c6cbe78e1fe-8-2-1\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\ 32
34 #id=8 34 33 #id=8 33
..................
#beat=0
39 # 39 38 # 38
40 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000004 40 ! 39 C:\monettesting\3c6cbe78e1fe-8-2-1\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000000 39
41 # wlr.transaction(4:lng, "2019-08-14T10:03:35.000":str, "monetdb":str); 41 ! 40 # wlr.transaction(0:lng, "2019-09-09T02:31:41.000":str, "monetdb":str); 40
42 # wlr.action("update tmp set i = 3 where i = 1;":str); 42 ! 41 # wlr.catalog("create table tmp(i int, s string);":str); 41
43 # wlr.update("sys":str, "tmp":str, "i":str, 0@0:oid, 3:int); 43 -
44 # wlr.commit(); 44 42 # wlr.commit(); 42
45 # 45 43 # 43
46 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000003 46 ! 44 C:\monettesting\3c6cbe78e1fe-8-2-1\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000001 44
47 # wlr.transaction(3:lng, "2019-08-14T10:03:34.000":str, "monetdb":str); 47 ! 45 # wlr.transaction(1:lng, "2019-09-09T02:31:41.000":str, "monetdb":str); 45
+ 46 # wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str); 46
+ 47 # wlr.append("sys":str, "tmp":str, "i":str, 1:int, 2:int); 47
+ 48 # wlr.append("sys":str, "tmp":str, "s":str, "hello":str, "world":str); 48
+ 49 # wlr.commit(); 49
+ 50 # 50
+ 51 C:\monettesting\3c6cbe78e1fe-8-2-1\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000002 51
+ 52 # wlr.transaction(2:lng, "2019-09-09T02:31:42.000":str, "monetdb":str); 52
+ 53 # wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str); 53
+ 54 # wlr.append("sys":str, "tmp":str, "i":str, 3:int, 4:int); 54
+ 55 # wlr.append("sys":str, "tmp":str, "s":str, "blah":str, "bloh":str); 55
+ 56 # wlr.commit(); 56
+ 57 # 57
+ 58 C:\monettesting\3c6cbe78e1fe-8-2-1\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000003 58
+ 59 # wlr.transaction(3:lng, "2019-09-09T02:31:44.000":str, "monetdb":str); 59
48 # wlr.action("insert into tmp values(5,\\'red\\'),(6,\\'fox\\');":str); 48 60 # wlr.action("insert into tmp values(5,\\'red\\'),(6,\\'fox\\');":str); 60
..................
# wlr.commit();
52 # 52 64 # 64
53 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000007 53 ! 65 C:\monettesting\3c6cbe78e1fe-8-2-1\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000004 65
54 # wlr.transaction(7:lng, "2019-08-14T10:03:38.000":str, "monetdb":str); 54 ! 66 # wlr.transaction(4:lng, "2019-09-09T02:31:45.000":str, "monetdb":str); 66
55 # wlr.action("delete from tmp;":str); 55 ! 67 # wlr.action("update tmp set i = 3 where i = 1;":str); 67
56 # wlr.clear_table("sys":str, "tmp":str); 56 ! 68 # wlr.update("sys":str, "tmp":str, "i":str, 0@0:oid, 3:int); 68
57 # wlr.commit(); 57 -
58 # 58 -
59 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000001 59 -
60 # wlr.transaction(1:lng, "2019-08-14T10:03:32.000":str, "monetdb":str); 60 -
61 # wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str); 61 -
62 # wlr.append("sys":str, "tmp":str, "i":str, 1:int, 2:int); 62 -
63 # wlr.append("sys":str, "tmp":str, "s":str, "hello":str, "world":str); 63 -
64 # wlr.commit(); 64 69 # wlr.commit(); 69
65 # 65 70 # 70
66 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000005 66 ! 71 C:\monettesting\3c6cbe78e1fe-8-2-1\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000005 71
67 # wlr.transaction(5:lng, "2019-08-14T10:03:35.000":str, "monetdb":str); 67 ! 72 # wlr.transaction(5:lng, "2019-09-09T02:31:45.000":str, "monetdb":str); 72
68 # wlr.action("update tmp set s = \\'blah\\';":str); 68 73 # wlr.action("update tmp set s = \\'blah\\';":str); 73
..................
# wlr.commit();
76 # 76 81 # 81
77 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000006 77 ! 82 C:\monettesting\3c6cbe78e1fe-8-2-1\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000006 82
78 # wlr.transaction(6:lng, "2019-08-14T10:03:36.000":str, "monetdb":str); 78 ! 83 # wlr.transaction(6:lng, "2019-09-09T02:31:47.000":str, "monetdb":str); 83
79 # wlr.action("delete from tmp where i < 4;":str); 79 84 # wlr.action("delete from tmp where i < 4;":str); 84
..................
# wlr.commit();
82 # 82 87 # 87
83 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000002 83 ! 88 C:\monettesting\3c6cbe78e1fe-8-2-1\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000007 88
84 # wlr.transaction(2:lng, "2019-08-14T10:03:32.000":str, "monetdb":str); 84 ! 89 # wlr.transaction(7:lng, "2019-09-09T02:31:48.000":str, "monetdb":str); 89
85 # wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str); 85 ! 90 # wlr.action("delete from tmp;":str); 90
86 # wlr.append("sys":str, "tmp":str, "i":str, 3:int, 4:int); 86 ! 91 # wlr.clear_table("sys":str, "tmp":str); 91
87 # wlr.append("sys":str, "tmp":str, "s":str, "blah":str, "bloh":str); 87 -
88 # wlr.commit(); 88 -
89 # 89 -
90 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000000 90 -
91 # wlr.transaction(0:lng, "2019-08-14T10:03:32.000":str, "monetdb":str); 91 -
92 # wlr.catalog("create table tmp(i int, s string);":str); 92 -
93 # wlr.commit(); 93 92 # wlr.commit(); 92