FlyingMao

Results 13 comments of FlyingMao

**Related case:** 1.show.sql:id:14、15

version :5.6.29-dble-9.9.9.9-6d0b936-20181101023043 still have bug: ``` mysql> select * from test_no_shard where R_NAME=_latin1 b'1000001'; ERROR 1064 (HY000): sql syntax error, no terminated. IDENTIFIER mysql> select * from test_no_shard where R_NAME=_utf8...

### 2. Durid parser error when `index_list` of USE INDEX is omitted steps: 1. prepare table in dble ``` drop table if exists aly_test; CREATE TABLE aly_test(`id` int(10) unsigned NOT...

### 3. **query:** ``` mysql> CREATE TABLE aly_test(id int, data1 varchar(10),data2 varchar(10),data3 varchar(20) GENERATED ALWAYS as (concat(data1,' ',data2))) -> ; ERROR 1064 (HY000): syntax error, error in :'(20) GENERATED ALWAYS...

### 4. query: ``` mysql> CREATE TABLE aly_test ( id int(11),test int,detail varchar(20),CONSTRAINT PRIMARY KEY (id ASC)); ERROR 1064 (HY000): syntax error, expect RPAREN, actual ASC pos 93, line 1,...

### 5. **query:** ``` mysql> CREATE TABLE aly_test ( id int(11),detail varchar(20),PRIMARY KEY (id) KEY_BLOCK_SIZE = 10); ERROR 1064 (HY000): syntax error, error in :'(id) KEY_BLOCK_SIZE = 10)', expect RPAREN,...

### 6. **query:** ``` mysql> CREATE TABLE aly_test ( id int(11),detail varchar(20),PRIMARY KEY (detail) WITH PARSER ngram); ERROR 1064 (HY000): syntax error, error in :'ail) WITH PARSER ngram)', expect RPAREN,...

### 7. **query:** ``` mysql> CREATE TABLE aly_test ( id int(11),test int,detail varchar(20),INDEX key_id (id) COMMENT 'string'); ERROR 1064 (HY000): syntax error, error in :'(id) COMMENT 'string')', expect RPAREN, actual...

### 8. **query:** ``` mysql> CREATE TABLE aly_test (id int, data varchar(10), FULLTEXT INDEX idn_id (data)); ERROR 1064 (HY000): error pos 63, line 1, column 58, token INDEX ``` **dble...