optimize table table / nonascii letter crash

>Description:
OPTIMIZE TABLE on a table will sometimes destroy a table with non
ascii characters (e.g. Norwegian letters) in text or varchar field
with fulltext index.

Note that this is the same bug as reported on the general mailinglist
yesterday, but this time with a smaler repeat script.

mysql> optimize table feil;
crashtest.feil | optimize | error    | 127 when fixing table
crashtest.feil | optimize | error    | Can't copy datafile-header to tempfile, error 9
crashtest.feil | optimize | status   | Operation failed

myisamcheck -o is required to restore the table.

This bug is not present in
Ver 4.0.18-standard for pc-linux on i686 (Official MySQL-standard binary)
running on the same computer (remove "DEFAULT CHARSET=latin1" to reproduce).

>How-To-Repeat:

DROP TABLE feil;
CREATE TABLE `feil` (
  `a` int(10) unsigned NOT NULL default '0',
  `c` text NOT NULL,
  PRIMARY KEY  (`a`),
  FULLTEXT KEY `ft` (`c`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
insert into feil (a, c) values (0,'tylfta serverte folkloren bestykning ram evolusjon tchad prent assistere homofili');
insert into feil (a, c) values (1,'vigler side argentinske monstret kontinentalsokkel attført aust nødvendigste horka travsportens');
update feil set c='arbeidsulykker barnsomshjem kommisjon kristiansand konditori makedonieren skattepolitikk substantivet annonsebyrå pressgjæren' where a=0;
update feil set c='val trøyte tråvbane assuransen kontinentet økonomien skånsom badedrakt forspille parodien' where a=1;
optimize table feil;

>Fix:
N/A

>Submitter-Id:	<submitter ID>
>Originator:	Jon Thingvold
>Organization:
Basefarm AS
>MySQL support: none
>Synopsis:	optimize table table / nonascii letter crash
>Severity:	serious
>Priority:	medium
>Category:	mysql
>Class:		sw-bug
>Release:	mysql-4.1.7-standard (Official MySQL-standard binary)

>C compiler:    8.0
>C++ compiler:  8.0
>Environment:
	
System: Linux mysql01.osl.basefarm.net 2.4.21-20.EL.c0smp #1 SMP Thu Sep 9 01:53:25 EDT
2004 i686 i686 i386 GNU/Linux
Architecture: i686

Some paths:  /local/bin/perl /local/gnu/bin/make /usr/bin/gmake

Compilation info: CC='icc'  CFLAGS='-O3 -unroll2 -ip -mp -no-gcc -restrict'  CXX='icc' 
CXXFLAGS='-O3 -unroll2 -ip -mp -no-gcc -restrict'  LDFLAGS=''  ASFLAGS=''
LIBC: 
lrwxr-xr-x    1 root     root           13 Nov 24 11:43 /lib/libc.so.6 -> libc-2.3.2.so
-rwxr-xr-x    1 root     root      1565376 Sep 10 04:12 /lib/libc-2.3.2.so
Configure command: ./configure '--prefix=/usr/local/mysql'
'--localstatedir=/usr/local/mysql/data' '--libexecdir=/usr/local/mysql/bin'
'--with-comment=Official MySQL-standard binary' '--with-extra-charsets=complex'
'--with-server-suffix=-standard' '--enable-thread-safe-client' '--enable-local-infile'
'--enable-assembler' '--disable-shared' '--with-zlib-dir=bundled' '--with-readline'
'--with-embedded-server' '--with-innodb' 'CC=icc' 'CFLAGS=-O3 -unroll2 -ip -mp -no-gcc
-restrict' 'CXXFLAGS=-O3 -unroll2 -ip -mp -no-gcc -restrict' 'CXX=icc'



-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]