Mailing-List: contact dev-help@ant.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Ant Developers List" <dev@ant.apache.org>
Date: Fri, 19 Nov 2004 07:44:50 +0100
Message-Id: <200411190644.iAJ6ioPY012747@ajax.apache.org>
From: bugzilla@apache.org
To: dev@ant.apache.org
Subject: DO NOT REPLY [Bug 27739]  -
    sql insert statement fails on '--' strings

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=27739>.
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=27739


------- Additional Comments From kevin.jackson@it.fts-vn.com  2004-11-19 07:44 -------
I've just spent an unproductive 30 mins trying to duplicate this bug.

I've only looked at the runStatements method as this seems to be the only one
that actively looks for comments "--, // or REM" and tries to deal with them.

My test SQL was a simple SELECT '--', '--' FROM USERS; --comment

The method deals with these -- as it should do.

I'm attaching a Junit test of the behaviour (excluding DB access).  At first I
was going to have two stubbed methods and then leave one whilst working on the
other, but as the first exhibits the correct behaviour as far as I know, there
didn't seem to be much point rewriting it.

Notes:
[1]I know that the code doesn't execute the SQL - my reasoning is that if the
method doesn't break the SQL at the first --, then it's going to be fine when it
passes it along to the DB - I'd process the statement if I was Oracle!

[2]I know that it won't prove the absence of a bug, but I think it may point to
a problem elsewhere, configuration, JDBC task etc?

-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@ant.apache.org
For additional commands, e-mail: dev-help@ant.apache.org