database/mariadb-columnstore-engine
1
0
Fork 0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-11-03 17:13:17 +03:00
Code Activity
6,849 Commits 383 Branches 90 Tags
boost_flat
Commit Graph

3 Commits

Author SHA1 Message Date
Alexey Antipovsky
cfa9a7ff2c feat(optimizer): MCOL-5250 rewrite queries with DISTINCT (#3666) 
* feat(optimizer): MCOL-5250 rewrite queries with DISTINCT

... as aggregated queries.
So query
```
SELECT DISTINCT <cols list>
FROM <from list>
WHERE <where clause>
HAVING <having clause>
ORDER BY <orderby list>
LIMIT <limit>
```
will become
```
SELECT *
FROM
  (
    SELECT <cols list>
    FROM <from list>
    WHERE <where clause>
    HAVING <having clause>
  ) a
GROUP BY 1,2,3,...,N
ORDER BY <orderby list>
LIMIT limit
```

* move ORDER BY to the outer query

* fix test

* reuse cloneWORecursiveSelects() in clone()

* fix subselect columns processing
 2025-09-22 16:16:37 +04:00
Leonid Fedorov
6ec363af70 MCOL-6145: mcsgetplan() UDF for CSEP printing 2025-09-02 12:51:39 +01:00
Leonid Fedorov
50c8e91ae6 chore(rbo, codemanagement) MCOL-6143: move rbo to separate dir 2025-08-21 17:01:32 +04:00