Fatal error with limit > 10000

[Robert Wille]

I have a table with a bunch of records that have 10,000 keys per partition
key (not sure if that¹s the right terminology). Here¹s the schema:

CREATE TABLE bdn_index_pub (

tshard VARCHAR,

pord INT,

ord INT,

hpath VARCHAR,

page BIGINT,

PRIMARY KEY (tshard, pord)

) WITH gc_grace_seconds = 0;


In most records, there are 10,000 pord values for each tshard value.

If I run a query without a limit clause in sqlsh, I get this:

select count(*) from bdn_index_pub where tshard = '-16:12';

 count
-------
 10000

(1 rows)

Default LIMIT of 10000 was used. Specify your own LIMIT clause to get more
results.

If I run a query with a limit clause > 10000, I get this:

select count(*) from bdn_index_pub where tshard = '-16:12' limit 10001;
TSocket read 0 bytes

Any query I run thereafter gives me the TSocket read 0 bytes error.

I am running 2.0.4. I¹m pretty sure this didn¹t happen in 2.0.2.

Any reason why I can¹t use a limit > 10000?

Thanks in advance

Robert