cqlsh:log> create table test (id bigint primary key, num bigint, str varchar);
cqlsh:log> create index testIDX on test(num);
cqlsh:log> insert into test(id,num,str) values(1,1,'ivan');
cqlsh:log> insert into test(id,num,str) values(1,1,'ivan');
cqlsh:log> insert into test(id,num,str) values(2,2,'ivan2');
cqlsh:log> insert into test(id,num,str) values(3,3,'ivan3');
cqlsh:log> insert into test(id,num,str) values(4,3,'ivan32');
cqlsh:log> insert into test(id,num,str) values(11,3,'ivan321');
cqlsh:log> insert into test(id,num,str) values(113,3,'ivan322');

cqlsh:log> select * from test; -- OK
 id  | num | str
-----+-----+---------
   1 |   1 |    ivan
   2 |   2 |   ivan2
   3 |   3 |   ivan3
   4 |   3 |  ivan32
 113 |   3 | ivan322
  11 |   3 | ivan321


cqlsh:log> select * from test where id>=1 and id<=2; -- OK
 id | num | str
----+-----+-------
  1 |   1 |  ivan
  2 |   2 | ivan2
  
cqlsh:log> select * from test where id>3;
 id  | num | str
-----+-----+---------
   4 |   3 |  ivan32
 113 |   3 | ivan322
  11 |   3 | ivan321

cqlsh:log> select * from test where id<3;
Bad Request: Key range clauses must include a start key (i.e. KEY > term) -- ?? ну ладно. дадим тебе точку старта

cqlsh:log> select * from test where id<3 and id>=1; -- ОК
 id | num | str
----+-----+-------
  1 |   1 |  ivan
  2 |   2 | ivan2

cqlsh:log> select * from test where id<3 and id>1; -- ОК
 id | num | str
----+-----+-------
  2 |   2 | ivan2

cqlsh:log> select * from test where id<100 and id>1; -- !WTF
 id | num | str
----+-----+-------
  2 |   2 | ivan2  

cqlsh:log> select * from test where id>=1 and id<=10; --- !WTF
 id | num | str
----+-----+------
  1 |   1 | ivan

cqlsh:log> select * from test where id>1 and id<=10; --- !WTF
cqlsh:log> select * from test where id>1 and id<10; --- !WTF
cqlsh:log> select * from test where id>=1 and id<10; --- !WTF
 id | num | str
----+-----+------
  1 |   1 | ivan

cqlsh:log> select * from test;
 id  | num | str
-----+-----+---------
   1 |   1 |    ivan
   2 |   2 |   ivan2
   3 |   3 |   ivan3
   4 |   3 |  ivan32
 113 |   3 | ivan322
  11 |   3 | ivan321


cqlsh:log> select * from test where id >1;
 id  | num | str
-----+-----+---------
   2 |   2 |   ivan2
   3 |   3 |   ivan3
   4 |   3 |  ivan32
 113 |   3 | ivan322
  11 |   3 | ivan321

cqlsh:log> select * from test where id >2;
 id  | num | str
-----+-----+---------
   3 |   3 |   ivan3
   4 |   3 |  ivan32
 113 |   3 | ivan322
  11 |   3 | ivan321

cqlsh:log> select * from test where id >3;
 id  | num | str
-----+-----+---------
   4 |   3 |  ivan32
 113 |   3 | ivan322
  11 |   3 | ivan321

cqlsh:log> select * from test where id>4;
 id  | num | str
-----+-----+---------
 113 |   3 | ivan322
  11 |   3 | ivan321

cqlsh:log> select * from test where id>100; -- !WTF
 id  | num | str
-----+-----+---------
   3 |   3 |   ivan3
   4 |   3 |  ivan32
 113 |   3 | ivan322
  11 |   3 | ivan321

cqlsh:log> select * from test where id>111;
 id | num | str
----+-----+---------
 11 |   3 | ivan321

cqlsh:log> select * from test where id>11;
cqlsh:log> select * from test where id>11;
cqlsh:log> select * from test where id>111;
 id | num | str
----+-----+---------
 11 |   3 | ivan321

cqlsh:log> select * from test where id>=111;
 id | num | str
----+-----+---------
 11 |   3 | ivan321

cqlsh:log> select * from test where id>=113;
 id  | num | str
-----+-----+---------
 113 |   3 | ivan322
  11 |   3 | ivan321

cqlsh:log>

select * from test where id>=113;