matrixone icon indicating copy to clipboard operation
matrixone copied to clipboard

[Bug]: json_extract jsonpath return array null value

Open heni02 opened this issue 3 years ago • 0 comments

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: 企业微信截图_8186435d-ff78-45d1-9d03-507c024af775

mysql: 企业微信截图_9695dc19-a179-4116-bcde-7ee577d43c62

Expected Behavior

No response

Steps to Reproduce

select json_extract(' {"af": [1, "2", {"aaf": "bb"}],"eab":"888"} ','$**.f');

Additional information

No response

heni02 avatar Oct 12 '22 08:10 heni02