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.
|