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

["Dayue Gao (JIRA)" <ji...@apache.org>]

    [ 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<='BBBB'
> 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":50000,"acceptPartial":true,"project":"learn_kylin","params":[{"className":"java.lang.String", "value":"ABIN"},{"className":"java.lang.String", "value":"BBBB"}]}
> Result: 0



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