[jira] [Commented] (KYLIN-3276) query with dynamic parameter get the same query result

["ASF subversion and git services (JIRA)" <ji...@apache.org>]

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

ASF subversion and git services commented on KYLIN-3276:
--------------------------------------------------------

Commit 6ba2fcaafc3c849851eed1e790318d1bc015fd7f in kylin's branch refs/heads/sync from [~nichunen]
[ https://gitbox.apache.org/repos/asf?p=kylin.git;h=6ba2fca ]

KYLIN-3276 Fix query with different dynamic parameters get the same query result


> query with dynamic parameter get the same query result
> ------------------------------------------------------
>
>                 Key: KYLIN-3276
>                 URL: https://issues.apache.org/jira/browse/KYLIN-3276
>             Project: Kylin
>          Issue Type: Bug
>          Components: Driver - JDBC, Query Engine
>    Affects Versions: v2.2.0
>         Environment: Kylin 2.2.0, JDK 1.8
>            Reporter: ZHAOXIXIN
>            Assignee: nichunen
>            Priority: Major
>             Fix For: v2.3.1
>
>
> sql:"select distinct uid from table where daytime=? limit 700000" 
> ps.setString(1,"2018-01-03") 
> store the result to ArrayList, and print the size of ArrayList. 
> when I set the daytime to different dates, the same result I got. 
> I changed the sql, just change limit value for example 
> sql:"select distinct uid from table where daytime=? limit 600000" 
> then I got the right value the same like query from GUI:count (distinct uid) 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)