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 |
# 32 lines, 105 words, 985 chars in all lines |
4 |
5 |
|
5 |
|
5 |
|
5 |
8 |
|
8 |
|
8 |
|
8 |
9 |
# 15:36:02 > |
9 |
! |
9 |
# 20:12:57 > |
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 |
# 20:12:57 > "mserver5" "--debug=0" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=30903" "--set" "mapi_usock=/var/tmp/mtest-2316/.s.monetdb.30903" "--set" "monet_prompt=" "--forcemito" "--set" "gdk_vm_maxsize=8589934592" "--dbpath=/export/scratch1/home/monet/testing/GNU-Fedora-x86_64-notint128-dbfarm-03daa4a14bfc-default/tests/sql/dbfarm/mTests_sql_test_BugTracker-2014" "--set" "embedded_c=true" |
10 |
11 |
# 15:36:02 > |
11 |
! |
11 |
# 20:12:57 > |
11 |
12 |
|
12 |
! |
12 |
|
12 |
13 |
|
13 |
! |
13 |
|
13 |
14 |
# 15:36:03 > |
14 |
! |
14 |
# 20:12:57 > |
14 |
15 |
# 15:36:03 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-29576" "--port=33717" |
15 |
! |
15 |
# 20:12:57 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-2316" "--port=30903" |
15 |
16 |
# 15:36:03 > |
16 |
! |
16 |
# 20:12:57 > |
16 |
17 |
|
17 |
! |
17 |
|
17 |
18 |
# 15:36:03 > |
18 |
! |
18 |
#~ MAPI = (monetdb) /var/tmp/mtest-2316/.s.monetdb.30903 |
18 |
19 |
# 15:36:03 > "Done." |
19 |
! |
19 |
QUERY = SELECT t0.id |
19 |
20 |
# 15:36:03 > |
20 |
! |
20 |
,t0.colint |
20 |
|
|
|
+ |
21 |
,t0.sqrt_colint |
21 |
|
|
|
+ |
22 |
FROM (SELECT id |
22 |
|
|
|
+ |
23 |
,colint |
23 |
|
|
|
+ |
24 |
,CASE WHEN colint < 0 |
24 |
|
|
|
+ |
25 |
THEN SQRT(-1 * colint) |
25 |
|
|
|
+ |
26 |
ELSE SQRT(colint) |
26 |
|
|
|
+ |
27 |
END AS sqrt_colint |
27 |
|
|
|
+ |
28 |
FROM t1 |
28 |
|
|
|
+ |
29 |
) t0 |
29 |
|
|
|
+ |
30 |
; |
30 |
|
|
|
+ |
31 |
ERROR = !Program contains errors.:(NONE).multiplex |
31 |
|
|
|
+ |
32 |
CODE = 42000 |
32 |
|
|
|
+ |
33 |
|
33 |
|
|
|
+ |
34 |
# 20:12:57 > |
34 |
|
|
|
+ |
35 |
# 20:12:57 > "Done." |
35 |
|
|
|
+ |
36 |
# 20:12:57 > |
36 |
21 |
|
21 |
|
37 |
|
37 |