linux-traipu team mailing list archive

[Kolbe <912410@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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

** Affects: drizzle
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of UBUNTU -
AL - BR, which is subscribed to Drizzle.
https://bugs.launchpad.net/bugs/912410

Title:
  Syntax errors with unquoted UTF-8 table names

Status in A Lightweight SQL Database for Cloud Infrastructure and Web Applications:
  New

Bug description:
  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

To manage notifications about this bug go to:
https://bugs.launchpad.net/drizzle/+bug/912410/+subscriptions