citusdata / citusdata/citus

negative LIMIT error

Open
#4,013 0 comments 0 reactions 0 assignees View on GitHub
sqlancer
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

````
CREATE TABLE t0(c0 int);
SELECT create_distributed_table('t0', 'c0');
SELECT * FROM t0 LIMIT 5827663656111450072 OFFSET 5859642692264431783;
ERROR: LIMIT must not be negative
```
This SELECT query executes on a local table; however, raises the above error on a distributed table. Attached is the log output including queries sent to workers.
[limitbug output.txt](https://github.com/citusdata/citus/files/4901347/limitbug.output.txt)

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.