Test with-between.Bug-2732.sql (id 257bc073dc33) (err)
with-between.Bug-2732.stable.out.FILTERED 2019-12-02 20:23:58.953878000 +0100with-between.Bug-2732.test.out.FILTERED 2019-12-02 20:24:00.404680500 +0100
1 Statistics about stdout of test 'with-between.Bug-2732` in directory 'sql/test/BugTracker-2010`: 1 1 Statistics about stdout of test 'with-between.Bug-2732` in directory 'sql/test/BugTracker-2010`: 1
2 13 lines, 76 words, 316 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 2 lines, 17 words, 139 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 13 lines, 76 words, 316 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 2 lines, 17 words, 139 chars in lines not matching '^$|^(\| |)#` 3
4 # 60 lines, 350 words, 2295 chars in all lines 4 ! 4 # 26 lines, 119 words, 936 chars in all lines 4
5 5 5 5
..................
# 60 lines, 350 words,
8 8 8 8
9 # 13:44:44 > 9 ! 9 # 20:22:54 > 9
10 # 13:44:44 > mserver5 "--config=/ufs/fabian/scratch/monetdb/current/program-x86_64/etc/monetdb5.conf" --debug=10 --set gdk_nr_threads=0 --set "monet_mod_path=/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/monetdb5:/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/monetdb5/lib:/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/monetdb5/bin" --set "gdk_dbfarm=/net/volund.ins.cwi.nl/export/scratch0/fabian/vtmp/mtest-current-volund.ins.cwi.nl/sql/dbfarm" --set mapi_open=true --set xrpc_open=true --set mapi_port=36387 --set xrpc_port=44547 --set monet_prompt= --trace --forcemito --set mal_listing=2 "--dbname=mTests_test_BugTracker-2010" --set mal_listing=0 ; echo ; echo Over.. 10 ! 10 # 20:22:54 > "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_BugTracker-2010" "--set" "embedded_c=true" 10
11 # 13:44:44 > 11 ! 11 # 20:22:54 > 11
12 12 ! 12 12
13 # MonetDB 5 server v11.0.0 13 ! 13 # MonetDB 5 server v11.35.4 13
14 # Release current-hg 14 ! 14 # This is an unreleased version 14
15 # Serving database 'mTests_test_BugTracker-2010', using 2 threads 15 ! 15 # Serving database 'mTests_sql_test_BugTracker-2010', using 4 threads 15
16 # Compiled for x86_64-pc-linux-gnu/64bit with 64bit OIDs dynamically linked 16 ! 16 # Compiled for i686-pc-winnt/32bit 16
17 # Found 7.750 GiB available main-memory. 17 ! 17 # Found 11.991 GiB available main-memory of which we use 1.500 GiB 17
18 # Copyright (c) 1993-July 2008 CWI. 18 ! 18 # Copyright (c) 1993 - July 2008 CWI. 18
19 # Copyright (c) August 2008-2015 MonetDB B.V., all rights reserved 19 ! 19 # Copyright (c) August 2008 - 2019 MonetDB B.V., all rights reserved 19
20 # Visit http://monetdb.cwi.nl/ for further information 20 ! 20 # Visit https://www.monetdb.org/ for further information 20
21 # MonetDB/SQL module v11.0.0 loaded 21 ! 21 # Listening for connection requests on mapi:monetdb://lab03:34655/ 21
22 # MonetDB/GIS module v11.0.0 loaded 22 ! 22 # MonetDB/GIS module loaded 22
23 23 ! 23 23
24 # SQL catalog created, loading sql scripts once 24 ! 24 24
25 25 ! 25 ! Server not ready; skipping attempt to start client! 25
26 26 ! 26 26
27 # 13:44:47 > 27 ! 27 27
28 # 13:44:47 > mclient -lsql -ftest -i -e --host=volund --port=36387 28 ! 28 # 20:23:57 > 28
29 # 13:44:47 > 29 ! 29 # 20:23:57 > "Done." 29
30 30 ! 30 # 20:23:57 > 30
31 #with t(p,s) as 31 -
32 # (select pre, size from (VALUES (1,4),(2,1),(3,0),(4,1),(5,0)) as t(pre,size)) 32 -
33 # 33 -
34 #select t1.p as p1, t2.p as p2, t3.p as p3 34 -
35 # from t as t1, t as t2, t as t3 35 -
36 # where t1.p = 1 36 -
37 # and t2.p between (t1.p + 1) and (t1.p + t1.s) 37 -
38 # and t3.p between (t2.p + 1) and (t2.p + t2.s); 38 -
39 % ., ., . # table_name 39 -
40 # .L12, .L14, .L16 # table_name 40 -
41 % p1, p2, p3 # name 41 -
42 % tinyint, tinyint, tinyint # type 42 -
43 % 1, 1, 1 # length 43 -
44 [ 1, 2, 3 ] 44 -
45 [ 1, 4, 5 ] 45 -
46 #with t(p,s) as 46 -
47 # (select pre, size from (VALUES (1,4),(2,1),(3,0),(4,1),(5,0)) as t(pre,size)) 47 -
48 # 48 -
49 #select t1.p as p1, t2.p as p2, t3.p as p3 49 -
50 # from t as t1, t as t2, t as t3 50 -
51 # where t1.p = 1 51 -
52 # and t2.p >= (t1.p + 1) and t2.p <= (t1.p + t1.s) 52 -
53 # and t3.p >= (t2.p + 1) and t3.p <= (t2.p + t2.s); 53 -
54 % ., ., . # table_name 54 -
55 # .L12, .L14, .L16 # table_name 55 -
56 % p1, p2, p3 # name 56 -
57 % tinyint, tinyint, tinyint # type 57 -
58 % 1, 1, 1 # length 58 -
59 [ 1, 2, 3 ] 59 -
60 [ 1, 4, 5 ] 60 -
61 61 -
62 # 13:44:48 > 62 -
63 # 13:44:48 > Done. 63 -
64 # 13:44:48 > 64 -
65 65 31 31