Actions
Defect #2417
closed
Sorting controlled values for merge in GUI doesn't order them (PostgreSQL) or fails (MS SQL)
Start date:
07/31/2020
Due date:
% Done:
100%
Estimated time:
Affected versions:
Rhyolite (9.7.0), Rhyolite (9.7.2), Rhyolite (9.7.3), Rhyolite (9.7.4), Rhyolite (9.7.5), Rhyolite (9.7.6), Rhyolite (9.7.7), Rhyolite (9.7.8), Rhyolite (9.7.9), Rhyolite (9.7.10), Rhyolite (9.7.11), Rhyolite (9.7.12), Rhyolite (9.7.13), 10.0.0, Rhyolite (9.7.14), 10.0.1, 10.1.0, Rhyolite (9.7.15), Rhyolite (9.7.16), 10.2.0, 10.0.2, 10.3.0, 10.3.1, 10.3.2, Rhyolite (9.7.17), 10.3.3, 10.4.0, 10.4.1, 10.4.2
Owner:
Description
Version 10.4.1
I tried to sort controlled values (merge) by the column "Value" on IdM running on MS SQL and got the Server error:
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
When tried on 9.7.16 running on PostgreSQL, it doesn't fail, but the result isn't ordered.
(The only reason why I tried this was searching for a specific value in the table. Otherwise the sorting is probably not needed here.)
Files
Actions