Test case-sqrt.Bug-3627.sql (id 0f951a98884e) (out)
case-sqrt.Bug-3627.stable.err.FILTERED 2018-07-11 23:25:11.984713300 +0200case-sqrt.Bug-3627.test.err.FILTERED 2018-07-11 23:25:11.984713300 +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, 134 words, 1164 chars in all lines 4
5 5 5 5
..................
# 16 lines, 64 words,
8 8 8 8
9 # 15:36:02 > 9 ! 9 # 23:25:11 > 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:25:11 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=35302" "--set" "monet_prompt=" "--forcemito" "--dbpath=C:\monettesting\Mic-Windows2012-x86_64-assert-propcheck-0f951a98884e-default\tests\sql\dbfarm\mTests_sql_test_BugTracker-2014" "--set" "embedded_c=true" 10
11 # 15:36:02 > 11 ! 11 # 23:25:11 > 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:25:11 > 18
19 # 15:36:03 > "Done." 19 ! 19 # 23:25:11 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=WIN2012" "--port=35302" 19
20 # 15:36:03 > 20 ! 20 # 23:25:11 > 20
+ 21 21
+ 22 #~ MAPI = monetdb@WIN2012:35302 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:25:11 > 38
+ 39 # 23:25:11 > "Done." 39
+ 40 # 23:25:11 > 40
21 21 41 41