Blueprint for overall tasks that need to be completed for IS work

Registered by Brian Aker

1) Remove final tables left over from transition:
| OLD_COLUMNS |
| OLD_GLOBAL_STATUS |
| OLD_GLOBAL_VARIABLES |
| OLD_KEY_COLUMN_USAGE |
| OLD_REFERENTIAL_CONSTRAINTS |
| OLD_SESSION_VARIABLES |
| OLD_STATISTICS |
| OLD_TABLE_CONSTRAINTS

2) Rewrite SHOW OPEN TABLES (or remove?...) (if kept it should use table_share)

3) Rewrite SHOW COLUMNS

4) Rewrite SHOW INDEXES

5) Convert STATUS variables to use new system.

6) Pull COMM out to their own system.

7) Remove SHOW_ARRAY support.

8) I hate eight, down with it!

9) Convert Innodb Tables
| INNODB_CMP |
| INNODB_CMPMEM |
| INNODB_CMPMEM_RESET |
| INNODB_CMP_RESET |
| INNODB_LOCKS |
| INNODB_LOCK_WAITS |
| INNODB_TRX

10) Remove dead I_S code

11) Remove dead show code

12) Add index support to TableFunctions

13) Fix Foreign Key support in TableProto (left over from Stewart's work)

14) Add information from FK then to data_dictionary

15) Define what tables should be in I_S, with which definitions.

16) Refactor how SHOW rewrite to functions (aka get the code out of
sql_yacc.yy)

*) Define SE interface for directories, allow TableFunctions to generate
some. Move current code over to engine interface (remove current one way
calls).

*) Rewrite SHOW ERRORS/WARNINGS to use tablefunctions under the hood.

*) Documentation ;) -- Jay will assist with this.

Blueprint information

Status:
Complete
Approver:
None
Priority:
High
Drafter:
Brian Aker
Direction:
Approved
Assignee:
Brian Aker
Definition:
Approved
Series goal:
Accepted for dexter
Implementation:
Implemented
Milestone target:
milestone icon 2010-05-24
Started by
Lee Bieber
Completed by
Lee Bieber

Related branches

Sprints

Whiteboard

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.