using a fieldname containing the word delimiter fails

Bug #733587 reported by Walter Heck on 2011-03-11
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Drizzle
Fix Released
Low
Andrew Hutchings
7.0
Fix Released
Low
Andrew Hutchings

Bug Description

see this:

drizzle> \s
--------------
Drizzle client 7 build 2011.03.11, for pc-linux-gnu (x86_64) using readline 6.1

Connection id: 14
Current schema: test
Current user: (null)
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 2011.03.11 Ubuntu
Protocol: mysql
Protocol version: 10
Connection: localhost
TCP port: 4427
--------------

drizzle>

drizzle> create table t4(t1_delimi varchar(10) default '' not null);
ERROR 1050 (42S01): Table 'test.t4' already exists
drizzle> create table t5(t1_delimi varchar(10) default '' not null);
Query OK, 0 rows affected (0.005698 sec)
drizzle> create table t6(t1_delimit varchar(10) default '' not null);
Query OK, 0 rows affected (0.035059 sec)
drizzle> create table t7(t1_delimiter varchar(10) default '' not null);
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> create table t8(t1_delimitr varchar(10) default '' not null);
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
    -> \d;
    -> \c
drizzle> \d;
drizzle> create table t8(t1_delimitr varchar(10) default '' not null);
Query OK, 0 rows affected (0.005721 sec)

drizzle> create table t9(t1_delimiter varchar(10) default '' not null);
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

Related branches

Changed in drizzle:
assignee: nobody → Andrew Hutchings (linuxjedi)
Andrew Hutchings (linuxjedi) wrote :

Bug fix to be backported from MySQL for this: http://bugs.mysql.com/bug.php?id=33812

Changed in drizzle:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.