Test wlr50.py (id 6b3b1396de21) (err)
wlr50.stable.out.FILTERED 2019-09-20 09:30:23.030803377 +0200wlr50.test.out.FILTERED 2019-09-20 09:30:23.040803811 +0200
1 Statistics about stdout of test 'wlr50` in directory 'sql/test/wlcr`: 1 1 Statistics about stdout of test 'wlr50` in directory 'sql/test/wlcr`: 1
2 14 lines, 37 words, 1175 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 17 lines, 46 words, 1322 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 14 lines, 37 words, 1175 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 17 lines, 46 words, 1322 chars in lines not matching '^$|^(\| |)#` 3
4 # 95 lines, 352 words, 4633 chars in all lines 4 ! 4 # 105 lines, 393 words, 4718 chars in all lines 4
5 5 5 5
..................
#select * from tmp;
31 % int, clob # type 31 28 % int, clob # type 28
32 % 1, 0 # length 32 ! 29 % 1, 5 # length 29
/export/scratch1 + 30 [ 1, "hello" ] 30
+ 31 [ 2, "world" ] 31
33 /mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc.config 33 ! 32 /home/monet/testing/6b3b1396de21-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc.config 32
34 #logs=/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/ 34 ! 33 #logs=/home/monet/testing/6b3b1396de21-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/ 33
35 #id=8 35 ! 34 #id=9 34
36 #write=2019-08-14T12:11:28.000 36 ! 35 #write=2019-09-20T09:30:21.000 35
37 #state=1 37 36 #state=1 36
..................
#write=2019-08-14T12:11:28.000
37 #state=1 37 36 #state=1 36
38 #batches=8 38 ! 37 #batches=9 37
39 #beat=0 39 38 #beat=0 38
40 # 40 39 # 39
41 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000004 41 ! 40 /home/monet/testing/6b3b1396de21-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000000 40
42 # wlr.transaction(4:lng, "2019-08-14T12:11:24.000":str, "monetdb":str); 42 ! 41 # wlr.transaction(0:lng, "2019-09-20T09:30:10.000":str, "monetdb":str); 41
43 # wlr.action("update tmp set i = 3 where i = 1;":str); 43 ! 42 # wlr.catalog("create table tmp0(i int, s string);":str); 42
44 # wlr.update("sys":str, "tmp":str, "i":str, 0@0:oid, 3:int); 44 -
45 # wlr.commit(); 45 43 # wlr.commit(); 43
46 # 46 44 # 44
47 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000003 47 ! 45 /home/monet/testing/6b3b1396de21-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000001 45
48 # wlr.transaction(3:lng, "2019-08-14T12:11:21.000":str, "monetdb":str); 48 ! 46 # wlr.transaction(1:lng, "2019-09-20T09:30:10.000":str, "monetdb":str); 46
49 # wlr.action("insert into tmp values(5,\\'red\\'),(6,\\'fox\\');":str); 49 ! 47 # wlr.action("insert into tmp0 values(1,\\'gaap\\'), (2,\\'sleep\\');":str); 47
50 # wlr.append("sys":str, "tmp":str, "i":str, 5:int, 6:int); 50 ! 48 # wlr.append("sys":str, "tmp0":str, "i":str, 1:int, 2:int); 48
51 # wlr.append("sys":str, "tmp":str, "s":str, "red":str, "fox":str); 51 ! 49 # wlr.append("sys":str, "tmp0":str, "s":str, "gaap":str, "sleep":str); 49
52 # wlr.commit(); 52 50 # wlr.commit(); 50
53 # 53 51 # 51
54 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000007 54 ! 52 /home/monet/testing/6b3b1396de21-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000002 52
55 # wlr.transaction(7:lng, "2019-08-14T12:11:28.000":str, "monetdb":str); 55 ! 53 # wlr.transaction(2:lng, "2019-09-20T09:30:10.000":str, "monetdb":str); 53
56 # wlr.action("delete from tmp;":str); 56 ! 54 # wlr.catalog("drop table tmp0;":str); 54
57 # wlr.clear_table("sys":str, "tmp":str); 57 ! 55 # wlr.commit(); 55
+ 56 # wlr.catalog("create table tmp(i int, s string);":str); 56
58 # wlr.commit(); 58 57 # wlr.commit(); 57
59 # 59 -
60 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000001 60 -
61 # wlr.transaction(1:lng, "2019-08-14T12:11:18.000":str, "monetdb":str); 61 -
62 # wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str); 62 58 # wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str); 58
..................
# wlr.commit();
66 # 66 62 # 62
67 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000005 67 ! 63 /home/monet/testing/6b3b1396de21-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000003 63
68 # wlr.transaction(5:lng, "2019-08-14T12:11:24.000":str, "monetdb":str); 68 ! 64 # wlr.transaction(3:lng, "2019-09-20T09:30:11.000":str, "monetdb":str); 64
+ 65 # wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str); 65
+ 66 # wlr.append("sys":str, "tmp":str, "i":str, 3:int, 4:int); 66
+ 67 # wlr.append("sys":str, "tmp":str, "s":str, "blah":str, "bloh":str); 67
+ 68 # wlr.commit(); 68
+ 69 # 69
+ 70 /home/monet/testing/6b3b1396de21-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000004 70
+ 71 # wlr.transaction(4:lng, "2019-09-20T09:30:13.000":str, "monetdb":str); 71
+ 72 # wlr.action("insert into tmp values(5,\\'red\\'),(6,\\'fox\\');":str); 72
+ 73 # wlr.append("sys":str, "tmp":str, "i":str, 5:int, 6:int); 73
+ 74 # wlr.append("sys":str, "tmp":str, "s":str, "red":str, "fox":str); 74
+ 75 # wlr.commit(); 75
+ 76 # 76
+ 77 /home/monet/testing/6b3b1396de21-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000005 77
+ 78 # wlr.transaction(5:lng, "2019-09-20T09:30:16.000":str, "monetdb":str); 78
+ 79 # wlr.action("update tmp set i = 3 where i = 1;":str); 79
+ 80 # wlr.update("sys":str, "tmp":str, "i":str, 0@0:oid, 3:int); 80
+ 81 # wlr.commit(); 81
+ 82 # 82
+ 83 /home/monet/testing/6b3b1396de21-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000006 83
+ 84 # wlr.transaction(6:lng, "2019-09-20T09:30:16.000":str, "monetdb":str); 84
69 # wlr.action("update tmp set s = \\'blah\\';":str); 69 85 # wlr.action("update tmp set s = \\'blah\\';":str); 85
..................
# wlr.commit();
77 # 77 93 # 93
78 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000006 78 ! 94 /home/monet/testing/6b3b1396de21-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000007 94
79 # wlr.transaction(6:lng, "2019-08-14T12:11:26.000":str, "monetdb":str); 79 ! 95 # wlr.transaction(7:lng, "2019-09-20T09:30:18.000":str, "monetdb":str); 95
80 # wlr.action("delete from tmp where i < 4;":str); 80 96 # wlr.action("delete from tmp where i < 4;":str); 96
..................
# wlr.commit();
83 # 83 99 # 99
84 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000002 84 ! 100 /home/monet/testing/6b3b1396de21-6-1-2/tests/sql/dbfarm/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000008 100
85 # wlr.transaction(2:lng, "2019-08-14T12:11:19.000":str, "monetdb":str); 85 ! 101 # wlr.transaction(8:lng, "2019-09-20T09:30:21.000":str, "monetdb":str); 101
86 # wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str); 86 ! 102 # wlr.action("delete from tmp;":str); 102
87 # wlr.append("sys":str, "tmp":str, "i":str, 3:int, 4:int); 87 ! 103 # wlr.clear_table("sys":str, "tmp":str); 103
88 # wlr.append("sys":str, "tmp":str, "s":str, "blah":str, "bloh":str); 88 -
89 # wlr.commit(); 89 -
90 # 90 -
91 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000000 91 -
92 # wlr.transaction(0:lng, "2019-08-14T12:11:18.000":str, "monetdb":str); 92 -
93 # wlr.catalog("create table tmp(i int, s string);":str); 93 -
94 # wlr.commit(); 94 104 # wlr.commit(); 104