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.
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[email protected]
