You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ant.apache.org by bu...@apache.org on 2001/09/12 00:38:32 UTC
[DO NOT REPLY: Bug 3556] New:
SQLExec inproperly handling REM statements
PLEASE DO NOT REPLY TO THIS MESSAGE. TO FURTHER COMMENT
ON THE STATUS OF THIS BUG PLEASE FOLLOW THE LINK BELOW
AND USE THE ON-LINE APPLICATION. REPLYING TO THIS MESSAGE
DOES NOT UPDATE THE DATABASE, AND SO YOUR COMMENT WILL
BE LOST SOMEWHERE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=3556
*** shadow/3556 Tue Sep 11 15:38:32 2001
--- shadow/3556.tmp.4834 Tue Sep 11 15:38:32 2001
***************
*** 0 ****
--- 1,38 ----
+ +============================================================================+
+ | SQLExec inproperly handling REM statements |
+ +----------------------------------------------------------------------------+
+ | Bug #: 3556 Product: Ant |
+ | Status: NEW Version: 1.4 |
+ | Resolution: Platform: All |
+ | Severity: Normal OS/Version: All |
+ | Priority: Other Component: Core tasks |
+ +----------------------------------------------------------------------------+
+ | Assigned To: ant-dev@jakarta.apache.org |
+ | Reported By: todd_evans@fanniemae.com |
+ | CC list: Cc: |
+ +----------------------------------------------------------------------------+
+ | URL: |
+ +============================================================================+
+ | DESCRIPTION |
+ The SQLExec target is inproperly handling of the REM statement. Any SQL
+ statement or column starting with Rem is ignored. For example
+
+ INSERT foo (
+ a,
+ RemittanceTypCd,
+ c ) VALUES (
+ 1,
+ 2,
+ 3)
+ ;
+
+ Since line is trimmed of white-space before the check of REM in the first 3
+ columns line with RemittanceTypCd will be ignored.
+
+ In SQLExec.runStatements(Reader, PrintStream) method the
+
+ if (line.length() > 2 &&
+ line.substring(0,3).equalsIgnoreCase("REM")) continue;
+
+ check should be moved ahead of the line.trim() statement. It appears that this
+ bug was added in the 1.4 release. I can supply a patch if needed.