MySQL Bugs: #26552: Can't create index on CSV table

Bug #26552	Can't create index on CSV table - please document
Submitted:	22 Feb 2007 1:12	Modified:	22 Feb 2007 3:09
Reporter:	Roland Bouman	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	5.1	OS:	na
Assigned to:		CPU Architecture:	Any
Tags:	csv, indexes

Description:
It is not possible to create an index on a table backed by the CSV storage engine. This limitation is not documented.

How to repeat:
create table csvtable (
c int
) engine = csv

alter table csvtable add index(c)

ERROR 1069 (42000): Too many keys specified; max 0 keys allowed

(of course, also does not work for PRIMARY KEY and UNIQUE)

Suggested fix:
Please document this in http://dev.mysql.com/doc/refman/5.1/en/se-csv-limitations.html

Thank you for the bug report. That is already documented:

http://dev.mysql.com/doc/refman/5.0/en/csv-storage-engine.html

...

"This format can be read, and even written, by spreadsheet applications such as Microsoft Excel or StarOffice Calc.

The CSV storage engine does not support indexing."

Hi Sveta,

thanks for looking. It may be documented for 5.0; it is not for 5.1

I updated the report with the version info. Can you please reopen and have it documented here:

http://dev.mysql.com/doc/refman/5.1/en/se-csv-limitations.html

thank you!