Bugs / compatibility issues of view · pingcap/tidb#9798

2019-03-19T05:09:02.000Z

## Description - [ ] https://github.com/pingcap/tidb/issues/9796 Create view with INSERT only privilege behaves different with MySQL 8.0 - [x] https://github.com/pingcap/tidb/issues/9788 Column name should be expanded when creating the view. - [ ] https://github.com/pingcap/tidb/issues/9815 ALTER VIEW not supported - [x] https://github.com/pingcap/tidb/issues/9875 EXPLAIN Select * from view requires different privileges to MySQL - [x] https://github.com/pingcap/tidb/issues/9893 mysql.tables_priv does not support view related privileges -> [WIP] https://github.com/pingcap/tidb/pull/9894 - [ ] https://github.com/pingcap/tidb/issues/17785 Views do not support column elimination - [x] https://github.com/pingcap/tidb/issues/9816 can't drop view ## SIG slack channel [#sig-exec](https://tidbcommunity.slack.com/archives/CMRD79DRR) ## Score - 300 ## Mentor * @SunRunAway

(1 comment) (1 reaction) (1 assignee)Go (40,090 stars) (6,186 forks)batch import

challenge-programhelp wantedpriority/P3sig/executiontype/compatibilitytype/new-feature

Description

https://github.com/pingcap/tidb/issues/9796 Create view with INSERT only privilege behaves different with MySQL 8.0
https://github.com/pingcap/tidb/issues/9788 Column name should be expanded when creating the view.
https://github.com/pingcap/tidb/issues/9815 ALTER VIEW not supported
https://github.com/pingcap/tidb/issues/9875 EXPLAIN Select * from view requires different privileges to MySQL
https://github.com/pingcap/tidb/issues/9893 mysql.tables_priv does not support view related privileges -> [WIP] https://github.com/pingcap/tidb/pull/9894
https://github.com/pingcap/tidb/issues/17785 Views do not support column elimination
https://github.com/pingcap/tidb/issues/9816 can't drop view

SIG slack channel

#sig-exec

Score

Mentor

@SunRunAway

Contributor guide

Tech stack: gosqlmysql
Domain: database
Issue type: bug
Difficulty: 4
Estimated time: over 1 week
Activity status: stale
Clarity: mostly clear
Prerequisites: SQL viewsGo programmingMySQL compatibilityTiDB internals
Newbie friendliness: 20
Research direction: This tracking issue lists multiple view related bugs and compatibility issues. A newcomer should first examine the open sub issues such as #9796 and #9815. The TiDB source code for view handling is in the 'ddl' package (e.g., ddl/view.go). Refer to the mentor @SunRunAway in the #sig exec Slack channel for guidance.