[OFBIZ-2396] "Manage Picklist" errors out with MS-Sql when there is more than 1 pick list

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Release Branch 4.0
• Fix Version/s: Release Branch 4.0, Release Branch 09.04, Trunk
• Component/s: product
• Assignee: Scott Gray
• Reporter: Brian Sanders
• Created: 30/Apr/09 20:16
• Updated: 01/May/09 08:20
• Resolved: 01/May/09 08:20

Description

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.