DataEase 数据集 自定义sql语句无法“保存并返回”，
sql如下：
SELECT
‘TR1/3’ AS RowName,
COUNT() AS total_count,
SUM(CASE WHEN stay_time > 60 THEN 1 ELSE 0 END) AS gt60_count,
ISNULL(
ROUND(
100.0 * SUM(CASE WHEN stay_time > 60 THEN 1 ELSE 0 END) / NULLIF(COUNT(), 0),
2
),
0
) AS gt60_percent
FROM v_park_record_today
WHERE car_type = ‘纳品车辆(社外业体)’
AND channel_in_name = ‘GATE2入口’
AND car_number NOT IN (
‘苏M818QH’, ‘苏MF2717’, ‘苏M36227’, ‘苏M35702’, ‘苏M33128’,
‘苏MB0682’, ‘苏M35898’, ‘苏MAP240’, ‘苏MAM920’, ‘苏MN2J96’,
‘苏M39392’, ‘苏MX9Z79’, ‘浙A077SC’, ‘苏MAD189’, ‘苏MF9432’,
‘苏ME250T’, ‘苏MM5618’, ‘苏MW801D’, ‘苏MW6G63’, ‘苏MAM508’
)
UNION ALL
SELECT
‘TR4’ AS RowName,
COUNT() AS total_count,
SUM(CASE WHEN stay_time > 60 THEN 1 ELSE 0 END) AS gt60_count,
ISNULL(
ROUND(
100.0 * SUM(CASE WHEN stay_time > 60 THEN 1 ELSE 0 END) / NULLIF(COUNT(), 0),
2
),
0
) AS gt60_percent
FROM v_park_record_today
WHERE car_type = ‘纳品车辆(社外业体)’
AND channel_in_name = ‘GATE7入2’
UNION ALL
SELECT
‘Comp’ AS RowName,
COUNT() AS total_count,
SUM(CASE WHEN stay_time > 60 THEN 1 ELSE 0 END) AS gt60_count,
ISNULL(
ROUND(
100.0 * SUM(CASE WHEN stay_time > 60 THEN 1 ELSE 0 END) / NULLIF(COUNT(), 0),
2
),
0
) AS gt60_percent
FROM v_park_record_today
WHERE car_type = ‘纳品车辆(社外业体)’
AND channel_in_name = ‘GATE2入口’
AND car_number IN (
‘苏M818QH’, ‘苏MF2717’, ‘苏M36227’, ‘苏M35702’, ‘苏M33128’,
‘苏MB0682’, ‘苏M35898’, ‘苏MAP240’, ‘苏MAM920’, ‘苏MN2J96’,
‘苏M39392’, ‘苏MX9Z79’, ‘浙A077SC’, ‘苏MAD189’, ‘苏MF9432’,
‘苏ME250T’, ‘苏MM5618’, ‘苏MW801D’, ‘苏MW6G63’, ‘苏MAM508’
);
运行和保存正常；
此处保存并返回是报错。