Bug #30673 EXPLAIN documentation doesn't mention fulltext as a join type

• Submitted: 28 Aug 2007 17:16
• Modified: 5 Sep 2007 18:28
• Reporter: Baron Schwartz (Basic Quality Contributor)
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 4.1, 5.0, 5.1
• OS: Any
• Assigned to: Paul DuBois
• CPU Architecture: Any

[28 Aug 2007 17:16] Baron Schwartz

Description:
The EXPLAIN documentation http://dev.mysql.com/doc/refman/5.0/en/explain.html doesn't mention 'fulltext' as a possible value for the 'type' column.

How to repeat:
create table foo(a varchar(500) not null, fulltext(a));

insert into foo(a) values('hello'),('goodbye'),('thesaurus');

explain select * from foo where match(a) against('hello')\G
*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: foo
         type: fulltext
possible_keys: a
          key: a
      key_len: 0
          ref: 
         rows: 1
        Extra: Using where

[28 Aug 2007 18:01] Sveta Smirnova

Thank you for the report.

Verified as described.

[5 Sep 2007 18:28] Paul DuBois

Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.