注册

mysql语句在dm报错

DM_281173 2024/12/18 318 1

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:
CREATE TABLE "permission"."t_position"
(
"id" VARCHAR(255) NOT NULL,
"create_time" BIGINT,
"created" VARCHAR(255),
"full_name" VARCHAR(255),
"level" INT,
"oa_mstate" INT,
"oa_parent_id" VARCHAR(255),
"oa_post_code" VARCHAR(255),
"operate_time" BIGINT,
"operated" VARCHAR(255),
"permission_level_code" VARCHAR(255),
"port_stationtype_no" VARCHAR(255),
"pos_attribute" INT DEFAULT 100,
"pos_type_code" VARCHAR(255),
"posi_code" VARCHAR(255),
"posi_name" VARCHAR(255),
"sort" INT,
"source" VARCHAR(255),
"source_hierarchy_code" VARCHAR(255),
"source_org_code" VARCHAR(255),
"status" VARCHAR(255),
"tenant_id" VARCHAR(255),
"view_sight_type" VARCHAR(255),
"label" LONGVARCHAR,
NOT CLUSTER PRIMARY KEY("id")) STORAGE(ON "MAIN", CLUSTERBTR) ;

执行sql 报错
explain select * from "permission"."t_position" where permission_level_code in ('sfsfs') and view_sight_type='ALL' and (0=1 or posi_name like concat('%','sfsf','%'))
union select * from "permission"."t_position" where permission_level_code = 'sfsfs' and (0=1 or posi_name like concat('%','fsfsfsf','%'))
union select * from "permission"."t_position" where id in ('sfsfsf') and (0=1 or posi_name like concat('%','sfsfs','%')) order by sort asc limit 1

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