Test string.sql (id 257bc073dc33) (err)
string.stable.out.FILTERED 2019-12-02 19:42:49.577740700 +0100string.test.out.FILTERED 2019-12-02 19:42:50.997343200 +0100
1 Statistics about stdout of test 'string` in directory 'sql/test`: 1 1 Statistics about stdout of test 'string` in directory 'sql/test`: 1
2 234 lines, 1224 words, 4881 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 2 lines, 17 words, 108 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 234 lines, 1224 words, 4881 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 2 lines, 17 words, 108 chars in lines not matching '^$|^(\| |)#` 3
4 # 345 lines, 1800 words, 9283 chars in all lines 4 ! 4 # 27 lines, 127 words, 1004 chars in all lines 4
5 5 5 5
..................
# 345 lines, 1800 words,
8 8 8 8
9 # 16:38:09 > 9 ! 9 # 19:41:44 > 9
10 # 16:38:09 > Mserver "--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set "monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB4/bin" --set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/dbfarm" --set "sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/sql_logs" --set "xquery_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB4/xquery_logs" --set mapi_open=true --set xrpc_open=true --set mapi_port=39708 --set xrpc_port=42376 --set monet_prompt= --trace "--dbname=mTests_src_test" "--dbinit= module(sql_server);" ; echo ; echo Over.. 10 ! 10 # 19:41:44 > "mserver5" "--debug=0" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=34655" "--forcemito" "--dbpath=C:\monettesting\257bc073dc33-2-1-1\tests\sql\dbfarm\mTests_sql_test" "--set" "embedded_c=true" 10
11 # 16:38:09 > 11 ! 11 # 19:41:44 > 11
12 12 ! 12 12
13 13 ! 13 # MonetDB 5 server v11.35.4 13
14 14 ! 14 # This is an unreleased version 14
15 # MonetDB server v5.3.0, based on kernel v1.21.0 15 ! 15 # Serving database 'mTests_sql_test', using 4 threads 15
16 # Serving database 'mTests_src_test' 16 ! 16 # Compiled for i686-pc-winnt/32bit 16
17 # Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked 17 ! 17 # Found 11.991 GiB available main-memory of which we use 1.500 GiB 17
18 # Copyright (c) 1993-2007 CWI, all rights reserved 18 ! 18 # Copyright (c) 1993 - July 2008 CWI. 18
19 # Visit http://monetdb.cwi.nl/ for further information 19 ! 19 # Copyright (c) August 2008 - 2019 MonetDB B.V., all rights reserved 19
20 # Listening for connection requests on mapi:monetdb://amelia.ins.cwi.nl:34553/ 20 ! 20 # Visit https://www.monetdb.org/ for further information 20
21 # MonetDB/SQL module v2.21.0 loaded 21 ! 21 # Listening for connection requests on mapi:monetdb://lab03:34655/ 21
22 22 ! 22 # MonetDB/GIS module loaded 22
23 #function user.main():void; 23 ! 23 # still reading write-ahead log "C:\monettesting\257bc073dc33-2-1-1\tests\sql\dbfarm\mTests_sql_test\sql_logs\sql\log.85" (3% done) 23
24 # clients.quit(); 24 ! 24 24
25 #end main; 25 ! 25 25
26 26 ! 26 ! Server not ready; skipping attempt to start client! 26
27 27 ! 27 27
28 # 12:30:46 > 28 ! 28 28
29 # 12:30:46 > mclient -lsql -umonetdb -Pmonetdb --host=amelia --port=31025 29 ! 29 # 19:42:48 > 29
30 # 12:30:46 > 30 ! 30 # 19:42:48 > "Done." 30
31 31 ! 31 # 19:42:48 > 31
32 [ 1 ] 32 -
33 [ 1 ] 33 -
34 [ 1 ] 34 -
35 [ 1 ] 35 -
36 % sys.stringtest, sys.stringtest # table_name 36 -
37 % str, str2 # name 37 -
38 % varchar, varchar # type 38 -
39 % 6, 4 # length 39 -
40 [ "", "test" ] 40 -
41 [ "test", "" ] 41 -
42 [ "", "" ] 42 -
43 [ " Test ", "" ] 43 -
44 #select length(str), str from stringtest; 44 -
45 % sys., sys.stringtest # table_name 45 -
46 # sys.L2, sys.stringtest # table_name 46 -
47 % L, str # name 47 -
48 # L2, str # name 48 -
49 % int, varchar # type 49 -
50 % 1, 6 # length 50 -
51 [ 0, "" ] 51 -
52 [ 4, "test" ] 52 -
53 [ 0, "" ] 53 -
54 [ 6, " Test " ] 54 -
55 #select substring(str from 2 for 8), str2 from stringtest; 55 -
56 % sys., sys.stringtest # table_name 56 -
57 # sys.L2, sys.stringtest # table_name 57 -
58 % L, str2 # name 58 -
59 # L2, str2 # name 59 -
60 % clob, varchar # type 60 -
61 % 5, 4 # length 61 -
62 [ "", "test" ] 62 -
63 [ "est", "" ] 63 -
64 [ "", "" ] 64 -
65 [ "Test ", "" ] 65 -
66 #select substring(str, 2, 8), str2 from stringtest; 66 -
67 % sys., sys.stringtest # table_name 67 -
68 # sys.L2, sys.stringtest # table_name 68 -
69 % L, str2 # name 69 -
70 # L2, str2 # name 70 -
71 % clob, varchar # type 71 -
72 % 5, 4 # length 72 -
73 [ "", "test" ] 73 -
74 [ "est", "" ] 74 -
75 [ "", "" ] 75 -
76 [ "Test ", "" ] 76 -
77 #select substring(str from 2 for 1), str2 from stringtest; 77 -
78 % sys., sys.stringtest # table_name 78 -
79 # sys.L2, sys.stringtest # table_name 79 -
80 % L, str2 # name 80 -
81 # L2, str2 # name 81 -
82 % clob, varchar # type 82 -
83 % 1, 4 # length 83 -
84 [ "", "test" ] 84 -
85 [ "e", "" ] 85 -
86 [ "", "" ] 86 -
87 [ "T", "" ] 87 -
88 #select substring(str, 2, 1), str2 from stringtest; 88 -
89 % sys., sys.stringtest # table_name 89 -
90 # sys.L2, sys.stringtest # table_name 90 -
91 % L, str2 # name 91 -
92 # L2, str2 # name 92 -
93 % clob, varchar # type 93 -
94 % 1, 4 # length 94 -
95 [ "", "test" ] 95 -
96 [ "e", "" ] 96 -
97 [ "", "" ] 97 -
98 [ "T", "" ] 98 -
99 #select substring(str from 2), str2 from stringtest; 99 -
100 % sys., sys.stringtest # table_name 100 -
101 # sys.L2, sys.stringtest # table_name 101 -
102 % L, str2 # name 102 -
103 # L2, str2 # name 103 -
104 % varchar, varchar # type 104 -
105 % 5, 4 # length 105 -
106 [ "", "test" ] 106 -
107 [ "est", "" ] 107 -
108 [ "", "" ] 108 -
109 [ "Test ", "" ] 109 -
110 #select substring(str, 2), str2 from stringtest; 110 -
111 % sys., sys.stringtest # table_name 111 -
112 # sys.L2, sys.stringtest # table_name 112 -
113 % L, str2 # name 113 -
114 # L2, str2 # name 114 -
115 % varchar, varchar # type 115 -
116 % 5, 4 # length 116 -
117 [ "", "test" ] 117 -
118 [ "est", "" ] 118 -
119 [ "", "" ] 119 -
120 [ "Test ", "" ] 120 -
121 #select position(str in str2), str, str2 from stringtest; 121 -
122 % sys., sys.stringtest, sys.stringtest # table_name 122 -
123 # sys.L2, sys.stringtest, sys.stringtest # table_name 123 -
124 % L, str, str2 # name 124 -
125 # L2, str, str2 # name 125 -
126 % int, varchar, varchar # type 126 -
127 % 1, 6, 4 # length 127 -
128 [ 1, "", "test" ] 128 -
129 [ 0, "test", "" ] 129 -
130 [ 1, "", "" ] 130 -
131 [ 0, " Test ", "" ] 131 -
132 #select locate(str,str2), str, str2 from stringtest; 132 -
133 % sys., sys.stringtest, sys.stringtest # table_name 133 -
134 # sys.L2, sys.stringtest, sys.stringtest # table_name 134 -
135 % L, str, str2 # name 135 -
136 # L2, str, str2 # name 136 -
137 % int, varchar, varchar # type 137 -
138 % 1, 6, 4 # length 138 -
139 [ 1, "", "test" ] 139 -
140 [ 0, "test", "" ] 140 -
141 [ 1, "", "" ] 141 -
142 [ 0, " Test ", "" ] 142 -
143 #select ascii(str), str from stringtest; 143 -
144 % sys., sys.stringtest # table_name 144 -
145 # sys.L2, sys.stringtest # table_name 145 -
146 % L, str # name 146 -
147 # L2, str # name 147 -
148 % int, varchar # type 148 -
149 % 3, 6 # length 149 -
150 [ NULL, "" ] 150 -
151 [ 116, "test" ] 151 -
152 [ NULL, "" ] 152 -
153 [ 32, " Test " ] 153 -
154 #select code(ascii(str)), str from stringtest; 154 -
155 % sys., sys.stringtest # table_name 155 -
156 # sys.L2, sys.stringtest # table_name 156 -
157 % L, str # name 157 -
158 # L2, str # name 158 -
159 % char, varchar # type 159 -
160 % 1, 6 # length 160 -
161 [ NULL, "" ] 161 -
162 [ "t", "test" ] 162 -
163 [ NULL, "" ] 163 -
164 [ " ", " Test " ] 164 -
165 #select left(str,3), str from stringtest; 165 -
166 % sys., sys.stringtest # table_name 166 -
167 # sys.L2, sys.stringtest # table_name 167 -
168 % L, str # name 168 -
169 # L2, str # name 169 -
170 % varchar, varchar # type 170 -
171 % 3, 6 # length 171 -
172 [ "", "" ] 172 -
173 [ "tes", "test" ] 173 -
174 [ "", "" ] 174 -
175 [ " Te", " Test " ] 175 -
176 #select right(str,3), str from stringtest; 176 -
177 % sys., sys.stringtest # table_name 177 -
178 # sys.L2, sys.stringtest # table_name 178 -
179 % L, str # name 179 -
180 # L2, str # name 180 -
181 % varchar, varchar # type 181 -
182 % 3, 6 # length 182 -
183 [ "", "" ] 183 -
184 [ "est", "test" ] 184 -
185 [ "", "" ] 185 -
186 [ "st ", " Test " ] 186 -
187 #select lower(str), str from stringtest; 187 -
188 % sys., sys.stringtest # table_name 188 -
189 # sys.L2, sys.stringtest # table_name 189 -
190 % L, str # name 190 -
191 # L2, str # name 191 -
192 % varchar, varchar # type 192 -
193 % 6, 6 # length 193 -
194 [ "", "" ] 194 -
195 [ "test", "test" ] 195 -
196 [ "", "" ] 196 -
197 [ " test ", " Test " ] 197 -
198 #select lcase(str), str from stringtest; 198 -
199 % sys., sys.stringtest # table_name 199 -
200 # sys.L2, sys.stringtest # table_name 200 -
201 % L, str # name 201 -
202 # L2, str # name 202 -
203 % varchar, varchar # type 203 -
204 % 6, 6 # length 204 -
205 [ "", "" ] 205 -
206 [ "test", "test" ] 206 -
207 [ "", "" ] 207 -
208 [ " test ", " Test " ] 208 -
209 #select upper(str), str from stringtest; 209 -
210 % sys., sys.stringtest # table_name 210 -
211 # sys.L2, sys.stringtest # table_name 211 -
212 % L, str # name 212 -
213 # L2, str # name 213 -
214 % varchar, varchar # type 214 -
215 % 6, 6 # length 215 -
216 [ "", "" ] 216 -
217 [ "TEST", "test" ] 217 -
218 [ "", "" ] 218 -
219 [ " TEST ", " Test " ] 219 -
220 #select ucase(str), str from stringtest; 220 -
221 % sys., sys.stringtest # table_name 221 -
222 # sys.L2, sys.stringtest # table_name 222 -
223 % L, str # name 223 -
224 # L2, str # name 224 -
225 % varchar, varchar # type 225 -
226 % 6, 6 # length 226 -
227 [ "", "" ] 227 -
228 [ "TEST", "test" ] 228 -
229 [ "", "" ] 229 -
230 [ " TEST ", " Test " ] 230 -
231 #select trim(str), str from stringtest; 231 -
232 % sys., sys.stringtest # table_name 232 -
233 # sys.L2, sys.stringtest # table_name 233 -
234 % L, str # name 234 -
235 # L2, str # name 235 -
236 % varchar, varchar # type 236 -
237 % 4, 6 # length 237 -
238 [ "", "" ] 238 -
239 [ "test", "test" ] 239 -
240 [ "", "" ] 240 -
241 [ "Test", " Test " ] 241 -
242 #select ltrim(str), str from stringtest; 242 -
243 % sys., sys.stringtest # table_name 243 -
244 # sys.L2, sys.stringtest # table_name 244 -
245 % L, str # name 245 -
246 # L2, str # name 246 -
247 % varchar, varchar # type 247 -
248 % 5, 6 # length 248 -
249 [ "", "" ] 249 -
250 [ "test", "test" ] 250 -
251 [ "", "" ] 251 -
252 [ "Test ", " Test " ] 252 -
253 #select rtrim(str), str from stringtest; 253 -
254 % sys., sys.stringtest # table_name 254 -
255 # sys.L2, sys.stringtest # table_name 255 -
256 % L, str # name 256 -
257 # L2, str # name 257 -
258 % varchar, varchar # type 258 -
259 % 5, 6 # length 259 -
260 [ "", "" ] 260 -
261 [ "test", "test" ] 261 -
262 [ "", "" ] 262 -
263 [ " Test", " Test " ] 263 -
264 #select insert(str,2,4,str2), str, str2 from stringtest; 264 -
265 % sys., sys.stringtest, sys.stringtest # table_name 265 -
266 # sys.L2, sys.stringtest, sys.stringtest # table_name 266 -
267 % L, str, str2 # name 267 -
268 # L2, str, str2 # name 268 -
269 % clob, varchar, varchar # type 269 -
270 % 4, 6, 4 # length 270 -
271 [ "test", "", "test" ] 271 -
272 [ "te", "test", "" ] 272 -
273 [ "", "", "" ] 273 -
274 [ " T", " Test ", "" ] 274 -
275 #select replace(str,'t',str), str, str2 from stringtest; 275 -
276 % sys., sys.stringtest, sys.stringtest # table_name 276 -
277 # sys.L2, sys.stringtest, sys.stringtest # table_name 277 -
278 % L, str, str2 # name 278 -
279 # L2, str, str2 # name 279 -
280 % varchar, varchar, varchar # type 280 -
281 % 11, 6, 4 # length 281 -
282 [ "", "", "test" ] 282 -
283 [ "testestest", "test", "" ] 283 -
284 [ "", "", "" ] 284 -
285 [ " Tes Test ", " Test ", "" ] 285 -
286 #select repeat(str,4), str from stringtest; 286 -
287 % sys., sys.stringtest # table_name 287 -
288 # sys.L2, sys.stringtest # table_name 288 -
289 % L, str # name 289 -
290 # L2, str # name 290 -
291 % varchar, varchar # type 291 -
292 % 24, 6 # length 292 -
293 [ "", "" ] 293 -
294 [ "testtesttesttest", "test" ] 294 -
295 [ "", "" ] 295 -
296 [ " Test Test Test Test ", " Test " ] 296 -
297 #select ascii(4), str from stringtest; 297 -
298 % ., sys.stringtest # table_name 298 -
299 # .L2, sys.stringtest # table_name 299 -
300 % L, str # name 300 -
301 # L2, str # name 301 -
302 % int, varchar # type 302 -
303 % 2, 6 # length 303 -
304 [ 52, "" ] 304 -
305 [ 52, "test" ] 305 -
306 [ 52, "" ] 306 -
307 [ 52, " Test " ] 307 -
308 #select str,str2,soundex(str),soundex(str2), editdistance2(soundex(str),soundex(str2)), editdistance(soundex(str),soundex(str2)), difference(str,str2) from stringtest; 308 -
309 % sys.stringtest, sys.stringtest, sys., sys., sys., sys., sys. # table_name 309 -
310 # sys.stringtest, sys.stringtest, sys.L4, sys.L6, sys.L10, sys.L12, sys.L14 # table_name 310 -
311 % str, str2, L, L, L, L, L # name 311 -
312 # str, str2, L4, L6, L10, L12, L14 # name 312 -
313 % varchar, varchar, varchar, varchar, int, int, int # type 313 -
314 % 6, 4, 4, 4, 1, 1, 1 # length 314 -
315 [ "", "test", "", "T230", 4, 4, 4 ] 315 -
316 [ "test", "", "T230", "", 4, 4, 4 ] 316 -
317 [ "", "", "", "", 0, 0, 0 ] 317 -
318 [ " Test ", "", " 323", "", 4, 4, 4 ] 318 -
319 [ 1 ] 319 -
320 #select levenshtein(str,str2, 1, 2, 3), str, str2 from stringtest; 320 -
321 % sys., sys.stringtest, sys.stringtest # table_name 321 -
322 # sys.L2, sys.stringtest, sys.stringtest # table_name 322 -
323 % L, str, str2 # name 323 -
324 # L2, str, str2 # name 324 -
325 % int, varchar, varchar # type 325 -
326 % 2, 13, 13 # length 326 -
327 [ 4, "", "test" ] 327 -
328 [ 4, "test", "" ] 328 -
329 [ 0, "", "" ] 329 -
330 [ 6, " Test ", "" ] 330 -
331 [ 12, "monetdbiscool", "coolismonetdb" ] 331 -
332 [ 1 ] 332 -
333 #select qgramnormalize(str) , qgramnormalize(str2), str, str2 from stringtest; 333 -
334 % sys., sys., sys.stringtest, sys.stringtest # table_name 334 -
335 # sys.L2, sys.L4, sys.stringtest, sys.stringtest # table_name 335 -
336 % L, L, str, str2 # name 336 -
337 # L2, L4, str, str2 # name 337 -
338 % varchar, varchar, varchar, varchar # type 338 -
339 % 16, 13, 17, 18 # length 339 -
340 [ "", "TEST", "", "test" ] 340 -
341 [ "TEST", "", "test", "" ] 341 -
342 [ "", "", "", "" ] 342 -
343 [ "TEST", "", " Test ", "" ] 343 -
344 [ "MONETDBISCOOL", "COOLISMONETDB", "monetdbiscool", "coolismonetdb" ] 344 -
345 [ "MONETDB45IS COOL", "123123 123123", "monetdb45is+ cool", " 123123 123123 " ] 345 -
346 346 -
347 # 12:30:46 > 347 -
348 # 12:30:46 > Done. 348 -
349 # 12:30:46 > 349 -
350 350 32 32