Strange issue with a complex stored procedure and Union Query
I have a complex stored procedure that executes on a schedule. It runs a union query and inserts the results into a table. I recently discovered that it needed to have a LIMIT added to both queries so I enclosed the two selects in brackets, and immediately the query error'd. Removing the brackets allowed the query to run correctly.
Are there any issues I should be aware of?
Answer Answered by Ian Gilfillan in this comment.
http://stackoverflow.com/questions/213851/sql-query-using-order-by-in-union probably answers your question.
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
