using a fieldname containing the word delimiter fails
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
- Drizzle Developers: Pending requested
-
Diff: 73 lines (+15/-32)1 file modifiedclient/drizzle.cc (+15/-32)
Changed in drizzle: | |
assignee: | nobody → Andrew Hutchings (linuxjedi) |
Changed in drizzle: | |
status: | Fix Committed → Fix Released |
Bug fix to be backported from MySQL for this: http:// bugs.mysql. com/bug. php?id= 33812