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
84c145590c
fix regex in mcs2_create_table_valid_names test
2025-09-30 17:51:00 +04:00
Leonid Fedorov
be91a85621
Merge branch 'stable-23.10' into disable_not_compatible_with_11.8
2025-09-27 00:12:22 +04:00
Timofey Turenko
1616b32101
fix mcs2_create_table_valid_names test
2025-09-26 21:35:12 +04:00
Timofey Turenko
fd3c385373
Fix 'illegal mix of collation' in the Columnxtore MTR
2025-09-26 21:35:12 +04:00
Timofey Turenko
8b8a6df5e3
Make MTR tests compatible with 11.8 default collation settings
2025-09-26 21:35:12 +04:00
Timofey Turenko
acfb0e6035
temporary disable tests incompatible with 11.8
2025-09-26 17:07:10 +03: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
Timofey Turenko
5c5c7f7bcb
Fix instability of basic.cal_named_udfs test
2025-09-11 19:03:19 +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
mariadb-KristinaPavlova
25b83f1cca
add error and MTR test
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
Timofey Turenko
dd4cfebaf4
change skip message for mcs114_comments test
2025-07-03 04:36:14 +04:00
Timofey Turenko
9c0accb447
disable tests inclompatible with 11.4
2025-07-03 04:36:14 +04:00
Timofey Turenko
1adb39db41
Fix merge error im the mysql-test/columnstore/basic/t/MCOL-5886-use-of-partitioned-tables-in-crossengine-steps
2025-07-03 04:36:14 +04:00
Timofey Turenko
4df58ffa96
Check for --extern before importing functions in the MCOL-5572-autoincrement-filtering.test
2025-07-03 04:36:14 +04:00
Timofey Turenko
d08766fd7d
disable basic.MCOL-5572-autoincrement-filtering when running without --extern
2025-07-03 04:36:14 +04:00
Timofey Turenko
06aff0bd0a
Drop functions in the basic suite tests
2025-07-03 04:36:14 +04:00
Timofey Turenko
72753308cd
Revert "add cleanups to MTR"
...
This reverts commit 9dafef641a
2025-07-03 04:36:14 +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
ce8368defd
Revert "add cleanups to MTR"
...
This reverts commit 9dafef641a
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
5831f578fe
set charset in the mcs271_substring_index_function MTR 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
68f60cd695
Add functions including into MTR tests
2025-07-03 04:36:14 +04:00
Timofey Turenko
7fd29de377
More disable tests in case of testing via Maxscale
2025-06-24 16:53:17 +04:00
Timofey Turenko
1640e87058
disable tests incompatible with Maxscale
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
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
