当前使用版本(必填,否则不予处理)
3.4.3.3
该问题是如何引起的?(确定最新版也有问题再提!!!)
PostgreSQL数据库,Mybatis-Plus在配置capital-mode: true和column-format: "\"%s\"" 后,生成的SQL语句仍然不带双引号,导致大写的数据库字段查不出来
重现步骤(如果有就写完整)
- 使用PostgreSQL数据库
- 配置Mybatis-Plus:
mybatis-plus:
# mapper.xml文件的路径
mapper-locations: classpath:/mapper/module/*/*.xml
global-config:
db-config:
capital-mode: true # 开启全局大写命名,表名和字段名都生效
column-format: "\"%s\""
- 配置实体类:
@Data
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
@TableName(value = "SYS_ORGANI")
@ApiModel("系统组织结构表")
@ExcelModel(includeAllField = false, excludeParent = true)
public class Organi extends Model<Organi> {
private static final long serialVersionUID = 1L;
/**
* 组织ID
*/
@TableId(value = "ORGANI_ID", type = IdType.ASSIGN_ID)
@ApiModelProperty(value = "组织ID", example = "1")
@ExcelColumn(title = "组织ID")
private String organiId;
/**
* 组织名称
*/
@TableField("ORGANI_NAME")
@ApiModelProperty(value = "组织名称")
@ExcelColumn(title = "组织名称")
private String organiName;
}
报错信息
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT ORGANI_ID, ORGANI_NAME, ORGANI_SIMPLE_NAME, ORGANI_REGION_ID, ORGANI_DESCRIPTION, ORGANI_PARENT_ID, ORGANI_TYPE_ID, ORGANI_RANK, ORGANI_STRUCTURE, ORGANI_CREATE_DATE, ORGANI_UPDATE_DATE, ORGANI_CREATE_USER_ID, ORGANI_UPDATE_USER_ID, ORGANI_SORT, ORGANI_LEAF, ORGANI_DISPLAY, ORGANI_STATUS, ORGANI_CODE, ORGANI_REMARK, ORGANI_ENG_NAME, ORGANI_ENG_SIMPLE_NAME FROM SYS_ORGANI WHERE ORGANI_ID = ?
### Cause: org.postgresql.util.PSQLException: ERROR: relation "sys_organi" does not exist
位置:371
; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: relation "sys_organi" does not exist
Comment From: miemieYaho