Azure / Azure/data-api-builder
MySql queries require Limit to maintain ordering
- 主要言語
- C#
- スター
- 1.5k
- フォーク
- 370
- 平均マージ
- 3日 22時間
- マージ済み PR(30日)
- 9
説明
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.
コントリビューションガイド
評価
この issue はまだ評価されていません。