为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】：window10
【CPU】:
【问题描述】*：执行sql语句报错误，提示不详细
select a.id,
a.name,
IFNULL(a.short_name,'') shortName,
CONCAT('[', LISTAGG('{"status":', IFNULL(ws.status,0), ', "count":', IFNULL(ws.count,0) ,'}'), ']') lineCells
from "water_frame_test".wt_area_info a
left join ( select count(1) count,
s.status,
s.province_id id
from "water_frame_test".wt_station_info s
where s.del_flag = 0
group by s.province_id ,
s.status ) ws
on ws.id = a.id
where a.del_flag = 0
and a.pid in(1)
group by a.id
order by a.sort,
a.id
执行失败(语句1)
-6803: 第18 行附近出现错误:
非法的参数数据
经过判断应该是LISTAGG调用处有问题，但是也不知道什么问题。一下是两个表的表结构
CREATE TABLE "water_frame_test"."WT_AREA_INFO"
(
"ID" BIGINT IDENTITY(3219, 1) NOT NULL,
"NAME" VARCHAR(50) DEFAULT '' NOT NULL,
"CODE" VARCHAR(30) DEFAULT '' NOT NULL,
"PID" BIGINT DEFAULT 0 NOT NULL,
"SORT" INT DEFAULT 0 NOT NULL,
"DEL_FLAG" INT DEFAULT 0 NOT NULL,
"LEVEL" INT DEFAULT 0 NOT NULL,
"IS_ROOT" INT DEFAULT 0 NOT NULL,
"CREATE_DATE" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP() NOT NULL,
"COMMENT" VARCHAR(255) DEFAULT '' NOT NULL,
"SHORT_NAME" VARCHAR(50) DEFAULT '' NOT NULL,
"POST_CODE" VARCHAR(10) DEFAULT '' NOT NULL,
"LATITUDE" DECIMAL(12,8) DEFAULT 0. NOT NULL,
"LONGITUDE" DECIMAL(12,8) DEFAULT 0. NOT NULL,
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) 😉
CREATE TABLE "water_frame_test"."WT_STATION_INFO"
(
"ID" BIGINT IDENTITY(118, 1) NOT NULL,
"NAME" VARCHAR(100) DEFAULT '' NOT NULL,
"CODE" VARCHAR(30) DEFAULT '' NOT NULL,
"PASSWORD" VARCHAR(10) DEFAULT '' NOT NULL,
"STATUS" INT DEFAULT 0 NOT NULL,
"IS_ACCEPT" INT DEFAULT 0,
"ACCEPT_DATE" TIMESTAMP(0),
"ADDRESS" VARCHAR(255) DEFAULT '' NOT NULL,
"MAINTAIN_COMPANY_ID" BIGINT DEFAULT 0 NOT NULL,
"MANAGE_ORG_ID" BIGINT DEFAULT 0 NOT NULL,
"LATITUDE" DECIMAL(12,8) DEFAULT 0. NOT NULL,
"LONGITUDE" DECIMAL(12,8) DEFAULT 0. NOT NULL,
"DESCRIPTION" VARCHAR(255) DEFAULT '' NOT NULL,
"HISTORY_DESCRIPTION" VARCHAR(500) DEFAULT '' NOT NULL,
"ABILITY" VARCHAR(10) DEFAULT '' NOT NULL,
"PROPERTIES" VARCHAR(100) DEFAULT '' NOT NULL,
"TYPE" INT DEFAULT 0 NOT NULL,
"ITEMS" INT DEFAULT 0 NOT NULL,
"CATEGORY" INT DEFAULT 0 NOT NULL,
"BASIN_ID" BIGINT DEFAULT 0 NOT NULL,
"RIVER_ID" BIGINT DEFAULT 0 NOT NULL,
"STREAM_SORT" INT DEFAULT 0 NOT NULL,
"RIVER_SORT" INT DEFAULT 0 NOT NULL,
"PROVINCE" VARCHAR(40) DEFAULT '' NOT NULL,
"CITY" VARCHAR(40) DEFAULT '' NOT NULL,
"DISTRICT" VARCHAR(40) DEFAULT '' NOT NULL,
"GOAL_LEVEL" INT DEFAULT 1 NOT NULL,
"CURRENT_LEVEL" INT DEFAULT 1 NOT NULL,
"COURSE_LEVEL" INT DEFAULT 1,
"RIVER_LEVEL" VARCHAR(20) DEFAULT '' NOT NULL,
"BUILD_PROVINCE" VARCHAR(40) DEFAULT '' NOT NULL,
"BUILD_CITY" VARCHAR(40) DEFAULT '' NOT NULL,
"INTRODUCTION" VARCHAR(500) DEFAULT '' NOT NULL,
"EXAMINE_PROVINCE" VARCHAR(40) DEFAULT '' NOT NULL,
"UPSTREAM_PROVINCE" VARCHAR(30) DEFAULT '0' NOT NULL,
"DOWNSTREAM_PROVINCE" VARCHAR(30) DEFAULT '0' NOT NULL,
"INNER_IMAGE" BIGINT DEFAULT 0 NOT NULL,
"OUTER_IMAGE" BIGINT DEFAULT 0 NOT NULL,
"SAMPLING_IMAGE" BIGINT DEFAULT 0 NOT NULL,
"LAB_IMAGE" BIGINT DEFAULT 0 NOT NULL,
"BUILD_IMAGE" BIGINT DEFAULT 0 NOT NULL,
"CREATE_DATE" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP() NOT NULL,
"COMMENT" VARCHAR(255) DEFAULT '' NOT NULL,
"PROVINCE_ID" BIGINT DEFAULT 0 NOT NULL,
"CITY_ID" BIGINT DEFAULT 0 NOT NULL,
"DISTRICT_ID" BIGINT DEFAULT 0 NOT NULL,
"DEL_FLAG" INT DEFAULT 0 NOT NULL,
"IS_ENABLE" INT DEFAULT 0,
"BUILD_PROVINCE_ID" BIGINT DEFAULT 0 NOT NULL,
"BUILD_CITY_ID" BIGINT DEFAULT 0 NOT NULL,
"OFFICE_ID" BIGINT DEFAULT 0 NOT NULL,
"EXAMINE_PROVINCE_ID" BIGINT DEFAULT 0 NOT NULL,
"UPSTREAM_PROVINCE_ID" BIGINT DEFAULT 0 NOT NULL,
"DOWNSTREAM_PROVINCE_ID" BIGINT DEFAULT 0 NOT NULL,
"RIVER_SYSTEM" VARCHAR(30) DEFAULT '' NOT NULL,
"STATION_COVER_IMAGES" BIGINT DEFAULT 0 NOT NULL,
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) 😉