matrixorigin / matrixone

Hyperconverged cloud-edge native database
https://docs.matrixorigin.cn/en
Apache License 2.0
1.79k stars 276 forks source link

[Bug]: the result of 'show node list' in mo and in bvt is different. #17598

Open Ariznawlll opened 3 months ago

Ariznawlll commented 3 months ago

Is there an existing issue for the same bug?

Branch Name

main

Commit ID

88e486e11b4310336ec6d40ba86e26a400974819

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

mo执行结果:

image

mo-tester里执行结果:

企业微信截图_930f1762-cc3d-4a9c-805a-703d3dfa61c0

Expected Behavior

No response

Steps to Reproduce

mo:
select node list;

mo-tester:
./run.sh -n -g -p /Users/ariznawl/code/matrixone/test/distributed/cases/query_result/query_result.sql -m genrs

Additional information

No response

daviszhen commented 3 months ago

show node list内部改写为“select 1 where 0”

CJKkkk-315 commented 3 months ago

image image image jdbc mysqlclient正常返回,抓包下也没有看到1的返回结果 可能是mo-tester的bug。

CJKkkk-315 commented 3 months ago

image jdbc执行整个sql文件结果也正确。应该要在mo-tester工具内部找原因