Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-7312

Fix queries using operator IN in their clauses for SQL Server

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 5.3.1
    • Fix Version/s: 5.5
    • Component/s: Core VCS
    • Environment:
      SQL Server with a case-insensitive collation configured
    • Upgrade notes:
      Hide

      Columns where this is a problem must be changed to have a binary collation, for instance:
      ALTER TABLE [hierarchy] ALTER COLUMN [primarytype] VARCHAR(256) COLLATE Latin1_General_BIN;
      ALTER TABLE [hierarchy] ALTER COLUMN [name] VARCHAR(256) COLLATE Latin1_General_BIN;

      Show
      Columns where this is a problem must be changed to have a binary collation, for instance: ALTER TABLE [hierarchy] ALTER COLUMN [primarytype] VARCHAR(256) COLLATE Latin1_General_BIN; ALTER TABLE [hierarchy] ALTER COLUMN [name] VARCHAR(256) COLLATE Latin1_General_BIN;

      Description

      When the server collation is case insensitive (CI present in the collation name), some queries will fail because they are supposed to match the File type but will also match the file complex properties.

      org.nuxeo.ecm.core.api.DocumentException: Unknown document type: file

        Attachments

          Issue Links

          depends on

          Bug - A problem which impairs or prevents the functions of the product. NXP-5183 Fix queries using operator IN in their clauses for MySQL

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: