| Bug #9683 | INFORMATION_SCH: Creation of temporary table allowed in Information_schema DB | ||
|---|---|---|---|
| Submitted: | 6 Apr 2005 16:18 | Modified: | 14 Sep 2005 18:21 |
| Reporter: | Disha | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 5.0.3 | OS: | Windows (Windows Server 2003) |
| Assigned to: | Sergei Glukhov | CPU Architecture: | Any |
[30 May 2005 19:42]
Peter Gulutzan
It's also possible to say CREATE PROCEDURE while using information_schema.
[1 Jun 2005 17:49]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/internals/25473
[13 Sep 2005 11:07]
Sergei Glukhov
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/internals/29725
[14 Sep 2005 8:31]
Sergei Glukhov
Fixed in 5.0.13
[14 Sep 2005 18:21]
Paul DuBois
Noted in 5.0.13 changelog.
Description: Creation of the temporary table in the information_schema database is allowed, that to with the name of the table which already exists in the information_table. How to repeat: Repro Steps use information_schema // create temporary table schemata(f1 char(10))// alter table schemata change f1 ff1 int // drop table schemata// Expected Results : It should not allow to do any kind of table creation/alteration in the information_schema database except for reading it. Actual Results : It allows to create a temporary table that to with the name of the table which already exists in the information_table.