Bug #7489 INFORMATION_SCHEMA.TABLES contains wrong TABLE_TYPE
Submitted: 22 Dec 2004 16:19 Modified: 22 Dec 2004 16:58
Reporter: Matthias Leich Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0 OS:
Assigned to: CPU Architecture:Any

[22 Dec 2004 16:19] Matthias Leich
Description:
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (f1 BIGINT);
COMMIT;
SELECT TABLE_TYPE FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME= 't1';
TABLE_TYPE
TEMPORARY     <-- I expect the value 'BASE TABLE'  .

My environment:
   - Intel PC with Linux(SuSE 9.1)
   - MySQL compiled from source
        Version 5.0 ChangeSet@1.1732.27.1, 2004-12-22

How to repeat:
Please execute the statements above.
[22 Dec 2004 16:58] MySQL Verification Team
Duplicate for #7218