Cannot Convert Infinity to Integer Error on Distributed Tables
Open
bug
sqlancer
tool_reported
- Dominant language
- C
- Stars
- 12.8k
- Forks
- 794
- Avg merge
- 2d 14h
- Merged PRs (30d)
- 31
Description
```
DROP TABLE IF EXISTS tbl1;
CREATE TABLE tbl1(a int);
SELECT * FROM tbl1 WHERE a IN (0.5, 'Infinity');
a
---
(0 rows)
SELECT create_distributed_table('tbl1', 'a');
SELECT * FROM tbl1 WHERE a IN (0.5, 'Infinity');
ERROR: cannot convert infinity to integer
```
Contributor guide
Assessment
This issue has not been assessed yet.