expected = CQLStatement.make(
"SELECT * FROM \"testspace\".\"testtypef9bf3332bb4ec879849ec43c67776131\" WHERE shardid = ? AND foreignid = ? AND instance = ? AND type = ? AND id >= ? AND id <= ? ORDER BY id DESC LIMIT 10 ALLOW FILTERING;",
TABLE_NAME,
Arrays.asList(Long.valueOf(144),"777","222222","5",start,stop).toArray()
);
actual.nextShard();
assertEquals("Descending: Should generate proper CQL for wide table get by index values",expected,actual.next());
expected = CQLStatement.make(
"SELECT * FROM \"testspace\".\"testtypef9bf3332bb4ec879849ec43c67776131\" WHERE shardid = ? AND foreignid = ? AND instance = ? AND type = ? AND id >= ? AND id <= ? ORDER BY id DESC LIMIT 5 ALLOW FILTERING;",
TABLE_NAME,
Arrays.asList(Long.valueOf(143),"777","222222","5",start,stop).toArray()