Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
4.3.0, 4.4.0, 4.5.0
-
None
-
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;