Skip to content
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.

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

[Bug] 拼装最终执行SQL的时候,com.tencent.supersonic.headless.core.translator.calcite.sql.render.JoinRender#render内拼装连表字段时匹配错误导致查询失败 #1906

Open
2 of 3 tasks
Alita-Z opened this issue Nov 12, 2024 · 0 comments
Labels
bug Something isn't working

Comments

@Alita-Z
Copy link

Alita-Z commented Nov 12, 2024

Search before asking

  • I had searched in the issues and found no similar issues.

Version

0.9.8

What's Wrong?

两个表:a(CONTRACTCODE)、b(contractcode)进行连表查询时,该字段为两张表的关联字段joinCondition(CONTRACTCODE,=,contractcode)
com.tencent.supersonic.headless.core.translator.calcite.sql.render.JoinRender#render方法的逻辑将字段匹配错误:
b.CONTRACTCODE AS CONTRACTCODE,导致查询时字段对应不上而报错。

What You Expected?

应该匹配对应表字段:b.contractcode AS contractcode

How to Reproduce?

No response

Anything Else?

No response

Are you willing to submit PR?

  • Yes I am willing to submit a PR!

Code of Conduct

@Alita-Z Alita-Z added the bug Something isn't working label Nov 12, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant