一、该问题的重现步骤是什么?
1. 后端版本: 4.3.0.RELEASE ,数据库PG库
2. 代码生成器生成-树表,正常生成,无报错。
3. 查询/tree接口时报错,后端断点显示:查询的SQL为:
SELECT id AS id, parent_id AS parent_id, name AS title, id AS 'value', id AS 'key' FROM tableName WHERE is_deleted = 0 AND tenant_id = '000000' ,原因是 'value' ,'key'别名带单引号,导致报错。
同样的在4.0.1.RELEASE 中是:SELECT id AS id, parent_id AS parent_id, name AS title, id AS value, id AS key FROM tableName WHERE is_deleted = 0 AND tenant_id = '000000'
二、你期待的结果是什么?实际看到的又是什么?
希望正常使用tree接口
三、你正在使用的是什么产品,什么版本?在什么操作系统上?
四、请提供详细的错误堆栈信息,这很重要。
{
"code": 500,
"success": false,
"data": {},
"msg": "\r\n### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near \"'value'\"\n 位置:63\r\n### The error may exist in /mapper/managerMapper.xml\r\n### The error may involve defaultParameterMap\r\n### The error occurred while setting parameters\r\n### SQL: SELECT id AS id, parent_id AS parent_id, name AS title, id AS 'value', id AS 'key' FROM th_floor_manager WHERE is_deleted = 0 AND tenant_id = ?\r\n### Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near \"'value'\"\n 位置:63\n; bad SQL grammar []"
}
五、若有更多详细信息,请在下面提供。
已修复:https://center.javablade.com/blade/BladeX-Tool/commit/008dc2971d8b114213d93fb9011aee4e85e5edce
你可以先拷贝这个文件,放到/resources/tempaltes/api文件夹下覆盖tool工程的定义
扫一扫访问 Blade技术社区 移动端