repair damages fulltext index

>Description:
"Repair table" damages the fulltext index, and on the subsequent
query you get: "ERROR 1030: Got error 127 from table handler".

The test case should be added to the MySQL Test Suite.

>How-To-Repeat:
#
# Check bug reported by Julian Ladisch
# ERROR 1030: Got error 127 from table handler
#

drop table if exists t1;
create table t1 (a text, fulltext key (a));
insert into t1 values ('aaaa');
repair table t1;
select * from t1 where match (a) against ('aaaa');
drop table t1;

>Originator: Julian Ladisch
>MySQL support: licence
>Synopsis: repair damages fulltext index
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-4.0.4-beta (Source distribution)
>Environment:
System: Linux 2.4.10-4GB #1 i686
Compilation info: CC='gcc' CFLAGS='-O3' CXX='gcc' CXXFLAGS='-O3 -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS=''
Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler --with-mysqld-ldflags=-all-static CFLAGS=-O3 'CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno -rtti' CXX=gcc


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12654@lists.mysql.com
To unsubscribe, e-mail

Re: repair damages fulltext index

On Monday 07 October 2002 20:00, Julian Ladisch wrote:
> >Description:
> "Repair table" damages the fulltext index, and on the subsequent
> query you get: "ERROR 1030: Got error 127 from table handler".
>=20
> The test case should be added to the MySQL Test Suite.
>=20
> >How-To-Repeat:
> #
> # Check bug reported by Julian Ladisch
> # ERROR 1030: Got error 127 from table handler
> #

Thank you for the bug report.=20

I was able to repeat the bug and so it should be fixed in the next
release.=20

--=20
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Peter Zaitsev
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Moscow, Russia
<___/ www.mysql.com M: +7 095 725 4955


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12672@lists.mysql.com
To unsubscribe, e-mail

Re: repair damages fulltext index

Hi!

On Oct 07, Julian Ladisch wrote:
> >Description:
> "Repair table" damages the fulltext index, and on the subsequent
> query you get: "ERROR 1030: Got error 127 from table handler".
>
> The test case should be added to the MySQL Test Suite.
>
> >How-To-Repeat:
> #
> # Check bug reported by Julian Ladisch
> # ERROR 1030: Got error 127 from table handler
> #
>
> drop table if exists t1;
> create table t1 (a text, fulltext key (a));
> insert into t1 values ('aaaa');
> repair table t1;
> select * from t1 where match (a) against ('aaaa');
> drop table t1;
>
> >Originator: Julian Ladisch
> >MySQL support: licence
> >Synopsis: repair damages fulltext index
> >Severity: serious
> >Priority: medium
> >Category: mysql
> >Class: sw-bug
> >Release: mysql-4.0.4-beta (Source distribution)
> >Environment:
> System: Linux 2.4.10-4GB #1 i686
> Compilation info: CC='gcc' CFLAGS='-O3' CXX='gcc' CXXFLAGS='-O3 -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS=''
> Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler --with-mysqld-ldflags=-all-static CFLAGS=-O3 'CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno -rtti' CXX=gcc

Fixed. Thanks.

Regards,
Sergei

--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12680@lists.mysql.com
To unsubscribe, e-mail