[Bug]: Inconsistent table rows and size for the same account

[DanielZhangQD]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Branch Name

1.2-dev

Commit ID

v1.2.0-91b0ae027-2024-06-03

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

• Create a new account a
• Check the table rows and size in the mo_catalog database:

SELECT account_id,relname AS `name`, mo_table_rows(reldatabase, relname) AS `rows`, mo_table_size(reldatabase, relname) AS `size`, if (role_name IS NULL, '-', role_name) AS `owner`, mo_tables.created_time AS created FROM mo_catalog.mo_tables LEFT JOIN mo_catalog.mo_role ON mo_catalog.mo_tables.owner=role_id WHERE relkind IN ('r','e','cluster') AND reldatabase='mo_catalog' Order by name;

• Check the table rows and size in the mo_catalog database for the same account with dump user:

SELECT account_id,relname AS `name`, mo_table_rows(reldatabase, relname) AS `rows`, mo_table_size(reldatabase, relname) AS `size`, if (role_name IS NULL, '-', role_name) AS `owner`, mo_tables.created_time AS created FROM mo_catalog.mo_tables LEFT JOIN mo_catalog.mo_role ON mo_catalog.mo_tables.owner=role_id WHERE relkind IN ('r','e','cluster') AND reldatabase='mo_catalog' and (account_id = 600330002) Order by name;

• The results for the above two steps are different

Expected Behavior

The result in the user account and the sys account should be same

Steps to Reproduce

See detail in Actual Behavior

Additional information

No response

[gouhongshen]

同一个租户 mo_catalog 下的表，sys 租户和该租户本身用 mo_table_size, mo_table_rows 查出来的结果不同。

[aressu1985]

经和徐鹏沟通，这个加一个开关，如果测试通过，就2.0.1打开，如果不通过，就还保持原来的处理

[gouhongshen]

这个问题的原因是上层调用 MoTableRows, MoTableSize 的地方没有给出正确的 account id, 导致实际查询的是 dump 里面同名的 table。

现在的 account id 是从 context 里面取的，但里面是 dump 用户的。

@ouyuanning 看看分给谁看一下。