Bug #24705 DESCRIBE don't running with char "-" in tablename
Submitted: 29 Nov 2006 22:07 Modified: 30 Nov 2006 3:08
Reporter: Roman Hanajik Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.21 OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any
Tags: DESCRIBE

[29 Nov 2006 22:07] Roman Hanajik
Description:
I have table like "table-abouth". I can work with this table, but use SQL command   DESCRIBE is impossible. 

How to repeat:
allways
[29 Nov 2006 22:30] MySQL Verification Team
Thank you for the bug report. I was unable to repeat the behavior
reported:

C:\dbs\4.1\bin>mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.1.21-community-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use test
Database changed
mysql> create table `table-abouth` (id int);
Query OK, 0 rows affected (0.08 sec)

mysql> desc `table-abouth`;
+-------+---------+------+-----+---------+-------+
| Field | Type    | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| id    | int(11) | YES  |     | NULL    |       |
+-------+---------+------+-----+---------+-------+
1 row in set (0.02 sec)

mysql> describe `table-abouth`;
+-------+---------+------+-----+---------+-------+
| Field | Type    | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| id    | int(11) | YES  |     | NULL    |       |
+-------+---------+------+-----+---------+-------+
1 row in set (0.00 sec)

mysql>
[30 Nov 2006 2:58] Roman Hanajik
ups, sorry, it's bug probably for phpmyadmin, and was probably on FreeBSD.
Anyway thanks for fast replay :)
[30 Nov 2006 3:03] Roman Hanajik
but not, from PHP script also... i will find more informations about system
[30 Nov 2006 3:08] Roman Hanajik
version compile os  	portbld-freebsd6.1
 version compile machine  	i386
 version comment  	FreeBSD port: mysql-server-4.1.21
 version bdb  	Sleepycat Software: Berkeley DB 4.1.24: (July 19, 2006)
 version  	4.1.21-log
 table type  	MyISAM