Test wlc30.py (id 3c6cbe78e1fe) (err)
wlc30.stable.out.FILTERED 2019-09-08 13:17:57.455109501 +0200wlc30.test.out.FILTERED 2019-09-08 13:17:57.457109483 +0200
1 Statistics about stdout of test 'wlc30` in directory 'sql/test/wlcr`: 1 1 Statistics about stdout of test 'wlc30` in directory 'sql/test/wlcr`: 1
2 20 lines, 65 words, 1025 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 20 lines, 65 words, 1137 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 20 lines, 65 words, 1025 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 20 lines, 65 words, 1137 chars in lines not matching '^$|^(\| |)#` 3
4 # 90 lines, 352 words, 3719 chars in all lines 4 ! 4 # 90 lines, 356 words, 3850 chars in all lines 4
5 5 5 5
..................
#select * from tmp;
39 [ 6, "blah" ] 39 39 [ 6, "blah" ] 39
40 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc.config 40 ! 40 /export/scratch1/home/monet/testing/3c6cbe78e1fe-5-1-3/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc.config 40
41 #logs=/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/ 41 ! 41 #logs=/export/scratch1/home/monet/testing/3c6cbe78e1fe-5-1-3/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/ 41
42 #id=6 42 42 #id=6 42
..................
#beat=0
47 # 47 47 # 47
48 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000004 48 ! 48 /export/scratch1/home/monet/testing/3c6cbe78e1fe-5-1-3/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000001 48
49 # wlr.transaction(4:lng, "2019-08-14T10:03:35.000":str, "monetdb":str); 49 ! 49 # wlr.transaction(1:lng, "2019-09-08T13:17:53.000":str, "monetdb":str); 49
50 # wlr.action("update tmp set i = 3 where i = 1;":str); 50 -
51 # wlr.update("sys":str, "tmp":str, "i":str, 0@0:oid, 3:int); 51 -
52 # wlr.commit(); 52 -
53 # 53 -
54 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000003 54 -
55 # wlr.transaction(3:lng, "2019-08-14T10:03:34.000":str, "monetdb":str); 55 -
56 # wlr.action("insert into tmp values(5,\\'red\\'),(6,\\'fox\\');":str); 56 -
57 # wlr.append("sys":str, "tmp":str, "i":str, 5:int, 6:int); 57 -
58 # wlr.append("sys":str, "tmp":str, "s":str, "red":str, "fox":str); 58 -
59 # wlr.commit(); 59 -
60 # 60 -
61 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000001 61 -
62 # wlr.transaction(1:lng, "2019-08-14T10:03:32.000":str, "monetdb":str); 62 -
63 # wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str); 63 50 # wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str); 50
..................
# wlr.commit();
67 # 67 54 # 54
68 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000005 68 ! 55 /export/scratch1/home/monet/testing/3c6cbe78e1fe-5-1-3/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000004 55
69 # wlr.transaction(5:lng, "2019-08-14T10:03:35.000":str, "monetdb":str); 69 ! 56 # wlr.transaction(4:lng, "2019-09-08T13:17:56.000":str, "monetdb":str); 56
+ 57 # wlr.action("update tmp set i = 3 where i = 1;":str); 57
+ 58 # wlr.update("sys":str, "tmp":str, "i":str, 0@0:oid, 3:int); 58
+ 59 # wlr.commit(); 59
+ 60 # 60
+ 61 /export/scratch1/home/monet/testing/3c6cbe78e1fe-5-1-3/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000005 61
+ 62 # wlr.transaction(5:lng, "2019-09-08T13:17:56.000":str, "monetdb":str); 62
70 # wlr.action("update tmp set s = \\'blah\\';":str); 70 63 # wlr.action("update tmp set s = \\'blah\\';":str); 63
..................
# wlr.commit();
78 # 78 71 # 71
79 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000002 79 ! 72 /export/scratch1/home/monet/testing/3c6cbe78e1fe-5-1-3/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000000 72
80 # wlr.transaction(2:lng, "2019-08-14T10:03:32.000":str, "monetdb":str); 80 ! 73 # wlr.transaction(0:lng, "2019-09-08T13:17:53.000":str, "monetdb":str); 73
+ 74 # wlr.catalog("create table tmp(i int, s string);":str); 74
+ 75 # wlr.commit(); 75
+ 76 # 76
+ 77 /export/scratch1/home/monet/testing/3c6cbe78e1fe-5-1-3/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000003 77
+ 78 # wlr.transaction(3:lng, "2019-09-08T13:17:55.000":str, "monetdb":str); 78
+ 79 # wlr.action("insert into tmp values(5,\\'red\\'),(6,\\'fox\\');":str); 79
+ 80 # wlr.append("sys":str, "tmp":str, "i":str, 5:int, 6:int); 80
+ 81 # wlr.append("sys":str, "tmp":str, "s":str, "red":str, "fox":str); 81
+ 82 # wlr.commit(); 82
+ 83 # 83
+ 84 /export/scratch1/home/monet/testing/3c6cbe78e1fe-5-1-3/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000002 84
+ 85 # wlr.transaction(2:lng, "2019-09-08T13:17:53.000":str, "monetdb":str); 85
81 # wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str); 81 86 # wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str); 86
..................
# wlr.commit();
85 # 85 90 # 90
86 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000000 86 -
87 # wlr.transaction(0:lng, "2019-08-14T10:03:32.000":str, "monetdb":str); 87 -
88 # wlr.catalog("create table tmp(i int, s string);":str); 88 -
89 # wlr.commit(); 89 -
90 # 90 -
91 91 91 91