Azure / Azure/data-api-builder

MySql queries require Limit to maintain ordering

Abierto
#350 0 comentarios 0 reacciones 1 asignado Reclamado por @junsu0ms Ver en GitHub
bug mysql
Lenguaje dominante
C#
Estrellas
1.5k
Forks
370
Merge medio
3 d 22 h
PR fusionados (30 d)
9

Descripción

Certain MySql queries will not maintain the ordering unless you include a limit in the query.

`SELECT JSON_ARRAYAGG(JSON_OBJECT('id', id, 'title', title, 'publisher_id', publisher_id)) AS data
FROM (
SELECT id, title, publisher_id
FROM " + _integrationTableName + @"
ORDER BY id desc, publisher_id
LIMIT 100
) AS subq"`

As an example, the above query will not pass the test which verifies the sorted order of the columns without including a LIMIT. This work around of adding a LIMIT currently provides a solution to this problem, but we should investigate if this can be resolved in another way.

Guía de contribución

Abrir la guía de contribución

Evaluación

Este issue todavía no se ha evaluado.

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.