| 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: | |
| Category: | MySQL Server | Severity: | S2 (Serious) |
| Version: | 4.1 | OS: | Any (all) |
| Assigned to: | Ramil Kalimullin | CPU Architecture: | Any |
[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

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;