| Bug #28562 | Table does not exist - Table already exists | ||
|---|---|---|---|
| Submitted: | 21 May 2007 14:57 | Modified: | 16 Jul 2007 7:54 |
| Reporter: | Georg Gut | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Server | Severity: | S2 (Serious) |
| Version: | 5.1.17-beta | OS: | Windows (XP SP2) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | but exists, Table does not exist | ||
[16 Jun 2007 7:54]
Valeriy Kravchuk
Thank you for a problem report. Please, send the entire error log (<hostname>.err in a data directory, usually).
[16 Jul 2007 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
Description: mysql> select count(*) from nopart_innodb; ERROR 1146 (42S02): Table 'benchmark.nopart_innodb' doesn't exist mysql> drop table nopart_innodb; ERROR 1051 (42S02): Unknown table 'nopart_innodb' mysql> CREATE TABLE nopart_innodb ( -> value_number FLOAT, -> datetime TIMESTAMP, -> step_id MEDIUMINT UNSIGNED, -> limit_id MEDIUMINT UNSIGNED, -> dut_id INT UNSIGNED -> ) ENGINE=INNODB; ERROR 1050 (42S01): Table 'nopart_innodb' already exists mysql> select version(); +------------------------------------+ | version() | +------------------------------------+ | 5.1.17-beta-community-nt-debug-log | +------------------------------------+ 1 row in set (0.00 sec) mysql> show tables; +---------------------+ | Tables_in_benchmark | +---------------------+ | nopart_innodb | | nopart_myisam | | part_innodb | | part_myisam | | starttable | +---------------------+ 5 rows in set (0.00 sec) mysql> How to repeat: Installed MySQL. Created 5 tables - see above.