INNODB_SYS_TABLES shows wrong number of columns
Bug #622406 reported by
Baron Schwartz
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.1 |
Won't Fix
|
Low
|
Unassigned | |||
5.5 |
Triaged
|
Low
|
Unassigned | |||
5.6 |
Invalid
|
Undecided
|
Unassigned | |||
5.7 |
Invalid
|
Undecided
|
Unassigned |
Bug Description
At a customer's site we selected from INNODB_SYS_TABLES and it showed that the tables had <MAX_32_
Changed in percona-server: | |
assignee: | Fred Linhoss (fred-linhoss) → nobody |
status: | Confirmed → Triaged |
tags: | added: xtradb |
To post a comment you must log in.
INNODB_SYS_TABLES is raw dump of the intrenal table "SYS_TABLES".
If it is as it is in the table, it is not bug.
I think SYS_TABLES doesn't have information of "number of columns" at all.
("N_COLS" seems to be used only for row format flag)
Because keeping it is bad for performance, it is transactional database.
What is the "number of columns" at the time?
Should it be updated for each INSERT/DELETE and conflict all INSERT and DELETE for the table?