Re: strange optimiazer behaviour with JOINed tables. - Alexander Y. Fomichev - com.mysql.lists.bugs

4 messages in com.mysql.lists.bugsRe: strange optimiazer behaviour with...

From	Sent On	Attachments
Alexander Y. Fomichev	03 Feb 2003 08:05
Sergei Golubchik	12 Feb 2003 07:13
Alexander Y. Fomichev	13 Feb 2003 03:10
Sergei Golubchik	18 Feb 2003 13:02

Subject:	Re: strange optimiazer behaviour with JOINed tables.
From:	Alexander Y. Fomichev (gl...@php4.ru)
Date:	02/13/2003 03:10:37 AM
List:	com.mysql.lists.bugs

I upload test case (table dump with explain) to: ftp://support.mysql.com:/pub/mysql/secret/fsearch_test.sql.bz2

mysql test_base < fsearch_test.sql

On Wednesday 12 February 2003 18:13, Sergei Golubchik wrote:

Hi!

Description: Optimizer don't use fulltext index with JOINed tables, (most likely not a bug but strange behaviour)

Unfortunately, I need a complete test case, not only table definitions, to be able to comment. As I cannot know why optimizer picks up that particular execution plan without table data.