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-union-query/ 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-union-query/ _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
