Bug #5428 small max_sort_length crash server
Submitted: 6 Sep 2004 9:37 Modified: 14 Sep 2004 8:16
Reporter: Oleksandr Byelkin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.1 OS:Any (all)
Assigned to: Ramil Kalimullin CPU Architecture:Any

[6 Sep 2004 9:37] Oleksandr Byelkin
Description:
debugging version of mysql trigger assert in case of small max_sort_length (4.0 worked 
correct) 
int my_strnxfrm_simple(CHARSET_INFO * cs, 
                       uchar *dest, uint len, 
                       const uchar *src, uint srclen) 
{ 
  uchar *map= cs->sort_order; 
  DBUG_ASSERT(len >= srclen); 

How to repeat:
set GLOBAL query_cache_size=1355776; 
create table t1 (id int auto_increment primary key, c char(25)); 
insert into t1 set c = repeat('x',24); 
insert into t1 set c = concat(repeat('x',24),'x'); 
insert into t1 set c = concat(repeat('x',24),'w'); 
insert into t1 set c = concat(repeat('x',24),'y'); 
set max_sort_length=20; 
select c from t1 order by c, id;
[14 Sep 2004 8:16] Ramil Kalimullin
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html