[Dbix-class] Union and Limit

[Peter Rabbitson]

Mike Raynham wrote:
> Hi,
> 
> It looks as though I have been led astray by MySQL.  The additional 
> parentheses around the individual SELECTs with the UNION set operation 
> are not supported by SQLite.  It appears as though support for ORDER and 
> LIMIT on each SELECT is also a MySQL thing.

No, it's a subselection thing as I showed you earlier. Also adding extra
parenthesis in the core code is counterproductive - it is easy to slap
an extra set, it is quite hard to remove an already existing set.