Syntax errors with unquoted UTF-8 table names

[Kolbe]

Some statements allow unquoted "exotic" UTF-8 characters, while others don't.

For example...

drizzle> create table ☃ (id int);
Query OK, 0 rows affected (0.02065 sec)

drizzle> show create table ☃;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near '' at line 1

drizzle> alter table ☃ add column a int;
Query OK, 0 rows affected (0.018981 sec)
Records: 0 Duplicates: 0 Warnings: 0

drizzle> select * from ☃;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near '' at line 1

drizzle> insert into ☃ values (1,1);
Query OK, 1 row affected (0.077079 sec)

drizzle> update ☃ set id=0;
Query OK, 1 row affected (0.004628 sec)
Rows matched: 1 Changed: 1 Warnings: 0

drizzle> drop table ☃;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near '' at line 1

[Kolbe (kolbe)]

I guess Jay didn't try dropping his table before he wrote that blog entry a few years ago ;)

http://planet.mysql.com/entry/?id=16120