sql解析错误，出现列名重复错误，Duplicate column name ‘xxxx’

[foryout]

建表语句中列名存在大写的字段，进行关联查询时，出现此错误，在sql的解析结果中同时出现了，字段的大写名和小写名
explain结果
each(targetName = c0,
................................
right join (
select

.............................

	`t17`.`audit_time`,
	`t17`.`SYSCREATORUUID`,

.......................
t17.syscreatoruuid,
.............

[junwen12221]

请问这个错,会导致无法返回结果集吗?

要调查这个问题的话,需要涉及的表的建表语句和完整的查询sql

[foryout]

无法返回结果集。
建表语句：
CREATE TABLE IF NOT EXISTS tb01 (
oo_uuid char(32) NOT NULL,
ss_type varchar(5) NOT NULL,
my_uuid char(32) NOT NULL,
cc_uuid char(32) NOT NULL,
SYSUUID char(32) NOT NULL,
PRIMARY KEY USING BTREE (oo_uuid),
KEY sharding_uuid USING BTREE (my_uuid)
) ENGINE = InnoDB CHARSET = utf8 COLLATE = utf8_bin
DBPARTITION BY hash(my_uuid);

CREATE TABLE IF NOT EXISTS tb02 (
cc_uuid char(32) NOT NULL,
my_uuid CHAR(32) NOT NULL,
sysuuid CHAR(32) NOT NULL,
aaaa varchar(20) NOT NULL,
bbbb char(32) NOT NULL,
cccc varchar(20) DEFAULT NULL,
PRIMARY KEY USING BTREE (cc_uuid),
KEY sharding_uuid USING BTREE (my_uuid)
) ENGINE = InnoDB CHARSET = utf8 COLLATE = utf8_bin
DBPARTITION BY hash(my_uuid);

CREATE TABLE IF NOT EXISTS tb03 (
id bigint(20) NOT NULL AUTO_INCREMENT,
ss_type varchar(50) NOT NULL,
ss_code varchar(5) NOT NULL,
PRIMARY KEY USING BTREE (id),
UNIQUE KEY uni_idx USING BTREE (ss_type, ss_code)
) BROADCAST ENGINE = InnoDB CHARSET = utf8 COLLATE = utf8_bin;

查询sql：
SELECT
COUNT(*) TOTAL_NUM
FROM
( SELECT
A.OO_UUID
FROM
tb01 A
LEFT JOIN tb02 B
ON B.my_uuid = A.my_uuid AND
B.cc_uuid = A.cc_uuid
LEFT JOIN tb03 C
ON C.ss_code = A.SS_TYPE
) ALLVIEW;

[junwen12221]

http://dl.mycat.org.cn/2.0/1.22-release/mycat2-1.22-release-jar-with-dependencies-2022-5-26.jar

[junwen12221]

http://dl.mycat.org.cn/2.0/1.22-release/mycat2-1.22-release-jar-with-dependencies-2022-6-15.jar