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

["Brian Sanders (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/OFBIZ-2396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Brian Sanders updated OFBIZ-2396:
---------------------------------

    Attachment: picklist.patch

The simple solution

> "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
>             Fix For: Release Branch 4.0
>
>         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.