I have a table with 3 columns as primary keys (Number, Number, Text).
I'm trying to execute
SELECT * FROM TABLE WHERE KEY1=1 AND KEY2=2 AND KEY3='text'
The query return 1 row. OK.
But when I execute
SELECT * FROM TABLE WHERE KEY1=1 AND KEY2=2
It returns nothing.
I've tried to compact&repair but it didn't help.
If instead of removing the KEY3 AND condition I remove any other, it works.
Thanks for your valuable report. v3.0.025 fixed an bug on utilizing part expression of component index to quicken query. That package will be available after about 24 hours.