Nodejs Client equal filter on secondary index (int)

secondary
index

#1

I am using aerospike nodejs client.

Created Secondary index on bin “permalink” (int type)

Issue: no results are returned when nodejs client equal filter is used with value 20150201230000

The following command works fine and returns result when executed from aql command line:

select * from namespace.table where permalink = 20150201230000

Same command when I try to run in nodejs client, I am not neither getting any result nor any error.

var statement = {filters:[aerospike.filter.equal('permalink', parseInt(20150201230000))]}
var query = db.client.query(namespace, table, statement)
var stream = query.execute()
var arr = [];

stream.on('data', function(rec)  {
	arr.push(rec)
})
stream.on('error', function(err)  {
	res.json({status : err})
})
stream.on('end', function()  {
	res.json(arr)
});

If I update the bin “permalink” and put value 2015020123, and then try above nodejs client with new value it works fine and returns the result as expected.

var statement = {filters:[aerospike.filter.equal('permalink', parseInt(2015020123))]} – this works fine

Can someone please help.


#2

Hi starthakur,

Thanks for reporting the issue. We will look into resolving it and get back to you as soon as we have an update.

Cheers!