[BUG] no `` around tablename

[expired user #412]'s profile image [expired user #412] posted 17 years ago in General Permalink
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]
ansgar's profile image ansgar posted 17 years ago Permalink
This bug is already fixed in our SVN working copy. So you just have to wait for the next release :)
[expired user #412]'s profile image [expired user #412] posted 17 years ago Permalink
any idea how long it will take for a next release?

since i use a lot of databases which have these codes as tables.
ansgar's profile image ansgar posted 17 years ago Permalink
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.