Bug #29528 'using rtree' clause in 'create index' statement is undocumented
Submitted: 3 Jul 2007 19:39 Modified: 5 Jul 2007 20:01
Reporter: Sergei Tkachenko Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.1 OS:Any
Assigned to: Paul Dubois CPU Architecture:Any
Tags: create, INDEX, rtree
Triage: D4 (Minor)

[3 Jul 2007 19:39] Sergei Tkachenko
Description:
Documentation on sql grammar for v5.1 (http://dev.mysql.com/doc/refman/5.1/en/create-index.html) doesn't mention rtree type of index, however grammar file sql_yacc.yy seems like it allows to use it along with btree & hash types.

How to repeat:
execute statement like:
CREATE INDEX index1
ON
test.table1(text1(10))
using rtree;

error message says:
Error Code : 1210
Incorrect arguments to RTREE INDEX

Suggested fix:
Document usage of 'using rtree' clause. Based on error message, this clause implies some contraints on given parapameters. Document also parameters expected by DBMS for this clause.
[3 Jul 2007 20:02] Sveta Smirnova
Thank you for the report.

Verified as described.
[5 Jul 2007 20:01] 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.

RTREE is allowable, but only for SPATIAL indexes. I've added this to the manual.