Sergey Zefirov
60dc7550f1
fix(group by, having): MCOL-5776: GROUP BY/HAVING closer to server's ( #3371 )
...
This patch introduces an internal aggregate operator SELECT_SOME that
is automatically added to columns that are not in GROUP BY. It
"computes" some plausible value of the column (actually, last one
passed).
Along the way it fixes incorrect handling of HAVING being transferred
into WHERE, window function handling and a bit of other inconsistencies.
2024-12-20 19:11:47 +00:00
..
2023-06-02 17:02:09 +03:00
2023-04-22 15:49:50 +03:00
2016-01-06 14:08:59 -06:00
2016-01-06 14:08:59 -06:00
2024-11-08 16:28:51 +04:00
2024-11-08 16:28:51 +04:00
2023-06-07 15:41:59 +03:00
2022-01-21 16:43:49 +00:00
2022-12-12 14:17:09 -06:00
2022-08-05 14:40:50 -04:00
2022-08-05 14:40:49 -04:00
2022-01-21 16:43:49 +00:00
2022-03-02 23:53:39 +03:00
2023-04-14 10:33:27 +00:00
2023-04-14 10:33:27 +00:00
2023-04-22 15:49:50 +03:00
2022-01-21 16:43:49 +00:00
2022-08-23 18:45:36 +08:00
2022-03-02 23:53:39 +03:00
2023-12-18 17:24:27 +03:00
2023-12-18 17:24:27 +03:00
2024-12-03 22:18:21 +00:00
2024-11-11 18:31:15 +00:00
2023-03-30 21:18:29 +03:00
2023-03-30 21:18:29 +03:00
2023-06-02 17:02:09 +03:00
2022-02-17 13:08:58 +03:00
2024-12-20 19:11:47 +00:00
2022-01-21 16:43:49 +00:00
2023-04-22 15:49:50 +03: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
2023-05-01 13:06:23 -04:00
2023-05-01 13:06:23 -04:00
2023-04-22 15:49:50 +03:00
2022-01-21 16:43:49 +00:00
2022-02-17 13:08:58 +03:00
2024-12-10 20:30:58 +04:00
2024-11-08 12:51:25 +00:00
2022-01-21 16:43:49 +00:00
2024-09-26 18:51:49 +04:00
2024-09-26 18:51:49 +04:00
2023-03-30 21:18:29 +03:00
2022-01-21 16:43:49 +00:00
2024-11-08 12:51:25 +00:00
2022-07-19 21:47:36 +03:00
2024-09-26 18:51:49 +04:00
2023-03-02 15:59:42 +00:00
2024-12-20 19:11:47 +00:00
2023-03-02 15:59:42 +00:00
2022-08-18 19:35:35 +00:00
2023-08-04 16:55:45 +03:00
2023-08-04 16:55:45 +03:00
2022-01-21 16:43:49 +00:00
2023-05-12 19:45:02 +00:00
2023-04-14 10:33:27 +00:00
2023-04-22 15:49:50 +03:00
2023-03-02 15:59:42 +00:00
2024-11-08 16:28:51 +04:00
2023-03-02 15:59:42 +00:00
2023-04-14 10:33:27 +00:00
2022-01-21 16:43:49 +00:00
2022-01-21 16:43:49 +00:00
2022-02-17 13:08:58 +03:00
2022-01-21 16:43:49 +00:00
2022-01-21 16:43:49 +00:00
2023-06-02 17:02:09 +03:00
2023-09-28 22:03:39 +03:00
2023-04-22 15:49:50 +03:00
2023-04-22 15:49:50 +03:00
2024-11-08 16:28:51 +04:00
2024-12-03 22:18:21 +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
2023-04-22 15:49:50 +03:00
2023-04-22 15:49:50 +03:00
2024-11-08 16:28:51 +04:00
2023-06-07 15:41:59 +03:00
2024-11-08 16:28:51 +04: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
2024-09-26 18:51:49 +04:00
2023-04-14 10:33:27 +00:00
2023-04-13 03:55:30 +03:00
2022-02-17 13:08:58 +03:00
2023-03-30 21:18:29 +03:00
2023-03-30 21:18:29 +03:00
2022-01-21 16:43:49 +00:00
2022-01-21 16:43:49 +00:00
2023-03-30 21:18:29 +03:00
2022-01-21 16:43:49 +00:00
2023-04-22 15:49:50 +03: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
2023-03-30 21:18:29 +03: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
2023-04-22 15:49:50 +03:00
2023-03-02 15:59:42 +00:00
2023-03-02 15:59:42 +00:00
2022-01-21 16:43:49 +00:00
2024-12-03 22:18:21 +00:00
2024-12-11 12:02:24 +00:00
2024-12-11 12:02:24 +00:00
2024-12-03 22:18:21 +00:00
2023-04-22 15:49:50 +03:00
2023-04-14 09:42:50 +00:00
2022-02-17 13:08:58 +03:00
2024-12-03 22:18:21 +00:00
2024-09-04 18:56:35 +04:00
2024-12-20 19:11:47 +00:00
2022-02-17 13:08:58 +03:00
2023-04-22 15:49:50 +03:00
2023-04-22 15:49:50 +03:00
2023-04-22 15:49:50 +03:00
2023-04-22 15:49:50 +03:00
2022-02-17 13:08:58 +03:00
2022-01-21 16:43:49 +00:00
2023-04-14 10:33:27 +00:00
2023-03-02 15:59:42 +00:00