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

Joining views of information_schema.columns panic #32459

Closed
jnf009 opened this issue Feb 18, 2022 · 0 comments · Fixed by #33946
Closed

Joining views of information_schema.columns panic #32459

jnf009 opened this issue Feb 18, 2022 · 0 comments · Fixed by #33946
Assignees
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

@jnf009
Copy link

jnf009 commented Feb 18, 2022

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

@jnf009 jnf009 added the type/bug The issue is confirmed as a bug. label Feb 18, 2022
@ChenPeng2013 ChenPeng2013 added the sig/sql-infra SIG: SQL Infra label Feb 18, 2022
@ti-chi-bot ti-chi-bot added may-affects-4.0 This bug maybe affects 4.0.x versions. may-affects-5.0 This bug maybe affects 5.0.x versions. may-affects-5.1 This bug maybe affects 5.1.x versions. may-affects-5.2 This bug maybe affects 5.2.x versions. may-affects-5.3 This bug maybe affects 5.3.x versions. may-affects-5.4 This bug maybe affects 5.4.x versions. labels Feb 24, 2022
@tangenta tangenta added 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. and removed may-affects-4.0 This bug maybe affects 4.0.x versions. may-affects-5.1 This bug maybe affects 5.1.x versions. may-affects-5.2 This bug maybe affects 5.2.x versions. may-affects-5.3 This bug maybe affects 5.3.x versions. may-affects-5.4 This bug maybe affects 5.4.x versions. may-affects-5.0 This bug maybe affects 5.0.x versions. labels Feb 24, 2022
@tangenta tangenta changed the title INFORMATION_SCHEMA.COLUMNS自关联视图导致tidb节点宕机 Joining views of information_schema.columns panic Feb 24, 2022
@tangenta tangenta self-assigned this Feb 24, 2022
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.
Projects
None yet
5 participants