On Thu, 2008-12-11 at 14:13 -0800, Markus Plesser wrote: > The idea on "ORDER BY sub.ismldef LIMIT 1" is to get entries flagged > as default language first. And I didn't know that such sets are not > sorted - we tested this on MySQL and they were (or at least appeared > to).
I can confirm that sorted subqueries both parse and can make a difference in SQLite3 as well. -- Joshua Paine LetterBlock: Web applications built with joy http://letterblock.com/ 301-576-1920 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
