#851 SQL update/upsert wizard fails if column name contains "SET"

[prichards]

Bulild 5.5.0.39 (GA)

The SQL Wizard for update and insert-update fails to create the correct xa:column_map, when a database column namecontains "SET" as part of the name. xa:table is set incorectly (contains part of the column text - up to the column with "SET" in the name) and ignores all columns preceding it in the xa:column_map. The columns cannot be mapped and the Bizcomp contains an incorrect column map for the first element.

For example,

<xa:request xa:oper="insert_update" xa:table="DEMO.XDEAL &#xD;&#xA;SET&#xD;&#xA; DEMO.XDEAL.DEAL_ID = ?,&#xD;&#xA; DEMO.XDEAL.">...

<xa:column_map>
<TLEMENT_DATE xa:sql_type="0" xa:sql_type_name="" xa:column_class="" />
<ISSUE_DATE xa:sql_type="91" xa:sql_type_name="DATE" xa:column_class="java.sql.Timestamp" />
</xa:column_map>

(should have columns DEAL_ID and SETTLEMENT_DATE (of type 91).

The Bizcomp can be manually corrected and will then execute correctly, but cannot be Edited with the Wizard again, or the same error will occur and all manual edits lost.