[BUG] no `` around tablename
| User, date | Message |
|---|---|
|
Written by koter84
6 years ago Category: General 15 posts since Wed, 08 Nov 06 |
When looking up data from a table whose name start with a number HeidiSQL gives an error. The SQL to produce this error is: SHOW COLUMNS FROM 871687110000310326 LIKE '%' which can be fixed by adding `` around the tablename like so: SHOW COLUMNS FROM `871687110000310326` LIKE '%' when the tablename doesn't start with a number there is no problem. [edit] The problem does not exists when there are ANY letters in the table name, apparently this problem only occurs when the tablename exists entirely of numbers. [/edit] |
|
Written by ansgar
6 years ago 3950 posts since Fri, 07 Apr 06 |
This bug is already fixed in our SVN working copy. So you just have to wait for the next release :) |
|
Written by koter84
6 years ago 15 posts since Wed, 08 Nov 06 |
any idea how long it will take for a next release? since i use a lot of databases which have these codes as tables. |
|
Written by ansgar
6 years ago 3950 posts since Fri, 07 Apr 06 |
Indeed we are short before the release of RC4. Will not take longer than days or weeks... :) |
|
Please login to leave a reply, or register at first. |