|
|
|
+ |
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, 262 words, 1912 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 |
# 23:35:21 > |
9 |
|
|
|
+ |
10 |
# 23:35:21 > "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-2018" "--set" "embedded_c=true" |
10 |
|
|
|
+ |
11 |
# 23:35:21 > |
11 |
|
|
|
+ |
12 |
|
12 |
|
|
|
+ |
13 |
|
13 |
|
|
|
+ |
14 |
# 23:35:21 > |
14 |
|
|
|
+ |
15 |
# 23:35:21 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-9667" "--port=30157" |
15 |
|
|
|
+ |
16 |
# 23:35:21 > |
16 |
|
|
|
+ |
17 |
|
17 |
|
|
|
+ |
18 |
#~ MAPI = (monetdb) /var/tmp/mtest-9667/.s.monetdb.30157 |
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) /var/tmp/mtest-9667/.s.monetdb.30157 |
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) /var/tmp/mtest-9667/.s.monetdb.30157 |
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) /var/tmp/mtest-9667/.s.monetdb.30157 |
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) /var/tmp/mtest-9667/.s.monetdb.30157 |
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 |
# 23:35:21 > |
39 |
|
|
|
+ |
40 |
# 23:35:21 > "Done." |
40 |
|
|
|
+ |
41 |
# 23:35:21 > |
41 |
|
|
|
+ |
42 |
|
42 |