1
0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-04-18 21:44:02 +03:00
Sergey Zefirov 1122b64cb1
MCOL-4234: improve GROUP BY and ORDER BY interaction (#3194)
This patch fixes the problem in MCOL-4234 and also generally improves
behavior of GROUP BY.

It does so by introducing a "dummy" aggregate and by wrapping columns
into it. This allows for columns that are not in GROUP BY to be used
more freely, for example, in SELECT * FROM tbl GROUP BY col - all
columns that are not "col" will be wrapped into an aggregate and query
will proceed to execution.

The dummy aggregate itself does nothing more than remember last value
passed into it.

There also an additional error message that tries to explain what types
of expressions can be wrapped into an aggregate.
2024-06-17 20:00:54 +03:00
..
2016-01-06 14:08:59 -06:00
2022-08-13 07:18:30 +03:00
2016-05-12 14:14:24 -05:00
2020-04-20 13:35:30 +00:00
2020-04-20 13:35:30 +00:00
2022-01-21 16:43:49 +00:00
2016-01-06 14:08:59 -06:00
2022-01-21 16:43:49 +00:00
2023-03-02 15:59:42 +00:00
2022-01-21 16:43:49 +00:00
2022-01-21 16:43:49 +00:00
2022-01-21 16:43:49 +00:00
2022-01-21 16:43:49 +00:00
2022-01-21 16:43:49 +00:00
2022-01-21 16:43:49 +00:00
2017-03-28 14:17:17 -05:00
2022-01-21 16:43:49 +00:00