Test wlr50.py (id 3c6cbe78e1fe) (err)
wlr50.stable.out.FILTERED 2019-09-08 12:32:50.940875700 +0200wlr50.test.out.FILTERED 2019-09-08 12:32:50.940875700 +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 10 lines, 17 words, 1062 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 14 lines, 37 words, 1175 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 10 lines, 17 words, 1062 chars in lines not matching '^$|^(\| |)#` 3
4 # 95 lines, 352 words, 4633 chars in all lines 4 ! 4 # 117 lines, 469 words, 5037 chars in all lines 4
5 5 5 5
..................
# Listening for UNIX domain connection r
23 # MonetDB/GIS module loaded 23 22 # MonetDB/GIS module loaded 22
24 #replay log file:/export/scratch1/mk/wlcr//Linux/var/MonetDB/mTests_sql_test_wlcr-clone/../mTests_sql_test_wlcr/master/mTests_sql_test_wlcr_000000000018 24 ! 23 # SQL catalog created, loading sql scripts once 23
25 #replay log file:/export/scratch1/mk/wlcr//Linux/var/MonetDB/mTests_sql_test_wlcr-clone/../mTests_sql_test_wlcr/master/mTests_sql_test_wlcr_000000000019 25 ! 24 # loading sql script: 09_like.sql 24
26 #replay log file:/export/scratch1/mk/wlcr//Linux/var/MonetDB/mTests_sql_test_wlcr-clone/../mTests_sql_test_wlcr/master/mTests_sql_test_wlcr_000000000020 26 ! 25 # loading sql script: 10_math.sql 25
+ 26 # loading sql script: 11_times.sql 26
+ 27 # loading sql script: 12_url.sql 27
+ 28 # loading sql script: 13_date.sql 28
+ 29 # loading sql script: 14_inet.sql 29
+ 30 # loading sql script: 15_querylog.sql 30
+ 31 # loading sql script: 16_tracelog.sql 31
+ 32 # loading sql script: 17_temporal.sql 32
+ 33 # loading sql script: 18_index.sql 33
+ 34 # loading sql script: 20_vacuum.sql 34
+ 35 # loading sql script: 21_dependency_views.sql 35
+ 36 # loading sql script: 22_clients.sql 36
+ 37 # loading sql script: 23_skyserver.sql 37
+ 38 # loading sql script: 25_debug.sql 38
+ 39 # loading sql script: 26_sysmon.sql 39
+ 40 # loading sql script: 27_rejects.sql 40
+ 41 # loading sql script: 39_analytics.sql 41
+ 42 # loading sql script: 40_geom.sql 42
+ 43 # loading sql script: 40_json.sql 43
+ 44 # loading sql script: 41_md5sum.sql 44
+ 45 # loading sql script: 45_uuid.sql 45
+ 46 # loading sql script: 46_profiler.sql 46
+ 47 # loading sql script: 51_sys_schema_extension.sql 47
+ 48 # loading sql script: 60_wlcr.sql 48
+ 49 # loading sql script: 75_storagemodel.sql 49
+ 50 # loading sql script: 80_statistics.sql 50
+ 51 # loading sql script: 80_udf.sql 51
+ 52 # loading sql script: 90_generator.sql 52
+ 53 # loading sql script: 99_system.sql 53
27 # MonetDB/SQL module loaded 27 54 # MonetDB/SQL module loaded 54
28 #select * from tmp; 28 ! 55 C:\monettesting\3c6cbe78e1fe-8-1-1\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc.config 55
29 % sys.tmp, sys.tmp # table_name 29 ! 56 #logs=C:\monettesting\3c6cbe78e1fe-8-1-1\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\ 56
30 % i, s # name 30 -
31 % int, clob # type 31 -
32 % 1, 0 # length 32 -
33 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc.config 33 -
34 #logs=/export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/ 34 -
35 #id=8 35 57 #id=8 57
..................
#beat=0
40 # 40 62 # 62
41 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000004 41 ! 63 C:\monettesting\3c6cbe78e1fe-8-1-1\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000000 63
42 # wlr.transaction(4:lng, "2019-08-14T12:11:24.000":str, "monetdb":str); 42 ! 64 # wlr.transaction(0:lng, "2019-09-09T02:32:37.000":str, "monetdb":str); 64
43 # wlr.action("update tmp set i = 3 where i = 1;":str); 43 ! 65 # wlr.catalog("create table tmp(i int, s string);":str); 65
44 # wlr.update("sys":str, "tmp":str, "i":str, 0@0:oid, 3:int); 44 -
45 # wlr.commit(); 45 66 # wlr.commit(); 66
46 # 46 67 # 67
47 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000003 47 ! 68 C:\monettesting\3c6cbe78e1fe-8-1-1\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000001 68
48 # wlr.transaction(3:lng, "2019-08-14T12:11:21.000":str, "monetdb":str); 48 ! 69 # wlr.transaction(1:lng, "2019-09-09T02:32:37.000":str, "monetdb":str); 69
+ 70 # wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str); 70
+ 71 # wlr.append("sys":str, "tmp":str, "i":str, 1:int, 2:int); 71
+ 72 # wlr.append("sys":str, "tmp":str, "s":str, "hello":str, "world":str); 72
+ 73 # wlr.commit(); 73
+ 74 # 74
+ 75 C:\monettesting\3c6cbe78e1fe-8-1-1\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000002 75
+ 76 # wlr.transaction(2:lng, "2019-09-09T02:32:39.000":str, "monetdb":str); 76
+ 77 # wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str); 77
+ 78 # wlr.append("sys":str, "tmp":str, "i":str, 3:int, 4:int); 78
+ 79 # wlr.append("sys":str, "tmp":str, "s":str, "blah":str, "bloh":str); 79
+ 80 # wlr.commit(); 80
+ 81 # 81
+ 82 C:\monettesting\3c6cbe78e1fe-8-1-1\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000003 82
+ 83 # wlr.transaction(3:lng, "2019-09-09T02:32:41.000":str, "monetdb":str); 83
49 # wlr.action("insert into tmp values(5,\\'red\\'),(6,\\'fox\\');":str); 49 84 # wlr.action("insert into tmp values(5,\\'red\\'),(6,\\'fox\\');":str); 84
..................
# wlr.commit();
53 # 53 88 # 88
54 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000007 54 ! 89 C:\monettesting\3c6cbe78e1fe-8-1-1\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000004 89
55 # wlr.transaction(7:lng, "2019-08-14T12:11:28.000":str, "monetdb":str); 55 ! 90 # wlr.transaction(4:lng, "2019-09-09T02:32:42.000":str, "monetdb":str); 90
56 # wlr.action("delete from tmp;":str); 56 ! 91 # wlr.action("update tmp set i = 3 where i = 1;":str); 91
57 # wlr.clear_table("sys":str, "tmp":str); 57 ! 92 # wlr.update("sys":str, "tmp":str, "i":str, 0@0:oid, 3:int); 92
58 # wlr.commit(); 58 -
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 -
63 # wlr.append("sys":str, "tmp":str, "i":str, 1:int, 2:int); 63 -
64 # wlr.append("sys":str, "tmp":str, "s":str, "hello":str, "world":str); 64 -
65 # wlr.commit(); 65 93 # wlr.commit(); 93
66 # 66 94 # 94
67 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000005 67 ! 95 C:\monettesting\3c6cbe78e1fe-8-1-1\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000005 95
68 # wlr.transaction(5:lng, "2019-08-14T12:11:24.000":str, "monetdb":str); 68 ! 96 # wlr.transaction(5:lng, "2019-09-09T02:32:43.000":str, "monetdb":str); 96
69 # wlr.action("update tmp set s = \\'blah\\';":str); 69 97 # wlr.action("update tmp set s = \\'blah\\';":str); 97
..................
# wlr.commit();
77 # 77 105 # 105
78 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000006 78 ! 106 C:\monettesting\3c6cbe78e1fe-8-1-1\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000006 106
79 # wlr.transaction(6:lng, "2019-08-14T12:11:26.000":str, "monetdb":str); 79 ! 107 # wlr.transaction(6:lng, "2019-09-09T02:32:45.000":str, "monetdb":str); 107
80 # wlr.action("delete from tmp where i < 4;":str); 80 108 # wlr.action("delete from tmp where i < 4;":str); 108
..................
# wlr.commit();
83 # 83 111 # 111
84 /export/scratch1/mk/branches/default//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000002 84 ! 112 C:\monettesting\3c6cbe78e1fe-8-1-1\tests\sql\dbfarm\mTests_sql_test_wlcr\wlc_logs\mTests_sql_test_wlcr_000000000007 112
85 # wlr.transaction(2:lng, "2019-08-14T12:11:19.000":str, "monetdb":str); 85 ! 113 # wlr.transaction(7:lng, "2019-09-09T02:32:47.000":str, "monetdb":str); 113
86 # wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str); 86 ! 114 # wlr.action("delete from tmp;":str); 114
87 # wlr.append("sys":str, "tmp":str, "i":str, 3:int, 4:int); 87 ! 115 # wlr.clear_table("sys":str, "tmp":str); 115
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 116 # wlr.commit(); 116