kylin-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF subversion and git services (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (KYLIN-3276) query with dynamic parameter get the same query result
Date Sun, 18 Mar 2018 18:31:00 GMT

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

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

Commit 60639456423a44ea6d88b0548fa3c1541db57e98 in kylin's branch refs/heads/2.3.x from [~nichunen]
[ https://gitbox.apache.org/repos/asf?p=kylin.git;h=6063945 ]

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)

Mime
View raw message