きっかけtom__boさんが書かれた8.0.22でのprepared statementの挙動変化 で、ORDER BY に列番号を指定する問題に注目が集まりました。 その中で紹介されていた、 For a prepared statement of the form SELECT expr1, expr2, … FROM table ORDER BY ?, passing an integer value N for the parameter no longer causes ordering of the results by the Nth expression in the select list; the results are no longer ordered, as is expected with ORDER BY constant. 「the results are n
![SQLのORDER BY 列番号と式 :: Noboru Saito's page](https://cdn-ak-scissors.b.st-hatena.com/image/square/c085deef9ef78134857606ad107170b40fa4262c/height=288;version=1;width=512/https%3A%2F%2Fnoborus.github.io%2Fimages%2Fnoborus.png)