Comments (1)
The problem is that privilege check on system table mysql
is failed:
tidb/pkg/planner/core/logical_plan_builder.go
Line 5464 in 2d552c0
When I check the value of tableInfo.View.Definer
, it comes to be ''@''
, which is not maintained by privilege manager. It will absolutely fail the check.
Since tidb_mdl_view
is created during cluster initialization, no user is suitable to be View.Definer
. So there is nothing wrong with ''@''
.
#48728 changed the definition of tidb_mdl_view
. Previously, we joined three system tables from information_schema
:
FROM information_schema.ddl_jobs,
information_schema.cluster_tidb_trx,
information_schema.cluster_processlist
After #48728, they become
FROM mysql.tidb_ddl_job
mysql.tidb_mdl_info,
information_schema.cluster_tidb_trx
RequestVerificationWithUser()
skips all checks related to information_schema
:
tidb/pkg/privilege/privileges/privileges.go
Lines 202 to 206 in 201f223
When it is changed to mysql
, the problem occurs.
from tidb.
Related Issues (20)
- README has some grammar problems
- `ddl.BatchCreateTableWithInfo` is different from `ddl.CreateTableWithInfo`
- unstable location assert in tests
- remove `mock.Context` usage in `ddl/internal/session/session_pool.go`
- Keyspace level GC: Support BR,Lightning,Dumpling update keyspace level Service safe point
- add additional information into slow log / stmtsummary
- add metrics labels from config
- should not return zero when lightning exits while processing the task HOT 4
- Will lose rows after execute `remove partitioning` on a partition table with `exchange partition` HOT 2
- outer join reorder will produce unexpected join sequence. HOT 3
- remove `mock.Context` usage in production code
- The default value of `GetDefaultCollationForUTF8MB4` is not righ `StaticExprContext`
- forceRebase behavior of AUTO_ID_CACHE=1 cause tidb fail to exit for a long time HOT 1
- Lightning support to configure `max-import-data-size` limit HOT 4
- GC: Optimizing the min start ts etcd path format
- incorrect query result using sum aggregation
- br backup txn or br restore txn,error:GetMinResolvedTSByStoresIDs 404 Not Found
- Skip system table when collecting prediction columns
- Compared with v7.5.1, v8.1.0 has a 7.3% performance regression in oltp_point_select on Kylin Linux HOT 3
- Unexpected full reload using info schema cache v2 HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from tidb.