Bug #24178 ctype_ucs.test fails wit --cursor-protocol
Submitted: 10 Nov 2006 10:40 Modified: 13 Nov 2006 6:22
Reporter: Magnus Blåudd Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Prepared statements Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any
Triage: Triaged: D3 (Medium)

[10 Nov 2006 10:40] Magnus Blåudd
Description:
./mtr --cursor-protocol ctype_ucs

*** r/ctype_ucs.result  2006-09-20 19:47:31.000000000 +0300
--- r/ctype_ucs.reject  2006-11-10 13:38:12.000000000 +0300
***************
*** 591,599 ****
  insert into t1 values ('a'), ('a '), ('a\t');
  select collation(a),hex(a) from t1 order by a;
  collation(a)  hex(a)
! ucs2_general_ci       00610009
! ucs2_general_ci       0061
! ucs2_general_ci       00610020
  drop table t1;
  select @@collation_connection;
  @@collation_connection
--- 591,599 ----
  insert into t1 values ('a'), ('a '), ('a\t');
  select collation(a),hex(a) from t1 order by a;
  collation(a)  hex(a)
! ucs2_general_ci       ????
! ucs2_general_ci       ??
! ucs2_general_ci       ????
  drop table t1;
  select @@collation_connection;
  @@collation_connection
***************

Several other similar test failure in that test

How to repeat:
./mtr --cursor-protocol ctype_ucs