avamingli commented on issue #795:
URL: https://github.com/apache/cloudberry/issues/795#issuecomment-2638898169
> Reproduce it on main branch, besides the `MAXVALUE`, the `MINVALUE` used
in sub partition also causes an error:
>
> 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..
Hi, all
I have a fix for the MAXVALUE in #904.
As said there:
However, addressing MINVALUE is more complex due to the current
implementation of the START/EVERY/END grammar, which only considers the end
boundary situation.
A broader refactor of the partition creation logic may be required to
properly support MINVALUE in subpartition definitions.
I think we first fix this one, then create a new one to track MINVALUE.
--
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]
