Try our conversational search powered by Generative AI!

Certain stored procedures fail to be created in database with Finnish_Swedish_CI_AI collation

Found in

EPiServer.Commerce 11.3.0

Fixed in

EPiServer.Commerce 13.16.1

(Or a related package)

Created

Feb 11, 2020

Updated

Mar 16, 2020

State

Closed, Fixed and tested


Description

Creation of two stored procedures (listed below) fails with the message "The correlation named 'w' is specified multiple times in a FROM clause."
This is because 'v' and 'w' are considered equal in Finnish_Swedish_CI_AI collation (specifically because it is accent insensitive - "AI"), and these stored procedures contain FROM clauses like

FROM someTable v INNER JOIN otherTable w on v.WorkId = w.WorkId

Stored procedures with this issue:

  • ecfVersion_SyncEntryData
  • ecfVersion_UpdateSeoByObjectIds