Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Search error for empty "in interval" condition #2298

Closed
daring2 opened this issue Jul 30, 2019 · 1 comment
Closed

Search error for empty "in interval" condition #2298

daring2 opened this issue Jul 30, 2019 · 1 comment
Assignees
Labels
comp: filter state: fixed Fixed by the developer type: exception ver: 7.0.10 Fixed in version ver: 7.1.0 Fixed in version ver: 7.2.0 Fixed in version
Milestone

Comments

@daring2
Copy link
Contributor

daring2 commented Jul 30, 2019

Environment

  • Platform version: 7.0.9
  • Client type: Web
  • Database: HSQL, PostgreSQL

Description of the bug or enhancement

The problem could be reproduced in project sample-library-cuba7.
Steps to reproduce:

  1. open Books screen
  2. add "in interval" search condition for "Created At" attribute
  3. click "Search" button

Actual behavior - error JpqlSyntaxException.
Stacktrace:

com.haulmont.cuba.core.global.RemoteException:
---
com.haulmont.cuba.core.sys.jpql.JpqlSyntaxException: Errors found for input jpql:[where]
CommonErrorNode [<unexpected: [@14,18:18='<EOF>',<-1>,3:4], resync=>]
	at com.haulmont.cuba.core.sys.ServiceInterceptor.aroundInvoke(ServiceInterceptor.java:124)
	at jdk.internal.reflect.GeneratedMethodAccessor152.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633)
	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:93)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
	at com.sun.proxy.$Proxy227.loadList(Unknown Source)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at com.haulmont.cuba.core.sys.remoting.LocalServiceInvokerImpl.invoke(LocalServiceInvokerImpl.java:94)
	at com.haulmont.cuba.web.sys.remoting.LocalServiceProxy$LocalServiceInvocationHandler.invoke(LocalServiceProxy.java:154)
	at com.sun.proxy.$Proxy34.loadList(Unknown Source)
...
@daring2 daring2 changed the title Serach error for empty "in interval" condition Search error for empty "in interval" condition Jul 30, 2019
@andreysubbotin andreysubbotin added this to the Release 7.0 milestone Aug 2, 2019
@haulmont-git haulmont-git added the ver: 7.0.10 Fixed in version label Aug 2, 2019
@haulmont-git haulmont-git added the ver: 7.1.0 Fixed in version label Aug 2, 2019
@haulmont-git haulmont-git added the ver: 7.2.0 Fixed in version label Aug 2, 2019
@natfirst natfirst assigned MikhailSilk and unassigned natfirst Aug 5, 2019
@MikhailSilk
Copy link

  1. Open Books screen
  2. Add the first "in interval" search condition for "Created At" attribute
  3. Add the second "in interval" search condition for "Created At" attribute
  4. Click "Search" button

Actual behavior
Occurs JpqlSyntaxException

com.haulmont.cuba.core.global.RemoteException:
---
com.haulmont.cuba.core.sys.jpql.JpqlSyntaxException: Errors found for input jpql:[where (
      
     and 
      
    )]
CommonErrorNode [<unexpected: [@16,20:22='and',<4>,3:5], resync=and>]
CommonErrorNode [<unexpected: [@30,36:36=')',<35>,5:4], resync=)>]
	at com.haulmont.cuba.core.sys.ServiceInterceptor.aroundInvoke(ServiceInterceptor.java:124)
	at sun.reflect.GeneratedMethodAccessor119.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633)
	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:93)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
	at com.sun.proxy.$Proxy229.loadList(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor182.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
comp: filter state: fixed Fixed by the developer type: exception ver: 7.0.10 Fixed in version ver: 7.1.0 Fixed in version ver: 7.2.0 Fixed in version
Projects
None yet
Development

No branches or pull requests

7 participants