[Bug]: json_extract(j1,'$[0]') inconsistent with MySQL results

[heni02]

Is there an existing issue for the same bug?

• [X] I have checked the existing issues.

Environment

- Version or commit-id (e.g. v0.1.0 or 8b23a93):
- Hardware parameters:
- OS type:
- Others:

Actual Behavior

MO results: mysql results:

Expected Behavior

No response

Steps to Reproduce

create table json_table_71(j1 json);
insert into  json_table_71 values('{
    "orderType": "BUY",
    "orderId": 20768330,
    "syncAction": "market_order",
    "itemCode": "DT_GOODS",
    "maxOfPeople": 214748,
    "itemName": "试用规格",
    "payFee": 0,
    "serviceStopTime": 1608825600000,
    "serviceStartTime": 1607481719000,
    "minOfPeople": 0,
    "paidtime": 1607481718000,
    "syncSeq": "0CD53B341284A223363FD8E4ACIHWBU98283"
}');
select  json_extract(j1,'$[0]') from json_table_71;

Additional information

No response