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;
DROP TABLE IF EXISTS t2;
CREATE TABLE t2 (
id_t2 mediumint unsigned NOT NULL default '0',
id_t1 mediumint unsigned NOT NULL default '0',
field_number tinyint unsigned NOT NULL default '0',
PRIMARY KEY (id_t2,id_t1,field_number),
KEY id_t1(id_t1)
) TYPE=MyISAM;
INSERT INTO t1 (tag,value) VALUES ('foobar','baz');
INSERT INTO t2 VALUES (1,1,1);
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
---------------------------------------------------------------------
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