Test case-sqrt.Bug-3627.sql (id b41f8504324f) (out)
case-sqrt.Bug-3627.stable.err.FILTERED 2018-05-30 23:38:02.909004147 +0200case-sqrt.Bug-3627.test.err.FILTERED 2018-05-30 23:38:02.913004249 +0200
1 Statistics about stderr of test 'case-sqrt.Bug-3627` in directory 'sql/test/BugTracker-2014`: 1 1 Statistics about stderr of test 'case-sqrt.Bug-3627` in directory 'sql/test/BugTracker-2014`: 1
2 1 lines, 8 words, 83 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 15 lines, 45 words, 302 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 1 lines, 8 words, 83 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 15 lines, 45 words, 302 chars in lines not matching '^$|^(\| |)#` 3
4 # 16 lines, 64 words, 646 chars in all lines 4 ! 4 # 36 lines, 139 words, 1313 chars in all lines 4
5 5 5 5
..................
# 16 lines, 64 words,
8 8 8 8
9 # 15:36:02 > 9 ! 9 # 23:38:02 > 9
10 # 15:36:02 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=33717" "--set" "mapi_usock=/var/tmp/mtest-29576/.s.monetdb.33717" "--set" "monet_prompt=" "--forcemito" "--set" "mal_listing=2" "--dbpath=/ufs/sjoerd/Monet-candidate/var/MonetDB/mTests_sql_test_BugTracker-2014" "--set" "mal_listing=0" "--set" "embedded_r=yes" 10 ! 10 # 23:38:02 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=30643" "--set" "mapi_usock=/var/tmp/mtest-14728/.s.monetdb.30643" "--set" "monet_prompt=" "--forcemito" "--set" "gdk_vm_maxsize=8589934592" "--dbpath=/export/scratch1/home/monet/testing/Int-Fedora-x86_64-assert-propcheck-b41f8504324f-default/tests/sql/dbfarm/mTests_sql_test_BugTracker-2014" "--set" "embedded_c=true" 10
11 # 15:36:02 > 11 ! 11 # 23:38:02 > 11
12 12 ! 12 12
13 13 ! 13 #WARNING To speedup mmath.sqrt a bulk operator implementation is needed 13
14 # 15:36:03 > 14 ! 14 # X_36:bat[:dbl] := mal.multiplex("mmath":str, "sqrt":str, X_31:bat[:dbl], X_34:bat[:oid]); 14
15 # 15:36:03 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-29576" "--port=33717" 15 ! 15 #WARNING To speedup mmath.sqrt a bulk operator implementation is needed 15
16 # 15:36:03 > 16 ! 16 # X_44:bat[:dbl] := mal.multiplex("mmath":str, "sqrt":str, X_39:bat[:dbl], X_43:bat[:oid]); 16
17 17 ! 17 17
18 # 15:36:03 > 18 ! 18 # 23:38:02 > 18
19 # 15:36:03 > "Done." 19 ! 19 # 23:38:02 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-14728" "--port=30643" 19
20 # 15:36:03 > 20 ! 20 # 23:38:02 > 20
+ 21 21
+ 22 #~ MAPI = (monetdb) /var/tmp/mtest-14728/.s.monetdb.30643 22
+ 23 QUERY = SELECT t0.id 23
+ 24 ,t0.colint 24
+ 25 ,t0.sqrt_colint 25
+ 26 FROM (SELECT id 26
+ 27 ,colint 27
+ 28 ,CASE WHEN colint < 0 28
+ 29 THEN SQRT(-1 * colint) 29
+ 30 ELSE SQRT(colint) 30
+ 31 END AS sqrt_colint 31
+ 32 FROM t1 32
+ 33 ) t0 33
+ 34 ; 34
+ 35 ERROR = !Program contains errors.:(NONE).multiplex 35
+ 36 CODE = 42000 36
+ 37 37
+ 38 # 23:38:02 > 38
+ 39 # 23:38:02 > "Done." 39
+ 40 # 23:38:02 > 40
21 21 41 41