为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:
【操作系统】：
【CPU】:
【问题描述】*：
SQL执行报错: Sort or calculate in blob or clob(text)
SQL

SELECT aaa.id,
        aaa.log_content AS alarmTitle,
        aaa.name AS deviceName,
        aaa.log_type AS alarmType,
        aaa.log_level AS alarmLevel,
        aaa.status AS alarmStatus,
        tttt.alarm_time AS firtAlarmTime,
        aaa.alarm_time AS lastAlarmTime
        FROM
        (
        SELECT t1.id,
        t1.log_content,
        t2.name,
        t1.log_type,
        t1.log_level,
        t1.status,
        MAX(t1.alarm_time) alarm_time
        FROM t_alarm t1
        LEFT JOIN t_device t2 ON t1.device_sn_no = t2.sn_no
        WHERE 1 = 1
        GROUP BY t2.name, t1.log_content
        ) aaa
        LEFT JOIN (
        SELECT t1.log_content,
        t2.name,
        MIN(t1.alarm_time) AS alarm_time
        FROM t_alarm t1
        LEFT JOIN t_device t2 ON t1.device_sn_no = t2.sn_no
        WHERE 1 = 1
        GROUP BY t2.name, t1.log_content
        ) tttt ON aaa.log_content = tttt.log_content AND aaa.name = tttt.name
        ORDER BY aaa.alarm_time DESC;

DDL

CREATE TABLE T_DEVICE (
	ID VARCHAR(64) NOT NULL,
	NAME VARCHAR(100),
	SN_NO VARCHAR(100),
	CONTROLLER_ID VARCHAR(100),
	ORG_CODE VARCHAR(100),
	IP VARCHAR(20),
	PORT INT,
	MAC VARCHAR(48),
	STATUS INT,
	BRAND VARCHAR(10),
	"TYPE" VARCHAR(50),
	MODEL VARCHAR(50),
	SOFTWARE_VERSION VARCHAR(10),
	HARDWARE_VERSION VARCHAR(20),
	FIRST_ONLINE_TIME TIMESTAMP,
	LAST_OFFLINE_TIME TIMESTAMP,
	TOTAL_ONLINE_TIME CLOB,
	OWNER VARCHAR(64),
	CITY VARCHAR(10),
	AREA VARCHAR(100),
	POINT_X NUMBER(10,6),
	POINT_Y NUMBER(10,6),
	CREATE_BY VARCHAR(64),
	CREATE_TIME TIMESTAMP DEFAULT CURRENT_TIMESTAMP(),
	UPDATE_BY VARCHAR(64),
	UPDATE_TIME TIMESTAMP,
	CONSTRAINT CONS134220427 PRIMARY KEY (ID)
);
CREATE UNIQUE INDEX INDEX33558933 ON QSGNMP.T_DEVICE (ID);


CREATE TABLE T_ALARM (
	ID VARCHAR(64) NOT NULL,
	DEVICE_SN_NO VARCHAR(100),
	DEVICE_ALARM_ID INT,
	APPLICATIONS VARCHAR(100),
	LOG_LEVEL VARCHAR(20),
	LOG_TYPE VARCHAR(100),
	APP_MODULE VARCHAR(100),
	OPERATOR VARCHAR(64),
	ERROR_CODE VARCHAR(20),
	LOG_CONTENT TEXT,
	ALARM_TIME TIMESTAMP,
	STATUS INT,
	UPDATE_BY VARCHAR(20),
	UPDATE_TIME TIMESTAMP,
	CONSTRAINT CONS134220506 PRIMARY KEY (ID)
);
CREATE UNIQUE INDEX INDEX33559012 ON QSGNMP.T_ALARM (ID);