[Bug]: [storage compatibility] show variables result is not correct from commit: bd7286d to 2257011

[aressu1985]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Environment

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

Actual Behavior

job link:
https://github.com/matrixorigin/mo-nightly-regression/actions/runs/5683391519/job/15403968348

2023-07-27 17:21:34 ERROR Executor:159 - [/runner/_work/mo-nightly-regression/mo-nightly-regression/matrixone/test/distributed/cases/operator/like_operator.sql][row:222][show variables where value ilike "%system%" and variable_name = "time_zone";] was executed failed, con[id=0, user=dump, ***
2023-07-27 17:21:34 ERROR Executor:161 - [EXPECT RESULT]:
Variable_name Value
time_zone SYSTEM
2023-07-27 17:21:34 ERROR Executor:162 - [ACTUAL RESULT]:
Variable_name Value
2023-07-27 17:21:34 INFO Executor:241 - The script file[/runner/_work/mo-nightly-regression/mo-nightly-regression/matrixone/test/distributed/cases/operator/like_operator.sql] has been executed, and cost: 1.096s, total:142, success:139, failed:1, ignored:2, abnoraml:0

the log from loki can be get :

http://a58ec25c4c81b42b4bc11f9a4eb1f54e-1422586515.us-west-2.elb.amazonaws.com/explore?orgId=1&left=%7B%22datasource%22:%22b08c0b34-9dfc-47c9-ac7b-b1dd15d38191%22,%22queries%22:%5B%7B%22refId%22:%22A%22,%22expr%22:%22%7Bnamespace%3D%5C%22mo-cpt%5C%22%7D%20%7C%3D%20%60%60%22,%22queryType%22:%22range%22,%22datasource%22:%7B%22type%22:%22loki%22,%22uid%22:%22b08c0b34-9dfc-47c9-ac7b-b1dd15d38191%22%7D,%22editorMode%22:%22builder%22%7D%5D,%22range%22:%7B%22from%22:%22now-12h%22,%22to%22:%22now%22%7D%7D

Expected Behavior

No response

Steps to Reproduce

No response

Additional information

No response

[daviszhen]

@YANGGMM 看下

[YANGGMM]

[YANGGMM]

[aressu1985]

maybe it is related to #10921

[aptend]

related #10734

[YANGGMM]

wait for #10734

[aressu1985]

fixed