Bug #22690 access information_schema.files always returns zero

• Submitted: 26 Sep 2006 4:29
• Modified: 26 Sep 2006 6:32
• Reporter: li david
• Status: Not a Bug
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.1.11-beta
• OS: Linux (redhat as 4)
• CPU Architecture: Any

[26 Sep 2006 4:29] li david

Description:
mysql> select count(*) from information_schema.files;
+----------+
| count(*) |
+----------+
|        0 | 
+----------+
1 row in set (0.00 sec)
;

How to repeat:
mysql> create table test.testib(id int,name varchar(30)) data directory='/usr/local/mysql/data' engine=innodb;
Query OK, 0 rows affected (0.11 sec)

mysql> insert into test.testib values(1,'a');
Query OK, 1 row affected (0.00 sec)

mysql> insert into test.testib values(1,'a');
Query OK, 1 row affected (0.00 sec)

mysql> commit;
Query OK, 0 rows affected (0.00 sec)

mysql> select count(*) from information_schema.files;
+----------+
| count(*) |
+----------+
|        0 | 
+----------+
1 row in set (0.00 sec)

mysql>

[26 Sep 2006 6:32] Sveta Smirnova

Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Read at http://dev.mysql.com/doc/refman/5.1/en/files-table.html for which table type INFORMATION_SCHEMA.FILES table provides information.