UCP: unexpected error happened when select dbName.viewName.col from another database

[XuHuaiyu]

Description

1. What did you do?

use test;
create table t(a int);
use mysql;
create view v as select * from test.t;
use test;
select mysql.v.a from mysql.v;

2. What did you expect to see?

no error happens

3. What did you see instead?

ERROR 1054 (42S22): Unknown column 'mysql.v.a' in 'field list'

Score

• 50

Mentor(s)

Contact the mentors: #tidb-challenge-program channel in TiDB Community Slack Workspace

Recommended Skills

• Golang Programming

Learning Materials

• Chinese: TiDB 精选技术讲解文章
• English: Awesome-Database-Learning

[XuHuaiyu]

We can fix this by changing this line to DBName: dbName

[hsqlu]

/pick-up-challenge

[sre-bot]

@hsqlu pick up issue success

[hsqlu]

/give-up-challenge

[sre-bot]

@hsqlu give up issue success