summaryrefslogtreecommitdiff
path: root/mysql-test/suite/parts
Commit message (Collapse)AuthorAgeFilesLines
* Merge 10.4 into 10.5Marko Mäkelä2023-01-031-1/+1
|\
| * Merge 10.3 into 10.4Marko Mäkelä2023-01-031-1/+1
| |\
| | * typosmusvaage2022-12-211-1/+1
| | |
* | | Merge 10.4 into 10.5Marko Mäkelä2022-12-137-0/+74
|\ \ \ | |/ /
| * | Merge 10.3 into 10.4Marko Mäkelä2022-12-137-0/+74
| |\ \ | | |/
| | * MDEV-29636 Assertion `part_share->auto_inc_initialized || ↵Nayuta Yanagisawa2022-12-076-0/+73
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | !can_use_for_auto_inc_init()' failed in ha_partition::set_auto_increment_if_higher upon REPLACE with partition pruning The bug is caused by a similar mechanism as MDEV-21027. The function, check_insert_or_replace_autoincrement, failed to open all the partitions on REPLACE SELECT statements and it results in the assertion error.
| | * Clean up file load.in in a testMarko Mäkelä2022-11-141-0/+1
| | | | | | | | | | | | | | | | | | | | | | | | This fixes the following test invocation: ./mtr --no-reorder parts.partition_special_myisam parts.partition_debug This was broken ever since afd4b25d8a0ab1447d37033a377ee05a03314d44 a.k.a. mysql/mysql-server@bde21e58108a1f311d15088c50414bb43ab45d62
| * | MDEV-27670 Assertion `(cs->state & 0x20000) == 0' failed in ↵Alexander Barkov2022-11-222-0/+99
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | my_strnncollsp_nchars_generic_8bit Also fixes: MDEV-27768 MDEV-25440: Assertion `(cs->state & 0x20000) == 0' failed in my_strnncollsp_nchars_generic_8bit The "strnncollsp_nchars" virtual function pointer for tis620_thai_nopad_ci was incorrectly initialized to a generic function my_strnncollsp_nchars_generic_8bit(), which crashed on assert. Implementing a tis620 specific function version.
* | | Merge 10.4 into 10.5Jan Lindström2022-11-302-0/+99
| | |
* | | Merge branch '10.4' into 10.5Sergei Golubchik2022-10-025-17/+17
|\ \ \ | |/ /
| * | Merge branch '10.3' into 10.4Sergei Golubchik2022-10-015-17/+17
| |\ \ | | |/
| | * MDEV-28548: ER_TABLEACCESS_DENIED_ERROR is missing information about DBAnel Husakovic2022-09-305-17/+17
| | | | | | | | | | | | | | | | | | | | | - Added missing information about database of corresponding table for various types of commands - Update some typos - Reviewed by: <vicentiu@mariadb.org>
* | | Merge remote-tracking branch 'origin/10.4' into 10.5Alexander Barkov2022-09-1486-2255/+2255
|\ \ \ | |/ /
| * | Merge 10.3 into 10.4Marko Mäkelä2022-09-1382-2254/+2254
| |\ \ | | |/
| | * MDEV-29446 Change SHOW CREATE TABLE to display default collationAlexander Barkov2022-09-1281-2252/+2252
| | |
* | | Merge 10.4 into 10.5Marko Mäkelä2022-07-016-11/+77
|\ \ \ | |/ /
| * | Merge 10.3 into 10.4Marko Mäkelä2022-07-016-11/+77
| |\ \ | | |/
| | * MDEV-21310 AUTO_INCREMENT column throws range error on INSERT in partitioned ↵Nayuta Yanagisawa2022-06-286-11/+77
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | table | Assertion `part_share->auto_inc_initialized || !can_use_for_auto_inc_init()' failed. The bug is caused by a similar mechanism as MDEV-21027. The function, check_insert_or_replace_autoincrement, failed to open all the partitions on INSERT SELECT statements and it results in the assertion error.
* | | Merge 10.4 into 10.5Marko Mäkelä2022-06-275-0/+39
|\ \ \ | |/ /
| * | Merge 10.3 into 10.4Marko Mäkelä2022-06-279-0/+68
| |\ \ | | |/
| | * MDEV-21027 Assertion `part_share->auto_inc_initialized || ↵Shunsuke Tokunaga2022-06-165-0/+39
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | !can_use_for_auto_inc_init()' failed in ha_partition::set_auto_increment_if_higher ha_partition::set_auto_increment_if_higher expects part_share->auto_inc_initialized is true or can_use_for_auto_inc_init() is false (but as the comment of this method says, it returns false only if we use Spider engine with DROP TABLE or ALTER TABLE query). However, part_share->auto_inc_initialized becomes true only after all partitions are opened (since 6dce6aecebe6ef78a14cb5c5c5daa8a355551e40). Therefore, I added a conditional expression in order to read all partitions when we execute REPLACE on a table that has an AUTO_INCREMENT column. Reviewed by: Nayuta Yanagisawa Reviewed by: Alexey Botchkov
| | * MDEV-26127 Assertion `err != DB_DUPLICATE_KEY' failed or InnoDB: Failing ↵Nayuta Yanagisawa2022-06-134-0/+29
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | assertion: id != 0 on ALTER ... REBUILD PARTITION During rebuild of partition, the partitioning engine calls alter_close_table(), which does not unlock and close some table instances of the target table. Then, the engine fails to rename partitions because there are table instances that are still locked. Closing all the table instance of the target table fixes the bug.
* | | MDEV-26127 Assertion `err != DB_DUPLICATE_KEY' failed or InnoDB: Failing ↵Nayuta Yanagisawa2022-06-134-0/+29
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | assertion: id != 0 on ALTER ... REBUILD PARTITION During rebuild of partition, the partitioning engine calls alter_close_table(), which does not unlock and close some table instances of the target table. Then, the engine fails to rename partitions because there are table instances that are still locked. Closing all the table instance of the target table fixes the bug.
* | | Merge branch '10.4' into 10.5Sergei Golubchik2022-05-092-1/+2
|\ \ \ | |/ /
| * | Merge branch '10.3' into 10.4Sergei Golubchik2022-05-082-1/+2
| |\ \ | | |/
| | * Merge branch '10.2' into 10.3Oleksandr Byelkin2022-05-032-1/+2
| | |\
| | | * MDEV-27065 fixup: disable tests under valgrindNayuta Yanagisawa2022-04-242-1/+2
| | | | | | | | | | | | | | | | | | | | The server behaves differently on the DATA/INDEX DIRECTORY clause under valgrind because symlink is disabled under valgrind.
* | | | Merge 10.4 into 10.5Marko Mäkelä2022-04-214-3/+87
|\ \ \ \ | |/ / /
| * | | Merge 10.3 into 10.4Marko Mäkelä2022-04-214-3/+87
| |\ \ \ | | |/ /
| | * | Merge remote-tracking branch 'origin/10.2' into 10.3Alexander Barkov2022-04-144-3/+87
| | |\ \ | | | |/
| | | * MDEV-27065 Partitioning tables with custom data directories moves data back ↵Nayuta Yanagisawa2022-04-084-3/+87
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | to default directory The partitioning engine does not support the table-level DATA/INDEX DIRECTORY specification. If one create a non-partitioned table with the DATA/INDEX DIRECTORY option and then performs ALTER TABLE ... PARTITION BY on it, the DATA/INDEX DIRECTORY specification of the old schema is ignored. The behavior might be a bit surprising for users because the value of a usual table option applies to all the partitions. Thus, we raise a warning on such ALTER TABLE ... PARTITION BY.
* | | | Merge branch '10.4' into 10.5Oleksandr Byelkin2022-02-012-0/+2
|\ \ \ \ | |/ / /
| * | | Merge branch '10.3' into 10.4Oleksandr Byelkin2022-01-302-0/+2
| |\ \ \ | | |/ /
| | * | Merge branch '10.2' into 10.3mariadb-10.3.33Oleksandr Byelkin2022-01-292-0/+2
| | |\ \ | | | |/
| | | * MDEV-26870 --skip-symbolic-links does not disallow .isl file creationMarko Mäkelä2022-01-212-0/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The InnoDB DATA DIRECTORY attribute is not implemented via symbolic links but something similar, *.isl files that contain the names of data files. InnoDB failed to ignore the DATA DIRECTORY attribute even though the server was started with --skip-symbolic-links. Native ALTER TABLE in InnoDB will retain the DATA DIRECTORY attribute of the table, no matter if the table will be rebuilt or not. Generic ALTER TABLE (with ALGORITHM=COPY) as well as TRUNCATE TABLE will discard the DATA DIRECTORY attribute. All tests have been run with and without the ./mtr option --mysqld=--skip-symbolic-links and some tests that use the InnoDB DATA DIRECTORY attribute have been adjusted for this.
| * | | Merge 10.3 into 10.4Marko Mäkelä2020-10-222-0/+33
| |\ \ \ | | |/ /
| | * | MDEV-23248 Server crashes in mi_extra / ha_partition::loop_extra_alter upon ↵Monty2020-10-162-0/+33
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | REORGANIZE This also fixes some issues with MDEV-23730 s3.replication_partition 'innodb,mix' segv The problem was that mysql_change_partitions() closes all handler files in case of error, which was not properly reflected in fast_alter_partition_table(). This caused handle_alter_part_error() to try to close already closed tables, which caused the crash. Fixed fast_alter_partion_table() to reflect when tables are opened. I also fixed that ha_partition::change_partitions() resets m_new_file in case of errors. Either of the above changes fixes the issue, but both are needed to ensure that the code works as expected.
* | | | remove unused result fileSergei Golubchik2021-09-111-6482/+0
| | | |
* | | | mtr: aix - stack-trace is optionalDaniel Black2021-07-223-3/+3
| | | |
* | | | Fix various spelling errors still found in codeOtto Kekäläinen2021-03-223-4/+4
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Reseting -> Resetting Unknow -> Unknown capabilites -> capabilities choosen -> chosen direcory -> directory informations -> information openned -> opened refered -> referred to access -> one to access missmatch -> mismatch succesfully -> successfully dont -> don't
* | | | MDEV-23730 s3.replication_partition 'innodb,mix' segvMonty2020-10-212-0/+33
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This failure was caused because of several bugs: - Someone had removed s3-slave-ignore-updates=1 from slave.cnf, which caused the slave to remove files that the master was working on. - Bug in ha_partition::change_partitions() that didn't reset m_new_file in case of errors. This caused crashes in ha_maria::extra() as the maria handler was called on files that was already closed. - In ma_pagecache there was a bug that when one got a read error one a big block (s3 block), it left the flag PCBLOCK_BIG_READ on for the page which cased an assert when the page where flushed. - Flush all cached tables in case of ignored ALTER TABLE Note that when merging code from 10.3, that fixes the partition bug, use the code from this patch instead. Changes to ma_pagecache.cc written or reviewed by Sanja
* | | | Merge branch '10.4' into 10.5Oleksandr Byelkin2020-08-042-0/+5
|\ \ \ \ | |/ / /
| * | | Merge branch '10.3' into 10.4Oleksandr Byelkin2020-08-032-0/+5
| |\ \ \ | | |/ /
| | * | Merge branch '10.2' into 10.3Oleksandr Byelkin2020-08-032-0/+5
| | |\ \ | | | |/
| | | * Merge branch '10.1' into 10.2Elena Stepanova2020-08-032-0/+5
| | | |\
| | | | * MDEV-23375 parts.partition_debug fails when it's run after another testElena Stepanova2020-08-032-0/+5
| | | | | | | | | | | | | | | | | | | | Make sure system tables aren't open, as the test kills the server
| * | | | Merge 10.3 into 10.4Marko Mäkelä2020-06-062-0/+60
| |\ \ \ \ | | |/ / /
| | * | | Merge 10.2 into 10.3Marko Mäkelä2020-06-061-0/+2
| | |\ \ \ | | | |/ /
| | | * | MDEV-22817: Skip the test in --embeddedMarko Mäkelä2020-06-061-0/+2
| | | | |
| | * | | Merge 10.2 into 10.3Marko Mäkelä2020-06-062-0/+58
| | |\ \ \ | | | |/ /