avamingli commented on issue #795:
URL: https://github.com/apache/cloudberry/issues/795#issuecomment-2559019253
Reproduce it on main branch, besides the `MAXVALUE`, the `MINVALUE` used
in sub partition also causes an error:
```sql
CREATE TABLE test_partition2 (
name character varying,
last_modified_date timestamp without time zone
)
WITH (appendoptimized=true, orientation=column, compresslevel=1)
DISTRIBUTED BY (name)
PARTITION BY RANGE (last_modified_date)
(
PARTITION partition_202411 START (MINVALUE) INCLUSIVE END ('2024-12-01
00:00:00') EXCLUSIVE,
PARTITION partition_max START ('2024-12-01 00:00:00') INCLUSIVE END
(MAXVALUE)
);
ERROR: cannot use column reference in partition bound expression
LINE 9: PARTITION partition_202411 START (MINVALUE) INCLUSIVE EN..
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
