negative LIMIT error
Open
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
Assessment
This issue has not been assessed yet.