Bug #5876 Parsing the ';' char
Submitted: 4 Oct 2004 10:59 Modified: 13 Oct 2004 1:47
Reporter: Antonello Franzil Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / NET Severity:S1 (Critical)
Version:1.0.0 OS:Windows (Win Server 2003)
Assigned to: Reggie Burnett CPU Architecture:Any

[4 Oct 2004 10:59] Antonello Franzil
Description:
I have a problem passing a Sql INSERT/UPDATE statement including a ';' char in a text field.

In the command.cs file --> PrepareCommandText --> TokenizeSql, the function check the ';' occurency and not recognize if is a part of a string field.

How to repeat:
(Mysql 4.0.21/nt and Connector/Net)

SQL statement

UPDATE spider_pagine SET ContentType='text/html; charset=iso-8859-1', DateAdd='2004/10/04 12.15.52', Description='Some char here; Some char here', Encoding='iso-8859-1', idSito=185, Keywords='Some char here.', 0, pLength=-1, URL='http://www.yourdomain.com/'; WHERE idPagina=13174
[8 Oct 2004 17:20] Matthew Lord
I verified this on windows 2000 using c# and the 1.0.0 beta driver.
[13 Oct 2004 1:47] Reggie Burnett
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html