为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:dm8:dm8_20241230_rev255012_x86_rh6_64
【操作系统】：Kylin 4.0.2
【CPU】: x86_64
【问题描述】* 字符串转换出错
建表语句如下
CREATE TABLE "TICHAIN_BASE"."BLADE_ROLE"
(
"ID" BIGINT NOT NULL,
"TENANT_ID" VARCHAR(12 CHAR) DEFAULT '000000',
"PARENT_ID" BIGINT DEFAULT 0,
"ROLE_NAME" VARCHAR(255 CHAR),
"SORT" INT,
"ROLE_ALIAS" VARCHAR(255 CHAR),
"IS_DELETED" INT DEFAULT 0,
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE TABLE "TICHAIN_BASE"."BLADE_USER"
(
"ID" BIGINT NOT NULL,
"TENANT_ID" VARCHAR(12 CHAR) DEFAULT '000000',
"CODE" VARCHAR(128 CHAR),
"USER_TYPE" INT,
"ACCOUNT" VARCHAR(128 CHAR),
"PASSWORD" VARCHAR(250 CHAR),
"NAME" VARCHAR(128 CHAR),
"REAL_NAME" VARCHAR(45 CHAR),
"AVATAR" VARCHAR(500 CHAR),
"EMAIL" VARCHAR(45 CHAR),
"PHONE" VARCHAR(45 CHAR),
"BIRTHDAY" TIMESTAMP(0),
"SEX" INT,
"ROLE_ID" VARCHAR(1000 CHAR),
"DEPT_ID" VARCHAR(1000 CHAR),
"POST_ID" VARCHAR(1000 CHAR),
"CREATE_USER" BIGINT,
"CREATE_DEPT" BIGINT,
"CREATE_TIME" TIMESTAMP(0),
"UPDATE_USER" BIGINT,
"UPDATE_TIME" TIMESTAMP(0),
"STATUS" INT,
"IS_DELETED" INT DEFAULT 0,
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

-- 执行正常
SELECT COUNT(*) AS total FROM blade_role WHERE role_alias <> 'administrator'

-- 执行报-6111: 字符串转换出错
SELECT COUNT(*) AS total FROM blade_user a LEFT JOIN blade_role b ON a.role_id = b.id WHERE b.role_alias <> 'administrator'

-- 执行正常
SELECT COUNT(*) AS total FROM blade_user a LEFT JOIN blade_role b ON a.role_id = b.id WHERE a.is_deleted = 0

-- 执行报-6111: 字符串转换出错
SELECT COUNT(*) AS total FROM blade_user a LEFT JOIN blade_role b ON a.role_id = b.id WHERE a.is_deleted = 0 AND b.role_alias <> 'administrator'