Bug #61047 main.loaddata test fails with no ucs2
Submitted: 4 May 2011 1:58 Modified: 4 Oct 2012 16:29
Reporter: Tim Charnecki Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Server Severity:S3 (Non-critical)
Version:5.1.56, 5.6.3 OS:Linux (RHEL5.5)
Assigned to: CPU Architecture:Any

[4 May 2011 1:58] Tim Charnecki 
Description:
After compiling from source, during make test I got the following error:

test main.loaddata failed with error
CURRENT_TEST: main.loaddata
mysqltest: At line 592: query 'LOAD DATA INFILE 'tmpp.txt' INTO TABLE t1
CHARACTER SET ucs2 
(@b) SET a=REVERSE(@b)' failed: 1115: Unknown character set: 'ucs2'

I noticed other tests are skipped because of no ucs2
main.mix2_myisam_ucs2                    [ skipped ]  Test requires:' have_ucs2'

Should main.loaddata be skipped if there is no ucs2

How to repeat:
Run make test on compiled source that doesn't have ucs2

Suggested fix:
Add the line
-- source include/have_ucs2.inc
to the top of mysql-test/t/loaddata.test
[5 May 2011 13:42] Sveta Smirnova 
Thank you for the report.

Verified as described.
[4 Oct 2012 16:29] Paul DuBois 
Changes to test suite. No changelog entry needed.