database/mariadb-columnstore-engine
1
0
Fork 0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-06-09 06:41:19 +03:00
Code
mariadb-columnstore-engine/mysql-test/columnstore/bugfixes
History
Leonid Fedorov dc4ca8d588
MCOL-5943: MCOL-4740 update rows counter for multi-table update (#3555) 
* fix(plugin): MCOL-4740: This fixes update rows counter for multi-table update
For UPDATEs involving a single table, the server call to handler::direct_update_rows() is used to correctly set the count for the number of updated rows in the UPDATE statement.
However, for UPDATEs involving multi-tables, the server does not call handler::direct_update_rows(). This patch adds support to correctly report the number of updated rows to the client by setting
multi_update::updated and multi_update::found in handler::rnd_end().

* fix(plugin): MCOL-4740: this is to addres the original patch QA found in the original patch

---------

Co-authored-by: Roman Nozdrin <rnozdrin@mariadb.com>
Co-authored-by: drrtuy <roman.nozdrin@mariadb.com>
2025-05-29 14:23:37 +01:00
..
mcol_4465.result
MCOL-4674 Fix ColumnStore to run MTR tests in a build directory
2021-04-13 11:25:25 +04:00
mcol_4465.test
MCOL-4674 Fix ColumnStore to run MTR tests in a build directory
2021-04-13 11:25:25 +04:00
mcol_4607.result
MCOL-4607 add tests
2025-04-10 19:54:26 +04:00
mcol_4607.test
MCOL-4607 add tests
2025-04-10 19:54:26 +04:00
mcol_4611.result
Fix(MCOL-4611): mod loses precision on huge narrow decimal (#3473)
2025-03-31 14:59:40 +01:00
mcol_4611.test
Fix(MCOL-4611): mod loses precision on huge narrow decimal (#3473)
2025-03-31 14:59:40 +01:00
mcol_4622.result
MCOL-4671: MCOL-4622: fix the behavior of both PRs
2025-05-23 05:12:17 +04:00
mcol_4622.test
MCOL-4671: MCOL-4622: fix the behavior of both PRs
2025-05-23 05:12:17 +04:00
mcol_4632.result
feat(datatypes): MCOL-4632 and MCOL-4648, fix cast leads to NULL.
2023-08-11 13:00:30 +00:00
mcol_4632.test
feat(datatypes): MCOL-4632 and MCOL-4648, fix cast leads to NULL.
2023-08-11 13:00:30 +00:00
mcol_4648.result
feat(datatypes): MCOL-4632 and MCOL-4648, fix cast leads to NULL.
2023-08-11 13:00:30 +00:00
mcol_4648.test
feat(datatypes): MCOL-4632 and MCOL-4648, fix cast leads to NULL.
2023-08-11 13:00:30 +00:00
mcol_4719.result
MCOL-4719 iterate into subquery looking for windowfunctions
2021-07-22 13:56:21 -05:00
mcol_4719.test
MCOL-4719 iterate into subquery looking for windowfunctions
2021-07-22 13:56:21 -05:00
mcol_5386.result
Revert "fix(MCOL-5386): Bitwise aggregation functions do not work with wide d…"
2025-05-20 19:17:05 +04:00
mcol_5386.test
Revert "fix(MCOL-5386): Bitwise aggregation functions do not work with wide d…"
2025-05-20 19:17:05 +04:00
MCOL_5175.result
MCOL-4480: TEXT type added for alter table add column (#3221)
2024-06-27 17:22:41 +04:00
MCOL_5175.test
MCOL-4480: TEXT type added for alter table add column (#3221)
2024-06-27 17:22:41 +04:00
mcol-3721.result
Recorded reference results
2022-12-09 02:24:40 +00:00
mcol-3721.test
Disable warnings for 'drop if exists' and 'create if not exist' commands
2022-12-08 11:37:44 -06:00
mcol-3785.result
MCOL-4674 Fix ColumnStore to run MTR tests in a build directory
2021-04-13 11:25:25 +04:00
mcol-3785.test
MCOL-4674 Fix ColumnStore to run MTR tests in a build directory
2021-04-13 11:25:25 +04:00
mcol-3879.result
MCOL-4758 Limit LONGTEXT and LONGBLOB to 16MB (#1995)
2021-07-05 02:09:41 -04:00
mcol-3879.test
MCOL-4758 Limit LONGTEXT and LONGBLOB to 16MB (#1995)
2021-07-05 02:09:41 -04:00
mcol-4407.result
MCOL-4407 and condtion does not work when HWM > columnstore_string_scan_threshold - 1
2021-06-21 14:04:26 +03:00
mcol-4407.test
MCOL-4407 and condtion does not work when HWM > columnstore_string_scan_threshold - 1
2021-06-21 14:04:26 +03:00
mcol-4412.result
MCOL-4674 Fix ColumnStore to run MTR tests in a build directory
2021-04-13 11:25:25 +04:00
mcol-4412.test
MCOL-4674 Fix ColumnStore to run MTR tests in a build directory
2021-04-13 11:25:25 +04:00
mcol-4453-4455.result
MCOL-4674 Fix ColumnStore to run MTR tests in a build directory
2021-04-13 11:25:25 +04:00
mcol-4453-4455.test
MCOL-4674 Fix ColumnStore to run MTR tests in a build directory
2021-04-13 11:25:25 +04:00
mcol-4493.result
MCOL-4674 Fix ColumnStore to run MTR tests in a build directory
2021-04-13 11:25:25 +04:00
mcol-4493.test
MCOL-4674 Fix ColumnStore to run MTR tests in a build directory
2021-04-13 11:25:25 +04:00
mcol-4499-float-null.result
Added more tests
2025-05-23 05:12:17 +04:00
mcol-4499-float-null.test
Added more tests
2025-05-23 05:12:17 +04:00
mcol-4499.result
Added more tests
2025-05-23 05:12:17 +04:00
mcol-4499.test
Added more tests
2025-05-23 05:12:17 +04:00
mcol-4505.result
MCOL-4674 Fix ColumnStore to run MTR tests in a build directory
2021-04-13 11:25:25 +04:00
mcol-4505.test
MCOL-4674 Fix ColumnStore to run MTR tests in a build directory
2021-04-13 11:25:25 +04:00
mcol-4671-func_left_right_negative.result
fix(funcexp): MCOL-4671 Fix behaviour of LEFT/RIGHT functions when negative trim length value is passedB
2025-05-23 05:12:17 +04:00
mcol-4671-func_left_right_negative.test
fix(funcexp): MCOL-4671 Fix behaviour of LEFT/RIGHT functions when negative trim length value is passedB
2025-05-23 05:12:17 +04:00
mcol-4715.result
MCOL-4715 Mixed inner and outer joins with "null" filter for the table which is not involved into the outer join produces wrong results.
2022-08-16 17:13:03 +03:00
mcol-4715.test
MCOL-4715 Mixed inner and outer joins with "null" filter for the table which is not involved into the outer join produces wrong results.
2022-08-16 17:13:03 +03:00
mcol-4728.result
MCOL-4728 Query with unusual use of aggregate functions on ColumnStore table crashes MariaDB Server
2021-09-21 14:00:56 +04:00
mcol-4728.test
MCOL-4728 Query with unusual use of aggregate functions on ColumnStore table crashes MariaDB Server
2021-09-21 14:00:56 +04:00
mcol-4740.result
MCOL-5943: MCOL-4740 update rows counter for multi-table update (#3555)
2025-05-29 14:23:37 +01:00
mcol-4740.test
MCOL-5943: MCOL-4740 update rows counter for multi-table update (#3555)
2025-05-29 14:23:37 +01:00
mcol-4741-strings-ranges-are-unsigned.result
MCOL-4741 in/like/equal(=) operations differ in results
2021-07-02 19:22:46 +03:00
mcol-4741-strings-ranges-are-unsigned.test
MCOL-4741 in/like/equal(=) operations differ in results
2021-07-02 19:22:46 +03:00
mcol-4756.result
fix(dbcon): MCOL-4756: having not() provokes an ERROR 2013
2025-05-23 05:12:17 +04:00
mcol-4756.test
fix(dbcon): MCOL-4756: having not() provokes an ERROR 2013
2025-05-23 05:12:17 +04:00
mcol-4758.result
MCOL-4480: TEXT type added for alter table add column (#3221)
2024-06-27 17:22:41 +04:00
mcol-4758.test
MCOL-4480: TEXT type added for alter table add column (#3221)
2024-06-27 17:22:41 +04:00
mcol-4778.result
[MCOL-4778] Return if we have an error in push_down_init.
2022-06-21 00:06:25 +03:00
mcol-4778.test
[MCOL-4778] Return if we have an error in push_down_init.
2022-06-21 00:06:25 +03:00
mcol-4786.result
[MCOL-4786] Fix filter comparison.
2021-07-12 19:18:02 +03:00
mcol-4786.test
[MCOL-4786] Fix filter comparison.
2021-07-12 19:18:02 +03:00
mcol-4868.result
MCOL-4868 Move test cases for MCOL-4264 to MTR.
2021-12-20 18:34:08 +00:00
mcol-4868.test
MCOL-4868 Move test cases for MCOL-4264 to MTR.
2021-12-20 18:34:08 +00:00
mcol-4874.result
MCOL-4874 Crossengine JOIN involving a ColumnStore table and a
2021-12-08 22:26:52 +00:00
mcol-4874.test
MCOL-4874 Crossengine JOIN involving a ColumnStore table and a
2021-12-08 22:26:52 +00:00
mcol-4899.result
MCOL-4899 MCS now applies a correct collation running IN for character data types
2022-01-05 12:00:01 +00:00
mcol-4899.test
MCOL-4899 MCS now applies a correct collation running IN for character data types
2022-01-05 12:00:01 +00:00
mcol-4931.result
MCOL-4931 Make cpimport charset-aware. (#2938)
2023-09-05 17:17:20 +03:00
mcol-4931.test
MCOL-4931 Make cpimport charset-aware. (#2938)
2023-09-05 17:17:20 +03:00
mcol-4940.result
MCOL-4580 extent elimination for dictionary-based text/varchar types
2022-03-02 23:53:39 +03:00
mcol-4940.test
MCOL-4580 extent elimination for dictionary-based text/varchar types
2022-03-02 23:53:39 +03:00
mcol-5061.result
[MCOL-5061] Fix wrong join id assignment for the views. (#2474)
2022-07-25 20:02:02 +03:00
mcol-5061.test
[MCOL-5061] Fix wrong join id assignment for the views. (#2474)
2022-07-25 20:02:02 +03:00
mcol-5074.result
Mcol 5074 Case with In and aggregates asserts (#2435)
2022-07-11 16:20:15 -05:00
mcol-5074.test
Mcol 5074 Case with In and aggregates asserts (#2435)
2022-07-11 16:20:15 -05:00
mcol-5236.result
fix(plugin): MCOL-5236 Take Item from Ref_Item for group by list (#3162) (#3163)
2024-06-27 17:25:57 +04:00
mcol-5236.test
fix(plugin): MCOL-5236 Take Item from Ref_Item for group by list (#3162) (#3163)
2024-06-27 17:25:57 +04:00
mcol-5237.result
MCOL-5237 Proper handle DATETIME column for "ifnull" function. (#3201)
2024-06-17 17:58:11 +04:00
mcol-5237.test
MCOL-5237 Proper handle DATETIME column for "ifnull" function. (#3201)
2024-06-17 17:58:11 +04:00
mcol-5328.result
MCOL-5328: PCRE based regexp regexp_substr regexp_instr regexp_replace [stable-23.10] (#3215)
2024-06-27 14:20:08 +04:00
mcol-5328.test
MCOL-5328: PCRE based regexp regexp_substr regexp_instr regexp_replace [stable-23.10] (#3215)
2024-06-27 14:20:08 +04:00
mcol-5357.result
MCOL-5357 Fix TPC-DS query error "MCS-3009: Unknown column '.<colname>'".
2023-05-03 16:06:20 +00:00
mcol-5357.test
MCOL-5357 Fix TPC-DS query error "MCS-3009: Unknown column '.<colname>'".
2023-05-03 16:06:20 +00:00
mcol-5438.result
MCOL-5438 COUNT() in math causes SEGV
2023-03-09 20:35:38 +00:00
mcol-5438.test
MCOL-5438 COUNT() in math causes SEGV
2023-03-09 20:35:38 +00:00
mcol-5468.result
Rename a limit var + change error message (#2946)
2023-09-05 12:19:15 +03:00
mcol-5468.test
Rename a limit var + change error message (#2946)
2023-09-05 12:19:15 +03:00
mcol-5476.result
fix(aggregation): MCOL-5467 Add support for duplicate expressions in group by. (#3052)
2023-12-05 18:29:44 +03:00
mcol-5476.test
fix(aggregation): MCOL-5467 Add support for duplicate expressions in group by. (#3052)
2023-12-05 18:29:44 +03:00
mcol-5480.result
MCOL-5480 LOAD DATA INFILE incorrectly loads values for MEDIUMINT datatype.
2023-05-23 16:00:05 -04:00
mcol-5480.test
MCOL-5480 LOAD DATA INFILE incorrectly loads values for MEDIUMINT datatype.
2023-05-23 16:00:05 -04:00
mcol-5522.result
dlee mtr 23.08.1 (#2932)
2023-08-18 00:01:33 +03:00
mcol-5522.test
dlee mtr 23.08.1 (#2932)
2023-08-18 00:01:33 +03:00
mcol-5651.result
fix(PrimProc): MCOL-5651 Add a workaround to avoid choosing an incorrect TupleHashJoinStep as a joiner [stable-23.10] (#3331)
2024-11-08 12:51:25 +00:00
mcol-5651.test
fix(PrimProc): MCOL-5651 Add a workaround to avoid choosing an incorrect TupleHashJoinStep as a joiner [stable-23.10] (#3331)
2024-11-08 12:51:25 +00:00
mcol-5669.result
bug(priproc) make last_day type a bit more accurate
2025-05-23 05:12:17 +04:00
mcol-5669.test
bug(priproc) make last_day type a bit more accurate
2025-05-23 05:12:17 +04:00
mcol-5670.result
bug(priproc) make last_day type a bit more accurate
2025-05-23 05:12:17 +04:00
mcol-5670.test
bug(priproc) make last_day type a bit more accurate
2025-05-23 05:12:17 +04:00
mcol-5703.result
Add test case
2025-05-23 05:12:17 +04:00
mcol-5703.test
Add test case
2025-05-23 05:12:17 +04:00
mcol-5708.result
MCOL-5708 Calculate precision and scale for constant decimal. (#3227)
2024-06-28 00:31:03 +04:00
mcol-5708.test
MCOL-5708 Calculate precision and scale for constant decimal. (#3227)
2024-06-28 00:31:03 +04:00
mcol-5779.result
MCOL-5779: use encoding to check alter table alter column statement correctly
2024-08-30 17:54:56 +04:00
mcol-5779.test
MCOL-5779: use encoding to check alter table alter column statement correctly
2024-08-30 17:54:56 +04:00
mcol-5812.result
fix(dbcon) MCOL-5812 server crash related to stored functions
2024-11-05 20:33:41 +04:00
mcol-5812.test
fix(dbcon) MCOL-5812 server crash related to stored functions
2024-11-05 20:33:41 +04:00
mcol-5890.result
chore(tests) lowercase database name due different distro settings
2025-04-11 19:10:37 +04:00
mcol-5890.test
chore(tests) lowercase database name due different distro settings
2025-04-11 19:10:37 +04:00
mcol-5932.result
MCOL-5932: fix heap buffer overflow with minimal revert of MCOL-5776 breaking change (#3445)
2025-04-15 14:46:25 +01:00
mcol-5932.test
MCOL-5932: fix heap buffer overflow with minimal revert of MCOL-5776 breaking change (#3445)
2025-04-15 14:46:25 +01:00
mcol-5992.result
MCOL-5922 add more datatypes for test
2025-04-02 19:54:47 +04:00
mcol-5992.test
MCOL-5922 add more datatypes for test
2025-04-02 19:54:47 +04:00
MCOL-4942-constant-select-empty-set.result
fix(plugin): MCOL-4942 No-table-SELECT now can return empty set (#3413)
2025-03-05 07:35:00 +00:00
MCOL-4942-constant-select-empty-set.test
fix(plugin): MCOL-4942 No-table-SELECT now can return empty set (#3413)
2025-03-05 07:35:00 +00:00
MCOL-5394-json_arrayagg.result
fix(PrimProc): MCOL-5394 JSON_ARRAYAGG in MCS works differently than in InnoDB
2025-04-11 15:21:07 +02:00
MCOL-5394-json_arrayagg.test
fix(PrimProc): MCOL-5394 JSON_ARRAYAGG in MCS works differently than in InnoDB
2025-04-11 15:21:07 +02:00
MCOL-5587-quick-is-default.test
fix(client): MCOL-5587: Add quick-max-column-width for maridb clients.
2024-12-22 16:59:13 +04:00
MCOL-5699.result
fix(plugin) MCOL-5699: throw error for unimplemented INTERSECT and EXCEPT (#3219)
2024-06-27 14:20:23 +04:00
MCOL-5699.test
fix(plugin) MCOL-5699: throw error for unimplemented INTERSECT and EXCEPT (#3219)
2024-06-27 14:20:23 +04:00
MCOL-5755-incorrect-group-by-handling-of-BLOB.result
fix: MCOL-5755: incorrect handling of BLOB (and TEXT) in GROUP BY
2025-05-23 05:12:17 +04:00
MCOL-5755-incorrect-group-by-handling-of-BLOB.test
fix: MCOL-5755: incorrect handling of BLOB (and TEXT) in GROUP BY
2025-05-23 05:12:17 +04:00
MCOL-5776-GROUP-BY-HAVING-functions-use.result
MCOL-5932: fix heap buffer overflow with minimal revert of MCOL-5776 breaking change (#3445)
2025-04-15 14:46:25 +01:00
MCOL-5776-GROUP-BY-HAVING-functions-use.test
MCOL-5932: fix heap buffer overflow with minimal revert of MCOL-5776 breaking change (#3445)
2025-04-15 14:46:25 +01:00
MCOL-5842-group-concat-json-object.result
fix(MCOL-5842): Fix JSON_OBJECT's handling of empty strings
2025-02-28 17:17:16 +04:00
MCOL-5842-group-concat-json-object.test
fix(MCOL-5842): Fix JSON_OBJECT's handling of empty strings
2025-02-28 17:17:16 +04:00
MCOL-5852-group-concat-memory-accounting.result
feat(PrimProc): MCOL-5852 disk-based GROUP_CONCAT & JSON_ARRAYAGG
2025-04-11 15:21:07 +02:00
MCOL-5852-group-concat-memory-accounting.test
feat(PrimProc): MCOL-5852 disk-based GROUP_CONCAT & JSON_ARRAYAGG
2025-04-11 15:21:07 +02:00
MCOL-5889-double-is-not-decimal.result
fix(MCOL-5889): Improper handle of DOUBLE result type with DECIMAL arguments
2025-02-12 18:41:55 +04:00
MCOL-5889-double-is-not-decimal.test
fix(MCOL-5889): Improper handle of DOUBLE result type with DECIMAL arguments
2025-02-12 18:41:55 +04:00
README
MCOL-4674 Fix ColumnStore to run MTR tests in a build directory
2021-04-13 11:25:25 +04:00
suite.opt
MCOL-4728 Query with unusual use of aggregate functions on ColumnStore table crashes MariaDB Server
2021-09-21 14:00:56 +04:00
suite.pm
MCOL-4728 Query with unusual use of aggregate functions on ColumnStore table crashes MariaDB Server
2021-09-21 14:00:56 +04:00

README 

This suite contains tests to validate newer bug fixes (post 4th dec 2020).