[jira] [Created] (PHOENIX-7649) Seconday uncovered Index on BSON data is not receiving mutation

["Rahul Kumar (Jira)" <ji...@apache.org>]

Rahul Kumar created PHOENIX-7649:
------------------------------------

             Summary: Seconday uncovered Index on BSON data is not receiving mutation
                 Key: PHOENIX-7649
                 URL: https://issues.apache.org/jira/browse/PHOENIX-7649
             Project: Phoenix
          Issue Type: Bug
            Reporter: Rahul Kumar
            Assignee: Rahul Kumar
             Fix For: 5.3.0


There is a difference in behaviour on indexing BSON col for uncovered indexes. For eg, I tried creating a covered({*}test_bson_idx{*}) and uncovered index({*}test_bson_idx_uncov{*}) with same column but uncovered index dint get update for UPSERT row.


{code:java}
0: jdbc:phoenix:zookeeper-0.zookeeper-headles> CREATE TABLE test_bson (PK1 VARCHAR NOT NULL, C1 VARCHAR, COL BSON, CONSTRAINT pk PRIMARY KEY(PK1));
2025-06-25 12:20:12,847 INFO  [main] client.HBaseAdmin - Operation: CREATE, Table Name: default:TEST_BSON, procId: 51716 completed

0: jdbc:phoenix:zookeeper-0.zookeeper-headles> CREATE UNCOVERED INDEX test_bson_idx_uncov ON test_bson(COL);
2025-06-25 12:21:19,465 INFO  [main] schema.MetaDataClient - STORAGE--ENCODING: ONE_CELL_PER_COLUMN--NON_ENCODED_QUALIFIERS
2025-06-25 12:21:19,466 INFO  [main] schema.MetaDataClient - Using CQSI level Default Index State=b for Index=TEST_BSON_IDX_UNCOV ON TEST_BSON
2025-06-25 12:21:20,604 INFO  [main] client.HBaseAdmin - Operation: CREATE, Table Name: default:TEST_BSON_IDX_UNCOV, procId: 51719 completed
2025-06-25 12:21:20,624 INFO  [main] schema.MetaDataClient - Created index TEST_BSON_IDX_UNCOV at 1750854080610

0: jdbc:phoenix:zookeeper-0.zookeeper-headles> CREATE INDEX  test_bson_idx ON test_bson(COL);
2025-06-25 12:21:40,729 INFO  [main] schema.MetaDataClient - STORAGE--ENCODING: ONE_CELL_PER_COLUMN--NON_ENCODED_QUALIFIERS
2025-06-25 12:21:40,729 INFO  [main] schema.MetaDataClient - Using CQSI level Default Index State=b for Index=TEST_BSON_IDX ON TEST_BSON
2025-06-25 12:21:41,867 INFO  [main] client.HBaseAdmin - Operation: CREATE, Table Name: default:TEST_BSON_IDX, procId: 51722 completed
2025-06-25 12:21:41,883 INFO  [main] schema.MetaDataClient - Created index TEST_BSON_IDX at 1750854101870

0: jdbc:phoenix:zookeeper-0.zookeeper-headles> UPSERT INTO test_bson VALUES('pk401', '401', '{"status": "enabled", "name": { "first": "Harry", "middle": "Peter", "last": "Watson"}}');

0: jdbc:phoenix:zookeeper-0.zookeeper-headles> select * from test_bson_idx_uncov;

0: jdbc:phoenix:zookeeper-0.zookeeper-headles> select * from test_bson_idx;
0:COL  
:PK1   Xpk4010COL��	�bXstatuenabledname9firstHarrymiddlePeterlastWatsonpk401

0: jdbc:phoenix:zookeeper-0.zookeeper-headles>  {code}

Also, in above covered index COL is null and PK1 is binary coded which is not as expected.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)