Test sqlitelogictest-groupby-coalesce-error-message.Bug-6608.sql (id 85ca3a09c8e6) (out)
sqlitelogictest-groupby-coalesce-error-message.Bug-6608.stable.err.FILTERED 2018-12-05 22:43:06.631179300 +0100sqlitelogictest-groupby-coalesce-error-message.Bug-6608.test.err.FILTERED 2018-12-05 22:43:06.646779300 +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, 470 words, 2855 chars in all lines 4
5 5 5 5
..................
#~ MAPI = (monetdb) /var/tmp/mtest-4323
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
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
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
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
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