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

[wangwz587]

Search before asking

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

Version

0.9.4

What's Wrong?

生成的语义sql如下： 转换成pg执行的sql如下： 此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

• [X] I agree to follow this project's Code of Conduct

[mainmainer]

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

[wangwz587]

跟修正S2SQL一样的