MySQL Bugs: #32603: "datadict" tests (all engines) fail in "community" tree: "PROFILING" table

Bug #32603	"datadict" tests (all engines) fail in "community" tree: "PROFILING" table
Submitted:	21 Nov 2007 21:41	Modified:	28 Mar 2008 19:18
Reporter:	Joerg Bruehe	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Tests: Server	Severity:	S3 (Non-critical)
Version:	5.0.51	OS:	Any
Assigned to:	Matthias Leich	CPU Architecture:	Any

Description:
Found in a build of the "community" tree:

innodb__datadict               [ fail ]

*** /PATH/mysql-test/suite/funcs_1/r/innodb__datadict.result
--- /PATH/mysql-test/var/log/innodb__datadict.reject
***************
*** 437,442
--- 437,443
  COLUMNS
  COLUMN_PRIVILEGES
  KEY_COLUMN_USAGE
+ PROFILING
  ROUTINES
  SCHEMATA
  SCHEMA_PRIVILEGES
***************
*** 585,590
--- 586,612
  TABLE_COMMENT
  TABLE_CATALOG NULL
  TABLE_SCHEMA  information_schema
+ TABLE_NAME    PROFILING
+ TABLE_TYPE    SYSTEM VIEW
+ ENGINE        MEMORY
+ VERSION       0
+ 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
+ TABLE_CATALOG NULL
+ TABLE_SCHEMA  information_schema
  TABLE_NAME    ROUTINES
  TABLE_TYPE    SYSTEM VIEW
  ENGINE        MyISAM
***************
...

and more consequential differences.

This happens in all "datadict" tests:
innodb__datadict
memory__datadict
myisam__datadict
ndb__datadict

How to repeat:
Run the "funcs_1" suite on the "community" tree.

This bug will be fixed within
WL#4203 Reorganize and fix the data dictionary tests of
        testsuite funcs_1

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/42956

ChangeSet@1.2584, 2008-02-25 21:52:13+01:00, mleich@five.local.lan +197 -0
  WL#4203 Reorganize and fix the data dictionary tests of
          testsuite funcs_1
  1. Fix the following bugs
     Bug#30440 "datadict" tests (all engines) fail:
               Character sets depend on configuration
        Solution: Test variants charset_collation_* adjusted to
                  different builds
     Bug#32603 "datadict" tests (all engines) fail in "community" tree:
               "PROFILING" table
        Solution: Excluding "PROFILING" table from queries
     Bug#33654 "slow log" is missing a line
        Solution: Unify the content of the fields TABLES.TABLE_ROWS and
                  STATISTICS.CARDINALITY within result sets
     Bug#34532 Some funcs_1 tests do not clean up at end of testing
        Solution: DROP objects/reset global server variables modified
                  during testing + let tests missing implementation end
                  before loading of tables
     Bug#31421 funcs_1: ndb__datadict fails, discrepancy between scripts
               and expected results
        Solution: Cut <engine>__datadict tests into smaller tests 
                  + generate new results.
     Bug#33599 INFORMATION_SCHEMA.STATISTICS got a new column INDEX_COMMENT:
               tests fail (2)
        Generation of new results during post merge fix
     Bug#33600 CHARACTER_OCTET_LENGTH is now CHARACTER_MAXIMUM_LENGTH * 4
        Generation of new results during post merge fix
     Bug#33631 Platform-specific replace of CHARACTER_MAXIMUM_LENGTH 
               broken by 4-byte encoding
        Generation of new results during post merge fix
        + removal of platform-specific replace routine (no more needed)
  2. Restructure the tests
     - Test not more than one INFORMATION_SCHEMA view per testscript
     - Separate tests of I_S view layout+functionality from content
       related to the all time existing databases 
       "information_schema", "mysql" and "test"
     - Avoid storage engine related variants of tests which are not 
       sensible to storage engines at all.
  3. Reimplement or add some subtests + cleanup
  There is a significant probability that even the reviewed changeset 
  - does not fix all bugs from above   or
  - contains new bugs which show up on some platforms <> Linux or on
    one of the various build types

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 "is_tables_is" and
   "is_columns_is".
3. The "optional" information_schema table "profiling"
   is excluded from result sets by using an appropriate
   WHERE qualification.

Horst and Joerg reviewed WL#4203 and therefore I
mark the reviewer check button.

Pushed into 5.1.24-rc

Pushed into 5.0.60

Pushed into 6.0.5-alpha

Fix involves test case changes. No changelog entry needed.