Bug #10836 ctype_tis620 test failure with ICC-compiled binaries on IA64
Submitted: 24 May 2005 18:04 Modified: 20 Oct 2005 1:16
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.13-pre OS:Linux (Linux/ia64 ICC only!)
Assigned to: Ramil Kalimullin CPU Architecture:Any

[24 May 2005 18:04] Joerg Bruehe
Description:
Build of 5.0.6, based on ChangeSet
  1.1894 05/05/23 21:15:00 kent@mysql.com +2 -0
  mysqld.dsp:
    Added BLACKHOLE and FEDERATED storage engines for max builds
    Some preparations for including yaSSL
  ha_federated.cc:
    Use local seach path for "mysql_priv.h"

  VC++Files/sql/mysqld.dsp
    1.31 05/05/23 21:00:11 kent@mysql.com +18 -9
    Added BLACKHOLE and FEDERATED storage engines for max builds
    Some preparations for including yaSSL

  sql/ha_federated.cc
    1.25 05/05/23 20:55:04 kent@mysql.com +1 -1
    Use local seach path for "mysql_priv.h"

Test "ctype_tis620" fails, only on this machine, only when compiled using icc.
Start of the differences:

-------------------------------------------------------
*** r/ctype_tis620.result       Tue May 24 04:27:52 2005
--- r/ctype_tis620.reject       Tue May 24 07:20:23 2005
***************
*** 317,326 ****
  ¡ØÊØÁÒ
  ¡ØËÅÒº
  ¡Ùê´ÇÔÅ ÍÔ¹´ÑʵÃÕé
- à¡ç¨¾ÔÃس
  ࡪÒ
  ࡳԡÒ
  ࡵØÁ³Õ
  à¡ÃÔ¡
  à¡ÃÔ¡ä¡Ã
  à¡ÃÔ¡¾§Éì
--- 317,326 ----
  ¡ØÊØÁÒ
  ¡ØËÅÒº
  ¡Ùê´ÇÔÅ ÍÔ¹´ÑʵÃÕé
  ࡪÒ
  ࡳԡÒ
  ࡵØÁ³Õ
+ à¡ç¨¾ÔÃس
  à¡ÃÔ¡
  à¡ÃÔ¡ä¡Ã
  à¡ÃÔ¡¾§Éì
***************
((further differences not quoted))

How to repeat:
Build using icc + test
[15 Sep 2005 7:51] Lenz Grimmer
This still happens in the latest 5.0.13 test builds. An update to Intel ICC 9.0 did not help to resolve it.
[11 Oct 2005 17:19] Lenz Grimmer
How to repeat:

Get a 5.0.13 source tarball and configure/compile it with the following options:

CC=icc CFLAGS="-O1 -ip" CXX=icpc CXXFLAGS="-O1 -ip"  ./configure --prefix=/usr/local/mysql --localstatedir=/usr/local/mysql/data --libexecdir=/usr/local/mysql/bin --with-extra-charsets=complex --enable-thread-safe-client --enable-local-infile  --disable-shared --with-big-tables --with-readline --with-archive-storage-engine --with-innodb

When the compile has finished, run the ctype_tis620 test to see the diff:

cd mysql-test
./mysql_test_run ctyp_tis620
[11 Oct 2005 18:29] Lenz Grimmer
Small typo in the last comment - the correct command to run the test is:

  ./mysql-test-run ctype_tis620
[12 Oct 2005 13:52] 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/internals/30964
[13 Oct 2005 8:39] Ramil Kalimullin
fixed in 4.1.16
[20 Oct 2005 1:16] Paul Dubois
Noted in 4.1.16, 5.0.15 changelogs.