Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

planner: support universal SQL bindings #48875

Closed
qw4990 opened this issue Nov 24, 2023 · 0 comments · Fixed by #50578, #50666 or #50822
Closed

planner: support universal SQL bindings #48875

qw4990 opened this issue Nov 24, 2023 · 0 comments · Fixed by #50578, #50666 or #50822
Assignees
Labels
epic/sql-plan-management sig/planner SIG: Planner type/feature-request This is a feature requests on the product

Comments

@qw4990
Copy link
Contributor

qw4990 commented Nov 24, 2023

Feature Request

Is your feature request related to a problem? Please describe:

In the context of database consolidation, it is common to encounter situations where identical applications repeat on multiple database schemas. When addressing performance issues with SQL binding, it becomes imperative to replicate the SQL bindings across each of these schemas. In some practical scenarios, it is not unusual to have approximately 500 databases within a single cluster. Implementing SQL binding across all these schemas can pose significant challenges for customers.

Describe the feature you'd like:

Support the syntax like:

CREATE GLOBAL BINDING USING SELECT * FROM *.t1, *.t2

The user can use wildcards as DB names when creating bindings.

@qw4990 qw4990 added the type/feature-request This is a feature requests on the product label Nov 24, 2023
@qw4990 qw4990 self-assigned this Nov 24, 2023
ti-chi-bot bot pushed a commit that referenced this issue Dec 6, 2023
AilinKid pushed a commit to AilinKid/tidb that referenced this issue Jan 17, 2024
ti-chi-bot bot pushed a commit that referenced this issue Jan 18, 2024
@hawkingrei hawkingrei mentioned this issue Jan 19, 2024
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue Jan 19, 2024
@hawkingrei hawkingrei reopened this Jan 24, 2024
@hawkingrei hawkingrei mentioned this issue Jan 25, 2024
13 tasks
ti-chi-bot bot pushed a commit that referenced this issue Jan 25, 2024
ti-chi-bot bot pushed a commit that referenced this issue Jan 29, 2024
ti-chi-bot bot pushed a commit that referenced this issue Jan 30, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
epic/sql-plan-management sig/planner SIG: Planner type/feature-request This is a feature requests on the product
Projects
None yet
2 participants