Bug #37167 funcs_1: Many tests fail if the embedded server is used.
Submitted: 3 Jun 2008 17:36 Modified: 10 Jul 2008 19:49
Reporter: Matthias Leich Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Server Severity:S3 (Non-critical)
Version:5.0+ OS:Any
Assigned to: Matthias Leich CPU Architecture:Any
Triage: D3 (Medium)

[3 Jun 2008 17:36] Matthias Leich
Description:
A lot of funcs_1 tests fail if the embedded server is used.

I assume that the embedded server behaves correct
but the tests are insensitive to its limitations.

How to repeat:
cd mysql-test
./mysql-test-run.pl --embedded --force --suite=funcs_1

Suggested fix:
Variants:
1. "Cheap" solution with no increased coverage for the
   embedded server
   Add
   "--source include/not_embedded.inc"
   to the corresponding scripts
2. More "expensive" solution with increased coverage for
   the embedded server + easier maintenance in future
   Split the affected tests into
   - a test runnable with/without embedded server
   - a test which gets skipped in case of embedded server
[6 Jun 2008 13:26] Matthias Leich
More than 40 tests fail if the embedded server is used.

I will go with a decision per test which is in most cases
skip testing if we meet the embedded server, because
expensive changes just for having better coverage in case
of embedded server and "high end features for fat
applications" like stored procedures, triggers, 
information_schema are not to justify if we think about
other areas where even the not embedded server is not
enough tested.
[10 Jun 2008 16:23] 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/47697
[11 Jun 2008 15:23] Patrick Crews
Ok to push.

Minor notes sent to developer for consideration.
[20 Jun 2008 15:58] Matthias Leich
Patch was pushed to
mysql-5.0-bugteam
mysql-5.1-bugteam
mysql-6.0-bugteam
[26 Jun 2008 13:40] Bugs System
Pushed into 5.0.66
[26 Jun 2008 13:40] Bugs System
Pushed into 5.0.64
[10 Jul 2008 19:49] Paul Dubois
Test case changes. No changelog entry needed.
[28 Jul 2008 13:47] Bugs System
Pushed into 5.0.68  (revid:kpettersson@mysql.com-20080715152926-s5kgnqhtu93b3c8v) (pib:2)
(Retry automatic marking, to ensure nothing is missed. cm01)
[28 Jul 2008 16:50] Bugs System
Pushed into 5.1.27  (revid:joerg@mysql.com-20080626161101-h5hsaluwtf05xdr2) (version source revid:joerg@mysql.com-20080626161101-h5hsaluwtf05xdr2) (pib:3)