Query with not unique index matches only the first condition [moved]

[lvca]

This is Issue 64 moved from a Google Code project.
Added by 2010-07-14T19:45:03.000Z by daiyam99@gmail.com.
Please review that bug for more context and additional comments, but update this bug.
Closed (Fixed).

Original labels: Type-Defect, Priority-Medium, v1.0rc3

Original description

Hello Luca,

I've discovered your database few days ago and I like some of its features.

I've found a problem when I query a database on which I have a not unique index.
If I do a select on the property with not unique index and on another property, the condition on the second property is ignored.

I've include a patch for the IndexTest.java file so you can test it.
It's just some few more tests which are doing:
 - remove the index on 'nick'
 - do some queries
 - add a not unique index on 'nick'
 - redo the same queries (fail here)
 - add a not unique index on 'name'
 - redo the same queries

I hope that will help.

Regards,
Baptiste

PS: I was wondering if it's possible to contribute to the project?