Test case-sqrt.Bug-3627.sql (id 03daa4a14bfc) (out)
case-sqrt.Bug-3627.stable.err.FILTERED 2018-06-14 20:12:57.393979129 +0200case-sqrt.Bug-3627.test.err.FILTERED 2018-06-14 20:12:57.394979120 +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 # 32 lines, 105 words, 985 chars in all lines 4
5 5 5 5
..................
# 16 lines, 64 words,
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