Is there an existing issue for the same bug?

• I have checked the existing issues.

Branch Name

main

Commit ID

413bff6

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

drop table if exists jt_diff;
create table jt_diff(id int primary key, doc json);

insert into jt_diff values (1, '{"status": "active", "score": 90}');
insert into jt_diff values (2, '{"status": "inactive", "score": 60}');
insert into jt_diff values (3, '{"status": "active", "score": 85}');

select id from jt_diff where doc -> '$.status' = '"active"' order by id;

Expected Behavior

No response

Steps to Reproduce

as above

Additional information

No response