表结构：
call sp_tabledef(‘SYSDBA’,‘TAB2’);
CREATE TABLE “SYSDBA”.“TAB2” ( “T_INT” INT NOT NULL, “T_INT1” INT, “T_DATE” DATE, “T_CLOB” CLOB, “T_TEXT” INT, “T_VARCHAR” CLOB, NOT CLUSTER PRIMARY KEY(“T_INT”), FOREIGN KEY(“T_INT1”) REFERENCES “SYSDBA”.“TAB1”(“ID_INT”)) STORAGE(ON “MAIN”, CLUSTERBTR) ;
插入数据：
insert into tab2 values(1,1,‘2022-04-11’,‘clob’,1,‘clob’);

insert into tab2 values(2,1,‘2022-04-11’,‘clob’,1,‘clob’);

insert into tab2 values(3,1,‘2022-04-11’,‘clob’,1,‘clob’);

insert into tab2 values(4,1,‘2022-04-11’,‘clobbak’,1,‘clob’);

insert into tab2 values(5,1,‘2022-04-11’,‘clob’,1,‘clob’);

insert into tab2 values(6,1,‘2022-04-11’,‘clob’,1,‘clob’);

insert into tab2 values(7,1,‘2022-04-11’,‘clob’,1,‘clob’);

insert into tab2 values(8,1,‘2022-04-11’,‘clobbak’,1,‘clob’);

insert into tab2 values(9,1,‘2022-04-11’,‘clobbak’,1,‘clob’);

insert into tab2 values(10,1,‘2022-04-11’,‘clobbak’,1,‘clob’);

select * from tab2;

select T_INT,T_CLOB from tab2 where T_INT>3 group by T_INT,T_CLOB order by T_INT;

报错如下：

解决方法：
将大字段转换为字符串
select T_INT,cast(T_CLOB as VARCHAR) from tab2 where T_INT>3 group by T_INT,cast(T_CLOB as VARCHAR) order by T_INT;

社区地址：https://eco.dameng.com