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:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.3 OS:Microsoft Windows (Windows Server 2003)
Assigned to: Sergei Glukhov CPU Architecture:Any

[6 Apr 2005 16:18] Disha
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.
[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.