MySQL Bugs: #68221: I can't create tablse with names that include hyphen(-)

Bug #68221	I can't create tablse with names that include hyphen(-)
Submitted:	30 Jan 2013 1:16	Modified:	30 Jan 2013 8:18
Reporter:	eran or	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.44	OS:	Linux (ubuntu 12.1 64 bit)
Assigned to:		CPU Architecture:	Any
Tags:	characters

Description:
I have synoptic package workbench download. I created a new schema with name that include hyphen and I tried to add table to it with no success. 

How to repeat:
try to create schema with name like: some-thing . and try to add a table to this schema.

This works fine, at least on recent sources:

mysql> select version();
+-----------+
| version() |
+-----------+
| 5.6.11    |
+-----------+
1 row in set (0.00 sec)

mysql> create database `a-b`;
Query OK, 1 row affected (0.00 sec)

mysql> use `a-b`;
Database changed

mysql> create table `x-y` (a integer);
Query OK, 0 rows affected (0.34 sec)

mysql> show tables;
+---------------+
| Tables_in_a-b |
+---------------+
| x-y           |
+---------------+
1 row in set (0.00 sec)

mysql> 

Given the version number above, it looks more like a WB problem. Moving to the WB category.

Hello eran,

Thank you for the report.
I can not repeat described behavior on latest WB version.
Please try version 5.2.45. Thanks.

Also, more info on manual page when special chars used in object names - http://dev.mysql.com/doc/refman/5.5/en/identifiers.html

tables with hyphen

Attachment: 68221.png (image/png, text), 108.66 KiB.