mirror of
https://github.com/MariaDB/server.git
synced 2025-10-12 18:59:14 +02:00
eeb00ceffd
Follow-up patch with adjustments of test files and updates of result files for tests. Some of tests were rewritten slighlty. Everywhere where common pattern used: ----- CREATE USER userA; --connect con1 ... userA ... <sql statements...> --disconnect con1 DROP USER userA; ----- the DROP USER statement has been eclosed into the directive --disable_warnings --enable_warnings This change is caused by the race conddition between --disconnect and DROP USER since a number of currently running sessions established on behalf the user being dropped is counted by holding the rw_lock THD_list_iterator::lock that is not acquired on execution the DROP USER statement but the lock is taken as the last step on handling disconnection (when the client is already sending the next statement). Therefore, for the cases where the command --disconnect precedes the DROP USER statement we hide the possible warnings about presence of active sessions for the user being deleted to make tests deterministic.
226 lines
6.1 KiB
Text
226 lines
6.1 KiB
Text
--source include/have_log_bin.inc
|
|
--source include/have_innodb.inc
|
|
--source include/have_archive.inc
|
|
#
|
|
# This test is based on the original test from Tencent for DROP TABLE ... FORCE
|
|
# In MariaDB we did reuse the code but MariaDB does not require the FORCE
|
|
# keyword to drop a table even if the .frm file or some engine files are
|
|
# missing.
|
|
# To make it easy to see the differences between the original code and
|
|
# the new one, we have left some references to the original test case
|
|
#
|
|
|
|
CALL mtr.add_suppression("InnoDB: File .*test/t1\\.ibd was not found");
|
|
|
|
let $DATADIR= `select @@datadir`;
|
|
|
|
--echo #Test1: table with missing .ibd can be dropped directly
|
|
# drop table without ibd
|
|
create table t1(a int)engine=innodb;
|
|
--remove_file $DATADIR/test/t1.ibd
|
|
drop table t1;
|
|
--list_files $DATADIR/test/
|
|
|
|
# Original DROP TABLE .. FORCE required SUPER privilege. MariaDB doesn't
|
|
--echo # Test droping table without frm without super privilege
|
|
|
|
# create table t1 and rm frm
|
|
create table t1(a int) engine=innodb;
|
|
--remove_file $DATADIR/test/t1.frm
|
|
|
|
# create test user
|
|
create user test identified by '123456';
|
|
grant all privileges on test.t1 to 'test'@'%'identified by '123456';
|
|
|
|
# connect as test
|
|
connect (con_test, localhost, test,'123456', );
|
|
--connection con_test
|
|
|
|
# drop table with user test
|
|
drop table t1;
|
|
--error ER_BAD_TABLE_ERROR
|
|
drop table t1;
|
|
|
|
# connect as root
|
|
--connection default
|
|
|
|
--disconnect con_test
|
|
--disable_warnings
|
|
drop user test;
|
|
--enable_warnings
|
|
|
|
# check files in datadir about t1
|
|
--list_files $DATADIR/test/
|
|
|
|
--echo #Test5: drop table with triger, and with missing frm
|
|
# create table t1 with triger and rm frm
|
|
create table t1(a int)engine=innodb;
|
|
create trigger t1_trg before insert on t1 for each row begin end;
|
|
|
|
let $DATADIR= `select @@datadir`;
|
|
--remove_file $DATADIR/test/t1.frm
|
|
|
|
drop table t1;
|
|
--error ER_BAD_TABLE_ERROR
|
|
drop table t1;
|
|
|
|
# check files in datadir about t1
|
|
--list_files $DATADIR/test/
|
|
|
|
--echo #Test6: table with foreign key references can not be dropped
|
|
# create table with foreign key reference and rm frm
|
|
CREATE TABLE parent (id INT NOT NULL, PRIMARY KEY (id)) ENGINE=INNODB;
|
|
CREATE TABLE child (id INT, parent_id INT, INDEX par_ind (parent_id), FOREIGN KEY (parent_id) REFERENCES parent(id) ON DELETE CASCADE) ENGINE=INNODB;
|
|
--remove_file $DATADIR/test/parent.frm
|
|
|
|
# parent can not be dropped when there are foreign key references
|
|
--error ER_ROW_IS_REFERENCED_2
|
|
drop table parent;
|
|
|
|
# parent can be dropped when there are no foreign key references
|
|
drop table child;
|
|
drop table parent;
|
|
|
|
# check files in datadir about child and parent
|
|
--list_files $DATADIR/test/
|
|
|
|
--echo #Test7: drop table twice
|
|
create table t1(a int)engine=innodb;
|
|
--remove_file $DATADIR/test/t1.frm
|
|
|
|
# first drop table will success
|
|
drop table t1;
|
|
|
|
# check files in datadir about t1
|
|
--list_files $DATADIR/test/
|
|
|
|
# second drop with if exists will also ok
|
|
drop table if exists t1;
|
|
|
|
# check files in datadir about t1
|
|
--list_files $DATADIR/test/
|
|
|
|
--echo #Test9: check compatibility with restrict/cascade
|
|
# create table with foreign key reference and rm frm
|
|
CREATE TABLE parent (id INT NOT NULL, PRIMARY KEY (id)) ENGINE=INNODB;
|
|
CREATE TABLE child (id INT, parent_id INT, INDEX par_ind (parent_id), FOREIGN KEY (parent_id) REFERENCES parent(id) ON DELETE CASCADE) ENGINE=INNODB;
|
|
|
|
# parent can not be dropped when there are foreign key references
|
|
--error ER_ROW_IS_REFERENCED_2
|
|
drop table parent;
|
|
--error ER_ROW_IS_REFERENCED_2
|
|
drop table parent restrict;
|
|
--error ER_ROW_IS_REFERENCED_2
|
|
drop table parent cascade;
|
|
--error ER_ROW_IS_REFERENCED_2
|
|
drop table parent;
|
|
--error ER_ROW_IS_REFERENCED_2
|
|
drop table parent restrict;
|
|
--error ER_ROW_IS_REFERENCED_2
|
|
drop table parent cascade;
|
|
|
|
# parent can be dropped when there are no foreign key references
|
|
drop table child;
|
|
drop table parent;
|
|
|
|
--echo #Test10: drop non-innodb engine table returns ok
|
|
# create myisam table t1 and rm .frm
|
|
create table t1(a int) engine=myisam;
|
|
--remove_file $DATADIR/test/t1.frm
|
|
--replace_result \\ /
|
|
drop table t1;
|
|
|
|
# create myisam table t1 and rm .MYD
|
|
create table t1(a int) engine=myisam;
|
|
--remove_file $DATADIR/test/t1.MYD
|
|
--replace_result \\ /
|
|
drop table t1;
|
|
|
|
# create myisam table t1 and rm .MYI
|
|
create table t1(a int) engine=myisam;
|
|
--remove_file $DATADIR/test/t1.MYI
|
|
--replace_result \\ /
|
|
drop table t1;
|
|
--list_files $DATADIR/test/
|
|
|
|
# create Aria table t1 and rm .frm and .MAD
|
|
create table t1(a int) engine=aria;
|
|
--remove_file $DATADIR/test/t1.frm
|
|
--remove_file $DATADIR/test/t1.MAD
|
|
--list_files $DATADIR/test/
|
|
--error ER_BAD_TABLE_ERROR
|
|
drop table t1;
|
|
--replace_result \\ /
|
|
show warnings;
|
|
--list_files $DATADIR/test/
|
|
|
|
# create Aria table t2 and rm .frm and .MAI
|
|
create table t2(a int) engine=aria;
|
|
flush tables;
|
|
--remove_file $DATADIR/test/t2.frm
|
|
--remove_file $DATADIR/test/t2.MAI
|
|
--list_files $DATADIR/test/
|
|
--error ER_BAD_TABLE_ERROR
|
|
drop table t2;
|
|
--replace_result \\ /
|
|
show warnings;
|
|
--list_files $DATADIR/test/
|
|
|
|
# create Aria table t2 and rm .MAI and .MAD
|
|
create table t2(a int) engine=aria;
|
|
flush tables;
|
|
--remove_file $DATADIR/test/t2.MAD
|
|
--remove_file $DATADIR/test/t2.MAI
|
|
--list_files $DATADIR/test/
|
|
--replace_result \\ /
|
|
drop table t2;
|
|
|
|
# create CVS table t2 and rm .frm
|
|
create table t2(a int not null) engine=CSV;
|
|
flush tables;
|
|
--remove_file $DATADIR/test/t2.frm
|
|
drop table t2;
|
|
--list_files $DATADIR/test/
|
|
|
|
# create CVS table t2 and rm .frm
|
|
create table t2(a int not null) engine=CSV;
|
|
flush tables;
|
|
--remove_file $DATADIR/test/t2.CSV
|
|
drop table t2;
|
|
--list_files $DATADIR/test/
|
|
|
|
# create Archive table t2 and rm
|
|
# Note that as Archive has discovery, removing the
|
|
# ARZ will automatically remove the .frm
|
|
|
|
create table t2(a int not null) engine=archive;
|
|
flush tables;
|
|
--error 1
|
|
--remove_file $DATADIR/test/t2.frm
|
|
select * from t2;
|
|
flush tables;
|
|
--remove_file $DATADIR/test/t2.ARZ
|
|
--error ER_NO_SUCH_TABLE
|
|
select * from t2;
|
|
--list_files $DATADIR/test/
|
|
--replace_result \\ /
|
|
--error ER_BAD_TABLE_ERROR
|
|
drop table t2;
|
|
|
|
create table t2(a int not null) engine=archive;
|
|
flush tables;
|
|
--remove_file $DATADIR/test/t2.ARZ
|
|
--error ER_BAD_TABLE_ERROR
|
|
drop table t2;
|
|
--list_files $DATADIR/test/
|
|
|
|
--echo #
|
|
--echo # MDEV-23549 CREATE fails after DROP without FRM
|
|
--echo #
|
|
create table t1 (a int);
|
|
select * from t1;
|
|
--remove_file $datadir/test/t1.frm
|
|
|
|
drop table t1;
|
|
create table t1 (a int);
|
|
drop table t1;
|