MySQL Bugs: #31421: funcs_1: ndb__datadict fails, discrepancy between scripts and expected results

Bug #31421	funcs_1: ndb__datadict fails, discrepancy between scripts and expected results
Submitted:	5 Oct 2007 14:44	Modified:	28 Mar 2008 19:28
Reporter:	Matthias Leich	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Tests: Server	Severity:	S3 (Non-critical)
Version:	5.1	OS:	Any
Assigned to:	Matthias Leich	CPU Architecture:	Any

Description:
Source tree mysql-5.1-build 
Last ChangeSet@1.2572, 2007-10-04

There is a discrepancy between the file with expected
results and the test scripts itself. They contain
different sequences of SQL statements.
There is most probably no Server Bug involved.

This bug is not already covered by
  Bug#31411 funcs_1: ndb_<every test> fail because of
            outdated expected results
because Bug#31411 refers to a changed server message only.

How to repeat:
1. Build a MySQL release.
2. cd mysql-test
3. ./mysql-test-run.pl --mem --suite=funcs_1 ndb__datadict

The bug fix will be done in
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.
3. New result files were generated.

Horst and Joerg reviewed WL#4203.
Therefore I mark the reviewer checkbox.

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.