Test case-sqrt.Bug-3627.sql (id 03daa4a14bfc) (out)
case-sqrt.Bug-3627.stable.err.FILTERED 2018-06-14 19:41:37.405171800 +0200case-sqrt.Bug-3627.test.err.FILTERED 2018-06-14 19:41:37.410171800 +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, 1144 chars in all lines 4
5 5 5 5
..................
# 16 lines, 64 words,
8 8 8 8
9 # 15:36:02 > 9 ! 9 # 19:41:36 > 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 # 19:41:36 > "mserver5" "--debug=0" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=32410" "--set" "monet_prompt=" "--forcemito" "--dbpath=C:\monettesting\Int-Windows7-i386-assert-03daa4a14bfc-default\tests\sql\dbfarm\mTests_sql_test_BugTracker-2014" "--set" "embedded_c=true" 10
11 # 15:36:02 > 11 ! 11 # 19:41:36 > 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 # 19:41:37 > 18
19 # 15:36:03 > "Done." 19 ! 19 # 19:41:37 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=LAB03" "--port=32410" 19
20 # 15:36:03 > 20 ! 20 # 19:41:37 > 20
+ 21 21
+ 22 #~ MAPI = monetdb@LAB03:32410 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 # 19:41:37 > 38
+ 39 # 19:41:37 > "Done." 39
+ 40 # 19:41:37 > 40
21 21 41 41