database/mariadb-columnstore-engine
1
0
Fork 0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-10-30 07:25:34 +03:00
Code Activity
Files
volatile_replace
mariadb-columnstore-engine/dbcon/execplan
History
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
..
aggregatecolumn.cpp
fix(QA,joblist): SimpleFilter::setSimpleColumnListExtended() now populates the correct SimpleColumn list.
2025-09-10 19:50:26 +01:00
aggregatecolumn.h
fix(QA,joblist): SimpleFilter::setSimpleColumnListExtended() now populates the correct SimpleColumn list.
2025-09-10 19:50:26 +01:00
arithmeticcolumn.cpp
Reapply "fix(joblist,QA): introduced extended SC ptrs collector to resolve the issue when ParseTree consist of ArithmCol-AggCol does not return SCs from AggCol."
2025-09-10 19:50:26 +01:00
arithmeticcolumn.h
Reapply "fix(joblist,QA): introduced extended SC ptrs collector to resolve the issue when ParseTree consist of ArithmCol-AggCol does not return SCs from AggCol."
2025-09-10 19:50:26 +01:00
arithmeticoperator.cpp
MCOL-4957 Fix performance slowdown for processing TIMESTAMP columns.
2022-02-14 14:12:27 -05:00
arithmeticoperator.h
chore(codestyle): mark virtual methods as override
2025-02-21 20:01:34 +04:00
blocksize.h
chore(codestyle): mark virtual methods as override
2025-02-21 20:01:34 +04:00
btdriver.cpp
clang format apply
2022-01-21 16:43:49 +00:00
Calpont.xml
the begginning
2016-01-06 14:08:59 -06:00
calpontexecutionplan.cpp
clang format apply
2022-01-21 16:43:49 +00:00
calpontexecutionplan.h
clang format apply
2022-01-21 16:43:49 +00:00
calpontexecutionplanfactory.cpp
clang format apply
2022-01-21 16:43:49 +00:00
calpontexecutionplanfactory.h
clang format apply
2022-01-21 16:43:49 +00:00
calpontselectexecutionplan.cpp
feat(optimizer): MCOL-5250 rewrite queries with DISTINCT (#3666)
2025-09-22 16:16:37 +04:00
calpontselectexecutionplan.h
feat(optimizer): MCOL-5250 rewrite queries with DISTINCT (#3666)
2025-09-22 16:16:37 +04:00
calpontsystemcatalog.cpp
fix string args
2025-07-04 19:57:49 +04:00
calpontsystemcatalog.h
feat(rbo,rule,QA): fixed JOIN example works with QA for one leg of the JOIN.
2025-08-13 13:20:55 +00:00
clientrotator.cpp
Revert "Deep build refactoring phase 2 (#3564)" (#3678)
2025-08-01 02:56:31 +04:00
clientrotator.h
chore(codestyle): mark virtual methods as override
2025-02-21 20:01:34 +04:00
CMakeLists.txt
Revert "Deep build refactoring phase 2 (#3564)" (#3678)
2025-08-01 02:56:31 +04:00
columnresult.h
MCOL-271 empty strings should not be NULLs (#2794)
2023-03-30 21:18:29 +03:00
constantcolumn.cpp
chore(build): fixes to satisfy clang19 warnings
2025-05-15 19:05:38 +04:00
constantcolumn.h
chore(build): fixes to satisfy clang19 warnings
2025-05-15 19:05:38 +04:00
constantfilter.cpp
Reapply "fix(joblist,QA): introduced extended SC ptrs collector to resolve the issue when ParseTree consist of ArithmCol-AggCol does not return SCs from AggCol."
2025-09-10 19:50:26 +01:00
constantfilter.h
Reapply "fix(joblist,QA): introduced extended SC ptrs collector to resolve the issue when ParseTree consist of ArithmCol-AggCol does not return SCs from AggCol."
2025-09-10 19:50:26 +01:00
existsfilter.cpp
MCOL-4530: toCppCode() method for ParseTree and TreeNode (#2777)
2023-03-22 23:25:06 +03:00
existsfilter.h
chore(codestyle): mark virtual methods as override
2025-02-21 20:01:34 +04:00
exp_templates.h
Remove windows ifdefs
2023-03-02 15:59:42 +00:00
expressionparser.cpp
clang format apply
2022-01-21 16:43:49 +00:00
expressionparser.h
chore(codestyle): mark virtual methods as override
2025-02-21 20:01:34 +04:00
filter.cpp
MCOL-4530: toCppCode() method for ParseTree and TreeNode (#2777)
2023-03-22 23:25:06 +03:00
filter.h
chore(codestyle): mark virtual methods as override
2025-02-21 20:01:34 +04:00
functioncolumn.cpp
MDEV-32854: Make JSON_DEPTH_LIMIT unlimited
2025-09-14 17:16:17 +04:00
functioncolumn.h
Reapply "fix(joblist,QA): introduced extended SC ptrs collector to resolve the issue when ParseTree consist of ArithmCol-AggCol does not return SCs from AggCol."
2025-09-10 19:50:26 +01:00
groupconcatcolumn.cpp
chore(build): fixes to satisfy clang19 warnings
2025-05-15 19:05:38 +04:00
groupconcatcolumn.h
chore(ci): collect asan ubsan and libc++ build with mtr and regression status ignored (#3672)
2025-07-31 00:32:32 +04:00
intervalcolumn.cpp
MCOL-4530: toCppCode() method for ParseTree and TreeNode (#2777)
2023-03-22 23:25:06 +03:00
intervalcolumn.h
chore(build): fixes to satisfy clang19 warnings
2025-05-15 19:05:38 +04:00
logicoperator.cpp
clang format apply
2022-01-21 16:43:49 +00:00
logicoperator.h
chore(codestyle): mark virtual methods as override
2025-02-21 20:01:34 +04:00
mcsanalyzetableexecutionplan.cpp
MCOL-4957 Fix performance slowdown for processing TIMESTAMP columns.
2022-02-14 14:12:27 -05:00
mcsanalyzetableexecutionplan.h
chore(build): fixes to satisfy clang19 warnings
2025-05-15 19:05:38 +04:00
mysqlexecutionplan.cpp
clang format apply
2022-01-21 16:43:49 +00:00
mysqlexecutionplan.h
clang format apply
2022-01-21 16:43:49 +00:00
njlcolumnresult.h
clang format apply
2022-01-21 16:43:49 +00:00
objectidmanager.cpp
chore(build): fixes to satisfy clang19 warnings
2025-05-15 19:05:38 +04:00
objectidmanager.h
clang format apply
2022-01-21 16:43:49 +00:00
objectreader.cpp
feat(runtime)!: MCOL-678 A "GROUP BY ... WITH ROLLUP" support
2023-09-26 17:01:53 +03:00
objectreader.h
chore(codestyle): mark virtual methods as override
2025-02-21 20:01:34 +04:00
operator.cpp
compiler failures with gcc 12.x
2023-07-04 12:58:18 -04:00
operator.h
chore(build): fixes to satisfy clang19 warnings
2025-05-15 19:05:38 +04:00
oracleexecutionplan.cpp
clang format apply
2022-01-21 16:43:49 +00:00
oracleexecutionplan.h
clang format apply
2022-01-21 16:43:49 +00:00
outerjoinonfilter.cpp
MCOL-4530: toCppCode() method for ParseTree and TreeNode (#2777)
2023-03-22 23:25:06 +03:00
outerjoinonfilter.h
chore(codestyle): mark virtual methods as override
2025-02-21 20:01:34 +04:00
parsetree.h
feat(rbo,rules,QA): SC in upper layer filters are updated.
2025-08-14 19:38:00 +04:00
predicateoperator.cpp
fix(group by, having): MCOL-5776: GROUP BY/HAVING closer to server's (#3371)
2024-12-20 19:11:47 +00:00
predicateoperator.h
Revert "Deep build refactoring phase 2 (#3564)" (#3678)
2025-08-01 02:56:31 +04:00
pseudocolumn.cpp
Revert "Deep build refactoring phase 2 (#3564)" (#3678)
2025-08-01 02:56:31 +04:00
pseudocolumn.h
chore(codestyle): mark virtual methods as override
2025-02-21 20:01:34 +04:00
range.cpp
clang format apply
2022-01-21 16:43:49 +00:00
range.h
clang format apply
2022-01-21 16:43:49 +00:00
returnedcolumn.cpp
feat(optimizer): MCOL-5250 rewrite queries with DISTINCT (#3666)
2025-09-22 16:16:37 +04:00
returnedcolumn.h
Reapply "fix(joblist,QA): introduced extended SC ptrs collector to resolve the issue when ParseTree consist of ArithmCol-AggCol does not return SCs from AggCol."
2025-09-10 19:50:26 +01:00
rewrites.cpp
chore(build): fixes to satisfy clang19 warnings
2025-05-15 19:05:38 +04:00
rewrites.h
Add a limit (as runtime value) for long in queries
2023-08-21 10:38:46 +03:00
rowcolumn.cpp
MCOL-4530: toCppCode() method for ParseTree and TreeNode (#2777)
2023-03-22 23:25:06 +03:00
rowcolumn.h
chore(codestyle): mark virtual methods as override
2025-02-21 20:01:34 +04:00
selectfilter.cpp
feat(joblist): descend into SelectFilter even if it contains correlated sub.
2025-09-15 20:22:10 +01:00
selectfilter.h
feat(joblist): descend into SelectFilter even if it contains correlated sub.
2025-09-15 20:22:10 +01:00
sessionmanager.cpp
chore(build): fixes to satisfy clang19 warnings
2025-05-15 19:05:38 +04:00
sessionmanager.h
chore(codestyle): mark virtual methods as override
2025-02-21 20:01:34 +04:00
sessionmonitor.cpp
clang format apply
2022-01-21 16:43:49 +00:00
sessionmonitor.h
chore(codestyle): mark virtual methods as override
2025-02-21 20:01:34 +04:00
simplecolumn_decimal.h
chore(codestyle): mark virtual methods as override
2025-02-21 20:01:34 +04:00
simplecolumn_int.h
chore(codestyle): mark virtual methods as override
2025-02-21 20:01:34 +04:00
simplecolumn_uint.h
chore(codestyle): mark virtual methods as override
2025-02-21 20:01:34 +04:00
simplecolumn.cpp
feat(optimizer): MCOL-5250 rewrite queries with DISTINCT (#3666)
2025-09-22 16:16:37 +04:00
simplecolumn.h
feat(optimizer): MCOL-5250 rewrite queries with DISTINCT (#3666)
2025-09-22 16:16:37 +04:00
simplefilter.cpp
fix(QA,joblist): SimpleFilter::setSimpleColumnListExtended() now populates the correct SimpleColumn list.
2025-09-10 19:50:26 +01:00
simplefilter.h
Reapply "fix(joblist,QA): introduced extended SC ptrs collector to resolve the issue when ParseTree consist of ArithmCol-AggCol does not return SCs from AggCol."
2025-09-10 19:50:26 +01:00
simplescalarfilter.cpp
MCOL-4530: toCppCode() method for ParseTree and TreeNode (#2777)
2023-03-22 23:25:06 +03:00
simplescalarfilter.h
chore(ci): collect asan ubsan and libc++ build with mtr and regression status ignored (#3672)
2025-07-31 00:32:32 +04:00
syscatOids.txt
the begginning
2016-01-06 14:08:59 -06:00
tdriver1.cpp
clang format apply
2022-01-21 16:43:49 +00:00
tdriver2.cpp
clang format apply
2022-01-21 16:43:49 +00:00
tdriver3.cpp
clang format apply
2022-01-21 16:43:49 +00:00
tdriver4.cpp
clang format apply
2022-01-21 16:43:49 +00:00
tdriver5.cpp
clang format apply
2022-01-21 16:43:49 +00:00
tdriver6.cpp
clang format apply
2022-01-21 16:43:49 +00:00
tdriver7.cpp
clang format apply
2022-01-21 16:43:49 +00:00
tdriver8.cpp
clang format apply
2022-01-21 16:43:49 +00:00
tdriver9.cpp
clang format apply
2022-01-21 16:43:49 +00:00
tdriver10.cpp
clang format apply
2022-01-21 16:43:49 +00:00
tdriver11.cpp
clang format apply
2022-01-21 16:43:49 +00:00
tdriver12.cpp
clang format apply
2022-01-21 16:43:49 +00:00
tdriver13.cpp
clang format apply
2022-01-21 16:43:49 +00:00
tdriver14.cpp
clang format apply
2022-01-21 16:43:49 +00:00
tdriver15.cpp
clang format apply
2022-01-21 16:43:49 +00:00
tdriver16.cpp
clang format apply
2022-01-21 16:43:49 +00:00
tdriver17.cpp
clang format apply
2022-01-21 16:43:49 +00:00
tdriver18.cpp
clang format apply
2022-01-21 16:43:49 +00:00
tdriver19.cpp
clang format apply
2022-01-21 16:43:49 +00:00
tdriver20.cpp
clang format apply
2022-01-21 16:43:49 +00:00
tdriver21.cpp
clang format apply
2022-01-21 16:43:49 +00:00
tdriver22.cpp
clang format apply
2022-01-21 16:43:49 +00:00
tdriver23.cpp
clang format apply
2022-01-21 16:43:49 +00:00
tdriver-oid.cpp
clang format apply
2022-01-21 16:43:49 +00:00
tdriver-sm.cpp
clang format apply
2022-01-21 16:43:49 +00:00
tdriver.cpp
clang format apply
2022-01-21 16:43:49 +00:00
treenode.cpp
clang format apply
2022-01-21 16:43:49 +00:00
treenode.h
chore(ci): collect asan ubsan and libc++ build with mtr and regression status ignored (#3672)
2025-07-31 00:32:32 +04:00
treenodeimpl.cpp
MCOL-4530: toCppCode() method for ParseTree and TreeNode (#2777)
2023-03-22 23:25:06 +03:00
treenodeimpl.h
chore(codestyle): mark virtual methods as override
2025-02-21 20:01:34 +04:00
udafcolumn.cpp
MCOL-4530: toCppCode() method for ParseTree and TreeNode (#2777)
2023-03-22 23:25:06 +03:00
udafcolumn.h
chore(codestyle): mark virtual methods as override
2025-02-21 20:01:34 +04:00
vendorexecutionplan.cpp
clang format apply
2022-01-21 16:43:49 +00:00
vendorexecutionplan.h
clang format apply
2022-01-21 16:43:49 +00:00
wf_frame.h
chore(codestyle): mark virtual methods as override
2025-02-21 20:01:34 +04:00
windowfunctioncolumn.cpp
Deep build refactoring phase 1 (#3562)
2025-05-30 14:05:21 +04:00
windowfunctioncolumn.h
chore(build): fixes to satisfy clang19 warnings
2025-05-15 19:05:38 +04:00