Skip to content

resolve equivalent join hints like TIDB_INLJ and INL_JOIN when building ID of bindings #15910

Open
@eurekaka

Description

Development Task

For these bind_sqls:

  • select /*+ tidb_inlj(t1, t2) */ * from t1, t2 where t1.a = t2.a
  • select /*+ inl_join(t1, t2) */ * from t1, t2 where t1.a = t2.a

They are same actually but they have different ID now. This applies to other join hints that have aliases. Resolve them when building ID of bindings, to avoid potential duplicate bindings in mysql.bind_info.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions