Bug: web版，使用Mysql数据库，表字段好几个mysql关键字

Open spsyche opened this issue 2 years ago • 1 comments

Chat2DB Version

Describe the bug

比如dashboard表使用了schema,data_source表使用了ssl字段，别的还没试过，使用就报错。只能自己改名

Dec 07 '23 01:12 spsyche

This is also the case when I use mysql. My solution is to enclose these keywords in backticks. In addition, there are other incompatible sql that also need to be modified. Finally, modify the DO class involving the ssl and schema keywords, and use the @TableField annotation to add backticks to the keywords.

A total of 5 files are involved and need to be modified. 3 sql files

Search in directory 2 java files

Dec 07 '23 12:12 DimonHo