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
drrtuy
7842d8ab4b
chore(tests): disabled an unstable test to pass MTR @Jenkins for ES 11.8.
2025-10-06 12:01:50 +01: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
Timofey Turenko
33693686b2
disable unstabe tests from MCOL-6165
2025-09-26 17:21:19 +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
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
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
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
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
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
c0307b6636
Fix analize_table test
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
