Debian Codegraph @

mysql-test/suite/sys_vars/t/ignore_db_dirs_basic.test

raw
1 call mtr.add_suppression("table or database name '.otherdir'");
2
3 select @@ignore_db_dirs;
4 let $MYSQLD_DATADIR= `select @@datadir`;
5
6 mkdir $MYSQLD_DATADIR/.mysqlgui;
7 mkdir $MYSQLD_DATADIR/.otherdir;
8 mkdir $MYSQLD_DATADIR/lost+found;
9 mkdir $MYSQLD_DATADIR/ignored_db;
10 --echo # Check that SHOW DATABASES ignores all directories from
11 --echo # @@ignore_db_dirs and all directories with names starting
12 --echo # with '.'
13 SHOW DATABASES;
14 --error ER_WRONG_DB_NAME
15 USE ignored_db;
16 --error ER_WRONG_DB_NAME
17 SELECT * FROM ignored_db.t1;
18 --error ER_WRONG_DB_NAME
19 CALL ignored_db.p1();
20 SELECT COUNT(*) FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME='ignored_db';
21 --error ER_WRONG_DB_NAME
22 CREATE DATABASE ignored_db;
23 CREATE DATABASE `lost+found`;
24 USE `lost+found`;
25 CREATE TABLE t1(id INT);
26 INSERT INTO t1 VALUES (1), (2);
27 SELECT * FROM `lost+found`.t1;
28 SHOW DATABASES;
29 DROP DATABASE `lost+found`;
30 rmdir $MYSQLD_DATADIR/.mysqlgui;
31 rmdir $MYSQLD_DATADIR/.otherdir;
32 rmdir $MYSQLD_DATADIR/lost+found;
33 rmdir $MYSQLD_DATADIR/ignored_db;
34
35 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
36 SET @@global.ignore_db_dirs = 'aha';
37 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
38 SET @@local.ignore_db_dirs = 'aha';
39 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
40 SET @@ignore_db_dirs = 'aha';