[Bug] [Data Development] NullPointerException when executing a query statement on the PG table

[jrenzone]

Search before asking

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

What happened

Table DDL:
CREATE TABLE ods_objs_point( id int8 NOT NULL DEFAULT nextval('gis_business_dynamic_data.point_objs_fusion_id_seq'::regclass), biz_id varchar NOT NULL, ts timestamptz(6) NOT NULL, speed numeric NULL, "position" public.geometry NOT NULL, heading numeric NULL, create_time timestamptz(6) NOT NULL DEFAULT now(), ext json NULL, source_id varchar NULL );

Sql:
select * from ods_objs_pointoopb where source_id = 'xxx' and biz_id = 'xxxxx';

Error:
2024-11-27 06:33:55.375 INFO org.dinky.metadata.driver.AbstractJdbcDriver(636): Execute query.
2024-11-27 06:33:55.505 ERROR org.dinky.metadata.driver.AbstractJdbcDriver(608): Query failed java.lang.NullPointerException: null
at org.dinky.metadata.convert.PostgreSqlTypeConvert.convertDecimalOrNumeric(PostgreSqlTypeConvert.java:69) ~[dinky-metadata-postgresql-1.0.3.jar:?]
at org.dinky.metadata.convert.AbstractTypeConvert.convert(AbstractTypeConvert.java:55) ~[dinky-metadata-base-1.0.3.jar:?]
at org.dinky.metadata.driver.AbstractJdbcDriver.query(AbstractJdbcDriver.java:583) ~[dinky-metadata-base-1.0.3.jar:?]
at org.dinky.metadata.driver.AbstractJdbcDriver.executeSql(AbstractJdbcDriver.java:637) ~[dinky-metadata-base-1.0.3.jar:?]
at org.dinky.service.impl.DataBaseServiceImpl.executeCommonSql(DataBaseServiceImpl.java:302) ~[dinky-admin-1.0.3.jar:?]
at org.dinky.service.impl.DataBaseServiceImpl$$FastClassBySpringCGLIB$$72759fa6.invoke() ~[dinky-admin-1.0.3.jar:?]
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.3.27.jar:5.3.27]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793) ~[spring-aop-5.3.27.jar:5.3.27]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.3.27.jar:5.3.27]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.27.jar:5.3.27]
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89) ~[spring-aop-5.3.27.jar:5.3.27]
at org.dinky.aop.ProcessAspect.processStepAround(ProcessAspect.java:110) ~[dinky-admin-1.0.3.jar:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_412]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_412]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_412]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_412]
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:634) ~[spring-aop-5.3.27.jar:5.3.27]
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:624) ~[spring-aop-5.3.27.jar:5.3.27]
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:72) ~[spring-aop-5.3.27.jar:5.3.27]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175) ~[spring-aop-5.3.27.jar:5.3.27]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.27.jar:5.3.27]
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97) ~[spring-aop-5.3.27.jar:5.3.27]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.27.jar:5.3.27]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763) ~[spring-aop-5.3.27.jar:5.3.27]
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708) ~[spring-aop-5.3.27.jar:5.3.27]
at org.dinky.service.impl.DataBaseServiceImpl$$EnhancerBySpringCGLIB$$7730097b.executeCommonSql() ~[dinky-admin-1.0.3.jar:?]
at org.dinky.service.task.CommonSqlTask.execute(CommonSqlTask.java:66) ~[dinky-admin-1.0.3.jar:?]

What you expected to happen

--

How to reproduce

--

Anything else

No response

Version

1.0.3

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

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