Hi, This should be fixed in the trunk now, see issue 387: WHERE condition getting pushed into sub-query with LIMIT.
Regards, Thomas On Tue, Mar 20, 2012 at 3:11 PM, Stefan Zeiger <[email protected]> wrote: > On 2012-03-20 14:03, Noel Grandin wrote: > > That looks like a bug. > Could you produce a reduced test-case? > > > It's reproducible with pretty much the simplest possible code (as long as > you're filtering on a second column and not on the COF_NAME directly): > > DROP TABLE COFFEES if exists; > CREATE TABLE COFFEES (COF_NAME VARCHAR,PRICE INT); > > INSERT INTO COFFEES (COF_NAME,PRICE) VALUES ('Colombian', 5); > INSERT INTO COFFEES (COF_NAME,PRICE) VALUES ('French_Roast', 5); > INSERT INTO COFFEES (COF_NAME,PRICE) VALUES ('Colombian_Decaf', 20); > > select * from ( > select COF_NAME, PRICE from COFFEES order by COF_NAME LIMIT 2 > ); > -- finds Colombian and Colombian_Decaf > > select * from ( > select COF_NAME, PRICE from COFFEES order by COF_NAME LIMIT 2 > ) where PRICE < 10; > -- should find only Colombian but also finds French_Roast > > > -- > Stefan Zeiger > Typesafe - The software stack for applications that scale > Twitter: @StefanZeiger > > -- > 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. -- 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.
