Actions
Defect #2417
closedSorting 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
Updated by Radek Tomiška about 4 years ago
- Assignee changed from Vít Švanda to Radek Tomiška
- Target version set to 10.5.0
Updated by Radek Tomiška about 4 years ago
- Status changed from New to Needs feedback
- Assignee changed from Radek Tomiška to Alena Peterová
- Target version changed from 10.5.0 to 10.4.3
- % Done changed from 0 to 90
- Affected versions 10.4.2 added
I removed sorting on "Value" column - sort is not available for serializable(bytea for PostgreSQL or image for MSSQL) data type.
Could you provide me a feedback, please?
Updated by Radek Tomiška about 4 years ago
- Target version changed from 10.4.3 to 10.4.4
Updated by Vít Švanda about 4 years ago
- Assignee changed from Alena Peterová to Vít Švanda
Updated by Vít Švanda about 4 years ago
- Status changed from Needs feedback to Resolved
- Target version changed from 10.4.4 to 10.5.0
- % Done changed from 90 to 100
I did review and tested it. Sorting by value is not supported now. Thanks for fixing this my bug.
Updated by Vít Švanda about 4 years ago
- Target version changed from 10.5.0 to 10.4.4
Updated by Radek Tomiška about 4 years ago
- Status changed from Resolved to Closed
- Assignee changed from Vít Švanda to Radek Tomiška
Actions