diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2021-10-28 08:28:39 +0300 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2021-10-28 08:28:39 +0300 |
| commit | 3a79e5fd317316c293baa459e8296fdb0744c280 (patch) | |
| tree | 9ff2059bbd651715daa6a1d7241c0ddd303c0071 /mysql-test/main/create_or_replace.result | |
| parent | 7948a1dc53eccc23095a83daa5fd6b3bfaedf7f2 (diff) | |
| parent | 657bcf928eb1c6a80ee2c82f0dcdd59ab02927e4 (diff) | |
| download | mariadb-git-3a79e5fd317316c293baa459e8296fdb0744c280.tar.gz | |
Merge 10.3 into 10.4
Diffstat (limited to 'mysql-test/main/create_or_replace.result')
| -rw-r--r-- | mysql-test/main/create_or_replace.result | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/main/create_or_replace.result b/mysql-test/main/create_or_replace.result index 485091e5810..3a7cfa53411 100644 --- a/mysql-test/main/create_or_replace.result +++ b/mysql-test/main/create_or_replace.result @@ -341,6 +341,27 @@ unlock tables; drop table t1; create table test.t1 (i int); drop database mysqltest2; +drop table test.t1; +# +# MDEV-23391 Server crash in close_thread_table or assertion, upon CREATE OR REPLACE TABLE under lock +# +create table t1 (i int); +lock table t1 write; +select * from information_schema.metadata_lock_info; +THREAD_ID LOCK_MODE LOCK_DURATION LOCK_TYPE TABLE_SCHEMA TABLE_NAME +# MDL_BACKUP_DDL NULL Backup lock +# MDL_BACKUP_DML NULL Backup lock +# MDL_INTENTION_EXCLUSIVE NULL Schema metadata lock test +# MDL_SHARED_NO_READ_WRITE NULL Table metadata lock test t1 +create or replace table t1 (a char(1)) engine=Innodb select 'foo' as a; +ERROR 22001: Data too long for column 'a' at row 1 +show tables; +Tables_in_test +t2 +select * from information_schema.metadata_lock_info; +THREAD_ID LOCK_MODE LOCK_DURATION LOCK_TYPE TABLE_SCHEMA TABLE_NAME +create table t1 (i int); +drop table t1; # # Testing CREATE .. LIKE # @@ -546,3 +567,4 @@ SELECT * FROM t3; ERROR HY000: Table 't3' was not locked with LOCK TABLES UNLOCK TABLES; DROP TABLE t3; +# End of 10.4 tests |