htyoung opened a new issue, #23570: URL: https://github.com/apache/doris/issues/23570
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version version: 2.0.1-rc03 ### What's Wrong? When I create MATERIALIZED VIEW based on a table, It will change table column Data Type. If column's Data Type is varchar(64), it will change to varchar(65533). If column's Data Type is char(32), it will change to char(255). ### What You Expected? The table schema should not change. ### How to Reproduce? ---- 物化视图bug复现 -- 创建表 CREATE TABLE IF NOT EXISTS test1( `create_time` DATETIME NOT NULL COMMENT "", `vid` VARCHAR(64) NOT NULL COMMENT "", `report_time` DATETIME NOT NULL COMMENT '', `block_version` int NOT NULL COMMENT '', `lights` JSON NULL COMMENT '', `show_active` int NULL COMMENT '', `high_beam_status` int NULL COMMENT '', `turn_lamp_mode` int NULL COMMENT '' ) ENGINE=OLAP UNIQUE KEY(`create_time`, `vid`, `report_time`) PARTITION BY RANGE(`create_time`) () DISTRIBUTED BY HASH(`vid`) BUCKETS AUTO PROPERTIES ( "replication_num" = "1", "dynamic_partition.prefix" = "p", "dynamic_partition.start" = "-1", "dynamic_partition.end" = "1", "dynamic_partition.enable" = "true", "dynamic_partition.time_unit" = "DAY", "dynamic_partition.create_history_partition" = "true" ); -- 查看表结构 show create table test1; CREATE TABLE `test1` ( `create_time` datetime NOT NULL, `vid` varchar(64) NOT NULL, `report_time` datetime NOT NULL COMMENT '', `block_version` int(11) NOT NULL COMMENT '', `lights` json NULL COMMENT '', `show_active` int(11) NULL COMMENT '', `high_beam_status` int(11) NULL COMMENT '', `turn_lamp_mode` int(11) NULL COMMENT '' ) ENGINE = OLAP UNIQUE KEY(`create_time`, `vid`, `report_time`) COMMENT 'OLAP' PARTITION BY RANGE(`create_time`) ( PARTITION p20230828 VALUES [('2023-08-28 00:00:00'), ('2023-08-29 00:00:00')), PARTITION p20230829 VALUES [('2023-08-29 00:00:00'), ('2023-08-30 00:00:00')) ) DISTRIBUTED BY HASH(`vid`) BUCKETS AUTO PROPERTIES ( "replication_allocation" = "tag.location.default: 1", "is_being_synced" = "false", "dynamic_partition.enable" = "true", "dynamic_partition.time_unit" = "DAY", "dynamic_partition.time_zone" = "Asia/Shanghai", "dynamic_partition.start" = "-3", "dynamic_partition.end" = "1", "dynamic_partition.prefix" = "p", "dynamic_partition.replication_allocation" = "tag.location.default: 1", "dynamic_partition.buckets" = "10", "dynamic_partition.create_history_partition" = "false", "dynamic_partition.history_partition_num" = "-1", "dynamic_partition.hot_partition_num" = "0", "dynamic_partition.reserved_history_periods" = "NULL", "dynamic_partition.storage_policy" = "", "dynamic_partition.storage_medium" = "HDD", "storage_format" = "V2", "light_schema_change" = "true", "disable_auto_compaction" = "false", "enable_single_replica_compaction" = "false" ); -- 创建物化视图 CREATE MATERIALIZED VIEW mv_reporttime_orderdesc as SELECT report_time, vid, create_time FROM test1 ORDER BY report_time DESC; --查看表结构 show create table test1; CREATE TABLE `test1` ( `create_time` datetime NOT NULL, `vid` varchar(65533) NOT NULL, `report_time` datetime NOT NULL COMMENT '', `block_version` int(11) NOT NULL COMMENT '', `lights` json NULL COMMENT '', `show_active` int(11) NULL COMMENT '', `high_beam_status` int(11) NULL COMMENT '', `turn_lamp_mode` int(11) NULL COMMENT '' ) ENGINE = OLAP UNIQUE KEY(`create_time`, `vid`, `report_time`) COMMENT 'OLAP' PARTITION BY RANGE(`create_time`) ( PARTITION p20230828 VALUES [('2023-08-28 00:00:00'), ('2023-08-29 00:00:00')), PARTITION p20230829 VALUES [('2023-08-29 00:00:00'), ('2023-08-30 00:00:00')) ) DISTRIBUTED BY HASH(`vid`) BUCKETS AUTO PROPERTIES ( "replication_allocation" = "tag.location.default: 1", "is_being_synced" = "false", "dynamic_partition.enable" = "true", "dynamic_partition.time_unit" = "DAY", "dynamic_partition.time_zone" = "Asia/Shanghai", "dynamic_partition.start" = "-3", "dynamic_partition.end" = "1", "dynamic_partition.prefix" = "p", "dynamic_partition.replication_allocation" = "tag.location.default: 1", "dynamic_partition.buckets" = "10", "dynamic_partition.create_history_partition" = "false", "dynamic_partition.history_partition_num" = "-1", "dynamic_partition.hot_partition_num" = "0", "dynamic_partition.reserved_history_periods" = "NULL", "dynamic_partition.storage_policy" = "", "dynamic_partition.storage_medium" = "HDD", "storage_format" = "V2", "light_schema_change" = "true", "disable_auto_compaction" = "false", "enable_single_replica_compaction" = "false" ); ### Anything Else? _No response_ ### Are you willing to submit PR? - [X] 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: [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]
