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

["Billy Liu (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/KYLIN-3276?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Billy Liu updated KYLIN-3276:
-----------------------------
    Fix Version/s: v2.3.1

> 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)