MySQL's order by and limit offset a problem, take it out and everybody study under

Today comes a very weird question, title about MySQL's order by statement and the limit offset statement.

Under Bug reproduction: SELECT *

From a A

where A.culomn1

Limit 5 Offset 0

ORDER BY a.culomn1 ASC

The SqlException appears, prompting the order by this line to have a problem.

To change the statement to the following, swap the limit statement with the ORDER BY statement:

SELECT *

From a A

where A.culomn1

ORDER BY a.culomn1 ASC

Limit 5 Offset 0

will be normal execution, I do not know very little about SQL, so take out to learn, but also hope that everyone's generous enlighten.