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
Triage: D3 (Medium)

[5 Oct 2007 14:44] Matthias Leich
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
[19 Feb 2008 17:15] Matthias Leich
The bug fix will be done in
WL#4203 Reorganize and fix the data dictionary tests of 
        testsuite funcs_1
[25 Feb 2008 21:08] Matthias Leich
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
[11 Mar 2008 11:22] 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.
3. New result files were generated.
[11 Mar 2008 11:39] Matthias Leich
Horst and Joerg reviewed WL#4203.
Therefore I mark the reviewer checkbox.
[27 Mar 2008 22:04] Bugs System
Pushed into 5.1.24-rc
[27 Mar 2008 22:11] Bugs System
Pushed into 5.0.60
[28 Mar 2008 11:10] Bugs System
Pushed into 6.0.5-alpha
[28 Mar 2008 19:28] Paul Dubois
Fix involves test case changes. No changelog entry needed.