It is fixed in 2.1.5. On Tue, Aug 20, 2024 at 3:33 PM -. GΤΟ <529690...@qq.com.invalid> wrote:
> 版本信息： > Git : git://VM-0-27-ubuntu@2dc65ce35658a1cfd3f3ddb14466954b1aef8432 > Version : doris-2.1.3-rc09 > BuildInfo : VM-0-27-ubuntu > > > > > 问题描述： > 通过使用insert into select语句进行数据导入时，无法触发主键自增。 > > > 在进行以下SQL数据操作时，执行报错： > insert into tbl_a (ac1, ac2) select bc1 as ac1, bc2 as ac2 from tbl_b报错信息： > column_name[id], null value for not null column, type=BIGINT. src line > [];tbl_a的表结构：CREATE TABLE `tbl_a` ( `id` BIGINT NOT NULL AUTO_INCREMENT(1), > `ac1` BIGINT NULL, `ac2` VARCHAR(50) NULL ) ENGINE=OLAP UNIQUE KEY(`id`) > COMMENT 'OLAP' DISTRIBUTED BY HASH(`id`) BUCKETS 10 PROPERTIES ( > "replication_allocation" = "tag.location.default: 3", > "min_load_replica_num" = "-1", "is_being_synced" = "false", > "storage_medium" = "hdd", "storage_format" = "V2", > "inverted_index_storage_format" = "V1", "enable_unique_key_merge_on_write" > = "true", "light_schema_change" = "true", "disable_auto_compaction" = > "false", "enable_single_replica_compaction" = "false", > "group_commit_interval_ms" = "10000", "group_commit_data_bytes" = > "134217728" );
