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
Sergey Zefirov
5c834ac7cd
fix(CEJ, segfault): MCOL-6198 - segfault during crossengine join
...
* fix(CEJ, segfault): MCOL-6198 - segfault during crossengine join
The patch moves joiners' initialization to a place after all possible
allocations of smallSideRGs vector so pointer to it's data does not
change anymore. This makes crash to cease.
An appropriate test is added to bugfixes suite.
* Change to test
* Another dangling pointer
* A change to test
* A change to test
2025-10-15 14:54:35 +01: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
Leonid Fedorov
f002c5abc1
MCOL-5843: fix(extents): print corrent N/A for temporal extents
2025-10-02 22:15:01 +04: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
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
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
Timofey Turenko
5d3a95b927
fix version check in mysql-test/columnstore/include/disable_before_10.9.inc
2025-09-18 18:11:20 +04:00
aleksei.bukhalov
14c1bd872d
MCOL-5756 add tests
2025-09-17 12:56:51 +02:00
drrtuy
88b441278f
chore(QA,tests): fixed MTR tests to return resut for TPC-H q20.
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
660457c3c6
Merge branch 'stable-23.10' into feat/MCOL-6072-parallel-scan-4-CES-4
2025-09-12 14:37:37 +01: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
drrtuy
1a6ed20fc9
Merge branch 'stable-23.10' into feat/MCOL-6072-parallel-scan-4-CES-4
2025-09-12 10:44:01 +01: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
Timofey Turenko
5c5c7f7bcb
Fix instability of basic.cal_named_udfs test
2025-09-11 19:03:19 +04: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
Leonid Fedorov
4f3ed2a6bd
fix(mtr): MCOL-5756, fix extended mtr tests
2025-09-09 18:05:11 +04: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
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
drrtuy
ed2c89196b
Merge branch 'stable-23.10' into feat/MCOL-6072-parallel-scan-4-CES-4
2025-09-04 15:47:40 +00:00
Leonid Fedorov
46b3b4fd79
chore(clean): test was cleaned
2025-09-02 12:51:39 +01:00
Leonid Fedorov
1bcb1a0982
chore(tests): now RBO tests can run without --extern
2025-09-02 12:51:39 +01:00
Leonid Fedorov
2e9900ea24
test(rbo): initial test
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
027d09310b
fix(tests): disable tests for 11.4 due to known bug
2025-09-02 14:49:52 +04:00
Leonid Fedorov
c2bf3e6b2a
fix(tests): fix mcol_2000
2025-09-02 14:49:52 +04: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
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
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
Sergey Zefirov
3418e68b78
fix(ddl): MCOL-5974 TIMESTAMP columns are not IS NOT NULL by default in MCS ( #3670 )
...
The old behavior was to assign TIMESTAMP columns an IS NOT NULL
constraint if list of constraints was empty. Apparently, this particular
invariant was changed in 11.4 and bugfixes' mcol-5480.test started to
fail.
This patch fixes behavioral difference and reenables mcol-5480 test in
11.4.
2025-07-27 20:06:40 +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
