New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Select子句，通过as取别名存在BUG #380

Closed

LegendaryGasai opened this issue Jul 11, 2024 · 1 comment · Fixed by #405

LegendaryGasai commented Jul 11, 2024

对同一个属性多次as，会进行覆盖。例如下图，对plt_oid属性列，通过as分别取了oid和plt_oid别名，但查询结果中显示的都是plt_oid

期望结果：在常规SQL中应该是这样的，对同一列多次as取别名是相互独立的，不会覆盖别名。比如下面的plt_oid as oid,plt_oid as plt_oid，查询结果正常，一个是oid，一个是plt_oid，希望达成这样的效果。

Member

zhuyuqing commented Jul 12, 2024

我们暂时不支持同一列多次重命名，后续会加上，逐步匹配SQL标准。谢谢

jzl18thu linked a pull request

that will close this issue

feat(core): rename duplicate same columns #405

Merged

zhuyuqing closed this as completed in #405

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment