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 <http://typesafe.com> - The software stack for applications
that scale
Twitter: @StefanZeiger <http://twitter.com/#%21/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.
