2i bug, using an integer index with negative values misses results [JIRA: CLIENTS-47]

[mcobzarenco]

I am using the LevelDB backend with the protobuf API (Riak 2.1.0). Range queries over negative values with endkey=0 always return empty results.

To reproduce:

rc = riak.RiakClient(protocol='pbc', nodes=[{'host': 'localhost', 'pb_port': 8087}])
bucket = rc.bucket('x') 

bucket.new('a').add_index('test_int', -3).store()
bucket.new('b').add_index('test_int', -5).store()

Now, doing a range query with endkey=0 does not return anything

In : b.get_index('test_int', startkey=-10, endkey=0).results
Out: []

Whereas

In : b.get_index('test_int', startkey=-10, endkey=1).results
Out: ['b', 'a']

Thanks
Marius

[mcobzarenco]

In addition, it seems that any integer that cannot fit in 32 bits ('L' suffix in Python 2.7.5) is ignored altogether by the Python client. The Erlang implementation of Riak uses arbitrary size integers for indexes, this should not happen. Indeed if I manually pass the integer value in a protobuf message it seems to work ok..

[pigmej]

In fact this is more deeper, for example when you will add more negative values as 2i, then you will get pretty random order as a result (shuffled, missing etc). But only when using HTTP mode, because as you noticed pbc removes "negatives".

However the thing what I'm talking about is not riak-python-client related but more core.

[seancribbs]

The source of this problem is that the end of the range is falsey when 0!

Here are the affected lines:

https://github.com/basho/riak-python-client/blob/master/riak/transports/http/resources.py#L100
https://github.com/basho/riak-python-client/blob/master/riak/transports/pbc/codec.py#L441

[Basho-JIRA]

Resolved by #388

_[posted via JIRA by Brett Hazen]_