Test wlc70.py (id f56b8f83e70a) (err)
wlc70.stable.out.FILTERED 2019-09-11 20:23:39.360263500 +0200wlc70.test.out.FILTERED 2019-09-11 20:23:39.360263500 +0200
1 Statistics about stdout of test 'wlc70` in directory 'sql/test/wlcr`: 1 1 Statistics about stdout of test 'wlc70` in directory 'sql/test/wlcr`: 1
2 8 lines, 39 words, 173 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 1 lines, 8 words, 59 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 8 lines, 39 words, 173 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 1 lines, 8 words, 59 chars in lines not matching '^$|^(\| |)#` 3
4 # 109 lines, 406 words, 4987 chars in all lines 4 ! 4 # 23 lines, 100 words, 677 chars in all lines 4
5 5 5 5
..................
# MonetDB 5 server v11.26.0
14 # This is an unreleased version 14 14 # This is an unreleased version 14
15 # Serving database 'mTests_sql_test_wlcr', using 8 threads 15 ! 15 # Serving database 'mTests_sql_test_wlcr', using 6 threads 15
16 # Compiled for x86_64-unknown-linux-gnu/64bit with 128bit integers 16 ! 16 # Compiled for x86_64-pc-winnt/64bit 16
17 # Found 15.589 GiB available main-memory. 17 ! 17 # Found 29.999 GiB available main-memory. 17
18 # Copyright (c) 1993-July 2008 CWI. 18 ! 18 # Copyright (c) 1993 - July 2008 CWI. 18
19 # Copyright (c) August 2008-2017 MonetDB B.V., all rights reserved 19 ! 19 # Copyright (c) August 2008 - 2019 MonetDB B.V., all rights reserved 19
20 # Visit http://www.monetdb.org/ for further information 20 ! 20 # Visit https://www.monetdb.org/ for further information 20
21 # Listening for connection requests on mapi:monetdb://vienna.da.cwi.nl:38889/ 21 ! 21 # Listening for connection requests on mapi:monetdb://win2k12r2:34813/ 21
22 # Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-1561/.s.monetdb.38889 22 -
23 # MonetDB/GIS module loaded 23 22 # MonetDB/GIS module loaded 22
24 # MonetDB/SQL module loaded 24 23 # MonetDB/SQL module loaded 23
25 #create table tmp2(i int, s string); 25 ! 24 24
26 #insert into tmp2 values(1,'hello'), (2,'world'); 26 ! 25 # 20:23:39 > 25
27 [ 2 ] 27 ! 26 # 20:23:39 > "Done." 26
28 #select * from tmp70; 28 ! 27 # 20:23:39 > 27
29 % sys.tmp70, sys.tmp70 # table_name 29 -
30 % i, s # name 30 -
31 % int, clob # type 31 -
32 % 1, 5 # length 32 -
33 [ 1, "hello" ] 33 -
34 [ 2, "world" ] 34 -
35 #/export/scratch1/mk/branches/Nov2019//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc.config 35 -
36 #logs=/export/scratch1/mk/branches/Nov2019//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/ 36 -
37 #id=10 37 -
38 #write=2019-08-14T10:05:49.000 38 -
39 #state=1 39 -
40 #batches=10 40 -
41 #beat=0 41 -
42 # 42 -
43 #/export/scratch1/mk/branches/Nov2019//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000008 43 -
44 # wlr.transaction(8:lng, "2019-09-07T22:18:04.000":str, "monetdb":str); 44 -
45 # wlr.catalog("create table tmp70(i int, s string);":str); 45 -
46 # wlr.commit(); 46 -
47 # 47 -
48 #/export/scratch1/mk/branches/Nov2019//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000004 48 -
49 # wlr.transaction(4:lng, "2019-09-07T22:17:59.000":str, "monetdb":str); 49 -
50 # wlr.action("update tmp set i = 3 where i = 1;":str); 50 -
51 # wlr.update("sys":str, "tmp":str, "i":str, 0@0:oid, 3:int); 51 -
52 # wlr.commit(); 52 -
53 # 53 -
54 #/export/scratch1/mk/branches/Nov2019//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000003 54 -
55 # wlr.transaction(3:lng, "2019-09-07T22:17:58.000":str, "monetdb":str); 55 -
56 # wlr.action("insert into tmp values(5,\\'red\\'),(6,\\'fox\\');":str); 56 -
57 # wlr.append("sys":str, "tmp":str, "i":str, 5:int, 6:int); 57 -
58 # wlr.append("sys":str, "tmp":str, "s":str, "red":str, "fox":str); 58 -
59 # wlr.commit(); 59 -
60 # 60 -
61 #/export/scratch1/mk/branches/Nov2019//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000009 61 -
62 # wlr.transaction(9:lng, "2019-09-07T22:18:04.000":str, "monetdb":str); 62 -
63 # wlr.action("insert into tmp70 values(1,\\'hello\\'), (2,\\'world\\');":str); 63 -
64 # wlr.append("sys":str, "tmp70":str, "i":str, 1:int, 2:int); 64 -
65 # wlr.append("sys":str, "tmp70":str, "s":str, "hello":str, "world":str); 65 -
66 # wlr.commit(); 66 -
67 # 67 -
68 #/export/scratch1/mk/branches/Nov2019//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000007 68 -
69 # wlr.transaction(7:lng, "2019-09-07T22:18:02.000":str, "monetdb":str); 69 -
70 # wlr.action("delete from tmp;":str); 70 -
71 # wlr.clear_table("sys":str, "tmp":str); 71 -
72 # wlr.commit(); 72 -
73 # 73 -
74 #/export/scratch1/mk/branches/Nov2019//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000001 74 -
75 # wlr.transaction(1:lng, "2019-09-07T22:17:55.000":str, "monetdb":str); 75 -
76 # wlr.action("insert into tmp values(1,\\'hello\\'), (2,\\'world\\');":str); 76 -
77 # wlr.append("sys":str, "tmp":str, "i":str, 1:int, 2:int); 77 -
78 # wlr.append("sys":str, "tmp":str, "s":str, "hello":str, "world":str); 78 -
79 # wlr.commit(); 79 -
80 # 80 -
81 #/export/scratch1/mk/branches/Nov2019//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000005 81 -
82 # wlr.transaction(5:lng, "2019-09-07T22:17:59.000":str, "monetdb":str); 82 -
83 # wlr.action("update tmp set s = \\'blah\\';":str); 83 -
84 # wlr.update("sys":str, "tmp":str, "s":str, 0@0:oid, "blah":str); 84 -
85 # wlr.update("sys":str, "tmp":str, "s":str, 1@0:oid, "blah":str); 85 -
86 # wlr.update("sys":str, "tmp":str, "s":str, 2@0:oid, "blah":str); 86 -
87 # wlr.update("sys":str, "tmp":str, "s":str, 3@0:oid, "blah":str); 87 -
88 # wlr.update("sys":str, "tmp":str, "s":str, 4@0:oid, "blah":str); 88 -
89 # wlr.update("sys":str, "tmp":str, "s":str, 5@0:oid, "blah":str); 89 -
90 # wlr.commit(); 90 -
91 # 91 -
92 #/export/scratch1/mk/branches/Nov2019//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000006 92 -
93 # wlr.transaction(6:lng, "2019-09-07T22:18:00.000":str, "monetdb":str); 93 -
94 # wlr.action("delete from tmp where i < 4;":str); 94 -
95 # wlr.delete("sys":str, "tmp":str, 0@0:oid, 0@0:oid, 0@0:oid); 95 -
96 # wlr.commit(); 96 -
97 # 97 -
98 #/export/scratch1/mk/branches/Nov2019//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000002 98 -
99 # wlr.transaction(2:lng, "2019-09-07T22:17:56.000":str, "monetdb":str); 99 -
100 # wlr.action("insert into tmp values(3,\\'blah\\'),(4,\\'bloh\\');":str); 100 -
101 # wlr.append("sys":str, "tmp":str, "i":str, 3:int, 4:int); 101 -
102 # wlr.append("sys":str, "tmp":str, "s":str, "blah":str, "bloh":str); 102 -
103 # wlr.commit(); 103 -
104 # 104 -
105 #/export/scratch1/mk/branches/Nov2019//Linux/var/MonetDB/mTests_sql_test_wlcr/wlc_logs/mTests_sql_test_wlcr_000000000000 105 -
106 # wlr.transaction(0:lng, "2019-09-07T22:17:55.000":str, "monetdb":str); 106 -
107 # wlr.catalog("create table tmp(i int, s string);":str); 107 -
108 # wlr.commit(); 108 -
109 # 109 -
110 110 -
111 # 12:34:12 > 111 -
112 # 12:34:12 > "Done." 112 -
113 # 12:34:12 > 113 -
114 114 28 28