diff options
| author | unknown <timour@mysql.com> | 2006-02-22 10:04:10 +0200 |
|---|---|---|
| committer | unknown <timour@mysql.com> | 2006-02-22 10:04:10 +0200 |
| commit | 475797a34622bb740409238f9ee63a5777476b4f (patch) | |
| tree | 4a5a2a2b3a5bbaa7697e835edb2bd20086f5fddc /mysql-test/t/join.test | |
| parent | 86c920ba776ddf5e9999e8293d5824be25bb43b6 (diff) | |
| download | mariadb-git-475797a34622bb740409238f9ee63a5777476b4f.tar.gz | |
Fix for BUG#17523: natural join and information schema.
The cause of the bug was an ASSERT that checked the consistency
of TABLE_SHARE::db and TABLE_LIST::db and failed for I_S tables.
The fix relaxes the requirement for consistency for I_S.
mysql-test/r/join.result:
Added test for BUG#17523
mysql-test/t/join.test:
Added test for BUG#17523
sql/table.cc:
Take into account that for I_S tables, TABLE_SHARE::db == 0,
while TABLE_LIST::db contains the database name of a table.
The only change is in the ASSERTs.
Diffstat (limited to 'mysql-test/t/join.test')
| -rw-r--r-- | mysql-test/t/join.test | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/t/join.test b/mysql-test/t/join.test index 553aaf987bb..90abc61ca07 100644 --- a/mysql-test/t/join.test +++ b/mysql-test/t/join.test @@ -523,6 +523,12 @@ select t1.b from v1a; -- error 1054 select * from v1a join v1b on t1.b = t2.b; +# +# Bug #17523 natural join and information_schema +# +select * from information_schema.statistics join information_schema.columns + using(table_name,column_name) where table_name='user'; + drop table t1; drop table t2; drop table t3; |