Test wlc21.py (id 3c6cbe78e1fe) (err)
wlc21.stable.out.FILTERED 2019-09-08 13:52:25.521806100 +0200wlc21.test.out.FILTERED 2019-09-08 13:52:25.521806100 +0200
1 Statistics about stdout of test 'wlc21` in directory 'sql/test/wlcr`: 1 1 Statistics about stdout of test 'wlc21` in directory 'sql/test/wlcr`: 1
2 17 lines, 60 words, 782 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 17 lines, 60 words, 762 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 17 lines, 60 words, 782 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 17 lines, 60 words, 762 chars in lines not matching '^$|^(\| |)#` 3
4 # 71 lines, 261 words, 2729 chars in all lines 4 ! 4 # 70 lines, 253 words, 2577 chars in all lines 4
5 5 5 5
..................
#select * from tmp;
37 [ 6, "fox" ] 37 36 [ 6, "fox" ] 36
38 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc.config 38 ! 37 C:\monettesting\3c6cbe78e1fe-8-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc.config 37
39 #logs=/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/ 39 ! 38 #logs=C:\monettesting\3c6cbe78e1fe-8-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\ 38
40 #id=4 40 39 #id=4 39
..................
#beat=0
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 C:\monettesting\3c6cbe78e1fe-8-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000000 45
47 # wlr.transaction(3:lng, "2019-08-14T10:03:34.000":str, "monetdb":str); 47 ! 46 # wlr.transaction(0:lng, "2019-09-09T02:52:21.000":str, "monetdb":str); 46
48 # wlr.action("insert into tmp values(5,\\'red\\'),(6,\\'fox\\');":str); 48 ! 47 # wlr.catalog("create table tmp(i int, s string);":str); 47
49 # wlr.append("sys":str, "tmp":str, "i":str, 5:int, 6:int); 49 -
50 # wlr.append("sys":str, "tmp":str, "s":str, "red":str, "fox":str); 50 -
51 # wlr.commit(); 51 48 # wlr.commit(); 48
52 # 52 49 # 49
53 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000001 53 ! 50 C:\monettesting\3c6cbe78e1fe-8-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000001 50
54 # wlr.transaction(1:lng, "2019-08-14T10:03:32.000":str, "monetdb":str); 54 ! 51 # wlr.transaction(1:lng, "2019-09-09T02:52:21.000":str, "monetdb":str); 51
55 # wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str); 55 52 # wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str); 52
..................
# wlr.commit();
59 # 59 56 # 56
60 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000002 60 ! 57 C:\monettesting\3c6cbe78e1fe-8-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000002 57
61 # wlr.transaction(2:lng, "2019-08-14T10:03:32.000":str, "monetdb":str); 61 ! 58 # wlr.transaction(2:lng, "2019-09-09T02:52:23.000":str, "monetdb":str); 58
62 # wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str); 62 59 # wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str); 59
..................
# wlr.commit();
66 # 66 63 # 63
67 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000000 67 ! 64 C:\monettesting\3c6cbe78e1fe-8-1-2\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000003 64
68 # wlr.transaction(0:lng, "2019-08-14T10:03:32.000":str, "monetdb":str); 68 ! 65 # wlr.transaction(3:lng, "2019-09-09T02:52:24.000":str, "monetdb":str); 65
69 # wlr.catalog("create table tmp(i int, s string);":str); 69 ! 66 # wlr.action("insert into tmp values(5,\\'red\\'),(6,\\'fox\\');":str); 66
+ 67 # wlr.append("sys":str, "tmp":str, "i":str, 5:int, 6:int); 67
+ 68 # wlr.append("sys":str, "tmp":str, "s":str, "red":str, "fox":str); 68
70 # wlr.commit(); 70 69 # wlr.commit(); 69