MySQL Forums
Forum List  »  General

Re: Two equal SELECTs with UNION, but different result
Posted by: Rick James
Date: July 02, 2014 08:02PM

Suggestion: Build yourself a permanent table of integers rather than building them on the fly.

It _may_ be that the optimizer may be validly evaluating it differently. The table of integers is likely to avoid such an issue.

Options: ReplyQuote


Subject
Written By
Posted
Re: Two equal SELECTs with UNION, but different result
July 02, 2014 08:02PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.