[jira] [Commented] (KYLIN-2085) PrepareStatement return incorrect result in some cases

2016-11-01 Thread Dayue Gao (JIRA) 

[ 
https://issues.apache.org/jira/browse/KYLIN-2085?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15625281#comment-15625281
 ] 

Dayue Gao commented on KYLIN-2085:
--

Encountered the same problem after upgrading to 1.5.4.1. Found this jira when 
I'm about to submitting a patch for it, so I just committed UTs for this, see 
cd9423fb5b6e88f7451d0684f7d9598b7e06c381.

> PrepareStatement return incorrect result in some cases
> --
>
> Key: KYLIN-2085
> URL: https://issues.apache.org/jira/browse/KYLIN-2085
> Project: Kylin
>  Issue Type: Bug
>  Components: Query Engine
>Reporter: Dong Li
>Assignee: Dong Li
> Fix For: v1.6.0
>
>
> With Kylin sample data,execute following SQL can get result: 
> select count(*) from kylin_sales where lstg_format_name>='ABIN' and 
> lstg_format_name<=''
> Result: 4054
> Send post with prestate:
> POST http://localhost:7070/kylin/api/query/prestate
> {"sql":"select count(*) from kylin_sales where lstg_format_name>=? and 
> lstg_format_name<=?","offset":0,"limit":5,"acceptPartial":true,"project":"learn_kylin","params":[{"className":"java.lang.String",
>  "value":"ABIN"},{"className":"java.lang.String", "value":""}]}
> Result: 0



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Commented] (KYLIN-2085) PrepareStatement return incorrect result in some cases

2016-10-12 Thread Dong Li (JIRA) 

[ 
https://issues.apache.org/jira/browse/KYLIN-2085?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15570668#comment-15570668
 ] 

Dong Li commented on KYLIN-2085:


Fixed in commit 8fbfc580c1b89e3e0065027eb22f8e3e5b7e0c67

> PrepareStatement return incorrect result in some cases
> --
>
> Key: KYLIN-2085
> URL: https://issues.apache.org/jira/browse/KYLIN-2085
> Project: Kylin
>  Issue Type: Bug
>  Components: Query Engine
>Reporter: Dong Li
>Assignee: Dong Li
> Fix For: v1.6.0
>
>
> With Kylin sample data,execute following SQL can get result: 
> select count(*) from kylin_sales where lstg_format_name>='ABIN' and 
> lstg_format_name<=''
> Result: 4054
> Send post with prestate:
> POST http://localhost:7070/kylin/api/query/prestate
> {"sql":"select count(*) from kylin_sales where lstg_format_name>=? and 
> lstg_format_name<=?","offset":0,"limit":5,"acceptPartial":true,"project":"learn_kylin","params":[{"className":"java.lang.String",
>  "value":"ABIN"},{"className":"java.lang.String", "value":""}]}
> Result: 0



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)