-
Notifications
You must be signed in to change notification settings - Fork 5.9k
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
Joining views of information_schema.columns
panic
#32459
Labels
affects-5.2
This bug affects 5.2.x versions.
affects-5.3
This bug affects 5.3.x versions.
affects-5.4
This bug affects the 5.4.x(LTS) versions.
affects-6.0
severity/major
sig/sql-infra
SIG: SQL Infra
type/bug
The issue is confirmed as a bug.
Comments
12 tasks
information_schema.columns
panic
12 tasks
ti-chi-bot
pushed a commit
that referenced
this issue
Apr 26, 2022
This was referenced Apr 26, 2022
12 tasks
12 tasks
zimulala
pushed a commit
to zimulala/tidb
that referenced
this issue
Aug 4, 2022
ti-chi-bot
pushed a commit
that referenced
this issue
Feb 27, 2023
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Labels
affects-5.2
This bug affects 5.2.x versions.
affects-5.3
This bug affects 5.3.x versions.
affects-5.4
This bug affects the 5.4.x(LTS) versions.
affects-6.0
severity/major
sig/sql-infra
SIG: SQL Infra
type/bug
The issue is confirmed as a bug.
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
第一步:创建视图
create view vw_dict as
select a.table_schema,
a.table_name as tabname,
a.column_name,
a.column_type,
a.column_default,
a.is_nullable,
b.column_comment
from information_schema.columns a
left join information_schema.columns b
on (a.table_name = b.table_name and
a.column_name = b.column_name and
b.table_schema = 'accountdb')
where (a.table_schema = 'query_account')
order by a.table_name, a.ordinal_position
第二步:查询视图
select * from vw_dict
where tabname = 't_loan'
2. What did you expect to see? (Required)
和没有视图一样,正常出结果
3. What did you see instead (Required)
前端查询的navicat显示:
[Err] 2013 - Lost connection to MySQL server during query
后台的部分tidb节点状态是:Down
4. What is your TiDB version? (Required)
Release Version: v5.3.0
Edition: Community
Git Commit Hash: 4a1b2e9
Git Branch: heads/refs/tags/v5.3.0
UTC Build Time: 2021-11-24 13:32:39
GoVersion: go1.16.4
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false
The text was updated successfully, but these errors were encountered: