citusdata / citusdata/citus

Cannot Convert Infinity to Integer Error on Distributed Tables

Open
#5,253 1 comment 0 reactions 0 assignees View on GitHub
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

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.