More fulltext problems
I'm obviously getting myself into more and more trouble with fulltext..
I have the following SQL statement;
SELECT indexIdentity, webpageIdentity, content, MATCH (content) AGAINST
('gallery' ) as score FROM db_com_pacificmomentum.tbl_index
where MATCH (content) AGAINST ('gallery' );
Which returns the following error: Can't find FULLTEXT index matching the
column list
While I know there is a fulltext index on the column, when I run
SELECT indexIdentity, webpageIdentity, content, MATCH (content) AGAINST
('gallery' in boolean mode) as score FROM db_com_pacificmomentum.tbl_index
where MATCH (content) AGAINST ('gallery' in boolean mode);
It works fine.
Kind regards,
Taco Fleur
Free Call 1800 032 982 or Mobile 0421 851 786
Pacific Fox http://www.pacificfox.com.au/ http://www.pacificfox.com.au an
industry leader with commercial IT experience since 1994 .
*
Web Design and Development
*
Accept online Credit Card payments www.commerceengine.com.au
http://www.commerceengine.com.au/
*
SMS Solutions, including developer API
*
Domain Registration, .COM for as low as fifteen dollars a year,
.COM.AU for fifty dollars two years!
FullText problems
Hello,
I tried the FULLTEXT example from the manual
(http://www.mysql.com/doc/F/u/Fulltext_Search.html) and run across some
problems. On some search terms, I get a result set and others I do not.
The query - SELECT * FROM articles WHERE MATCH (title,body) AGAINST
('database') returns a result, while the query - SELECT * FROM articles
WHERE MATCH (title,body) AGAINST ('following') does not.
Also, how can I search for multiple search terms within a full text column
('database design' for example)?
Any ideas?
Thanks.
--Kevin
[EMAIL PROTECTED]
=
CREATE TABLE `articles` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(200) default NULL,
`body` text,
PRIMARY KEY (`id`),
FULLTEXT KEY `title` (`title`,`body`)
) TYPE=MyISAM;
INSERT INTO `articles` VALUES(1,MySQL Tutorial,DBMS stands for DataBase
...);
INSERT INTO `articles` VALUES(2,How To Use MySQL Efficiently,After you
went through a ...);
INSERT INTO `articles` VALUES(3,Optimising MySQL,In this tutorial we
will show ...);
INSERT INTO `articles` VALUES(4,1001 MySQL Trick,1. Never run mysqld as
root. 2. ...);
INSERT INTO `articles` VALUES(5,MySQL vs. YourSQL,In the following
database comparison ...);
INSERT INTO `articles` VALUES(6,MySQL Security,When configured
properly, MySQL ...);
-
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
Re: Boolean Fulltext problems part III
Hi! On Feb 19, Alexander Belyaev wrote: Hello, Sergey, thanks for the patch, I applied it for 4.0.1 and seems like mentioned bug closed. But I found new bug :) Strange, but the query WORKS AS EXPECTED without fulltext index! The results for 4.0.1 with latest fulltext patch applied: If you need full testcase, please conteact me. Thanks, Alexander Thank you. It's fixed finally. 4.0.2 will contain the bugfix. 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
Re: Fulltext problems 4.0.1 part two
Hi!
On Feb 02, Alexander Belyaev wrote:
Hello,
I have found a bug( or bad feature? :) ) in 4.0.1
boolean fulltext search
Please help...
--
select id,txt from test.logo_text where match(txt) against ('+desig*
+service' in boolean mode)
--
2 rows in set (0.03 sec)
--
select id,txt from test.logo_text where match(txt) against ('+design
+service' in boolean mode)
--
-+
4 rows in set (0.03 sec)
Sorry for delay :-(
Anyway, the bug is fixed now, thank you.
Bugfix will be present in MySQL 4.0.2
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
Boolean Fulltext problems part III
Hello,
Sergey, thanks for the patch, I applied it for 4.0.1 and seems like
mentioned bug closed.
But I found new bug :)
Strange, but the query WORKS AS EXPECTED without fulltext index!
The results for 4.0.1 with latest fulltext patch applied:
If you need full testcase, please conteact me.
Thanks, Alexander
--
show variables like 'ft%'
--
+--++
| Variable_name| Value |
+--++
| ft_min_word_len | 2 |
| ft_max_word_len | 254|
| ft_max_word_len_for_sort | 20 |
| ft_boolean_syntax| + -()~*:| |
+--++
4 rows in set (0.00 sec)
--
show index from logo_text
--
+---++--+--+-+--
-+-+--++--+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation
| Cardinality | Sub_part | Packed | Comment |
+---++--+--+-+--
-+-+--++--+
| logo_text | 0 | PRIMARY |1 | id | A
| 38347 | NULL | NULL | |
| logo_text | 1 | fff |1 | txt | A
| 38347 |1 | NULL | FULLTEXT |
+---++--+--+-+--
-+-+--++--+
2 rows in set (0.00 sec)
--
select * from logo_text where match(txt) against ('+sony -play*' in boolean
mode)
--
+---+---
---+
| id| txt
|
+---+---
---+
| 3198 | sony
|
| 3199 | sony
|
| 5947 | cd changer 6 sony
|
| 5948 | wega fd trinitron sony
|
| 7539 | playstation sony
|
| 11814 | my first sony
|
| 11815 | my first sony
|
| 11835 | sony music
|
| 11836 | sony versity
|
| 11869 | it's a sony sony
|
| 19720 | playstation 2 sony
|
| 19721 | playstation sony
|
| 20417 | sony music 550
|
| 21186 | sony mobile
|
| 21187 | xplod sony
|
| 21188 | memory stick sony
|
| 27096 | sdds sony dynamic digital sound digital movie sound system
|
| 29512 | playstation sony
|
| 30292 | vaio sony
|
| 37280 | sony ericsson mobile communications
http://www.sonyericssonmobile.com/ |
| 37281 | sony ericsson mobile communications
http://www.sonyericssonmobile.com/ |
| 39170 | sony computer entertainment
|
| 39548 | ali the movie will smith sony pictures entertainment
|
| 40117 | digital cinematography sony
|
| 40133 | cinealta sony
|
| 40134 | cinealta sony
|
| 40310 | superslim sony monitors
|
| 40506 | sony walkman
|
+---+---
---+
28 rows in set (0.00 sec)
--
ALTER TABLE logo_text DROP INDEX fff
--
Query OK, 38347 rows affected (1.44 sec)
Records: 38347 Duplicates: 0 Warnings: 0
--
select * from logo_text where match(txt) against ('+sony -play*' in boolean
mode)
--
+---+---
---+
| id| txt
|
+---+---
---+
| 3198 | sony
|
| 3199 | sony
|
| 5947 | cd changer 6 sony
|
| 5948 | wega fd trinitron sony
|
| 11814 | my first sony
|
| 11815 | my first sony
|
| 11835 | sony music
|
| 11836 | sony versity
|
| 11869 | it's a sony sony
|
| 20417 | sony music 550
|
| 21186 | sony mobile
|
| 21187 | xplod sony
|
| 21188 | memory stick sony
|
| 27096 | sdds sony dynamic digital sound digital movie sound system
|
| 30292 | vaio sony
|
| 37280 | sony ericsson mobile communications
http://www.sonyericssonmobile.com/ |
| 37281 | sony ericsson mobile communications
http://www.sonyericssonmobile.com/ |
| 39170 | sony computer entertainment
|
| 39548 | ali the movie will smith sony pictures entertainment
|
| 40117 | digital cinematography sony
|
| 40133 | cinealta sony
|
| 40134 | cinealta sony
|
| 40310 | superslim sony monitors
|
| 40506 | sony walkman
|
+---+---
---+
24 rows in set (0.43 sec)
Bye
Server version: 4.0.1-alpha
Uptime: 23 min 52 sec
Threads: 2 Questions: 164 Slow queries: 4 Opens: 94 Flush tables: 1
Open tables: 4 Queries per second avg: 0.115
--
-
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
Re: Fulltext problems 4.0.1 part two (fwd)
Hi! Alex == Alex Aulbach [EMAIL PROTECTED] writes: Alex I found out, that the fulltext engine is misbehaving with less than 5 Alex entries. Seems to me, that this is exactly the same case... Alex Perhaps a flush inside the engine or so isn't made with such less entries? Alex The bug is also in 3.23 gamma. Alex Workaround: Enter more rows to fix it. :) Alex I send this bug 1 month ago to the developer who has done the fulltext Alex engine (I just forgot the name and the adresses are in the company - a Alex russian name). Perhaps I should have sent it better to bugs... cut Alex Test case with table can be found at http://logo.nino.ru/fulltextbug.tar.gz Thanks! Sergei, the developer of the MySQL fulltext has been at a conference and should be back working tomorrow. He will take a look at this problem ASAP and come back to you about this. Regards, Monty - 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
Re: Fulltext problems 4.0.1 part two (fwd)
I found out, that the fulltext engine is misbehaving with less than 5
entries. Seems to me, that this is exactly the same case...
Perhaps a flush inside the engine or so isn't made with such less entries?
The bug is also in 3.23 gamma.
Workaround: Enter more rows to fix it. :)
I send this bug 1 month ago to the developer who has done the fulltext
engine (I just forgot the name and the adresses are in the company - a
russian name). Perhaps I should have sent it better to bugs...
--
SSilk - Alexander Aulbach - Herbipolis/Frankonia Minoris
-- Forwarded message --
Date: Sat, 2 Feb 2002 11:41:36 +0300
From: Alexander Belyaev [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: Fulltext problems 4.0.1 part two
Hello,
I have found a bug( or bad feature? :) ) in 4.0.1
boolean fulltext search
Please help...
Test case with table can be found at http://logo.nino.ru/fulltextbug.tar.gz
Alexander
( sql database query table for you, spam protector:)
--
show variables like 'ft%'
--
+--++
| Variable_name| Value |
+--++
| ft_min_word_len | 2 |
| ft_max_word_len | 254|
| ft_max_word_len_for_sort | 20 |
| ft_boolean_syntax| + -()~*:| |
+--++
4 rows in set (0.00 sec)
--
show index from logo_text
--
+---++--+--+-+--
-+-+--++--+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation
| Cardinality | Sub_part | Packed | Comment |
+---++--+--+-+--
-+-+--++--+
| logo_text | 0 | PRIMARY |1 | id | A
| 38347 | NULL | NULL | |
| logo_text | 1 | |1 | txt | A
| 38347 |1 | NULL | FULLTEXT |
+---++--+--+-+--
-+-+--++--+
2 rows in set (0.00 sec)
--
check table logo_text
--
++---+--+---
--+
| Table | Op| Msg_type | Msg_text
|
++---+--+---
--+
| test.logo_text | check | warning | Found 38347 parts
Should be: 0 parts |
| test.logo_text | check | status | OK
|
++---+--+---
--+
2 rows in set (0.40 sec)
--
repair table logo_text
--
+++--+--+
| Table | Op | Msg_type | Msg_text |
+++--+--+
| test.logo_text | repair | status | OK |
+++--+--+
1 row in set (3.02 sec)
--
check table logo_text
--
++---+--+---
--+
| Table | Op| Msg_type | Msg_text
|
++---+--+---
--+
| test.logo_text | check | warning | Found 38347 parts
Should be: 0 parts |
| test.logo_text | check | status | OK
|
++---+--+---
--+
2 rows in set (0.45 sec)
--
select id,txt from test.logo_text where match(txt) against ('+desig*
+service' in boolean mode)
--
+---+---
-+
| id| txt
|
+---+---
-+
| 26570 | wave design a full service design agency seth brewer
http://www.wavedesign.com |
| 38847 | manucom hands on it service j.shannon design
|
+---+---
-+
2 rows in set (0.03 sec)
--
select id,txt from test.logo_text where match(txt) against ('+design
+service' in boolean mode)
--
+---+---
-+
| id| txt
|
+---+---
-+
| 1405 | design service ?? ??
|
| 1480 | edv-service grafik-design
|
| 26570 | wave design a full service design agency seth brewer
http://www.wavedesign.com |
| 38847 | manucom hands on it service j.shannon design
|
+---+---
-+
4 rows in set (0.03 sec)
Bye
-
Before posting, please check
Re: Fulltext problems 4.0.1 part two
Hello,
I have found a bug( or bad feature? :) ) in 4.0.1
boolean fulltext search
Please help...
Test case with table can be found at http://logo.nino.ru/fulltextbug.tar.gz
Alexander
( sql database query table for you, spam protector:)
--
show variables like 'ft%'
--
+--++
| Variable_name| Value |
+--++
| ft_min_word_len | 2 |
| ft_max_word_len | 254|
| ft_max_word_len_for_sort | 20 |
| ft_boolean_syntax| + -()~*:| |
+--++
4 rows in set (0.00 sec)
--
show index from logo_text
--
+---++--+--+-+--
-+-+--++--+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation
| Cardinality | Sub_part | Packed | Comment |
+---++--+--+-+--
-+-+--++--+
| logo_text | 0 | PRIMARY |1 | id | A
| 38347 | NULL | NULL | |
| logo_text | 1 | |1 | txt | A
| 38347 |1 | NULL | FULLTEXT |
+---++--+--+-+--
-+-+--++--+
2 rows in set (0.00 sec)
--
check table logo_text
--
++---+--+---
--+
| Table | Op| Msg_type | Msg_text
|
++---+--+---
--+
| test.logo_text | check | warning | Found 38347 parts
Should be: 0 parts |
| test.logo_text | check | status | OK
|
++---+--+---
--+
2 rows in set (0.40 sec)
--
repair table logo_text
--
+++--+--+
| Table | Op | Msg_type | Msg_text |
+++--+--+
| test.logo_text | repair | status | OK |
+++--+--+
1 row in set (3.02 sec)
--
check table logo_text
--
++---+--+---
--+
| Table | Op| Msg_type | Msg_text
|
++---+--+---
--+
| test.logo_text | check | warning | Found 38347 parts
Should be: 0 parts |
| test.logo_text | check | status | OK
|
++---+--+---
--+
2 rows in set (0.45 sec)
--
select id,txt from test.logo_text where match(txt) against ('+desig*
+service' in boolean mode)
--
+---+---
-+
| id| txt
|
+---+---
-+
| 26570 | wave design a full service design agency seth brewer
http://www.wavedesign.com |
| 38847 | manucom hands on it service j.shannon design
|
+---+---
-+
2 rows in set (0.03 sec)
--
select id,txt from test.logo_text where match(txt) against ('+design
+service' in boolean mode)
--
+---+---
-+
| id| txt
|
+---+---
-+
| 1405 | design service ?? ??
|
| 1480 | edv-service grafik-design
|
| 26570 | wave design a full service design agency seth brewer
http://www.wavedesign.com |
| 38847 | manucom hands on it service j.shannon design
|
+---+---
-+
4 rows in set (0.03 sec)
Bye
-
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
Fulltext problems
Hello,
Why score is 0 in my query?
Any suggestions? Seems like fulltext '*' operator produce buggy results.
Alexander
mysql \s
--
./mysql Ver 11.19 Distrib 4.0.1-alpha, for pc-solaris2.8 (i386)
Connection id: 9
Current database:
Current user: root@localhost
Current pager: stdout
Using outfile: ''
Server version: 4.0.1-alpha
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset:cp1251
Server characterset:cp1251
UNIX socket:/tmp/mysql.sock
Uptime: 28 min 19 sec
Threads: 3 Questions: 1047 Slow queries: 0 Opens: 48 Flush tables: 1
Open tables: 2 Queries per second avg: 0.616
--
mysql show indexes from test.logo_text;
*** 1. row ***
Table: logo_text
Non_unique: 0
Key_name: PRIMARY
Seq_in_index: 1
Column_name: id
Collation: A
Cardinality: 38347
Sub_part: NULL
Packed: NULL
Comment:
*** 2. row ***
Table: logo_text
Non_unique: 1
Key_name:
Seq_in_index: 1
Column_name: txt
Collation: A
Cardinality: 38347
Sub_part: 1
Packed: NULL
Comment: FULLTEXT
mysql select id,txt,match(txt) against('+desi* +service' in boolean mode)
as score from test.logo_text where match(txt) against ('+design +service' in
boolean mode);
*** 1. row ***
id: 1405
txt: design service
score: 0
*** 2. row ***
id: 1480
txt: edv-service grafik-design
score: 0
*** 3. row ***
id: 26570
txt: wave design a full service design agency seth brewer
http://www.wavedesign.com
score: 0
*** 4. row ***
id: 38847
txt: manucom hands on it service j.shannon design
score: 0
mysql
-
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
Re: 3.23.31 gives FULLTEXT problems on sparc64 Linux
Hello The error says: "Can't read indexpage from filepos: -1". [...] 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. [...] Thanks for the fix and the explanation! 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
Re: 3.23.31 gives FULLTEXT problems on sparc64 Linux
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
Re: 3.23.31 gives FULLTEXT problems on sparc64 Linux
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
3.23.31 gives FULLTEXT problems on sparc64 Linux
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
-
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
Re: 3.23.31 gives FULLTEXT problems on sparc64 Linux
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
