citusdata / citusdata/citus

Unrecognized Node Type (119) Error during ALTER TABLE with Complex int4range Expressions

Open
#7,211 3 comments 1 reaction 2 assignees Claimed by @ihalatci View on GitHub
backport cherry-pick-12.0 sqlancer
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

When attempting to alter the default value of a column with complex int4range expressions, an error is encountered, resulting in an "unrecognized node type: 119" message. This issue seems to be related to the specific combination of int4range operations used in the ALTER TABLE statement.

Steps to reproduce :
```sql
CREATE TABLE IF NOT EXISTS t1(c0 int, c1 boolean);

SELECT create_distributed_table('t1', 'c0');
ALTER TABLE t1 ALTER c1 SET DEFAULT (NOT ((((('[-1,-1]'::int4range)*('[1,1]'::int4range)))>>((('[-2,-2)'::int4range)*('[2,2)'::int4range)))))) IS TRUE;

ERROR: unrecognized node type: 119
```

[database7.log](https://github.com/citusdata/citus/files/12660876/database7.log)
[database7-cur.log](https://github.com/citusdata/citus/files/12660877/database7-cur.log)

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.