Bug #33632 "*__datadict" assume fixed list of table handlers, adding Falcon makes them fail
Submitted: 2 Jan 2008 19:38 Modified: 23 Jun 2008 14:30
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Engine Severity:S3 (Non-critical)
Version:6.0.4-alpha OS:Any
Assigned to: Matthias Leich CPU Architecture:Any
Triage: D3 (Medium) / R3 (Medium) / E1 (None/Negligible)

[2 Jan 2008 19:38] Joerg Bruehe
Description:
The following difference shows up in the build of 6.0.4-alpha,
on the platforms where Falcon gets configured, in all <engine>__datadict tests
(innodb__datadict, memory__datadict, myisam__datadict).

(Currently, this is Linux on x86 and x86_64 only,
but I still classify "any" because it is no OS or compiler issue
which triggers the test failure, rather the server configuration.)

This is just an extract of the differences (in full, 293 lines):

--- /PATH/mysql-test/suite/funcs_1/r/innodb__datadict.result
+++ /PATH/mysql-test/suite/funcs_1/r/innodb__datadict.reject
@@ -469,6 +469,7 @@
 TRIGGERS
 USER_PRIVILEGES
 VIEWS
+FALCON_VERSION
 select * from schemata ORDER BY 2 DESC, 1 ASC;
 CATALOG_NAME   SCHEMA_NAME     DEFAULT_CHARACTER_SET_NAME      DEFAULT_COLLATION_NAME  SQL_PATH
 NULL   test4   latin1  latin1_swedish_ci       NULL
@@ -1067,6 +1068,27 @@
 CHECKSUM       NULL
 CREATE_OPTIONS #CO#
 TABLE_COMMENT
+TABLE_CATALOG  NULL
+TABLE_SCHEMA   information_schema
+TABLE_NAME     FALCON_VERSION
+TABLE_TYPE     SYSTEM VIEW
+ENGINE MEMORY
+VERSION        10
+ROW_FORMAT     Fixed
+TABLE_ROWS     NULL
+AVG_ROW_LENGTH #ARL#
+DATA_LENGTH    #DL#
+MAX_DATA_LENGTH        #MDL#
+INDEX_LENGTH   #IL#
+DATA_FREE      #DF#
+AUTO_INCREMENT NULL
+CREATE_TIME    YYYY-MM-DD hh:mm:ss
+UPDATE_TIME    YYYY-MM-DD hh:mm:ss
+CHECK_TIME     YYYY-MM-DD hh:mm:ss
+TABLE_COLLATION        utf8_general_ci
+CHECKSUM       NULL
+CREATE_OPTIONS #CO#
+TABLE_COMMENT
 SELECT * FROM tables
 WHERE NOT( table_schema = 'information_schema')
 AND NOT (table_schema = 'mysql' AND table_name LIKE 'help_%');
@@ -1909,6 +1931,7 @@
 NULL   db_datadict     latin1  SYSTEM VIEW     MEMORY
 NULL   db_datadict     latin1  SYSTEM VIEW     MEMORY
 NULL   db_datadict     latin1  SYSTEM VIEW     MEMORY
+NULL   db_datadict     latin1  SYSTEM VIEW     MEMORY
 NULL   db_datadict     latin1  SYSTEM VIEW     MyISAM
 NULL   db_datadict     latin1  SYSTEM VIEW     MyISAM
 NULL   db_datadict     latin1  SYSTEM VIEW     MyISAM
@@ -1978,6 +2001,7 @@
 NULL   information_schema      utf8    SYSTEM VIEW     MEMORY
 NULL   information_schema      utf8    SYSTEM VIEW     MEMORY
 NULL   information_schema      utf8    SYSTEM VIEW     MEMORY
+NULL   information_schema      utf8    SYSTEM VIEW     MEMORY
 NULL   information_schema      utf8    SYSTEM VIEW     MyISAM
 NULL   information_schema      utf8    SYSTEM VIEW     MyISAM
 NULL   information_schema      utf8    SYSTEM VIEW     MyISAM
@@ -2047,6 +2071,7 @@
 NULL   mysql   latin1  SYSTEM VIEW     MEMORY
 NULL   mysql   latin1  SYSTEM VIEW     MEMORY
 NULL   mysql   latin1  SYSTEM VIEW     MEMORY
+NULL   mysql   latin1  SYSTEM VIEW     MEMORY
 NULL   mysql   latin1  SYSTEM VIEW     MyISAM
 NULL   mysql   latin1  SYSTEM VIEW     MyISAM
 NULL   mysql   latin1  SYSTEM VIEW     MyISAM
.....
@@ -3511,6 +3544,7 @@
 Table or view 'TRIGGERS' is associated with the database 'information_schema'.
 Table or view 'USER_PRIVILEGES' is associated with the database 'information_schema'.
 Table or view 'VIEWS' is associated with the database 'information_schema'.
+Table or view 'FALCON_VERSION' is associated with the database 'information_schema'.
 Table or view 'v1' is associated with the database 'db_datadict'.
 Table or view 'vu' is associated with the database 'db_datadict'.
 Table or view 'vu1' is associated with the database 'db_datadict'.
@@ -3598,6 +3632,7 @@
 ENGINES        6
 event  22
 EVENTS 24
+FALCON_VERSION 2
 FILES  38
 func   4
 general_log    6
.....
@@ -14502,6 +14852,7 @@
 NULL   information_schema      TRIGGERS        SYSTEM VIEW     MyISAM  10      Dynamic NULL    #ARL#   #DL#    #MDL#   #IL
 NULL   information_schema      USER_PRIVILEGES SYSTEM VIEW     MEMORY  10      Fixed   NULL    #ARL#   #DL#    #MDL#   #IL
 NULL   information_schema      VIEWS   SYSTEM VIEW     MyISAM  10      Dynamic NULL    #ARL#   #DL#    #MDL#   #IL#    #DF
+NULL   information_schema      FALCON_VERSION  SYSTEM VIEW     MEMORY  10      Fixed   NULL    #ARL#   #DL#    #MDL#   #IL
 SELECT * FROM information_schema.tables
 WHERE NOT( table_schema = 'information_schema') AND NOT (table_schema = 'mysql' AND table_name LIKE 'help_%');
 TABLE_CATALOG  TABLE_SCHEMA    TABLE_NAME      TABLE_TYPE      ENGINE  VERSION ROW_FORMAT      TABLE_ROWS      AVG_ROW_LEN

How to repeat:
Run the extra tests.
[11 Mar 2008 15:51] Matthias Leich
WL#4203 Reorganize and fix the data dictionary tests of
        testsuite funcs_1
was pushed to mysql-<version>-build
Version is in (5.0,5.1,6.0).

1. The tests "<engine>__datadict" do no more exist.
2. The checks where the problem above occured were
   moved into the new tests and adjusted to optional
   existence of Falcon
   is_tables_is  + is_columns_is
      Retrieve content of I_S about objects of I_S
      with Falcon I_S views excluded from queries
   is_tables_is_falcon + is_columns_is_falcon
      Retrieve content of I_S about Falcon I_S
      views only
[23 Jun 2008 14:30] Matthias Leich
The code of
WL#4203 Reorganize and fix the data dictionary tests of
        testsuite funcs_1
is now within the main tree, which means the *_dadadict
scripts completely replaced. Therefore I close this bug now.

No need for documentation, bug within the tests.