distal-attribute
distal-attribute
distal-attribute
distal-attribute

[BUG] no `` around tablename

User, date Message
Written by koter84
8 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
8 years ago
4936 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
8 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
8 years ago
4936 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.