Hi!
On Jan 19, Tibor Simko wrote:
> Hello
>
> After upgrading to 3.23.31, FULLTEXT selects give often "error -1 from
> table handler" for me. The error log says "ft_read_first: Got error
> -1 when reading table foo". I think I have not seen those for older
> 3.23.x versions (x=28 or so), at least not that frequently.
>
> A small example to reproduce the error:
>
> 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 ('foo123','bar1');
> INSERT INTO t2 VALUES (2231626,64280,0);
> INSERT INTO t1 (tag,value) VALUES ('foo123','bar2');
> INSERT INTO t2 VALUES (2231626,64281,0);
> SELECT DISTINCT t2.id_t2
> FROM t2, t1
> WHERE MATCH (t1.value) AGAINST ('baz')
> AND t1.id = t2.id_t1;
>
> The error occurs during final SELECT. I've seen it only for FULLTEXT
> searches; if I use e.g. "WHERE t1.value LIKE 'baz%' in that statement,
> everything works fine.
>
> P.S. Self-compiled 3.23.31 on sparc64 Linux (Debian stable).
>
> cheers
> --
> TS
>
Thanks for a bug report!
This would be fixed in a nex release.
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Helsinki, Finland (till Sunday)
<___/
---------------------------------------------------------------------
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