DO NOT REPLY [Bug 30502] - SQLExec: treatment of "--" inside of strings

[bugzilla]

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=30502>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=30502

SQLExec:  treatment of "--" inside of strings





------- Additional Comments From [EMAIL PROTECTED]  2004-08-05 21:51 -------
Oh, here's the build.xml snippet:

    <target name="blah"
        <sql driver="${mysql.driver}"
             url="jdbc:mysql://${db.host.mysql}/${db.dbname.mysql}"
             userid="${db.user.mysql}"
             password="${db.password.mysql}"
             classpathref="compile.path"
             autocommit="false">

DROP TABLE IF EXISTS some_table;
CREATE TABLE some_table
(
  id    tinyint(4) NOT NULL,
  text  varchar(20) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=InnoDB;

INSERT INTO some_table VALUES (1, 'Blah blah blah--blah blah blah');
INSERT INTO some_table VALUES (2, "Blah blah blah blah blah blah");

        </sql>
    </target>

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]