MySQL Forums
Forum List  »  Custom Storage Engines

Range Queries on Custom Storage Engines
Posted by: Primal Wijesekera
Date: August 01, 2011 08:25PM

Hello All,

I am just trying to figure out how a range query such as below mentioned one would pass on the storage engine.

select * from usertable where age < 45 and age > 40;

The custom engine only called for index search of 40 not for 45. I was assuming it would call for both values.

It seems that internally mysql engine is doing the filtering for 45.

Is that correct ? or am I missing something here ?

Thank You very much in advance.

- primal

Options: ReplyQuote

Written By
Range Queries on Custom Storage Engines
August 01, 2011 08:25PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.