Re: Bug in MySQL 4.0.10 - myisamchk with FULLTEXT-index - Tobias Lind - com.mysql.lists.bugs

8 messages in com.mysql.lists.bugsRe: Bug in MySQL 4.0.10 - myisamchk w...

From	Sent On	Attachments
Tobias Lind	19 Feb 2003 15:39
Sinisa Milivojevic	21 Feb 2003 11:19
Tobias Lind	21 Feb 2003 18:15
Steven Roussey	22 Feb 2003 00:33
Alexander Keremidarski	22 Feb 2003 01:26
Tobias Lind	22 Feb 2003 02:33
Alexander Keremidarski	22 Feb 2003 02:43
Sergei Golubchik	22 Feb 2003 06:53

Subject:	Re: Bug in MySQL 4.0.10 - myisamchk with FULLTEXT-index
From:	Tobias Lind (tob....@telia.com)
Date:	02/22/2003 02:33:43 AM
List:	com.mysql.lists.bugs

Hí! Well, I'm actually not sorting by the full-text-indexed column - I was sorting by the primary index (the fulltext-index in the example-code was no. 2, and I'm, was running myisamchk -R 1) The reason for using myisamchk -R is exactly wat you noted: to make SELECTs faster with ORDER BY column 1. I've been using that in my application for a long time, but haven't been using any fulltext-indexes. Now I started experimenting with fulltext-indexing, and found out that the sorting (on primary key) failed when I added a fulltext-index on a certain column...

But as Steven Roussey noted, "ALTER TABLE usrProfileTable2 ORDER BY usrName" will work, so I can use that instead for now... :)

Tobias,

Tobias Lind wrote:

Hi! Ok, I finally managed to create a small test case that shows a bug with myisamchk -R on a table with fulltext-index and certain content in the table.

Thanks for your Bug Report It is BUG and it will be fixed, but I would ask you why do you want to use this at all.

What are you trying to achieve with myisamchk -R on Full-Text Index? I can't find even way to define what expected result should be ....

You see if you have usual non-fultext Index then you have Index_value -> Row pairs stored there -R makes sense as "Order Rows table in order of appearance in Index"

There is reason to do it in case you expect to speed up queries with ORDER BY Indexed_columns.

But full-text index stores completely different information. According to what you expect rows to be sorted by myisamchk -R ?

And what this will give you? You can't ORDER BY by Full-text index content.

I believe -R makes no sence with Full-text at all and will be forbidden.

Best regards

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