maria-discuss team mailing list archive

Thread
Date

New Question: Strange issue with a complex stored procedure and Union Query

To: maria-discuss@xxxxxxxxxxxxxxxxxxx
From: AskMonty KB <noreply@xxxxxxxxxxxx>
Date: Wed, 01 Apr 2015 17:00:03 -0000

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/