| Bug #9683 | INFORMATION_SCH: Creation of temporary table allowed in Information_schema DB | ||
|---|---|---|---|
| Submitted: | 6 Apr 2005 18:18 | Modified: | 14 Sep 2005 20:21 |
| Reporter: | Disha | ||
| Status: | Closed | ||
| Category: | Server | Severity: | S3 (Non-critical) |
| Version: | 5.0.3 | OS: | Microsoft Windows (Windows Server 2003) |
| Assigned to: | Sergey Gluhov | Target Version: | |
[30 May 2005 21:42]
Peter Gulutzan
It's also possible to say CREATE PROCEDURE while using information_schema.
[1 Jun 2005 19: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 13:07]
Sergey Gluhov
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 10:31]
Sergey Gluhov
Fixed in 5.0.13
[14 Sep 2005 20: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.