注册

disql执行sql脚本提示[-2112]:有歧义的列名

蓝辰" 2025/05/22 373 9

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8 03134284336-20250117-257733-20132
【操作系统】:linux
【CPU】:32
【问题描述】*:使用disql执行建表语句sql脚本,提示-2112:有歧义的列名[DATA_ID],详情日志:
./disql bonree/Bonree123@10.241.131.24:5238 `/tmp/br_nacos.sql

CREATE TABLE "BR_NACOS"."CONFIG_INFO_TAG"
(
"ID" BIGINT AUTO_INCREMENT NOT NULL,
"DATA_ID" VARCHAR(510 CHAR) NOT NULL,
"GROUP_ID" VARCHAR(256 CHAR) NOT NULL,
"TENANT_ID" VARCHAR(256 CHAR) DEFAULT '',
"TAG_ID" VARCHAR(256 CHAR) NOT NULL,
"APP_NAME" VARCHAR(256 CHAR),
"CONTENT" CLOB NOT NULL,
"MD5" VARCHAR(64 CHAR),
"GMT_CREATE" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP() NOT NULL,
"GMT_MODIFIED" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP() NOT NULL,
"SRC_USER" TEXT,
"SRC_IP" VARCHAR(100 CHAR),
NOT CLUSTER PRIMARY KEY("ID") ,
CONSTRAINT "UK_CONFIGINFOTAG_DATAGROUPTENANTTAG" UNIQUE("DATA_ID", "GROUP_ID", "TENANT_ID", "TAG_ID") ) AUTO_INCREMENT = 1;

COMMENT ON TABLE BR_NACOS.CONFIG_INFO_TAG IS 'config_info_tag';
COMMENT ON COLUMN BR_NACOS.CONFIG_INFO_TAG."APP_NAME" IS 'app_name';
COMMENT ON COLUMN BR_NACOS.CONFIG_INFO_TAG."CONTENT" IS 'content';
COMMENT ON COLUMN BR_NACOS.CONFIG_INFO_TAG."DATA_ID" IS 'data_id';
COMMENT ON COLUMN BR_NACOS.CONFIG_INFO_TAG."GMT_CREATE" IS '创建时间';
COMMENT ON COLUMN BR_NACOS.CONFIG_INFO_TAG."GMT_MODIFIED" IS '修改时间';
COMMENT ON COLUMN BR_NACOS.CONFIG_INFO_TAG."GROUP_ID" IS 'group_id';
COMMENT ON COLUMN BR_NACOS.CONFIG_INFO_TAG."ID" IS 'id';
COMMENT ON COLUMN BR_NACOS.CONFIG_INFO_TAG."MD5" IS 'md5';
COMMENT ON COLUMN BR_NACOS.CONFIG_INFO_TAG."SRC_IP" IS 'source ip';
COMMENT ON COLUMN BR_NACOS.CONFIG_INFO_TAG."SRC_USER" IS 'source user';
COMMENT ON COLUMN BR_NACOS.CONFIG_INFO_TAG."TAG_ID" IS 'tag_id';
COMMENT ON COLUMN BR_NACOS.CONFIG_INFO_TAG."TENANT_ID" IS 'tenant_id';

CREATE TABLE "BR_NACOS"."CONFIG_TAGS_RELATION"
(
"ID" BIGINT NOT NULL,
"TAG_NAME" VARCHAR(256 CHAR) NOT NULL,
"TAG_TYPE" VARCHAR(128 CHAR),
"DATA_ID" VARCHAR(510 CHAR) NOT NULL,
"GROUP_ID" VARCHAR(256 CHAR) NOT NULL,
"TENANT_ID" VARCHAR(256 CHAR) DEFAULT '',
"NID" BIGINT AUTO_INCREMENT NOT NULL,
NOT CLUSTER PRIMARY KEY("NID") ,
CONSTRAINT "UK_CONFIGTAGRELATION_CONFIGIDTAG" UNIQUE("ID", "TAG_NAME", "TAG_TYPE") ) AUTO_INCREMENT = 1;

COMMENT ON TABLE BR_NACOS.CONFIG_TAGS_RELATION IS 'config_tag_relation';
COMMENT ON COLUMN BR_NACOS.CONFIG_TAGS_RELATION."DATA_ID" IS 'data_id';
COMMENT ON COLUMN BR_NACOS.CONFIG_TAGS_RELATION."GROUP_ID" IS 'group_id';
COMMENT ON COLUMN BR_NACOS.CONFIG_TAGS_RELATION."ID" IS 'id';
COMMENT ON COLUMN BR_NACOS.CONFIG_TAGS_RELATION."TAG_NAME" IS 'tag_name';
COMMENT ON COLUMN BR_NACOS.CONFIG_TAGS_RELATION."TAG_TYPE" IS 'tag_type';
COMMENT ON COLUMN BR_NACOS.CONFIG_TAGS_RELATION."TENANT_ID" IS 'tenant_id';

已用时间: 16.860(毫秒). 执行号:0.
SQL> exit

回答 0
暂无回答
扫一扫
联系客服