BiteTheDDDDt opened a new issue, #11709: URL: https://github.com/apache/doris/issues/11709
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues. ### Description 1. date format support: ```sql CREATE TABLE s267d_modify_test_modify_varchar_to_date_wrong_format_db.s5292_modify_test_modify_varchar_to_date_wrong_format_tb ( k1 INT NOT NULL, k2 VARCHAR(4096) NOT NULL, k3 VARCHAR(4096) NOT NULL, v1 FLOAT SUM NOT NULL, v2 DECIMAL(20,7) SUM NOT NULL ) AGGREGATE KEY(k1,k2,k3) PARTITION BY RANGE(k1) ( PARTITION partition_a VALUES LESS THAN ("5"), PARTITION partition_b VALUES LESS THAN ("30"), PARTITION partition_c VALUES LESS THAN ("100"), PARTITION partition_d VALUES LESS THAN ("500"), PARTITION partition_e VALUES LESS THAN ("1000"), PARTITION partition_f VALUES LESS THAN ("2000"), PARTITION partition_g VALUES LESS THAN MAXVALUE ) DISTRIBUTED BY HASH(k1, k2) BUCKETS 13 insert into s5292_modify_test_modify_varchar_to_date_wrong_format_tb values(1,"1","202001011200",1,1) ALTER TABLE s267d_modify_test_modify_varchar_to_date_wrong_format_db.s5292_modify_test_modify_varchar_to_date_wrong_format_tb MODIFY COLUMN k3 date select 1, 1, cast("2020-01-01" as date), 1, 1.0 ``` 2. interger cast overflow: ```sql CREATE TABLE s9f1f_e_modify_test_modify_varchar_to_number_overflow_db.sd013_e_modify_test_modify_varchar_to_number_overflow_tb ( k1 INT NOT NULL, k2 VARCHAR(4096) NOT NULL, k3 VARCHAR(4096) NOT NULL, k4 VARCHAR(4096) NOT NULL, k5 VARCHAR(4096) NOT NULL, k6 VARCHAR(4096) NOT NULL, k7 VARCHAR(4096) NOT NULL, k8 VARCHAR(4096) NOT NULL, k9 VARCHAR(4096) NOT NULL, v1 FLOAT SUM NOT NULL, v2 DECIMAL(20,7) SUM NOT NULL ) AGGREGATE KEY(k1,k2,k3,k4,k5,k6,k7,k8,k9) PARTITION BY RANGE(k1) ( PARTITION partition_a VALUES LESS THAN ("5"), PARTITION partition_b VALUES LESS THAN ("30"), PARTITION partition_c VALUES LESS THAN ("100"), PARTITION partition_d VALUES LESS THAN ("500"), PARTITION partition_e VALUES LESS THAN ("1000"), PARTITION partition_f VALUES LESS THAN ("2000"), PARTITION partition_g VALUES LESS THAN MAXVALUE ) DISTRIBUTED BY HASH(k1, k2) BUCKETS 3 insert into sd013_e_modify_test_modify_varchar_to_number_overflow_tb values(1, "1", "1", "1", "2147483648", "1", "1", "1", "1", 1, 1) ALTER TABLE s9f1f_e_modify_test_modify_varchar_to_number_overflow_db.sd013_e_modify_test_modify_varchar_to_number_overflow_tb MODIFY COLUMN k5 INT ``` ### Solution _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- 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: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
