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