doris icon indicating copy to clipboard operation
doris copied to clipboard

fix get_json_string does not support array

Open y115520509 opened this issue 1 month ago • 6 comments

What problem does this PR solve?

Issue Number: open #58815

Problem Summary:

2.1.1 branch-2.1

In the official documentation, the following SQL statements have return values,but it is currently returning null

mysql> SELECT get_json_string('[{"k1":"v1"}, {"k2":"v2"}, {"k1":"v3"}, {"k1":"v4"}]', '$.k1');
+---------------------------------------------------------------------------------+
| get_json_string('[{"k1":"v1"}, {"k2":"v2"}, {"k1":"v3"}, {"k1":"v4"}]', '$.k1') |
+---------------------------------------------------------------------------------+
| ["v1","v3","v4"]                                                                |
+---------------------------------------------------------------------------------+

Release note

None

Check List (For Author)

  • Test

    • [x] Regression test
    • [ ] Unit Test
    • [ ] Manual test (add detailed scripts or steps below)
    • [ ] No need to test or manual test. Explain why:
      • [ ] This is a refactor/code format and no logic has been changed.
      • [ ] Previous test can cover this change.
      • [ ] No code files have been changed.
      • [ ] Other reason
  • Behavior changed:

    • [ ] No.
    • [ ] Yes.
  • Does this need documentation?

    • [ ] No.
    • [ ] Yes.

Check List (For Reviewer who merge this PR)

  • [ ] Confirm the release note
  • [ ] Confirm test cases
  • [ ] Confirm document
  • [ ] Add branch pick label

y115520509 avatar Dec 08 '25 09:12 y115520509

Thank you for your contribution to Apache Doris. Don't know what should be done next? See How to process your PR.

Please clearly describe your PR:

  1. What problem was fixed (it's best to include specific error reporting information). How it was fixed.
  2. Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be.
  3. What features were added. Why was this function added?
  4. Which code was refactored and why was this part of the code refactored?
  5. Which functions were optimized and what is the difference before and after the optimization?

hello-stephen avatar Dec 08 '25 09:12 hello-stephen

run buildall

y115520509 avatar Dec 08 '25 09:12 y115520509

BE UT Coverage Report

Increment line coverage 68.57% (24/35) :tada:

Increment coverage report Complete coverage report

Category Coverage
Function Coverage 39.15% (10402/26568)
Line Coverage 30.14% (86290/286319)
Region Coverage 27.69% (49840/179968)
Branch Coverage 24.25% (24456/100850)

doris-robot avatar Dec 08 '25 09:12 doris-robot

run buildall

y115520509 avatar Dec 09 '25 08:12 y115520509

BE UT Coverage Report

Increment line coverage 68.57% (24/35) :tada:

Increment coverage report Complete coverage report

Category Coverage
Function Coverage 39.14% (10399/26568)
Line Coverage 30.13% (86256/286319)
Region Coverage 27.68% (49822/179968)
Branch Coverage 24.24% (24449/100850)

hello-stephen avatar Dec 09 '25 09:12 hello-stephen

run p0

y115520509 avatar Dec 11 '25 02:12 y115520509

run p0

y115520509 avatar Dec 16 '25 11:12 y115520509

run buildall

y115520509 avatar Dec 17 '25 06:12 y115520509

BE UT Coverage Report

Increment line coverage 68.57% (24/35) :tada:

Increment coverage report Complete coverage report

Category Coverage
Function Coverage 39.15% (10402/26568)
Line Coverage 30.13% (86273/286319)
Region Coverage 27.69% (49826/179968)
Branch Coverage 24.24% (24448/100850)

doris-robot avatar Dec 17 '25 07:12 doris-robot