Test case_aggr.Bug-3705.sql (id 59ad0c7a230f) (err)
case_aggr.Bug-3705.stable.out.FILTERED 2020-01-13 19:46:12.539322700 +0100case_aggr.Bug-3705.test.out.FILTERED 2020-01-13 19:46:12.539322700 +0100
1 Statistics about stdout of test 'case_aggr.Bug-3705` in directory 'sql/test/BugTracker-2015`: 1 1 Statistics about stdout of test 'case_aggr.Bug-3705` in directory 'sql/test/BugTracker-2015`: 1
2 22 lines, 97 words, 387 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 1 lines, 8 words, 83 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 22 lines, 97 words, 387 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 1 lines, 8 words, 83 chars in lines not matching '^$|^(\| |)#` 3
4 # 67 lines, 339 words, 2195 chars in all lines 4 ! 4 # 30 lines, 145 words, 1114 chars in all lines 4
5 5 5 5
..................
# MonetDB/R module loaded
26 26 25 25
+ 26 # 19:46:12 > 26
+ 27 # 19:46:12 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=WIN2K12R2" "--port=31240" 27
+ 28 # 19:46:12 > 28
27 27 29 29
28 # 12:40:01 > 28 -
29 # 12:40:01 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-19388" "--port=34044" 29 -
30 # 12:40:01 > 30 -
31 31 -
32 #CREATE TABLE t1(a INTEGER, b INTEGER, c INTEGER, d INTEGER, e INTEGER); 32 -
33 #INSERT INTO t1(e,c,b,d,a) VALUES(103,102,100,101,104); 33 -
34 [ 1 ] 34 -
35 #SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END FROM t1; 35 -
36 % sys. # table_name 36 -
37 # sys.L7 # table_name 37 -
38 % L # name 38 -
39 # L7 # name 39 -
40 % bigint # type 40 -
41 % 4 # length 41 -
42 [ 1000 ] 42 -
43 #SELECT abs(b-c) FROM t1; 43 -
44 % sys. # table_name 44 -
45 # sys.L2 # table_name 45 -
46 % L # name 46 -
47 # L2 # name 47 -
48 % bigint # type 48 -
49 % 1 # length 49 -
50 [ 2 ] 50 -
51 #SELECT abs(b-c), CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END FROM t1; 51 -
52 % sys., sys. # table_name 52 -
53 # sys.L2, sys.L11 # table_name 53 -
54 % L, L # name 54 -
55 # L2, L11 # name 55 -
56 % bigint, bigint # type 56 -
57 % 1, 4 # length 57 -
58 [ 2, 1000 ] 58 -
59 #SELECT CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, abs(b-c) FROM t1; 59 -
60 % sys., sys. # table_name 60 -
61 # sys.L7, sys.L11 # table_name 61 -
62 % L, L # name 62 -
63 # L7, L11 # name 63 -
64 % bigint, bigint # type 64 -
65 % 4, 1 # length 65 -
66 [ 1000, 2 ] 66 -
67 #drop table t1; 67 30 #drop table t1; 30