Bug #34706 FALCON_TABLES shows wrong information on temporary tables
Submitted: 20 Feb 2008 21:17 Modified: 18 Oct 2008 15:57
Reporter: Hakan Küçükyılmaz Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Falcon storage engine Severity:S3 (Non-critical)
Version:6.0.4 OS:Any
Assigned to: Sergey Vojtovich CPU Architecture:Any

[20 Feb 2008 21:17] Hakan Küçükyılmaz
Description:
There is an issue with reporting temporary tables with FALCON_TABLES.

How to repeat:
mysql> create temporary table test.t1 (f1 integer) engine=falcon;
Query OK, 0 rows affected (0.02 sec)
mysql> select * from information_schema.FALCON_TABLES;
+-------------+------------+-----------+------------------+---------------+
| SCHEMA_NAME | TABLE_NAME | PARTITION | TABLESPACE       | INTERNAL_NAME |
+-------------+------------+-----------+------------------+---------------+
| TMP         |            |           | FALCON_TEMPORARY | #SQL7D29_1_2  |
+-------------+------------+-----------+------------------+---------------+
1 row in set (0.00 sec)

In my humble opinion, SCHEMA_NAME should be "test", TABLE_NAME must be "t1" and, in case
[20 Feb 2008 22:12] Sveta Smirnova
Thank you for the report.

Verified as described.
[27 Feb 2008 20:25] Kevin Lewis
possibly related to 34705
[17 Jul 2008 16:35] Christopher Powers
This works on Windows (but still not on Linux):

+-------------+------------+-----------+------------------+--------------+
| SCHEMA_NAME | TABLE_NAME | PARTITION | TABLESPACE       | INTERNAL_NAME|
+-------------+------------+-----------+------------------+--------------+
| TMP         |            |           | FALCON_TEMPORARY | #SQLF5C_2_0  |
| TEST        | T1         |           | FALCON_USER      | T1           |
+-------------+------------+-----------+------------------+--------------+
[18 Jul 2008 0:14] Kevin Lewis
Assigning to Sergey Votjovich.  We have decided to delete INFORMATION_SCHEME.FALCON_TABLES which should eliminate this problem.

>>Vlad wrote;
>>
>> How would you fix these bugs? For example, to have proper table name as
>> defined by user (in all cases, that is even with non-latin characters and
>> after RENAME) we would need  filename_to_tablename() , that is banned from
>> server API.  And possibly we'd also need to fix Falcon uppercasing while
>> we are at it ;) Too much hacking, is not it?

>Ann wrote;
>Too much hacking and too little value, I agree.  Also too much confusion
>about what table to trust, giving that there is a very large overlap
>between TABLES and FALCON_TABLES.  I can think of no case where the
>internal Falcon name is of interest to anything but Falcon.  So, fine,
>lets get rid of FALCON_TABLES and close all three bugs.
[29 Jul 2008 11:48] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/50640

2761 Sergey Vojtovich	2008-07-29
      BUG#29211 - Falcon: information_schema has a falcon_tables view
      BUG#34705 - FALCON_TABLES shows wrong TABLE_NAME
      BUG#34706 - FALCON_TABLES shows wrong information on temporary tables
      
      There were several problems relating to INFORMATION_SCHEMA.FALCON_TABLES,
      e.g.:
      - there is no worklog entry for I_S.FALCON_TABLES, so it is not
        there by design
      - MySQL already has I_S.FILES and I_S.TABLES, which provide
        duplicating information
      - it didn't show properly table names with non-ascii characters
      - it didn't show properly table and schema names for temporary
        tables
      
      This patch removes INFORMATION_SCHEMA.FALCON_TABLES and all
      relevant code.
      
      No test case needed for this fix - it is already covered by existing
      tests.
[18 Aug 2008 11:17] Sergey Vojtovich
Was pushed to 6.0.7.
[14 Sep 2008 3:53] Bugs System
Pushed into 6.0.7-alpha  (revid:svoj@mysql.com-20080729104539-5grheqzat2gs0avq) (version source revid:v.narayanan@sun.com-20080820070709-nx09bk6qx81osd5s) (pib:3)
[18 Oct 2008 15:57] Jon Stephens
Documented in the 6.0.7 changelog as follows:

        *IMPORTANT CHANGE* The INFORMATION_SCHEMA.FALCON_TABLES table has been 
        removed.

Updated se-falcon-stats section of 6.0 Manual accordingly.