Binding variables for lists do not work

[nickhristov]

I have the following code:

@RequestMapping(value = "/queryByIdAndDate" , method = POST)
public @ResponseBody String isoDateFormat(@RequestBody QueryTestRequest testRequest) {
     ImmutableMap<String, Object> parameters = ImmutableMap.of("ldids", ImmutableList.of(testRequest.getLdId()));
     Statement statement = new SimpleStatement("SELECT * FROM location_data.location_data WHERE ld_id IN :ldids", parameters);
     ResultSet resultSet = session.execute(statement); 
     List<Row> rows = resultSet.all();
     return String.valueOf(rows.size());
}

And kicking it off with:

curl -H 'Content-Type: application/json' -vvv --data '{"ldId": "0a44ea7e-2b26-40ff-b486-7b86c0853a08"}' http://localhost/api/locationUpdates/queryByIdAndDate

I get 0 as a response.

The problem is that the data exists in the table:

cqlsh:location_data> SELECT ld_id FROM location_data.location_data WHERE ld_id = 0a44ea7e-2b26-40ff-b486-7b86c0853a08 LIMIT 1;

 ld_id
--------------------------------------
 0a44ea7e-2b26-40ff-b486-7b86c0853a08

(1 rows)

Now, if I were to embed the list in the statement, instead of using bind variables, things work:

@RequestMapping(value = "/queryByIdAndDate" , method = POST)
public @ResponseBody String isoDateFormat(@RequestBody QueryTestRequest testRequest) {
	ImmutableMap<String, Object> parameters = ImmutableMap.of();
	String ldIdFragment = Joiner.on(",").join(ImmutableList.of(testRequest.getLdId()));
	Statement statement = new SimpleStatement("SELECT * FROM location_data.location_data WHERE ld_id IN ( " + ldIdFragment + " )", parameters);
	ResultSet resultSet = session.execute(statement);
	List<Row> rows = resultSet.all();
	return String.valueOf(rows.size());
}

With this code I now get 14 as a result, which matches the query in cqlsh:

cqlsh:location_data> SELECT ld_id FROM location_data.location_data WHERE ld_id = 0a44ea7e-2b26-40ff-b486-7b86c0853a08;

 ld_id
--------------------------------------
 0a44ea7e-2b26-40ff-b486-7b86c0853a08
 0a44ea7e-2b26-40ff-b486-7b86c0853a08
 0a44ea7e-2b26-40ff-b486-7b86c0853a08
 0a44ea7e-2b26-40ff-b486-7b86c0853a08
 0a44ea7e-2b26-40ff-b486-7b86c0853a08
 0a44ea7e-2b26-40ff-b486-7b86c0853a08
 0a44ea7e-2b26-40ff-b486-7b86c0853a08
 0a44ea7e-2b26-40ff-b486-7b86c0853a08
 0a44ea7e-2b26-40ff-b486-7b86c0853a08
 0a44ea7e-2b26-40ff-b486-7b86c0853a08
 0a44ea7e-2b26-40ff-b486-7b86c0853a08
 0a44ea7e-2b26-40ff-b486-7b86c0853a08
 0a44ea7e-2b26-40ff-b486-7b86c0853a08
 0a44ea7e-2b26-40ff-b486-7b86c0853a08

(14 rows)

[robertpang]

@nickhristov Thank you for reporting the issue. There was a small glitch in resolving bind variable for list type and we have just fixed it.

[kmuthukk]

Relevant commit: 0365a89