Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-1709

And expression of primary key RVCs can not compile

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 3.3.1, 4.3.1, 4.4.0
    • None
    • None

    Description

      1 . create table t (a integer not null, b integer not null, c integer
      constraint pk primary key (a,b));

      2. select c from t where a in (1,2) and b = 3 and (a,b) in ( (1,2) , (1,3));

      I got exception on compile :

      java.lang.IllegalArgumentException
      at
      com.google.common.base.Preconditions.checkArgument(Preconditions.java:76)
      at
      org.apache.phoenix.compile.WhereOptimizer$KeyExpressionVisitor$KeySlot.inter
      sect(WhereOptimizer.java:955)
      at
      org.apache.phoenix.compile.WhereOptimizer$KeyExpressionVisitor.intersectSlot
      s(WhereOptimizer.java:506)
      at
      org.apache.phoenix.compile.WhereOptimizer$KeyExpressionVisitor.andKeySlots(W
      hereOptimizer.java:551)
      at
      org.apache.phoenix.compile.WhereOptimizer$KeyExpressionVisitor.visitLeave(Wh
      ereOptimizer.java:725)
      at
      org.apache.phoenix.compile.WhereOptimizer$KeyExpressionVisitor.visitLeave(Wh
      ereOptimizer.java:349)
      at
      org.apache.phoenix.expression.AndExpression.accept(AndExpression.java:100)
      at
      org.apache.phoenix.compile.WhereOptimizer.pushKeyExpressionsToScan(WhereOpti
      mizer.java:117)
      at
      org.apache.phoenix.compile.WhereCompiler.compile(WhereCompiler.java:105)
      at
      org.apache.phoenix.compile.QueryCompiler.compileSingleQuery(QueryCompiler.ja
      va:324)
      at
      org.apache.phoenix.compile.QueryCompiler.compile(QueryCompiler.java:132)
      at
      org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePl
      an(PhoenixStatement.java:296)
      at
      org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePl
      an(PhoenixStatement.java:284)
      at
      org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:208)
      at
      org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:204)
      at
      org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.j
      ava:54)
      at
      org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:
      204)
      at
      org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:967)
      at sqlline.SqlLine$Commands.execute(SqlLine.java:3673)
      at sqlline.SqlLine$Commands.sql(SqlLine.java:3584)
      at sqlline.SqlLine.dispatch(SqlLine.java:821)
      at sqlline.SqlLine.begin(SqlLine.java:699)
      at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441)
      at sqlline.SqlLine.main(SqlLine.java:424)

      Attachments

        1. PHOENIX-1709.patch
          5 kB
          James R. Taylor
        2. PHOENIX-1709_v5.patch
          12 kB
          James R. Taylor
        3. PHOENIX-1709_v4.patch
          7 kB
          James R. Taylor
        4. PHOENIX-1709_v3.patch
          8 kB
          mengqingyi
        5. PHOENIX-1709_v2.patch
          6 kB
          James R. Taylor

        Activity

          People

            jamestaylor James R. Taylor
            jamestaylor James R. Taylor
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: