3 messages in com.mysql.lists.bugsStrange parser bug with MySQL-4.0.4
FromSent OnAttachments
Jocelyn Fournier24 Sep 2002 05:17 
Roger Baklund24 Sep 2002 06:14 
Michael Widenius24 Sep 2002 11:48 
Subject:Strange parser bug with MySQL-4.0.4
From:Jocelyn Fournier (jo@presence-pc.com)
Date:09/24/2002 05:17:12 AM
List:com.mysql.lists.bugs

Hi,

I tried by mistake to execute a malformed SQL query, and it results in the following strange result :

How-to-repeat :

CREATE TABLE forum ( no int(11) NOT NULL auto_increment, exp varchar(50) default NULL, la_date datetime default NULL, sujet varchar(250) default NULL, message text, ref int(11) NOT NULL default '0', last_modif datetime default NULL, admin varchar(10) default NULL, PRIMARY KEY (no) ) TYPE=MyISAM;

INSERT INTO forum VALUES (41, 'KARINE', '2002-09-23 15:55:22', 'ACOUSTIQUE avec un C... ds 'je passe tous les jours sur le forum!!! Il faut le faire vivre!!!!!!! lol\r<br />\n\r<br />\nToussssss au concert!!!!!!!!!!! Ou!!!!\r<br />\n\r<br />\nB\'zoussssss a toussssss!!!!', 38, NULL, ''); ERROR 2005: Unknown MySQL Server Host '/>\n\r<br' (1)

Any idea of what happened ?

Regards, Jocelyn