Unrecognized Node Type (119) Error during ALTER TABLE with Complex int4range Expressions
- 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
Assessment
This issue has not been assessed yet.