[Bug]: 3.0-dev lacks privilege and metadata compatibility fixes

[LeftHandCold]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Branch Name

3.0-dev

Commit ID

d1e78d8

Other Environment Information

- Hardware parameters: N/A (branch-compare audit)
- OS type: Darwin
- Others:
  - Compared `base/main` vs `base/3.0-dev`
  - Audit window: 2025-10-01 .. 2026-04-24

Actual Behavior

3.0-dev still misses two clear main-only compatibility fixes in privilege/metadata behavior: GRANT/REVOKE support on views with the intended security semantics, and the information_schema.statistics.INDEX_TYPE fix that should return idx.algo instead of NULL.

Expected Behavior

3.0-dev should expose the same privilege and metadata semantics as main, especially for MySQL-compatible metadata inspection and grant behavior.

Steps to Reproduce

1. Compare `base/main` and `base/3.0-dev` for PRs `#23469` and `#23930`.
2. Verify the missing surface on `3.0-dev`:
   - `git cat-file -e base/3.0-dev:test/distributed/cases/zz_accesscontrol/grant_view.sql` -> missing
   - `git grep -n 'idx\.algo' base/3.0-dev -- pkg/util/sysview/predefined.go` -> no match
3. Try representative SQL on `3.0-dev`, for example:
   - grant/revoke flows on views with nested security semantics
   - `select index_type from information_schema.statistics where table_schema = ... and table_name = ...;`

Additional information

Main-only reference commits:

• 7d0ac00d83 feat: Support GRANT/REVOKE on views with security semantics and tests (#23469)
• 412a05981f fix(information_schema): statistics INDEX_TYPE should use idx.algo instead of NULL (#23930)

SHOW TABLE STATUS Auto_increment is intentionally excluded from this issue because 3.0-dev already has overlapping coverage there.

[heni02]

已验证，closed