Hi!
Sorry for delay :-(
On Jan 24, Tibor Simko wrote:
> Hello
>
> I wrote:
>
> > > After upgrading to 3.23.31, FULLTEXT selects give often "error -1
> > > from table handler" for me. [...]
>
> Sergei Golubchik <[EMAIL PROTECTED]> wrote:
>
> > Thanks for a bug report! This would be fixed in a nex release.
>
> Thanks. In 3.23.32 the test case I submitted apparently works better,
> but bad things still happen, like the following table corruption:
>
> DROP TABLE IF EXISTS t1;
> CREATE TABLE t1 (
> id mediumint unsigned NOT NULL auto_increment,
> tag char(6) NOT NULL default '',
> value text NOT NULL default '',
> PRIMARY KEY (id),
> KEY kt(tag),
> KEY kv(value(15)),
> FULLTEXT KEY kvf(value)
> ) TYPE=MyISAM;
> INSERT INTO t1 (tag,value) VALUES ('foobar','baz');
> CHECK TABLE t1;
>
> The error says: "Can't read indexpage from filepos: -1". Moreover,
> myisachk isn't able to repair it! (neither -r nor -o).
>
> Tested on both sparc64-linux (sun4u) and sparc-solaris2.6 (sun4m).
>
> cheers
> --
> TS
Thank you for reporting this.
This will be fixed in a next release.
But it was really not a big problem - the table was not really corrupted.
myisamchk thought it was because there was empty index and non-empty
table - something that should never happen with normal index.
The bug was fixed by making myisamchk to treat such a situation
as normal.
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ 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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
