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.

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

[Bug] 针对pg数据库对where条件做to_char时间转换时表达式右侧的值未转换成字符串类型 #1384

Open
2 of 3 tasks
wangwz587 opened this issue Jul 10, 2024 · 2 comments
Open
2 of 3 tasks

[Bug] 针对pg数据库对where条件做to_char时间转换时表达式右侧的值未转换成字符串类型 #1384

wangwz587 opened this issue Jul 10, 2024 · 2 comments
Labels
bug Something isn't working

Comments

@wangwz587
Copy link

Search before asking

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

Version

0.9.4

What's Wrong?

生成的语义sql如下：
image
转换成pg执行的sql如下：
image
此sql是错误的无法执行。

What You Expected?

pg对where条件和having条件等做to_char转换时需要将表达式右侧的数值类型转换为字符串类型的值。

How to Reproduce?

No response

Anything Else?

无

Are you willing to submit PR?

  • Yes I am willing to submit a PR!

Code of Conduct
@wangwz587 wangwz587 added the bug Something isn't working label Jul 10, 2024
@mainmainer mainmainer self-assigned this Jul 10, 2024
@mainmainer
Copy link
Contributor

模型生成的SQL是啥样的？ @wangwz587

@wangwz587
Copy link
Author

跟修正S2SQL一样的

@mainmainer mainmainer removed their assignment Jul 16, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@mainmainer @wangwz587