Bug #18743 Several test cases fails if "classic" configuration in 5.0
Submitted: 3 Apr 2006 15:12 Modified: 18 Jun 2010 1:07
Reporter: Kent Boortz Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.21-pre OS:Any
Assigned to: Alexey Kopytov CPU Architecture:Any

[3 Apr 2006 15:12] Kent Boortz
Description:
Several test cases fails if configured without InnoDB.

  ctype_ucs2_def                 [ fail ]

  Errors are (from var/log/mysqltest-time) :
  This test is not supported by this installation
.
.
  information_schema             [ fail ]

  Errors are (from var/log/mysqltest-time) :
  mysqltest: At line 742: query 'create table t1(a blob, b text charset utf8, c text charset ucs2)' failed: 1115: Unknown character set: 'ucs2'
.
.
sp                             [ fail ]

Errors are (from var/log/mysqltest-time) :
mysqltest: At line 5539: query 'create table t3 (a varchar(256) unicode)' failed: 1115: Unknown character set: 'ucs2'
.
.

How to repeat:
Configure, build and test with 

  ./configure --without-innodb --without-berkeley-db --without-ndbcluster
  make
  cd mysql-test
  ./mysql-test-run.pl --force
[3 Apr 2006 15:19] Kent Boortz
mysql                          [ fail ]

  Errors are (from var/log/mysqltest-time) :
  ^G/Users/kent/mysql/bk/mysql-5.0-new/client/.libs/mysql: Character set 'cp932' is not a compiled character set and is not specified in the '/usr/local/share/mysql/charsets/Index.xml' file
  ^G/Users/kent/mysql/bk/mysql-5.0-new/client/.libs/mysql: Character set 'cp932' is not a compiled character set and is not specified in the '/usr/local/share/mysql/charsets/Index.xml' file
  mysqltest: At line 52: command "$MYSQL --default-character-set=cp932 test -e "charset utf8;"" failed
.
.
  mysqlbinlog                    [ fail ]

  Errors are (from var/log/mysqltest-time) :
  Warning: ignoring Execute_load_query as there is no Begin_load_query event for file_id: 5
  Warning: ignoring Execute_load_query as there is no Begin_load_query event for file_id: 5
  mysqltest: At line 113: query 'create table t4 (f text character set cp932)' failed: 1115: Unknown character set: 'cp932'
[23 May 2006 10:26] 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/6762
[18 Jan 2007 13:26] 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/18336

ChangeSet@1.2362, 2007-01-18 16:25:51+03:00, kaa@polly.local +20 -0
  Bug#18743: Several test cases fails if "classic" configuration in 5.0
  The problem happened because those tests were using "cp932" and "ucs2" without checking whether these character sets are available. This fix moves test parts to make character set specific parts be tested only if they are:
  - some parts were moved to "ctype_ucs.test" and "ctype_cp932.test"
  - some parts were moved to the newly added tests "innodb-ucs2.test", "mysqlbinglog-cp932.test" and "sp-ucs2.test"
[5 Feb 2007 11:49] Alexander Barkov
Dear Alexey,

--- 1.3/mysql-test/t/ctype_ucs2_def-master.opt	2007-01-18 16:25:59 +03:00
+++ 1.4/mysql-test/t/ctype_ucs2_def-master.opt	2007-01-18 16:25:59 +03:00
@@ -1 +1 @@
---default-collation=ucs2_unicode_ci --default-character-set=ucs2
+--default-character-set=ucs2,latin1 --default-collation=ucs2_unicode_ci

Changing the order of --default-collation and --default-character-set
will discard test covering the  BUG#15276.

See the patch here:
http://lists.mysql.com/commits/6630

Consider implemeting it in a way to keep the order of the
commands in ctype_ucs2_def.opt:

--default-collation=ucs2_unicode_ci --default-character-set=ucs2,latin1 

Otherwise, the patch looks goood.
[5 Feb 2007 14:14] 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/19321

ChangeSet@1.2362, 2007-02-05 19:13:59+05:00, kaa@polly.local +20 -0
  Bug#18743: Several test cases fails if "classic" configuration in 5.0
  The problem happened because those tests were using "cp932" and "ucs2" without checking whether these character sets are available. This fix moves test parts to make character set specific parts be tested only if they are:
  - some parts were moved to "ctype_ucs.test" and "ctype_cp932.test"
  - some parts were moved to the newly added tests "innodb-ucs2.test", "mysqlbinglog-cp932.test" and "sp-ucs2.test"
[12 Feb 2007 9:06] Sveta Smirnova
There is similar Bug #26274
[16 Feb 2007 11:45] 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/19994

ChangeSet@1.2362, 2007-02-16 14:54:00+03:00, kaa@polly.local +20 -0
  Bug#18743: Several test cases fails if "classic" configuration in 5.0
  The problem happened because those tests were using "cp932" and "ucs2" without checking whether these character sets are available. This fix moves test parts to make character set specific parts be tested only if they are:
  - some parts were moved to "ctype_ucs.test" and "ctype_cp932.test"
  - some parts were moved to the newly added tests "innodb-ucs2.test", "mysqlbinglog-cp932.test" and "sp-ucs2.test"
[16 Feb 2007 13:00] Alexander Barkov
The patch "bk commit into 5.0 tree (kaa:1.2362) BUG#18743" is ok to push.
[19 Feb 2007 17:54] 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/20086

ChangeSet@1.2391, 2007-02-19 15:31:55+03:00, kaa@polly.local +5 -0
  5.1-specific fix for bug #18743.
  
  Moved tests requiring ucs2 from mix2_myisam.test to a separate unit.
[19 Feb 2007 17:54] 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/20078

ChangeSet@1.2362, 2007-02-19 13:57:06+03:00, kaa@polly.local +19 -0
  Bug#18743: Several test cases fails if "classic" configuration in 5.0
  The problem happened because those tests were using "cp932" and "ucs2" without checking whether these character sets are available. This fix moves test parts to make character set specific parts be tested only if they are:
  - some parts were moved to "ctype_ucs.test" and "ctype_cp932.test"
  - some parts were moved to the newly added tests "innodb-ucs2.test", "mysqlbinglog-cp932.test" and "sp-ucs2.test"
[21 Feb 2007 16:41] 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/20287

ChangeSet@1.2457, 2007-02-21 19:50:48+03:00, kaa@polly.local +3 -0
  Moved the test requiring cp932 to a separate unit.
  
  This is for bug #18743.
[22 Feb 2007 12:19] 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/20352

ChangeSet@1.2420, 2007-02-22 15:28:42+03:00, kaa@polly.local +1 -0
  Force the server restart before running mysqlbinlog-cp932.test to fix PB failures introduced by the patch for bug #18743.
[22 Feb 2007 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/20353

ChangeSet@1.2460, 2007-02-22 15:41:39+03:00, kaa@polly.local +1 -0
  Fixed the binlog_row_ctype_cp932 test failure in PB introduced by the patch for bug #18743.
[8 Mar 2007 22:13] Timothy Smith
pushed to 5.0.38, 5.1.17

probably no user-visible changes here
[15 Mar 2007 4:33] Paul Dubois
No changelog entry needed.
[5 May 2010 15:27] Bugs System
Pushed into 5.1.47 (revid:joro@sun.com-20100505145753-ivlt4hclbrjy8eye) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[6 May 2010 1:59] Paul Dubois
Push resulted from incorporation of InnoDB tree. No changes pertinent to this bug. Re-closing.
[28 May 2010 5:55] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100524190136-egaq7e8zgkwb9aqi) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (pib:16)
[28 May 2010 6:24] Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20100524190941-nuudpx60if25wsvx) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[28 May 2010 6:52] Bugs System
Pushed into 5.5.5-m3 (revid:alik@sun.com-20100524185725-c8k5q7v60i5nix3t) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[28 May 2010 21:42] Paul Dubois
Push resulted from incorporation of InnoDB tree. No changes pertinent to this bug.
Re-closing.
[17 Jun 2010 11:57] Bugs System
Pushed into 5.1.47-ndb-7.0.16 (revid:martin.skold@mysql.com-20100617114014-bva0dy24yyd67697) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[17 Jun 2010 12:36] Bugs System
Pushed into 5.1.47-ndb-6.2.19 (revid:martin.skold@mysql.com-20100617115448-idrbic6gbki37h1c) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[17 Jun 2010 13:23] Bugs System
Pushed into 5.1.47-ndb-6.3.35 (revid:martin.skold@mysql.com-20100617114611-61aqbb52j752y116) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)