drrtuy
2506d3fe1e
fix(QA,joblist): SimpleFilter::setSimpleColumnListExtended() now populates the correct SimpleColumn list.
2025-09-10 19:50:26 +01:00
drrtuy
0d609ec485
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."
...
This reverts commit f807ebcdfd
2025-09-10 19:50:26 +01:00
Leonid Fedorov
00c81ab758
Merge branch 'stable-23.10' into feat/MCOL-6072-parallel-scan-4-CES-4
2025-09-09 20:36:06 +04:00
drrtuy
0bf8241e3c
fix(rbo,QA): add merge statistics into IN and Scalar subquery.
2025-09-09 19:55:39 +04:00
Aleksei Antipovskii
a7496ac9d0
fix(PP,THJS): MCOL-6106 Fix race condition in TupleHashJoinStep
2025-09-09 17:09:13 +04:00
drrtuy
71035c1002
fix(plugin): fix QA extract statistics stub signature to fix 10.6 compilation.
2025-09-08 15:52:15 +00:00
drrtuy
b73c245ecc
fix(rbo,QA): removed duplicated symbols
2025-09-08 15:20:31 +00:00
drrtuy
d981f96b2a
Merge branch 'stable-23.10' into feat/MCOL-6072-parallel-scan-4-CES-4
2025-09-08 15:16:52 +00:00
drrtuy
f807ebcdfd
Revert "fix(joblist,QA): introduced extended SC ptrs collector to resolve the issue when ParseTree consist of ArithmCol-AggCol does not return SCs from AggCol."
...
This reverts commit 8c0c85080c
2025-09-08 11:59:31 +00:00
Aleksei Antipovskii
95901fcd19
review fixes
2025-09-05 17:07:21 +04:00
Aleksei Antipovskii
76f135b2ac
Code cleanup and deduplication
2025-09-05 17:07:21 +04:00
Aleksei Antipovskii
5bdeaa6555
Fix normalization FP -> string to match server behaviour.
2025-09-05 17:07:21 +04:00
Aleksei Antipovskii
378f964cca
Fix queries like (SELECT * FROM t ORDER BY 1) UNION (SELECT ...)
2025-09-05 17:07:21 +04:00
Aleksei Antipovskii
3a316181e7
feat(joblist): MCOL-5756 MCOL-5222 ORDER BY on UNIONs in outer select
2025-09-05 17:07:21 +04:00
drrtuy
ed2c89196b
Merge branch 'stable-23.10' into feat/MCOL-6072-parallel-scan-4-CES-4
2025-09-04 15:47:40 +00:00
drrtuy
8c0c85080c
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-04 13:10:18 +00:00
drrtuy
eb1de4b024
fix(rbo,rules,QA): SCs in AC->AggC->AC ParseTree are not updated with the corresponding derived table if needed.
2025-09-03 09:25:10 +04:00
drrtuy
96fc875255
fix(rbo,rules,QA): ExistsFilter::transform merges statistics to enable QA for EXISTS expressions.
2025-09-03 09:25:10 +04:00
Leonid Fedorov
b92e5ae155
fix(review): cal* functions removed
2025-09-02 12:51:39 +01:00
Leonid Fedorov
0554ab3dd0
chore(format): apply clang-format
2025-09-02 12:51:39 +01:00
Leonid Fedorov
6ec363af70
MCOL-6145: mcsgetplan() UDF for CSEP printing
2025-09-02 12:51:39 +01:00
Leonid Fedorov
6e464bcd18
fix(crash, plugin), chore(ci): catch missed exception, set FE identity, install dgb_symbols
2025-09-02 00:36:33 +04:00
Leonid Fedorov
20dc485b92
Merge branch 'stable-23.10' into feat/MCOL-6072-parallel-scan-4-CES-4
2025-08-28 03:47:19 +04:00
drrtuy
ea225145c0
fix(rbo,QA): SC'es CORRELATED_JOIN flag created unexpected ghost table in JobList compiler.
2025-08-28 03:46:11 +04:00
Leonid Fedorov
9ed33c7e04
fix(leak): MCOL-6018: cleanup stacks on error again
2025-08-26 20:24:38 +04:00
Leonid Fedorov
49691e7e10
MCOL-6148: feat(rbo): Semi-joins and correlated subqueries in filters
2025-08-22 16:09:23 +04:00
Leonid Fedorov
e28b120527
fix(rbo): fix null values handling. Crash on incomplete SimpleFilter and transform
...
(col >= bound_n-1 and col < bound_n) or col is null to
(col >= bound_n-1 or col is null) and (col < bound_n)
2025-08-22 12:59:23 +01:00
Leonid Fedorov
67370721db
feat(rbo) parallel factor via session veriable
2025-08-22 12:58:52 +01:00
Leonid Fedorov
8c3a99699c
fix(rbo): Usage of statistics bounds
2025-08-22 12:58:52 +01:00
drrtuy
8962ec4830
Merge branch 'stable-23.10' into feat/MCOL-6072-parallel-scan-4-CES-4
2025-08-21 16:56:11 +00:00
Leonid Fedorov
50c8e91ae6
chore(rbo, codemanagement) MCOL-6143: move rbo to separate dir
2025-08-21 17:01:32 +04:00
drrtuy
8d802c076c
fix(rbo,rules,QA): add HAVING pass.
2025-08-21 04:03:13 +04:00
drrtuy
01e1ffc43e
feat(rbo,rules,QA): projection, GB, OB and filtering populate projection for the derived and UNION units to make tpch q1 work.
2025-08-21 04:03:13 +04:00
Leonid Fedorov
2c5043f2fe
feat(rbo): configfile and pron params can be used to turn off rbo rules selectively
2025-08-20 15:57:51 +04:00
Leonid Fedorov
9cde37345e
feat(rbo,rules,QA): Parallel rewrite now correctly handles NULLs in range filters by including OR IS NULL in the last union subquery range
2025-08-20 14:38:54 +04:00
mariadb-KristinaPavlova
74b5dc437e
change check for invalid args in pseudofunctions
2025-08-20 09:24:19 +01:00
mariadb-KristinaPavlova
c78a61d258
change check
2025-08-20 09:24:19 +01:00
mariadb-KristinaPavlova
25b83f1cca
add error and MTR test
2025-08-20 09:24:19 +01:00
mariadb-KristinaPavlova
011a1edabb
add solution only for the example
2025-08-20 09:24:19 +01:00
drrtuy
5368a45e05
chore(rbo,QA): fixed recursive application of the rule.
2025-08-19 18:48:15 +01:00
drrtuy
2fccfb5ffb
feat(rbo,rules,QA): AggregateColumn in projection and also GB/OB columns support.
2025-08-19 18:48:15 +01:00
drrtuy
f924f9430a
chore(rbo,rules,QA): refactor applyRule to facilitate patch cherry-pick.
2025-08-19 18:48:15 +01:00
Leonid Fedorov
98a301c1c5
chore(execplan): MCOL: 6144 prerry print filters and havings as a tree ( #3712 )
...
* MCOL-6144: print Filters and Having indented for better CSEP visualization
2025-08-19 13:18:06 +01:00
Leonid Fedorov
56d04cb711
MCOL-6018: cleanup stacks on error
2025-08-18 15:47:06 +04:00
Leonid Fedorov
14fe4401bc
chore(rbo): MCOL-6143: Settle down rbo as a separate lib for Unittesting ( #3708 )
...
* fix builds
* MCOL-6143: rbo as a separate library
* Move get_unstable_optimizer out of rbo, move findStatisticsForATable to header bo be (dirty fix, but cuts the corner)
* Add some helpers to a headerfile for unittesting
* Simple unittests with some mocks
2025-08-15 12:28:28 +01:00
drrtuy
08d89fcef7
chore(rbo,rules): removed extra printouts.
2025-08-14 19:38:00 +04:00
drrtuy
80f81526eb
feat(rbo,rules,QA): replace monotonic counter with column_name->col_index map and added fields to activate existing filters pushdown machinery.
2025-08-14 19:38:00 +04:00
drrtuy
0c876e1ed4
feat(rbo,rules,QA): SC in upper layer filters are updated.
2025-08-14 19:38:00 +04:00
drrtuy
4cc1492b95
chore(): resolution for compilation issues introduced by rebase.
2025-08-13 14:46:14 +00:00
drrtuy
7ad42678d4
chore(QA): fixed compilation and preprocessor filtering macro.
2025-08-13 13:24:30 +00:00
