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

TypeMismatchException thrown while querying a table that has an index with a Boolean

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.3.0, 4.4.0, 4.5.0
    • Fix Version/s: 4.6.0
    • Component/s: None
    • Labels:
      None

      Description

      Getting below exception scanning through index on boolean column.

      java.lang.RuntimeException: org.apache.phoenix.schema.TypeMismatchException: ERROR 203 (22005): Type mismatch. DECIMAL cannot be coerced to BOOLEAN 
      at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2440) 
      at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2074) 
      at sqlline.SqlLine.print(SqlLine.java:1735) 
      at sqlline.SqlLine$Commands.execute(SqlLine.java:3683) 
      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) 
      

      Here are simple steps to reproduce

      CREATE TABLE TABLE_TEST (PK INTEGER PRIMARY KEY, COL1 BOOLEAN);
      UPSERT INTO TABLE_TEST VALUES (1, true);
      UPSERT INTO TABLE_TEST VALUES (2, false);
      SELECT * FROM TABLE_TEST;
      CREATE INDEX TABLE_TEST_IDX ON TABLE_TEST(COL1);
      SELECT * FROM TABLE_TEST;
      DROP TABLE TABLE_TEST;
      

        Attachments

        1. PHOENIX-2313.patch
          2 kB
          Rajeshbabu Chintaguntla
        2. PHOENIX-2313_addendum.patch
          5 kB
          James R. Taylor

          Activity

            People

            • Assignee:
              rajeshbabu Rajeshbabu Chintaguntla
              Reporter:
              rajeshbabu Rajeshbabu Chintaguntla
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: