Aleksei Bukhalov
17035ab990
Revert "fix(plugin): MCOL 5675 - fix error message for null-safe equal ( #3754 )"
...
This reverts commit 45fecde902
2025-10-23 14:14:01 +02:00
aleksei.bukhalov
8dd0e7f2ba
MCOL-6197 add more testcases
2025-10-22 12:35:26 +02:00
aleksei.bukhalov
11d5815e79
fix(mtr): lowercase database name
2025-10-22 12:07:17 +02:00
Kristina Pavlova
45fecde902
fix(plugin): MCOL 5675 - fix error message for null-safe equal ( #3754 )
2025-10-21 14:03:54 +01:00
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.bukhalov
9e1f5db0a0
MCOL-5250 add test
2025-09-30 18:01:30 +04:00
Timofey Turenko
fd3c385373
Fix 'illegal mix of collation' in the Columnxtore MTR
2025-09-26 21:35:12 +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
Timofey Turenko
74659192bf
Make mcs11_show_db_table, mcs12_alter_table, mcs1_create_table_data_types compatible tests with 11.4
2025-09-18 18:11:40 +04:00
aleksei.bukhalov
14c1bd872d
MCOL-5756 add tests
2025-09-17 12:56:51 +02: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
Leonid Fedorov
878efe55ba
fix(engine): MCOL-5778: if function fixed with handling temporal times and null values
2025-09-12 15:02:51 +04:00
Aleksei Antipovskii
3d26e4d6fd
fix tests
2025-09-05 17:07:21 +04:00
aleksei.bukhalov
ebde9b5648
fix(tests): add deterministic ordering for failing mtrs
2025-09-05 16:33:04 +04:00
Leonid Fedorov
c2bf3e6b2a
fix(tests): fix mcol_2000
2025-09-02 14:49:52 +04:00
mariadb-KristinaPavlova
e3af51f3b3
add more cases in mtr test
2025-08-20 09:24:19 +01:00
mariadb-KristinaPavlova
e824ae95f6
update mtr test
2025-08-20 09:24:19 +01:00
mariadb-KristinaPavlova
30203350e2
fix idbPartition func name in test
2025-08-20 09:24:19 +01:00
mariadb-KristinaPavlova
74b5dc437e
change check for invalid args in pseudofunctions
2025-08-20 09:24:19 +01:00
Aleksei Antipovskii
c30b490027
skip bad rows report test on multinode setup
2025-07-15 20:52:29 +04:00
Aleksei Antipovskii
1ce46b5e0b
feature(cpimport): MCOL-5164 ignore all errors (-e all)
2025-07-15 20:52:29 +04:00
Alexey Antipovsky
78c1b5034d
Feature/mcol 4882 cpimport skip rows ( #3594 )
...
* feat(cpimport): MCOL-4882 add a parameter to skip header rows
* chore(cpimport): MCOL-4882 Use boost::program_options to arguments parsing
* feat(cpimport.bin): MCOL-4882 Add missing changes
* add test
* fix clang
* add missing cmdline argument
* fix bug
* Fix double lines skipping
* Fix incorrect --silent (-N) parsing
* fix default --max-errors processing
* fix overwriting default username
* move initialization to members declaration
2025-07-11 23:35:43 +04:00
mariadb-KristinaPavlova
7aac943ffe
record test result
2025-07-04 19:57:49 +04:00
mariadb-KristinaPavlova
e8b7442afa
record new test results
2025-07-04 19:57:49 +04:00
Aleksei Bukhalov
1dc794d4db
MCOL-5906 expected error updated
2025-07-04 19:57:49 +04:00
Timofey Turenko
e95fef4f26
Fix MCOL-5572-autoincrement-filtering test
2025-07-03 04:36:14 +04:00
Timofey Turenko
1c6985cbf5
add cleanups to MTR
2025-07-03 04:36:14 +04:00
Timofey Turenko
549b33f945
Fix analize_table test
2025-07-03 04:36:14 +04:00
Timofey Turenko
e789dfd1bf
enable sequence engine in the mcol-4786 test
2025-07-03 04:36:14 +04:00
Timofey Turenko
069bdf47f5
fix MCOL-5572-autoincrement-filtering and mcol-5669 tests
2025-07-03 04:36:14 +04:00
Timofey Turenko
f277a1f3d0
fix MCOL-5886-use-of-partitioned-tables-in-crossengine-steps test
2025-07-03 04:36:14 +04:00
Timofey Turenko
bdf0a956ff
Fix MCOL-5572-autoincrement-filtering test
2025-07-03 04:36:14 +04:00
Timofey Turenko
3d64026d0a
add cleanups to MTR
2025-07-03 04:36:14 +04:00
Timofey Turenko
c0307b6636
Fix analize_table test
2025-07-03 04:36:14 +04:00
Timofey Turenko
e9c6c6b5d3
enable sequence engine in the mcol-4786 test
2025-07-03 04:36:14 +04:00
Timofey Turenko
2d400d919d
add have_inndb to MTR
2025-07-03 04:36:14 +04:00
Timofey Turenko
38a5a7edec
Fix charset in MTR
2025-07-03 04:36:14 +04:00
Timofey Turenko
1640e87058
disable tests incompatible with Maxscale
2025-06-24 16:53:17 +04:00
Timofey Turenko
cfe95ea846
Fix mcs170_session_functions_maxscale test
2025-06-24 16:53:17 +04:00
Timofey Turenko
b7dbf89482
skip all tests with LOAD DATA in case of tests via Maxscale
2025-06-24 16:53:17 +04:00
aleksei.bukhalov
780e34680f
MCOL-6022 fix unstable mtrs
2025-06-18 14:31:56 +04:00
Serguey Zefirov
3bb2496ca1
fix: MCOL-5755: incorrect handling of BLOB (and TEXT) in GROUP BY
...
BLOB fields did not work as grouping keys at all, they were assigned
value NULL for any value, be it NULL or not. The fix is in the
rowaggregation.cpp in the initMapping(), a switch/case branch was added
to handle BLOB field copying there.
Also, TEXT columns did not distinguish between NULL and empty string in
the grouping algorithm, now they do. The fix is in the equals()
function, now we specifically check for isNull() equality between
values.
2025-05-23 05:12:17 +04:00
Sergey Zefirov
ef451af860
feat(ddl): MCOL-5744: better handling of utf8 charset aliases ( #3174 )
...
Server expands ut8_XXX aliases to utf8mb3_XXX or utf8mb4_XXX depending
on the UTF8_IS_UTF8MB3 setting in the OLD_MODE environment variable.
Server already has the necessary code implemented in the get_utf8_flag()
method of class THD. There are several uses of this flag and all we have
to do to be in line with server is to use it.
This patch does that for DDL as work on MCOL-5705 uncovered some
problems in that area.
2025-05-23 05:12:17 +04:00
Sergey Zefirov
5f6080e09c
fix(join): Fixes MCOL-5056, an error of joining TEXT column from InnoDB ( #3160 )
...
We incorrectly identified TEXT columns from external tables as BLOB.
Alexander Barkov suggested a way to discriminate them which I
implemented here.
2025-05-23 05:12:17 +04:00
Sergey Zefirov
11324c468d
feat(primproc,aggregegation)!: Changes for ROLLUP with single-phase aggregation ( #3025 )
...
The fix is simple: enable subtotals in single-phase aggregation and
disable parallel processing when there are subtotals and aggregation is
single-phase.
2025-05-23 05:12:17 +04:00
Serguey Zefirov
bd1622f331
feat(MCOL-5886): support InnoDB's table partitions in cross-engine joins
...
The purpose of this changeset is to obtain list of partitions from
SELECT_LEX structure and pass it down to joblist and then to
CrossEngineStep to pass to InnoDB.
2025-04-23 08:24:10 +03:00
Timofey Turenko
1fddc0c41c
Remove SHOW VARIABLES LIKE 'character_set%' from the mcs228 test
2025-04-16 02:01:32 +03:00
Timofey Turenko
8c8e3ab842
Fix deprication warnings in the MTR with select * from .. into
2025-04-15 20:21:31 +04:00
Aleksei Antipovskii
c618fa284d
fix(PrimProc): MCOL-5394 JSON_ARRAYAGG in MCS works differently than in InnoDB
2025-04-11 15:21:07 +02:00
drrtuy
90b4322470
feat(): propagated changes into SLTPoolAllocator and friends
2025-03-27 22:12:48 +00:00
