Bug #4410 When inserting into a column of string type (char, varchar or text), the

• Submitted: 5 Jul 2004 15:45
• Modified: 5 Jul 2004 16:17
• Reporter: David Johnson
• Status: Can't repeat
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.0.13
• OS: Linux (Linux)
• CPU Architecture: Any

[5 Jul 2004 15:45] David Johnson

Description:
When inserting into a column of string type (char, varchar or text), the
"values" cannot contain a semi-colon.  For example, this gets a syntax
error:  INSERT INTO abc VALUES (53, 'this; is wrong');    The same is true
even when the semi-colon is escaped.  Found in Version 4.0.13; don't know
if this exists in other versions.

How to repeat:
1. Create a table that contains at least one field of string type (char, varchar or text)
2. Try to insert a value into that string field where the string being inserted contains an embedded semi-colon

[5 Jul 2004 16:17] Guilhem Bichot

Hi,
Could not repeat it with 4.0.20 and 4.1.3:
SLAVE> create table u (a varchar(100));
Query OK, 0 rows affected (0.03 sec)

SLAVE> insert into u values('this; is wrong');
Query OK, 1 row affected (0.19 sec)

SLAVE> select * from u;
+----------------+
| a              |
+----------------+
| this; is wrong |
+----------------+
1 row in set (0.12 sec)