Content text collation: schema apply does not see it, and SQL Server may order characters above U+FFFF differently

Ouverte
#3,476 0 commentaires 0 réactions 0 personnes assignées Voir sur GitHub

Les mainteneurs répondent en général sous 1 jour

Personne n'a encore pris cette issue.

Évaluation

Difficulté
4/5
Temps estimé
3-5 jours
Accessibilité débutants
48/100
Type d'issue
Bug
Clarté
Plutôt claire
Activité
Active
Stack technique
csharp, postgresql
Domaine
databases

Piste de recherche

Read the collation work in #3308, #3474, and #2874, then find the schema apply comparison for content text columns and its tests. Check which SQL Server binary collation is used and add a provider test around U+FFFF. Done means schema apply reports the mismatch with tested apply behavior, and the ordering issue has a provider test plus a fix or a specification sentence.

Rédigé par le modèle d'indexation à partir du texte de l'issue.

Description

area:storage type:bug

Follow-ups of the collation of content text (#3308, #3474), found in its review.

  • Schema apply does not report or fix a content text column whose collation differs from the model. It compares only type and nullability, so after #3474 an existing PostgreSQL database on schema apply keeps the database collation on its content text columns, and a SQL Server database made before #2874 keeps its old collation, without a word in the plan or the startup report. Report such a column, and decide whether apply changes it (SQL Server refuses ALTER COLUMN ... COLLATE on an indexed column).
  • SQL Server's binary collation may order characters above U+FFFF by UTF-16 code unit. Then a character at U+10000 or above sorts before one in U+E000 to U+FFFF on SQL Server and after it on SQLite and PostgreSQL, so "code-point order on every provider" would not hold there. Not verified: check which _BIN or _BIN2 collation is used and add a provider test with such characters.

Wanted

  • Schema apply names a content text column with another collation, with a test.
  • A provider test of the order around U+FFFF, and a fix or a sentence in the specification.

Found in the review of #3474. Bundle 13.

Langage dominant
C#
Étoiles
567
Forks
107
Merge moyen
1 h 19 min
PR mergées (30 j)
353

Préparer son environnement

Par où commencer

  1. Lisez l'issue en entier, puis le guide de contribution du projet.
  2. Signalez en commentaire que vous la prenez — cela évite que deux personnes fassent le même travail.
  3. Forkez le dépôt et travaillez sur une branche.
  4. Ouvrez une pull request qui référence le numéro de l'issue.

Autres issues de fluentcms/FluentCMS

Toutes les issues de fluentcms/FluentCMS

Issues similaires

Plus d'issues C#

Recevez les nouvelles issues par e-mail

Un résumé court des issues GitHub adaptées aux débutants.