注册

关键字作为别名会导致嵌套层次太深?

果不其蓝 2023/08/07 585 3

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【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";

image.png

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";

image.png

回答 0
暂无回答
扫一扫
联系客服