Debian Codegraph @

mysql-test/suite/sys_vars/r/ignore_db_dirs_basic.result

raw
1 call mtr.add_suppression("table or database name '.otherdir'");
2 select @@ignore_db_dirs;
3 @@ignore_db_dirs
4 e,lost+found,.mysqlgui,ignored_db
5 # Check that SHOW DATABASES ignores all directories from
6 # @@ignore_db_dirs and all directories with names starting
7 # with '.'
8 SHOW DATABASES;
9 Database
10 #mysql50#.otherdir
11 information_schema
12 mtr
13 mysql
14 performance_schema
15 sys
16 test
17 USE ignored_db;
18 ERROR 42000: Incorrect database name 'ignored_db'
19 SELECT * FROM ignored_db.t1;
20 ERROR 42000: Incorrect database name 'ignored_db'
21 CALL ignored_db.p1();
22 ERROR 42000: Incorrect database name 'ignored_db'
23 SELECT COUNT(*) FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME='ignored_db';
24 COUNT(*)
25 1
26 CREATE DATABASE ignored_db;
27 ERROR 42000: Incorrect database name 'ignored_db'
28 CREATE DATABASE `lost+found`;
29 USE `lost+found`;
30 CREATE TABLE t1(id INT);
31 INSERT INTO t1 VALUES (1), (2);
32 SELECT * FROM `lost+found`.t1;
33 id
34 1
35 2
36 SHOW DATABASES;
37 Database
38 #mysql50#.otherdir
39 information_schema
40 lost+found
41 mtr
42 mysql
43 performance_schema
44 sys
45 test
46 DROP DATABASE `lost+found`;
47 SET @@global.ignore_db_dirs = 'aha';
48 ERROR HY000: Variable 'ignore_db_dirs' is a read only variable
49 SET @@local.ignore_db_dirs = 'aha';
50 ERROR HY000: Variable 'ignore_db_dirs' is a read only variable
51 SET @@ignore_db_dirs = 'aha';
52 ERROR HY000: Variable 'ignore_db_dirs' is a read only variable