使用postgresql时，生成的代码list接口，map传入参数被转成String，但是数据库中为bigint8，无法使用。

Blade 已结

关注举报

 1  26

wusong285 剑童 2小时前

一、该问题的重现步骤是什么？

1. 使用postgresql15.10数据库

2. 使用代码生成器生成代码

3.调用list方法，数据库中的字段为bigint8，但是传入的参数被转成了string

 Condition.getQueryWrapper(messageBox, MessageBoxEntity.class)

Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint = character varying

建议：No operator matches the given name and argument types. You might need to add explicit type casts.

出现此错误

二、你期待的结果是什么？实际看到的又是什么？

SqlKeyword使用了Map传值，但是如此数据没有转成对应的数据类型，导致查询时候数据类型无法匹配。

三、你正在使用的是什么产品，什么版本？在什么操作系统上？

boot商业版，winds本地机器

四、请提供详细的错误堆栈信息，这很重要。

org.springframework.jdbc.BadSqlGrammarException:

### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint = character varying

建议：No operator matches the given name and argument types. You might need to add explicit type casts.

位置：93

### The error may exist in com/eastfair/modules/exhibition/mapper/MessageBoxMapper.java (best guess)

### The error may involve defaultParameterMap

### The error occurred while setting parameters

### SQL: SELECT COUNT(*) AS total FROM internet_message_box WHERE is_deleted = 0 AND (recipient_user = ?)

### Cause: org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint = character varying

建议：No operator matches the given name and argument types. You might need to add explicit type casts.

位置：93

; bad SQL grammar []

at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:112)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:107)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:116)

at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)

at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)

at jdk.proxy2/jdk.proxy2.$Proxy129.selectList(Unknown Source)

at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)

at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:164)

at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)

at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:152)

at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)

at jdk.proxy2/jdk.proxy2.$Proxy181.selectList(Unknown Source)

at com.baomidou.mybatisplus.core.mapper.BaseMapper.selectPage(BaseMapper.java:432)

at java.base/java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:732)

at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$DefaultMethodInvoker.invoke(MybatisMapperProxy.java:166)

at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)

at jdk.proxy2/jdk.proxy2.$Proxy181.selectPage(Unknown Source)

at com.baomidou.mybatisplus.extension.service.IService.page(IService.java:449)

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)

at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.base/java.lang.reflect.Method.invoke(Method.java:568)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:354)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)

at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:174)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)

at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:720)

at com.eastfair.modules.exhibition.service.impl.MessageBoxServiceImpl$$SpringCGLIB$$0.page(<generated>)

at com.eastfair.modules.exhibition.controller.MessageBoxController.list(MessageBoxController.java:95)