[bug] create index synatx

[BohuTANG]

Summary

CREATE INDEX idx ON table(col);

doesn't work at v1.0.8, we should backport this patch from vitess(renamed 'force eof' -> 'skip to end') to fix it:
vitessio/vitess@4409977

[zhyass]

First, we need to fix the create index bug.

mysql> create index b_c_idx on t1(b,c); 
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

[zhyass]

syntax:

CREATE [UNIQUE | FULLTEXT] INDEX index_name
    [index_type]
    ON tbl_name (key_part,...)
    [index_option]
    [algorithm_option | lock_option] ...
	
key_part:
    col_name [(length)] [ASC | DESC]

index_option:
    KEY_BLOCK_SIZE [=] value
  | index_type
  | WITH PARSER parser_name
  | COMMENT 'string'

index_type:
    USING {BTREE | HASH}

algorithm_option:
    ALGORITHM [=] {DEFAULT | INPLACE | COPY}

lock_option:
    LOCK [=] {DEFAULT | NONE | SHARED | EXCLUSIVE}

[zhyass]

1. create index syntax.
CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name
    ON tbl_name (key_part,...)
    [index_option]
    [algorithm_option | lock_option] ...

key_part:
    col_name [(length)]

index_option:
    KEY_BLOCK_SIZE [=] value
  | index_type
  | WITH PARSER ngram
  | COMMENT 'string'

index_type:
    USING {BTREE | HASH}

algorithm_option:
    ALGORITHM [=] {DEFAULT | INPLACE | COPY}

lock_option:
    LOCK [=] {DEFAULT | NONE | SHARED | EXCLUSIVE}

2. create table index definition syntax.
index_definition:
    PRIMARY KEY (key_part,...)
  | UNIQUE [index_or_key] index_name (key_part,...) [index_option]
  | index_or_key index_name (key_part,...) [index_option]
  | FULLTEXT index_or_key index_name (key_part,...) [index_option]
  | SPATIAL index_or_key index_name (key_part,...) [index_option]

index_or_key:
    INDEX
  | KEY