diff options
| author | unknown <gluh@eagle.intranet.mysql.r18.ru> | 2005-10-21 13:14:54 +0500 |
|---|---|---|
| committer | unknown <gluh@eagle.intranet.mysql.r18.ru> | 2005-10-21 13:14:54 +0500 |
| commit | 4c872f749bc6d437c9fc12bcf0798911c1092315 (patch) | |
| tree | 96dd6125088a46fb48f7c9fb3eff8d6b3bac3a7c /mysql-test/r/information_schema.result | |
| parent | ad731d3888ff0ef87313d41c365a30fdf18cee68 (diff) | |
| download | mariadb-git-4c872f749bc6d437c9fc12bcf0798911c1092315.tar.gz | |
fix for bug#14089 FROM list subquery always fails when
information_schema is current database
skip the check of I_S tables if table is derived table
mysql-test/r/information_schema.result:
fix for bug#14089 FROM list subquery always fails when
information_schema is current database
test case
mysql-test/t/information_schema.test:
fix for bug#14089 FROM list subquery always fails when
information_schema is current database
test case
Diffstat (limited to 'mysql-test/r/information_schema.result')
| -rw-r--r-- | mysql-test/r/information_schema.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/information_schema.result b/mysql-test/r/information_schema.result index 0d53180b6d6..9c3d6d40139 100644 --- a/mysql-test/r/information_schema.result +++ b/mysql-test/r/information_schema.result @@ -1013,3 +1013,15 @@ grant all on information_schema.* to 'user1'@'localhost'; ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema' grant select on information_schema.* to 'user1'@'localhost'; ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema' +use test; +create table t1(id int); +insert into t1(id) values (1); +select 1 from (select 1 from test.t1) a; +1 +1 +use information_schema; +select 1 from (select 1 from test.t1) a; +1 +1 +use test; +drop table t1; |