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

Abierto
#3,476 0 comentarios 0 reacciones 0 asignados Ver en GitHub

Los mantenedores suelen responder en 1 día

Nadie ha tomado este issue todavía.

Evaluación

Dificultad
4/5
Tiempo estimado
3-5 días
Aptitud para principiantes
48/100
Tipo de issue
Error
Claridad
Bastante claro
Estado de actividad
Activo
Stack tecnológico
csharp, postgresql
Área
databases

Línea de trabajo

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.

Escrito por el modelo de indexación a partir del texto del issue.

Descripción

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.

Lenguaje dominante
C#
Estrellas
567
Forks
107
Merge medio
1 h 19 min
PR fusionados (30 d)
353

Preparar el entorno

Primeros pasos

  1. Lee el issue completo y luego la guía de contribución del proyecto.
  2. Comenta en el issue que vas a ocuparte — evita que dos personas hagan lo mismo.
  3. Haz un fork del repositorio y trabaja en una rama.
  4. Abre un pull request que haga referencia al número del issue.

Más de fluentcms/FluentCMS

Todos los issues de fluentcms/FluentCMS

Issues similares

Más issues de C#

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.