non-inclusive bounds not processed correctly

[GoogleCodeExporter]

What steps will reproduce the problem?

See attached file.  It creates a 2-column table a,b with an index on both 
columns, and 6 records: (1,0),(1,1),(1,2),(1,0),(1,1),(1.2).

It then does an index query for record from 1,2 to 1,2 in two ways.  This query 
should find the two rows with value (1,2). 

The scope query using [1,2]:[1,2] properly finds 2 rows but the scope query 
with open left bounds (1,1):[1,2] finds none, which is a bug.

What version of the product are you using? On what operating system?

1.0.4.b986.

Please provide any additional information below.

Original issue reported on code.google.com by cdemarc...@gmail.com on 25 Mar 2011 at 7:00

Attachments:

• SqljetIndexTest.java

[GoogleCodeExporter]

Original comment by kit...@gmail.com on 25 Mar 2011 at 1:44

• Changed state: Accepted

[GoogleCodeExporter]

Thank you for reporting this issue! New code to support non-inclusive bounds 
did not work properly with non-unique indices, now this is fixed.

Fix is available since SqlJet 1.0.4.b1007 and you may get binaries at our build 
server at 
https://teamcity.svnkit.com/viewLog.html?buildId=13716&tab=artifacts&buildTypeId
=bt31

Original comment by kit...@gmail.com on 29 Mar 2011 at 1:47

• Changed state: Fixed