Bug #42836 Funcs_1 storedproc and storedproc_08 tests failing.

• Submitted: 13 Feb 2009 15:17
• Modified: 13 Mar 2009 20:22
• Reporter: Patrick Crews
• Status: Closed
• Category: Tests: Server
• Severity: S3 (Non-critical)
• Version: 5.1
• OS: Any
• Assigned to: Matthias Leich
• CPU Architecture: Any
• Tags: funcs_1, mtr, StoredProc, storedproc_08, test failure

[13 Feb 2009 15:17] Patrick Crews

Description:
The tests funcs_1.storedproc and funcs_1.<engine>_storedproc_08 are failing.

This is due to a SELECT * FROM INFORMATION_SCHEMA.ROUTINES call in these tests that look at all routines created.

The tests are failing in the 5.1.32 clone due to changes in the character_set_client and collation_connection values used in some storedprocs created by mysql-test-run (such as add_suppression, etc):

Example output:
> SPECIFIC_NAME    check_testcase
> ROUTINE_CATALOG    NULL
> ROUTINE_SCHEMA    mtr
> ROUTINE_NAME    check_testcase
> ROUTINE_TYPE    PROCEDURE
> DTD_IDENTIFIER    NULL
> ROUTINE_BODY    SQL
> <snip>
> EXTERNAL_NAME    NULL
> EXTERNAL_LANGUAGE    NULL
> PARAMETER_STYLE    SQL
> IS_DETERMINISTIC    NO
> SQL_DATA_ACCESS    CONTAINS SQL
> SQL_PATH    NULL
> SECURITY_TYPE    DEFINER
> CREATED    <modified>
> LAST_ALTERED    <created>
> SQL_MODE   
> ROUTINE_COMMENT   
> DEFINER    root@localhost
> CHARACTER_SET_CLIENT    utf8 -> should be latin1
> COLLATION_CONNECTION    utf8_general_ci -> should be latin1_swedish_ci
> DATABASE_COLLATION    latin1_swedish_ci

How to repeat:
Run these tests with the 5.1.32 clone.

Unable to duplicate with branches of -bugteam / -main

./mysql-test-run.pl --force --suite=funcs_1 --do-test=.*storedproc.*

Suggested fix:
Limit the scope of these tests to only look at the routines created within the test itself, not all (likely variable) routines that exist in the system.

[13 Feb 2009 18:07] 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/66281

2795 Matthias Leich	2009-02-13
      Fix for Bug#42836 Funcs_1 storedproc and storedproc_08 tests failing

[16 Feb 2009 22:12] Matthias Leich

Pushed to
6.0-bugteam
5.1-bugteam

[19 Feb 2009 13:03] Bugs System

Pushed into 6.0.10-alpha (revid:[e-mail]-20090218125737-5y5b2xo3duo1wlvo) (version source revid:[e-mail]-20090216212836-8ec1lzvty0vaxqow) (merge vers: 6.0.10-alpha) (pib:6)

[27 Feb 2009 20:12] Paul DuBois

Test case changes. No changelog entry needed.

Setting report to NDI pending push into 5.1.x.

[13 Mar 2009 19:05] Bugs System

Pushed into 5.1.33 (revid:[e-mail]-20090313111355-7bsi1hgkvrg8pdds) (version source revid:[e-mail]-20090218093153-sjzxf01i4ezte0xp) (merge vers: 5.1.33) (pib:6)

[13 Mar 2009 20:22] Paul DuBois

Test case changes. No changelog entry needed.

[9 May 2009 16:44] Bugs System

Pushed into 5.1.34-ndb-6.2.18 (revid:[e-mail]-20090508185236-p9b3as7qyauybefl) (version source revid:[e-mail]-20090508100057-30ote4xggi4nq14v) (merge vers: 5.1.33-ndb-6.2.18) (pib:6)

[9 May 2009 17:41] Bugs System

Pushed into 5.1.34-ndb-6.3.25 (revid:[e-mail]-20090509063138-1u3q3v09wnn2txyt) (version source revid:[e-mail]-20090508175813-s6yele2z3oh6o99z) (merge vers: 5.1.33-ndb-6.3.25) (pib:6)

[9 May 2009 18:38] Bugs System

Pushed into 5.1.34-ndb-7.0.6 (revid:[e-mail]-20090509154927-im9a7g846c6u1hzc) (version source revid:[e-mail]-20090509073226-09bljakh9eppogec) (merge vers: 5.1.33-ndb-7.0.6) (pib:6)