Serguey Zefirov
bb631dcffb
feat(JSON,data_type): MCOL-6197 - support for JSON type
...
This patch does exactly this, it implements support for JSON in DDL.
Right now we use server's check for JSON validity on INSERT. We do not implement
JSON validity check during updates, it is postponed for later work.
2025-10-17 11:48:46 +03:00
Aleksei Antipovskii
3cf5792779
fix(build): fix compilation issue with 11.08-server
2025-10-09 19:01:45 +04:00
Leonid Fedorov
2740cbec7b
fix(plugin,leak): One more memory leak in plugin ( #3805 )
2025-10-02 11:44:51 +01:00
Leonid Fedorov
111d169e40
fix(crash): Debug build of columnstore crashed on asserts with 11.8 ( #3800 )
...
due this wonderful code
DBUG_ASSERT(!comment || !comment[0] || comment[strlen(comment)-1] != '.');
DBUG_ASSERT(!comment || !comment[0] || comment[strlen(comment)-1] != ' ');
So I had to fix the comments
2025-09-30 18:54:17 +04:00
Serguey Zefirov
a9f23729a9
feat(MCOL-6082) Cluster with read-only nodes should correctly work with DML
...
This patch changes logic from counting all nodes to counting only
read-write nodes when messaging about DML operations.
feat(MCOL-6082): Multiple readers of dbroots using OamCache logic
This patch introduces centralized logic of selecting what dbroot is
accessible in PrimProc on what node. The logic is in OamCache for time
being and can be moved later.
Fix build
2025-09-26 21:55:10 +04:00
mariadb-KristinaPavlova
b01be6ae2d
fix: MCOL-5778 sum return null value due to nullif function
2025-09-24 19:21:25 +04:00
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
Aleksei Antipovskii
5ffc688c26
fix(plugin): MCOL-6029 use the right field from the rows_stats struct for inserts
2025-09-19 12:01:49 +04:00
drrtuy
9cbb160130
feat(joblist): descend into SelectFilter even if it contains correlated sub.
2025-09-15 20:22:10 +01:00
Rucha Deodhar
9fe37d5919
MDEV-32854: Make JSON_DEPTH_LIMIT unlimited
...
This patch is the columnstore-part of the task. Columnstore wanted to have
previous 32 depth, so this patch aims at keeping the compatibility.
2025-09-14 17:16:17 +04:00
drrtuy
3d6e2a6bd7
chore(QA): added MTR tests for TPC-H, removed printouts and added a doc on the feature.
2025-09-11 18:35:38 +01:00
drrtuy
3f88085360
chore(udf): rename mcsgetplan.
2025-09-11 18:35:38 +01:00
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
