[#IDEADEV-27001] SQL: MySQL: prefix length in an index specification is rejected

IDEA: Development

SQL: MySQL: prefix length in an index specification is rejected

Created: 02 Jun 08 21:29 Updated: 26 Aug 08 19:12

Component/s:

SQL

Fix Version/s:

Diana 8769

Original Estimate:

Unknown

Remaining Estimate:

Unknown

Time Spent:

Unknown

Build:	8,431
Fixed in build:	8,743

Description

« Hide

IDEA report error for specification of index prefix length in CREATE TABLE statement like:

create table manual64 (
	id integer primary key,
	t1 text, index(t1(5)),
	t2 text, index(t2(10) asc)
);

This is valid statement, but both numbers in parenthesis are "red".
Moreover, MySQL requires length specification for indexing BLOB and TEXT columns.

You can search for "prefix length" on this page: http://dev.mysql.com/doc/refman/6.0/en/create-table.html for detailed information.

All

Comments

Work Log

Change History

Sort Order:

[ Permlink | « Hide ]

Alexander Chernikov - 26 Aug 08 19:12

8745: fix confirmed.