MySQL Bugs: #41718: FALCON_TABLESPACES isn't included.

Bug #41718	FALCON_TABLESPACES isn't included.
Submitted:	23 Dec 2008 18:24	Modified:	19 Jan 2009 15:12
Reporter:	Santo Leto	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S2 (Serious)
Version:	6.0.8-alpha	OS:	Any
Assigned to:	MC Brown	CPU Architecture:	Any
Tags:	falcon, falcon metadata, FALCON_TABLESPACES

Description:
Hi!

The FALCON_TABLES table has been removed in v.6.0.7. 
Did you remove FALCON_TABLESPACES in v.6.0.8? 

This is not documented in the release notes, if I am not mistaken.

Thanks.

How to repeat:
mysql> SELECT VERSION();
+---------------------------+
| VERSION()                 |
+---------------------------+
| 6.0.8-alpha-community-log |
+---------------------------+
1 row in set (0.00 sec)

mysql> USE information_schema;
Database changed
mysql> SHOW TABLES LIKE '%FALCON%';
+-----------------------------------------+
| Tables_in_information_schema (%FALCON%) |
+-----------------------------------------+
| FALCON_RECORD_CACHE_SUMMARY             |
| FALCON_SYSTEM_MEMORY_DETAIL             |
| FALCON_TABLESPACE_IO                    |
| FALCON_SYSTEM_MEMORY_SUMMARY            |
| FALCON_VERSION                          |
| FALCON_TRANSACTION_SUMMARY              |
| FALCON_SERIAL_LOG_INFO                  |
| FALCON_SYNCOBJECTS                      |
| FALCON_TRANSACTIONS                     |
| FALCON_RECORD_CACHE_DETAIL              |
+-----------------------------------------+
10 rows in set (0.00 sec)

mysql>

Indeed, if one will compare http://dev.mysql.com/doc/refman/6.0/en/se-falcon-stats.html to the reality:

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -uroot -proot -P3311
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 6.0.8-alpha-community MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use information_schema;
Database changed
mysql> show tables like '%FALCON%';
+-----------------------------------------+
| Tables_in_information_schema (%FALCON%) |
+-----------------------------------------+
| FALCON_RECORD_CACHE_SUMMARY             |
| FALCON_SYSTEM_MEMORY_DETAIL             |
| FALCON_TABLESPACE_IO                    |
| FALCON_SYSTEM_MEMORY_SUMMARY            |
| FALCON_VERSION                          |
| FALCON_TRANSACTION_SUMMARY              |
| FALCON_SERIAL_LOG_INFO                  |
| FALCON_SYNCOBJECTS                      |
| FALCON_TRANSACTIONS                     |
| FALCON_RECORD_CACHE_DETAIL              |
+-----------------------------------------+
10 rows in set (0.03 sec)

she may get some questions... For example, I do not see FALCON_TABLESPACE_FILES table also. So, we definitely have a problem here.

In an effort to avoid having each engine create new information schema
tables that overlap the tables from other engines, a new IS table called
TABLESPACES was created to hold both Falcon and Cluster tablespace
information and the FALCON_TABLESPACES table was dropped.

We should keep our documentation in sync with reality, hence documentation bug.

The documentation has been updated, both removing the outdated information, and pointing the user to the corresponding global I_S tables.