| Bug #382 | ERROR 1104 when opening a table in MySQL Control Center | ||
|---|---|---|---|
| Submitted: | 6 May 2003 11:49 | Modified: | 21 Aug 2003 1:01 |
| Reporter: | Jan Sijm | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQLCC | Severity: | S2 (Serious) |
| Version: | 9.0.2 | OS: | Windows (Windows 98 SE) |
| Assigned to: | Jorge del Conde | CPU Architecture: | Any |
[21 Aug 2003 1:01]
Jorge del Conde
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.
If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information
about accessing the source trees is available at
http://www.mysql.com/doc/en/Installing_source_tree.html
Description: Hi, I have the following table in MySQL (unique index on CountryID): CREATE TABLE Country ( CountryID int NOT NULL PRIMARY KEY AUTO_INCREMENT, Country varchar(50) NULL, CountryCode varchar(3) NULL ) ; When the table is empty, I can open the table without error. After inserting the first record, I get the following error message: [MySQLServer] ERROR 1104: The SELECT would examine too many records and probably take a very long time. Check your WHERE and use SET OPTION SQL_BIG_SELECTS=1 if the SELECT is ok I have tried to solve this problem, but nothing seems to help. I have the strong impression that it has to do with the fact that the CountryID column has an auto_increment attribute. I have the same problem with other tables that also have a column with the auto_increment attribute. How to repeat: See table definition above... Suggested fix: Fix MYSQLCC to correctly open a table that has the auto_increment attribute.