Debian Codegraph @

mysql-test/suite/archive/discover_5438.test

raw
1 #
2 # MDEV-5438 - A view can mask a table that supports discovery
3 #
4 # in a few places the server was still using !access(path, F_OK) to
5 # determine whether a table exists
6 #
7 source include/have_archive.inc;
8
9 create table t1 (a int) engine=archive;
10 --error ER_TABLE_EXISTS_ERROR
11 create view t1 as select "I am a view" as a;
12 drop table t1;
13
14 create table t1 (a int) engine=archive;
15 create user foo@bar;
16 grant select on test.t1 to foo@bar;
17 drop user foo@bar;
18 drop table t1;
19
20 create table t1 (a int) engine=archive;
21 create table t2 (a int);
22 --error ER_TABLE_EXISTS_ERROR
23 alter table t2 rename t1;
24 drop table t2, t1;
25
26