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:
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.1 OS:na
Assigned to: CPU Architecture:Any
Tags: csv, indexes

[22 Feb 2007 1:12] Roland Bouman
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
[22 Feb 2007 3:09] MySQL Verification Team
Thank you for the bug report. That is already documented:



"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."
[22 Feb 2007 7:40] Roland Bouman
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:


thank you!