Project

General

Profile

Actions
Copy link

Defect #2417

closed

Sorting controlled values for merge in GUI doesn't order them (PostgreSQL) or fails (MS SQL)

Added by Alena Peterová about 4 years ago. Updated about 4 years ago.

Status:
Closed
Priority:
Low
Assignee:
Radek Tomiška
Category:
Provisioning
Target version:
10.4.4
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

merge_attributes_mssql_error.png (22.9 KB) merge_attributes_mssql_error.png Alena Peterová, 07/31/2020 01:58 PM
Actions
Copy link
 #1

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
Actions
Copy link
 #2

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.

Commit:
https://github.com/bcvsolutions/CzechIdMng/commit/15d732989e4b836edcc2764cb3aa07da0feff719#diff-c32a8bc66224f1d8cfd2fce24ac7d186R55

Could you provide me a feedback, please?

Actions
Copy link
 #3

Updated by Radek Tomiška about 4 years ago

  • Target version changed from 10.4.3 to 10.4.4
Actions
Copy link
 #4

Updated by Vít Švanda about 4 years ago

  • Assignee changed from Alena Peterová to Vít Švanda
Actions
Copy link
 #5

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.

Actions
Copy link
 #6

Updated by Vít Švanda about 4 years ago

  • Target version changed from 10.5.0 to 10.4.4
Actions
Copy link
 #7

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
Copy link

Also available in: Atom PDF