diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2022-11-14 13:08:00 +0200 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2022-11-14 13:08:00 +0200 |
| commit | c82f3f1b041b877ac0a149e594756a61d1f6ef48 (patch) | |
| tree | 0b71cc8f0ce1925f66fa6392ed8ba352819ec6f5 /mysql-test/suite/innodb/r | |
| parent | 704c74cd992f691952c3942722f485402053512a (diff) | |
| download | mariadb-git-c82f3f1b041b877ac0a149e594756a61d1f6ef48.tar.gz | |
MDEV-29978 Corruption errors upon CHECK on temporary InnoDB table
row_check_index(): Treat secondary indexes of temporary tables as if
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
is in effect. That is, only consider the delete-mark and nothing else.
Diffstat (limited to 'mysql-test/suite/innodb/r')
| -rw-r--r-- | mysql-test/suite/innodb/r/temporary_table.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/r/temporary_table.result b/mysql-test/suite/innodb/r/temporary_table.result index a8a073cb257..ffcee726f0d 100644 --- a/mysql-test/suite/innodb/r/temporary_table.result +++ b/mysql-test/suite/innodb/r/temporary_table.result @@ -789,4 +789,16 @@ CHECK TABLE t EXTENDED; Table Op Msg_type Msg_text test.t check status OK DROP TEMPORARY TABLE t; +# +# MDEV-29978 Corruption errors upon CHECK on temporary InnoDB table +# +CREATE TEMPORARY TABLE t (f INT UNIQUE) ENGINE=InnoDB; +INSERT INTO t (f) VALUES (1),(2); +CHECK TABLE t; +Table Op Msg_type Msg_text +test.t check status OK +CHECK TABLE t EXTENDED; +Table Op Msg_type Msg_text +test.t check status OK +DROP TEMPORARY TABLE t; # End of 10.6 tests |