为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【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
你好,我尝试了一下你提供的语句,应该是大小写的问题,创建表时字段带了双引号,字段名小写,查询时,管理工具会默认将不带双引号的字段装换位大写,你在字段名前加上双引号,应该就可以了