| 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: | |
| Category: | MySQL Server | Severity: | S2 (Serious) |
| Version: | 5.0 | OS: | |
| Assigned to: | CPU Architecture: | Any | |
Duplicate for #7218
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.058 sec. using MySQL 8.4.5-u7-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
© 2025, Oracle Corporation and/or its affiliates
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.