zddr commented on PR #57234: URL: https://github.com/apache/doris/pull/57234#issuecomment-3465982314
> > There is a scenario where unexpected behavior may occur in this way, for example, today is October 30, 2025, and the value of partition p1 is 20251025. Under the following configuration, the previous behavior will report an error, which is in line with expectations. However, after the change, there will be no error. The actual time of p1 will become 20251001, and it has been more than 10 days since then, and the partition will not be visible 'partition_sync_limit'='10', 'partition_sync_time_unit'='DAY', 'partition_date_format'='%Y%m' > > If the partition format is like 'dt=202510' and 'dt=202511', then it will not be possible to create a view based on this base table(error: Invalid value for DayOfMonth (valid values 1–28/31): 0).You can execute the test case in my regression test. <img alt="image" width="893" height="753" src="https://private-user-images.githubusercontent.com/38941777/507401608-2628c8be-3ab2-47af-9e1c-6677f5f688fb.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NjE3OTUwNDAsIm5iZiI6MTc2MTc5NDc0MCwicGF0aCI6Ii8zODk0MTc3Ny81MDc0MDE2MDgtMjYyOGM4YmUtM2FiMi00N2FmLTllMWMtNjY3N2Y1ZjY4OGZiLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTEwMzAlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUxMDMwVDAzMjU0MFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWU3MTJkYzE3MjY4YmI1NGE1OWQwYWMyMTQyM2MzOTc1N2JmZGE1MGMwNTBiNjliYzJhMzgxY2JmYzhkOWYzN jcmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.scrWKEa5XbpUlIWsi4gijGbA12Y3IMHOghJcTchueuc"> ok -- 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]
