[Backport 2.18] [Backport 2.x] Array values are preserved (#1300) (#3095)

[opensearch-trigger-bot[bot]]

Backport 81577dfc8035a1baf0751e87e3ac98736021c5dd from #3120.

[codecov[bot]]

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Project coverage is 94.54%. Comparing base (34ad0d1) to head (12b4928). Report is 2 commits behind head on 2.18.

Additional details and impacted files

```diff @@ Coverage Diff @@ ## 2.18 #3142 +/- ## ========================================= Coverage 94.54% 94.54% - Complexity 5454 5457 +3 ========================================= Files 529 529 Lines 15600 15610 +10 Branches 1027 1028 +1 ========================================= + Hits 14749 14759 +10 Misses 804 804 Partials 47 47 ``` | [Flag](https://app.codecov.io/gh/opensearch-project/sql/pull/3142/flags?src=pr&el=flags&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=opensearch-project) | Coverage Δ | | |---|---|---| | [sql-engine](https://app.codecov.io/gh/opensearch-project/sql/pull/3142/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=opensearch-project) | `94.54% <100.00%> (+<0.01%)` | :arrow_up: | Flags with carried forward coverage won't be shown. [Click here](https://docs.codecov.io/docs/carryforward-flags?utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=opensearch-project#carryforward-flags-in-the-pull-request-comment) to find out more.

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.

[penghuo]

Upload artificats failed, good to merge.