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, 1311 chars in all lines |
4 |
5 |
|
5 |
|
5 |
|
5 |
8 |
|
8 |
|
8 |
|
8 |
9 |
# 15:36:02 > |
9 |
! |
9 |
# 23:30:56 > |
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:30:56 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=8" "--set" "mapi_open=true" "--set" "mapi_port=30157" "--set" "mapi_usock=/var/tmp/mtest-9667/.s.monetdb.30157" "--set" "monet_prompt=" "--forcemito" "--set" "gdk_vm_maxsize=8589934592" "--dbpath=/home/monet/testing/GNU-Fedora-powerpc64-thrs=8-assert-propcheck-dbfarm-b41f8504324f-default/tests/sql/dbfarm/mTests_sql_test_BugTracker-2014" "--set" "embedded_c=true" |
10 |
11 |
# 15:36:02 > |
11 |
! |
11 |
# 23:30:56 > |
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:30:56 > |
18 |
19 |
# 15:36:03 > "Done." |
19 |
! |
19 |
# 23:30:56 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-9667" "--port=30157" |
19 |
20 |
# 15:36:03 > |
20 |
! |
20 |
# 23:30:56 > |
20 |
|
|
|
+ |
21 |
|
21 |
|
|
|
+ |
22 |
#~ MAPI = (monetdb) /var/tmp/mtest-9667/.s.monetdb.30157 |
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:30:56 > |
38 |
|
|
|
+ |
39 |
# 23:30:56 > "Done." |
39 |
|
|
|
+ |
40 |
# 23:30:56 > |
40 |
21 |
|
21 |
|
41 |
|
41 |