|
|
|
+ |
1 |
Statistics about stderr of test 'sqlitelogictest-groupby-coalesce-error-message.Bug-6608` in directory 'sql/test/BugTracker-2018`: |
1 |
|
|
|
+ |
2 |
16 lines, 182 words, 1003 chars in lines not matching '^$|^(\| |)#|^=` |
2 |
|
|
|
+ |
3 |
= 16 lines, 182 words, 1003 chars in lines not matching '^$|^(\| |)#` |
3 |
|
|
|
+ |
4 |
# 37 lines, 253 words, 1665 chars in all lines |
4 |
|
|
|
+ |
5 |
|
5 |
|
|
|
+ |
6 |
stderr of test 'sqlitelogictest-groupby-coalesce-error-message.Bug-6608` in directory 'sql/test/BugTracker-2018` itself: |
6 |
|
|
|
+ |
7 |
|
7 |
|
|
|
+ |
8 |
|
8 |
|
|
|
+ |
9 |
# 20:24:37 > |
9 |
|
|
|
+ |
10 |
# 20:24:37 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=38015" "--set" "monet_prompt=" "--forcemito" "--dbpath=C:\monettesting\Int-Windows2012-x86_64-assert-propcheck-03daa4a14bfc-default\tests\sql\dbfarm\mTests_sql_test_BugTracker-2018" "--set" "embedded_c=true" |
10 |
|
|
|
+ |
11 |
# 20:24:37 > |
11 |
|
|
|
+ |
12 |
|
12 |
|
|
|
+ |
13 |
|
13 |
|
|
|
+ |
14 |
# 20:24:38 > |
14 |
|
|
|
+ |
15 |
# 20:24:38 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=WIN2012" "--port=38015" |
15 |
|
|
|
+ |
16 |
# 20:24:38 > |
16 |
|
|
|
+ |
17 |
|
17 |
|
|
|
+ |
18 |
#~ MAPI = monetdb@WIN2012:38015 |
18 |
|
|
|
+ |
19 |
QUERY = SELECT DISTINCT - COALESCE ( - 86, + cor0.col1, cor0.col1, - cor0.col0 ) AS col2 FROM tab0 AS cor0 GROUP BY cor0.col2, cor0.col0; |
19 |
|
|
|
+ |
20 |
ERROR = !SELECT: no such aggregate 'sql_neg' |
20 |
|
|
|
+ |
21 |
CODE = 42000 |
21 |
|
|
|
+ |
22 |
#~ MAPI = monetdb@WIN2012:38015 |
22 |
|
|
|
+ |
23 |
QUERY = SELECT ALL + 33 * - COALESCE ( - 86, tab1.col2 ) + + col1 FROM tab1 GROUP BY tab1.col1; |
23 |
|
|
|
+ |
24 |
ERROR = !SELECT: no such aggregate 'sql_add' |
24 |
|
|
|
+ |
25 |
CODE = 42000 |
25 |
|
|
|
+ |
26 |
#~ MAPI = monetdb@WIN2012:38015 |
26 |
|
|
|
+ |
27 |
QUERY = SELECT ALL + COALESCE ( - cor0.col1, cor0.col1, 63, - cor0.col2 ) * - cor0.col1 AS col1 FROM tab0 cor0 GROUP BY cor0.col0, col1; |
27 |
|
|
|
+ |
28 |
ERROR = !SELECT: no such aggregate 'sql_mul' |
28 |
|
|
|
+ |
29 |
CODE = 42000 |
29 |
|
|
|
+ |
30 |
#~ MAPI = monetdb@WIN2012:38015 |
30 |
|
|
|
+ |
31 |
QUERY = SELECT - 38 + - tab1.col1 - tab1.col1 / COALESCE ( + 20, - tab1.col0 ) FROM tab1 GROUP BY tab1.col1; |
31 |
|
|
|
+ |
32 |
ERROR = !SELECT: no such aggregate 'sql_sub' |
32 |
|
|
|
+ |
33 |
CODE = 42000 |
33 |
|
|
|
+ |
34 |
#~ MAPI = monetdb@WIN2012:38015 |
34 |
|
|
|
+ |
35 |
QUERY = SELECT DISTINCT COALESCE ( - 82, - cor0.col0, - CAST ( NULL AS INTEGER ) ) / - 70 FROM tab0 AS cor0 GROUP BY cor0.col2; |
35 |
|
|
|
+ |
36 |
ERROR = !SELECT: no such aggregate 'sql_div' |
36 |
|
|
|
+ |
37 |
CODE = 42000 |
37 |
|
|
|
+ |
38 |
|
38 |
|
|
|
+ |
39 |
# 20:24:38 > |
39 |
|
|
|
+ |
40 |
# 20:24:38 > "Done." |
40 |
|
|
|
+ |
41 |
# 20:24:38 > |
41 |
|
|
|
+ |
42 |
|
42 |