History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: IDEADEV-27001
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Gregory Shrago
Reporter: Alexander Chernikov
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
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:
Alexander Chernikov - 26 Aug 08 19:12
8745: fix confirmed.