Uploaded image for project: 'Kylin'
  1. Kylin
  2. KYLIN-3276

Fix the query cache bug with dynamic parameter

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • v2.2.0
    • v2.3.1
    • Driver - JDBC, Query Engine
    • None
    • Kylin 2.2.0, JDK 1.8

    Description

      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)

      Attachments

        Activity

          People

            nichunen nichunen
            XIXIN ZHAOXIXIN
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: