[
https://issues.apache.org/jira/browse/OFBIZ-2396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Scott Gray closed OFBIZ-2396.
-----------------------------
Resolution: Fixed
Fix Version/s: SVN trunk
Release Branch 9.04
Thanks Brian, fixed in all 3 versions
trunk - r770571
9.04 - r770574
4.0 - r770575
Instead of clearing the field I just used a set operation in place of string-to-list so the old value will be overwritten.
> "Manage Picklist" errors out with MS-Sql when there is more than 1 pick list
> ----------------------------------------------------------------------------
>
> Key: OFBIZ-2396
> URL:
https://issues.apache.org/jira/browse/OFBIZ-2396> Project: OFBiz
> Issue Type: Bug
> Components: product
> Affects Versions: Release Branch 4.0
> Reporter: Brian Sanders
> Assignee: Scott Gray
> Fix For: Release Branch 4.0, Release Branch 9.04, SVN trunk
>
> Attachments: picklist.patch
>
>
> This may not affect other DBMS', but it definitely affects MS-Sql. Even though a "workaround" would be to only have 1 picklist at a time, I don't exactly consider that acceptable. Fortunately, it's an easy fix. It looks like this issue still lurks in the trunk as well. To sum it up, getPicklistSingleInfoInline is called for each picklist. In the method there is an "orderBy" list to which "sequenceId" is added. The first pass works fine, on the second pass, "sequenceId" is added to the list again and MS-Sql complains because the column is in the "order by" clause twice. The solution is to clear the field before-hand.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
Locked
