[
https://issues.apache.org/jira/browse/IBATIS-143?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12473852
]
Paul Benedict commented on IBATIS-143:
--------------------------------------
It's not just trimming the produced output. But it is splitting the SQL into
multiple lines (split on carriage returns), trim there, aggregate output. You
want one line with extraneous spaces removed -- across all lines. Most people
like me write SQL more vertical than horizontal :-)
> Remove blanks in SQL
> --------------------
>
> Key: IBATIS-143
> URL: https://issues.apache.org/jira/browse/IBATIS-143
> Project: iBatis for Java
> Issue Type: Improvement
> Components: SQL Maps
> Environment: all
> Reporter: Steffen Legler
> Priority: Minor
>
> Dynamically built SQL-Statements include a lot of blanks when using
> conditional
> elements like <isEqual>. The database doesn't care, but for logging it would
> be
> nice to have a well written sql-statement, e.g. :
> <update id="update" parameterClass="paramClass">
> update schema.table1 set
> <isEqual property="listId" compareValue="1">
> column1 = #value#
>
> </isEqual>
> <isEqual property="listId" compareValue="2">
> column2 = #value#
>
> </isEqual>
> where id=#instanceId#
> </update>
>
> The result of a statement looks like this;
> update schema.table1 set column1 = '123'
> where id = 1000
>
> For readability it would be nice to have something like this:
> update schema.table1 set column1 = '123' where id = 1000
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
