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: [EMAIL PROTECTED] | + | Reported By: [EMAIL PROTECTED] | + | 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.
