[Maria-discuss] New Question: Strange issue with a complex stored procedure and Union Query
Hello, A new question has been asked in "MariaDB Community" by stewartpage. Please answer it at http://mariadb.com/kb/en/strange-issue-with-a-complex-stored-procedure-and-u... as the person asking the question may not be subscribed to the mailing list. -------------------------------- 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? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/strange-issue-with-a-complex-stored-procedure-and-u...
participants (1)
-
AskMonty KB