Bug #36788 Multiple funcs_1 'trig' tests are failing on vanilla builds
Submitted: 18 May 2008 21:38 Modified: 29 Jul 2008 9:54
Reporter: Patrick Crews 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
Tags: charset, funcs_1, Tests
Triage: D3 (Medium)

[18 May 2008 21:38] Patrick Crews
Description:
Multiple funcs_1 'trig' tests are failing on vanilla server builds:
Enterprise, Classic , Pushbuild or Source-without-max build (suspect all of these are affected).
only the myisam and ndb variants seem to be affected as these are the only engines in the more basic builds.
The following tests are affected:
<engine>_trig_102
<engine>_trig_03
<engine>_trig_0407
<engine>_trig_08
<engine>_trig_09
<engine>_trig_1011ext

All of these use the include file: suite/funcs_1/include/<engine>_tb3.inc
This include file is trying to use the ucs2 character set, which is no longer included in these builds.

This failure is related to Bug #36787	Test funcs_1.charset_collation_1 failing

How to repeat:
Build a version of 5.1+ with BUILD/compile-dist

Run the tests:
./mysql-test-run --suite=funcs_1 --do-test trig.

Observe the failures:  (output snipped for brevity)

mysqltest: In included file "./suite/funcs_1/include/ndb_tb3.inc": At line 6: query 'create table tb3 (
...
failed: 1115: Unknown character set: 'ucs2'

Suggested fix:
This is tied to Bug #36787	Test funcs_1.charset_collation_1 failing
As such, we need to determine if ucs2 is or is not supposed to be a part of these particular builds

If it is no longer included with the builds, the test needs to be altered so that this character set is no longer used.

If the character set *is* supposed to be a part of the build, then the resolution of Bug#36787 will also correct this bug (ucs2 will be available again).
[30 May 2008 15:12] 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/47262
[30 May 2008 17:56] Patrick Crews
Ok to push.
[2 Jun 2008 19:57] 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/47340
[3 Jun 2008 10:22] 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/47347
[3 Jun 2008 12:11] 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/47359
[3 Jun 2008 12:31] 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/47360
[3 Jun 2008 12:32] 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/47361
[3 Jun 2008 12:32] 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/47362
[3 Jun 2008 12:36] Matthias Leich
Patch pushed to
mysql-5.0-bugteam
mysql-5.1-bugteam
mysql-6.0-bugteam
[28 Jul 2008 13:39] Georgi Kodinov
Pushed into 5.0.68, 5.1.28 and 6.0.7-alpha
[28 Jul 2008 13:48] Bugs System
Pushed into 5.0.64  (revid:mleich@mysql.com-20080602195711-ltzn2r0y2dkmo93m) (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)
[28 Jul 2008 17:59] Paul Dubois
Test case change. No 5.0.x/5.1.x changelog entry needed.

Setting report to Patch Queued pending push of fix into 6.0.x.
[29 Jul 2008 8:51] Georgi Kodinov
Pushed to 6.0.7-alpha
[29 Jul 2008 9:54] Jon Stephens
Closed per comment from Paul.