mirror of
https://github.com/MariaDB/server.git
synced 2026-02-06 02:39:08 +01:00
0397e4e4dc
When executing an atomic sequence of RENAME operations, such as:
RENAME TABLE t1 TO t2, t3 TO t4, ...
any failure in the sequence triggers a rollback of previously completed
renames to preserve atomicity.
However, when an error occurs, `my_error()` is invoked immediately, which
sets the `thd->is_error()` flag. This premature flag setting causes
the rollback logic to misinterpret the thread state, leading to incorrect
reversion behavior and assertion failures.
To address this, the errors are now not emitted immediately but captured
and postponed. A new class `Postponed_error_handler` is introduced for
this purpose. Only after all operations are completed (including
possible DDL reversion), the captured errors are emitted.
215 lines
6.3 KiB
Text
215 lines
6.3 KiB
Text
drop table if exists t0,t1,t2,t3,t4;
|
|
drop table if exists t0,t5,t6,t7,t8,t9,t1_1,t1_2,t9_1,t9_2;
|
|
create table t0 SELECT 1,"table 1";
|
|
create table t2 SELECT 2,"table 2";
|
|
create table t3 SELECT 3,"table 3";
|
|
rename table t0 to t1;
|
|
rename table t3 to t4, t2 to t3, t1 to t2, t4 to t1;
|
|
select * from t1;
|
|
3 table 3
|
|
3 table 3
|
|
rename table t3 to t4, t2 to t3, t1 to t2, t4 to t1;
|
|
rename table t3 to t4, t2 to t3, t1 to t2, t4 to t1;
|
|
select * from t1;
|
|
1 table 1
|
|
1 table 1
|
|
rename table t1 to t2;
|
|
ERROR 42S01: Table 't2' already exists
|
|
rename table t1 to t1;
|
|
ERROR 42S01: Table 't1' already exists
|
|
rename table t3 to t4, t2 to t3, t1 to t2, t4 to t2;
|
|
ERROR 42S01: Table 't2' already exists
|
|
show tables like "t_";
|
|
Tables_in_test (t_)
|
|
t1
|
|
t2
|
|
t3
|
|
rename table t3 to t1, t2 to t3, t1 to t2, t4 to t1;
|
|
ERROR 42S01: Table 't1' already exists
|
|
rename table t3 to t4, t5 to t3, t1 to t2, t4 to t1;
|
|
ERROR 42S02: Table 'test.t5' doesn't exist
|
|
select * from t1;
|
|
1 table 1
|
|
1 table 1
|
|
select * from t2;
|
|
2 table 2
|
|
2 table 2
|
|
select * from t3;
|
|
3 table 3
|
|
3 table 3
|
|
drop table if exists t1,t2,t3,t4;
|
|
Warnings:
|
|
Note 1051 Unknown table 'test.t4'
|
|
connect con1,localhost,root,,;
|
|
connect con2,localhost,root,,;
|
|
connection con1;
|
|
CREATE TABLE t1 (a int);
|
|
CREATE TABLE t3 (a int);
|
|
connection con2;
|
|
FLUSH TABLES WITH READ LOCK;
|
|
connection con1;
|
|
RENAME TABLE t1 TO t2, t3 to t4;
|
|
connection con2;
|
|
show tables;
|
|
Tables_in_test
|
|
t1
|
|
t3
|
|
UNLOCK TABLES;
|
|
connection con1;
|
|
connection con2;
|
|
show tables;
|
|
Tables_in_test
|
|
t2
|
|
t4
|
|
drop table t2, t4;
|
|
disconnect con2;
|
|
disconnect con1;
|
|
connection default;
|
|
End of 4.1 tests
|
|
#
|
|
# Bug#14959: "ALTER TABLE isn't able to rename a view"
|
|
# Bug#53976: "ALTER TABLE RENAME is allowed on views
|
|
# (not documented, broken)"
|
|
#
|
|
create table t1(f1 int);
|
|
create view v1 as select * from t1;
|
|
alter table v1 rename to v2;
|
|
ERROR HY000: 'test.v1' is not of type 'BASE TABLE'
|
|
drop view v1;
|
|
drop table t1;
|
|
End of 5.0 tests
|
|
CREATE OR REPLACE TABLE t1 (a INT);
|
|
CREATE OR REPLACE TABLE t2 (a INT);
|
|
CREATE OR REPLACE TEMPORARY TABLE t1_tmp (b INT);
|
|
CREATE OR REPLACE TEMPORARY TABLE t2_tmp (b INT);
|
|
rename table t1 to t2;
|
|
ERROR 42S01: Table 't2' already exists
|
|
rename table t1 to tmp, tmp to t2;
|
|
ERROR 42S01: Table 't2' already exists
|
|
rename table t1_tmp to t2_tmp;
|
|
ERROR 42S01: Table 't2_tmp' already exists
|
|
rename table t1_tmp to tmp, tmp to t2_tmp;
|
|
ERROR 42S01: Table 't2_tmp' already exists
|
|
show create table t1_tmp;
|
|
Table Create Table
|
|
t1_tmp CREATE TEMPORARY TABLE `t1_tmp` (
|
|
`b` int(11) DEFAULT NULL
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
|
|
show create table t2_tmp;
|
|
Table Create Table
|
|
t2_tmp CREATE TEMPORARY TABLE `t2_tmp` (
|
|
`b` int(11) DEFAULT NULL
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
|
|
rename table t1 to t1_tmp;
|
|
rename table t2_tmp to t2;
|
|
rename table t2 to tmp, tmp to t2;
|
|
rename table t1_tmp to tmp, tmp to t1_tmp;
|
|
show tables;
|
|
Tables_in_test
|
|
t1_tmp
|
|
t2
|
|
SHOW CREATE TABLE t1_tmp;
|
|
Table Create Table
|
|
t1_tmp CREATE TEMPORARY TABLE `t1_tmp` (
|
|
`b` int(11) DEFAULT NULL
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
|
|
drop table t1_tmp;
|
|
SHOW CREATE TABLE t1_tmp;
|
|
Table Create Table
|
|
t1_tmp CREATE TABLE `t1_tmp` (
|
|
`a` int(11) DEFAULT NULL
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
|
|
drop table t1_tmp;
|
|
SHOW CREATE TABLE t2;
|
|
Table Create Table
|
|
t2 CREATE TEMPORARY TABLE `t2` (
|
|
`b` int(11) DEFAULT NULL
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
|
|
drop table t2;
|
|
SHOW CREATE TABLE t2;
|
|
Table Create Table
|
|
t2 CREATE TABLE `t2` (
|
|
`a` int(11) DEFAULT NULL
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
|
|
drop table t2;
|
|
CREATE TABLE t1 (a INT);
|
|
insert into t1 values (1);
|
|
CREATE TEMPORARY TABLE t1 (b INT);
|
|
insert into t1 values (2);
|
|
RENAME TABLE t1 TO tmp, t1 TO t2;
|
|
select * from tmp;
|
|
b
|
|
2
|
|
select * from t2;
|
|
a
|
|
1
|
|
drop table tmp,t2;
|
|
create table t1 (a int) engine=memory;
|
|
rename table t1 to non_existent.t2;
|
|
ERROR 42000: Unknown database 'non_existent'
|
|
drop table t1;
|
|
#
|
|
# Test rename IF EXISTS
|
|
#
|
|
rename table if exists t1 to t2;
|
|
Warnings:
|
|
Note 1146 Table 'test.t1' doesn't exist
|
|
alter table if exists t1 rename to t2;
|
|
Warnings:
|
|
Error 1146 Table 'test.t1' doesn't exist
|
|
create table t2 (a int);
|
|
alter table if exists t1 rename to t2;
|
|
Warnings:
|
|
Error 1146 Table 'test.t1' doesn't exist
|
|
rename table if exists t1 to t2;
|
|
Warnings:
|
|
Note 1146 Table 'test.t1' doesn't exist
|
|
create table t1 (a int);
|
|
rename table if exists t1 to t2;
|
|
ERROR 42S01: Table 't2' already exists
|
|
alter table if exists t1 rename to t2;
|
|
ERROR 42S01: Table 't2' already exists
|
|
drop table t2;
|
|
rename table if exists t1 to t2;
|
|
alter table if exists t2 rename to t1;
|
|
drop table t1;
|
|
#
|
|
# MDEV-27027 Atomic DDL: Assertion `!param->got_error' failed upon
|
|
# unsuccessful multi-RENAME TABLE
|
|
#
|
|
CREATE TABLE t1 (a INT);
|
|
CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW
|
|
INSERT INTO db.t SELECT SLEEP(0.05);
|
|
# Missing table in RENAME TABLE (should error)
|
|
RENAME TABLE t1 TO t2,
|
|
missing1 TO m1;
|
|
ERROR 42S02: Table 'test.missing1' doesn't exist
|
|
SHOW CREATE TRIGGER tr1;
|
|
Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
|
|
tr1 STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` TRIGGER tr1 AFTER INSERT ON `t1` FOR EACH ROW
|
|
INSERT INTO db.t SELECT SLEEP(0.05) latin1 latin1_swedish_ci latin1_swedish_ci #
|
|
CREATE TABLE t2 (a INT);
|
|
# Attempt to rename to existing table (should error)
|
|
RENAME TABLE t2 TO t3,
|
|
t1 TO t3;
|
|
ERROR 42S01: Table 't3' already exists
|
|
SHOW CREATE TRIGGER tr1;
|
|
Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
|
|
tr1 STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` TRIGGER tr1 AFTER INSERT ON `t1` FOR EACH ROW
|
|
INSERT INTO db.t SELECT SLEEP(0.05) latin1 latin1_swedish_ci latin1_swedish_ci #
|
|
# Test multiple warnings captured during renaming
|
|
RENAME TABLE IF EXISTS
|
|
missing1 TO m1,
|
|
missing2 TO m2,
|
|
t2 TO t3, # this rename succeeds
|
|
missing3 TO m3;
|
|
Warnings:
|
|
Note 1146 Table 'test.missing1' doesn't exist
|
|
Note 1146 Table 'test.missing2' doesn't exist
|
|
Note 1146 Table 'test.missing3' doesn't exist
|
|
RENAME TABLE IF EXISTS
|
|
missing1 TO m1,
|
|
t1 TO t3, # this will error: table exists
|
|
missing2 TO m2;
|
|
ERROR 42S01: Table 't3' already exists
|
|
DROP TABLE t1, t3;
|