Test wlc50.py (id 3c6cbe78e1fe) (err)
wlc50.stable.out.FILTERED 2019-09-08 12:40:09.000000000 +0200wlc50.test.out.FILTERED 2019-09-08 12:40:09.000000000 +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, 1189 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 15 lines, 40 words, 1180 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 15 lines, 40 words, 1189 chars in lines not matching '^$|^(\| |)#` 3
4 # 94 lines, 349 words, 4193 chars in all lines 4 ! 4 # 94 lines, 353 words, 4236 chars in all lines 4
5 5 5 5
..................
#select * from tmp;
31 % 1, 0 # length 31 31 % 1, 0 # length 31
32 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc.config 32 ! 32 /Users/monet/scratch/3c6cbe78e1fe-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc.config 32
33 #logs=/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/ 33 ! 33 #logs=/Users/monet/scratch/3c6cbe78e1fe-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/ 33
34 #id=8 34 34 #id=8 34
..................
#beat=0
39 # 39 39 # 39
40 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000004 40 ! 40 /Users/monet/scratch/3c6cbe78e1fe-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000000 40
41 # wlr.transaction(4:lng, "2019-08-14T10:03:35.000":str, "monetdb":str); 41 ! 41 # wlr.transaction(0:lng, "2019-09-08T12:40:02.000":str, "monetdb":str); 41
42 # wlr.action("update tmp set i = 3 where i = 1;":str); 42 ! 42 # wlr.catalog("create table tmp(i int, s string);":str); 42
43 # wlr.update("sys":str, "tmp":str, "i":str, 0@0:oid, 3:int); 43 -
44 # wlr.commit(); 44 43 # wlr.commit(); 43
45 # 45 44 # 44
46 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000003 46 ! 45 /Users/monet/scratch/3c6cbe78e1fe-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000001 45
47 # wlr.transaction(3:lng, "2019-08-14T10:03:34.000":str, "monetdb":str); 47 ! 46 # wlr.transaction(1:lng, "2019-09-08T12:40:02.000":str, "monetdb":str); 46
+ 47 # wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str); 47
+ 48 # wlr.append("sys":str, "tmp":str, "i":str, 1:int, 2:int); 48
+ 49 # wlr.append("sys":str, "tmp":str, "s":str, "hello":str, "world":str); 49
+ 50 # wlr.commit(); 50
+ 51 # 51
+ 52 /Users/monet/scratch/3c6cbe78e1fe-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000002 52
+ 53 # wlr.transaction(2:lng, "2019-09-08T12:40:03.000":str, "monetdb":str); 53
+ 54 # wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str); 54
+ 55 # wlr.append("sys":str, "tmp":str, "i":str, 3:int, 4:int); 55
+ 56 # wlr.append("sys":str, "tmp":str, "s":str, "blah":str, "bloh":str); 56
+ 57 # wlr.commit(); 57
+ 58 # 58
+ 59 /Users/monet/scratch/3c6cbe78e1fe-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000003 59
+ 60 # wlr.transaction(3:lng, "2019-09-08T12:40:04.000":str, "monetdb":str); 60
48 # wlr.action("insert into tmp values(5,\\'red\\'),(6,\\'fox\\');":str); 48 61 # wlr.action("insert into tmp values(5,\\'red\\'),(6,\\'fox\\');":str); 61
..................
# wlr.commit();
52 # 52 65 # 65
53 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000007 53 ! 66 /Users/monet/scratch/3c6cbe78e1fe-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000004 66
54 # wlr.transaction(7:lng, "2019-08-14T10:03:38.000":str, "monetdb":str); 54 ! 67 # wlr.transaction(4:lng, "2019-09-08T12:40:06.000":str, "monetdb":str); 67
55 # wlr.action("delete from tmp;":str); 55 ! 68 # wlr.action("update tmp set i = 3 where i = 1;":str); 68
56 # wlr.clear_table("sys":str, "tmp":str); 56 ! 69 # wlr.update("sys":str, "tmp":str, "i":str, 0@0:oid, 3:int); 69
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 70 # wlr.commit(); 70
65 # 65 71 # 71
66 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000005 66 ! 72 /Users/monet/scratch/3c6cbe78e1fe-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000005 72
67 # wlr.transaction(5:lng, "2019-08-14T10:03:35.000":str, "monetdb":str); 67 ! 73 # wlr.transaction(5:lng, "2019-09-08T12:40:06.000":str, "monetdb":str); 73
68 # wlr.action("update tmp set s = \\'blah\\';":str); 68 74 # wlr.action("update tmp set s = \\'blah\\';":str); 74
..................
# wlr.commit();
76 # 76 82 # 82
77 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000006 77 ! 83 /Users/monet/scratch/3c6cbe78e1fe-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000006 83
78 # wlr.transaction(6:lng, "2019-08-14T10:03:36.000":str, "monetdb":str); 78 ! 84 # wlr.transaction(6:lng, "2019-09-08T12:40:07.000":str, "monetdb":str); 84
79 # wlr.action("delete from tmp where i < 4;":str); 79 85 # wlr.action("delete from tmp where i < 4;":str); 85
..................
# wlr.commit();
82 # 82 88 # 88
83 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000002 83 ! 89 /Users/monet/scratch/3c6cbe78e1fe-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000007 89
84 # wlr.transaction(2:lng, "2019-08-14T10:03:32.000":str, "monetdb":str); 84 ! 90 # wlr.transaction(7:lng, "2019-09-08T12:40:08.000":str, "monetdb":str); 90
85 # wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str); 85 ! 91 # wlr.action("delete from tmp;":str); 91
86 # wlr.append("sys":str, "tmp":str, "i":str, 3:int, 4:int); 86 ! 92 # wlr.clear_table("sys":str, "tmp":str); 92
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 93 # wlr.commit(); 93