Test sqlitelogictest-groupby-coalesce-error-message.Bug-6608.sql (id cbeba89afadb) (out)
sqlitelogictest-groupby-coalesce-error-message.Bug-6608.stable.err.FILTERED 2019-01-10 01:56:32.517965644 +0100sqlitelogictest-groupby-coalesce-error-message.Bug-6608.test.err.FILTERED 2019-01-10 01:56:32.517965644 +0100
1 Statistics about stderr of test 'sqlitelogictest-groupby-coalesce-error-message.Bug-6608` in directory 'sql/test/BugTracker-2018`: 1 1 Statistics about stderr of test 'sqlitelogictest-groupby-coalesce-error-message.Bug-6608` in directory 'sql/test/BugTracker-2018`: 1
2 31 lines, 429 words, 2413 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 31 lines, 379 words, 2103 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 31 lines, 429 words, 2413 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 31 lines, 379 words, 2103 chars in lines not matching '^$|^(\| |)#` 3
4 # 57 lines, 532 words, 3501 chars in all lines 4 ! 4 # 57 lines, 484 words, 3250 chars in all lines 4
5 5 5 5
..................
# 15:10:14 >
17 17 17 17
18 #~ MAPI = (monetdb) /var/tmp/mtest-4323/.s.monetdb.30108 18 ! 18 #~ MAPI = (monetdb) /var/tmp/mtest-11872/.s.monetdb.37033 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 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: cannot use non GROUP BY column 'cor0.col1' in query results without an aggregate function 20 ! 20 ERROR = !SELECT: no such aggregate 'sql_neg' 20
21 CODE = 42000 21 21 CODE = 42000 21
..................
#~ MAPI = (monetdb) /var/tmp/mtest-4323
25 CODE = 42000 25 25 CODE = 42000 25
26 #~ MAPI = (monetdb) /var/tmp/mtest-4323/.s.monetdb.30108 26 ! 26 #~ MAPI = (monetdb) /var/tmp/mtest-11872/.s.monetdb.37033 26
27 QUERY = SELECT ALL + 33 * - COALESCE ( - 86, tab1.col2 ) + + col1 FROM tab1 GROUP BY tab1.col1; 27 27 QUERY = SELECT ALL + 33 * - COALESCE ( - 86, tab1.col2 ) + + col1 FROM tab1 GROUP BY tab1.col1; 27
28 ERROR = !SELECT: cannot use non GROUP BY column 'tab1.col2' in query results without an aggregate function 28 ! 28 ERROR = !SELECT: no such aggregate 'sql_add' 28
29 CODE = 42000 29 29 CODE = 42000 29
..................
#~ MAPI = (monetdb) /var/tmp/mtest-4323
33 CODE = 42000 33 33 CODE = 42000 33
34 #~ MAPI = (monetdb) /var/tmp/mtest-4323/.s.monetdb.30108 34 ! 34 #~ MAPI = (monetdb) /var/tmp/mtest-11872/.s.monetdb.37033 34
35 QUERY = SELECT ALL + COALESCE ( - cor0.col1, cor0.col1, 63, - cor0.col2 ) * - cor0.col1 AS col1 FROM tab0 cor0 GROUP BY cor0.col0, col1; 35 35 QUERY = SELECT ALL + COALESCE ( - cor0.col1, cor0.col1, 63, - cor0.col2 ) * - cor0.col1 AS col1 FROM tab0 cor0 GROUP BY cor0.col0, col1; 35
36 ERROR = !SELECT: cannot use non GROUP BY column 'cor0.col2' in query results without an aggregate function 36 ! 36 ERROR = !SELECT: no such aggregate 'sql_mul' 36
37 CODE = 42000 37 37 CODE = 42000 37
..................
#~ MAPI = (monetdb) /var/tmp/mtest-4323
41 CODE = 42000 41 41 CODE = 42000 41
42 #~ MAPI = (monetdb) /var/tmp/mtest-4323/.s.monetdb.30108 42 ! 42 #~ MAPI = (monetdb) /var/tmp/mtest-11872/.s.monetdb.37033 42
43 QUERY = SELECT - 38 + - tab1.col1 - tab1.col1 / COALESCE ( + 20, - tab1.col0 ) FROM tab1 GROUP BY tab1.col1; 43 43 QUERY = SELECT - 38 + - tab1.col1 - tab1.col1 / COALESCE ( + 20, - tab1.col0 ) FROM tab1 GROUP BY tab1.col1; 43
44 ERROR = !SELECT: cannot use non GROUP BY column 'tab1.col0' in query results without an aggregate function 44 ! 44 ERROR = !SELECT: no such aggregate 'sql_sub' 44
45 CODE = 42000 45 45 CODE = 42000 45
..................
#~ MAPI = (monetdb) /var/tmp/mtest-4323
49 CODE = 42000 49 49 CODE = 42000 49
50 #~ MAPI = (monetdb) /var/tmp/mtest-4323/.s.monetdb.30108 50 ! 50 #~ MAPI = (monetdb) /var/tmp/mtest-11872/.s.monetdb.37033 50
51 QUERY = SELECT DISTINCT COALESCE ( - 82, - cor0.col0, - CAST ( NULL AS INTEGER ) ) / - 70 FROM tab0 AS cor0 GROUP BY cor0.col2; 51 51 QUERY = SELECT DISTINCT COALESCE ( - 82, - cor0.col0, - CAST ( NULL AS INTEGER ) ) / - 70 FROM tab0 AS cor0 GROUP BY cor0.col2; 51
52 ERROR = !SELECT: cannot use non GROUP BY column 'cor0.col0' in query results without an aggregate function 52 ! 52 ERROR = !SELECT: no such aggregate 'sql_div' 52
53 CODE = 42000 53 53 CODE = 42000 53