Test wlc40.py (id 3c6cbe78e1fe) (err)
wlc40.stable.out.FILTERED 2019-09-08 13:46:42.955120728 +0200wlc40.test.out.FILTERED 2019-09-08 13:46:42.957120709 +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, 1383 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 27 lines, 95 words, 1255 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 27 lines, 95 words, 1383 chars in lines not matching '^$|^(\| |)#` 3
4 # 102 lines, 398 words, 4135 chars in all lines 4 ! 4 # 102 lines, 402 words, 4281 chars in all lines 4
5 5 5 5
..................
#select * from tmp;
45 [ 6, "blah" ] 45 45 [ 6, "blah" ] 45
46 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc.config 46 ! 46 /export/scratch1/home/monet/testing/3c6cbe78e1fe-5-1-4/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc.config 46
47 #logs=/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/ 47 ! 47 #logs=/export/scratch1/home/monet/testing/3c6cbe78e1fe-5-1-4/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/ 47
48 #id=7 48 48 #id=7 48
..................
#beat=0
53 # 53 53 # 53
54 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000004 54 ! 54 /export/scratch1/home/monet/testing/3c6cbe78e1fe-5-1-4/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000001 54
55 # wlr.transaction(4:lng, "2019-08-14T10:03:35.000":str, "monetdb":str); 55 ! 55 # wlr.transaction(1:lng, "2019-09-08T13:46:37.000":str, "monetdb":str); 55
56 # wlr.action("update tmp set i = 3 where i = 1;":str); 56 -
57 # wlr.update("sys":str, "tmp":str, "i":str, 0@0:oid, 3:int); 57 -
58 # wlr.commit(); 58 -
59 # 59 -
60 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000003 60 -
61 # wlr.transaction(3:lng, "2019-08-14T10:03:34.000":str, "monetdb":str); 61 -
62 # wlr.action("insert into tmp values(5,\\'red\\'),(6,\\'fox\\');":str); 62 -
63 # wlr.append("sys":str, "tmp":str, "i":str, 5:int, 6:int); 63 -
64 # wlr.append("sys":str, "tmp":str, "s":str, "red":str, "fox":str); 64 -
65 # wlr.commit(); 65 -
66 # 66 -
67 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000001 67 -
68 # wlr.transaction(1:lng, "2019-08-14T10:03:32.000":str, "monetdb":str); 68 -
69 # wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str); 69 56 # wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str); 56
..................
# wlr.commit();
73 # 73 60 # 60
74 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000005 74 ! 61 /export/scratch1/home/monet/testing/3c6cbe78e1fe-5-1-4/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000004 61
75 # wlr.transaction(5:lng, "2019-08-14T10:03:35.000":str, "monetdb":str); 75 ! 62 # wlr.transaction(4:lng, "2019-09-08T13:46:40.000":str, "monetdb":str); 62
+ 63 # wlr.action("update tmp set i = 3 where i = 1;":str); 63
+ 64 # wlr.update("sys":str, "tmp":str, "i":str, 0@0:oid, 3:int); 64
+ 65 # wlr.commit(); 65
+ 66 # 66
+ 67 /export/scratch1/home/monet/testing/3c6cbe78e1fe-5-1-4/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000005 67
+ 68 # wlr.transaction(5:lng, "2019-09-08T13:46:40.000":str, "monetdb":str); 68
76 # wlr.action("update tmp set s = \\'blah\\';":str); 76 69 # wlr.action("update tmp set s = \\'blah\\';":str); 69
..................
# wlr.commit();
84 # 84 77 # 77
85 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000006 85 ! 78 /export/scratch1/home/monet/testing/3c6cbe78e1fe-5-1-4/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000000 78
86 # wlr.transaction(6:lng, "2019-08-14T10:03:36.000":str, "monetdb":str); 86 ! 79 # wlr.transaction(0:lng, "2019-09-08T13:46:37.000":str, "monetdb":str); 79
87 # wlr.action("delete from tmp where i < 4;":str); 87 ! 80 # wlr.catalog("create table tmp(i int, s string);":str); 80
88 # wlr.delete("sys":str, "tmp":str, 0@0:oid, 0@0:oid, 0@0:oid); 88 -
89 # wlr.commit(); 89 81 # wlr.commit(); 81
90 # 90 82 # 82
91 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000002 91 ! 83 /export/scratch1/home/monet/testing/3c6cbe78e1fe-5-1-4/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000003 83
92 # wlr.transaction(2:lng, "2019-08-14T10:03:32.000":str, "monetdb":str); 92 ! 84 # wlr.transaction(3:lng, "2019-09-08T13:46:39.000":str, "monetdb":str); 84
+ 85 # wlr.action("insert into tmp values(5,\\'red\\'),(6,\\'fox\\');":str); 85
+ 86 # wlr.append("sys":str, "tmp":str, "i":str, 5:int, 6:int); 86
+ 87 # wlr.append("sys":str, "tmp":str, "s":str, "red":str, "fox":str); 87
+ 88 # wlr.commit(); 88
+ 89 # 89
+ 90 /export/scratch1/home/monet/testing/3c6cbe78e1fe-5-1-4/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000002 90
+ 91 # wlr.transaction(2:lng, "2019-09-08T13:46:38.000":str, "monetdb":str); 91
93 # wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str); 93 92 # wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str); 92
..................
# wlr.commit();
97 # 97 96 # 96
98 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000000 98 ! 97 /export/scratch1/home/monet/testing/3c6cbe78e1fe-5-1-4/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000006 97
99 # wlr.transaction(0:lng, "2019-08-14T10:03:32.000":str, "monetdb":str); 99 ! 98 # wlr.transaction(6:lng, "2019-09-08T13:46:41.000":str, "monetdb":str); 98
100 # wlr.catalog("create table tmp(i int, s string);":str); 100 ! 99 # wlr.action("delete from tmp where i < 4;":str); 99
+ 100 # wlr.delete("sys":str, "tmp":str, 0@0:oid, 1@0:oid, 2@0:oid); 100
101 # wlr.commit(); 101 101 # wlr.commit(); 101