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 留言) (1 反應) (1 負責人)Go (40,090 star) (6,186 fork)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

貢獻者指南

技術棧: gosqlmysql
領域: database
議題類型: bug
難度: 4
預計時間: over 1 week
活動狀態: stale
清晰度: mostly clear
前置要求: SQL viewsGo programmingMySQL compatibilityTiDB internals
新手友善度: 20
研究方向: 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.