为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: dm8 (20220xxx)
【操作系统】: centos7
【CPU】: 8
【问题描述】*:关键字作为别名会导致嵌套层次太深? 不确定后面版本有没有修复。
-- 建表语句
CREATE TABLE "t_temp"
(
"id" BIGINT IDENTITY(1, 1) NOT NULL,
"NO" VARCHAR(255),
"STime" DATETIME(6),
"act3_stat" INTEGER
) ;
-- 查询的bug语句
SELECT HOUR(t."STime") AS "hour", COUNT(DISTINCT t."no") AS "no", MAX(t."STime") AS createTime
FROM "t_temp" t
GROUP BY "hour";
hour的别名改成其它的就正常,这个不确定是否修复了
SELECT HOUR(t."STime") AS "ahour", COUNT(DISTINCT t."no") AS "no", MAX(t."STime") AS createTime
FROM "t_temp" t
GROUP BY "ahour";
我的本地库测试没问题。
数据库版本
你的是什么版本
-- 查询的bug语句 SELECT HOUR(t."STime") AS "hour", COUNT(DISTINCT t."no") AS "no", MAX(t."STime") AS createTime FROM "t_temp" t GROUP BY HOUR(t."STime"); group by不支持别名