FlyingMao

* **dble version：** dble-9.9.9.9-9bf5140bf8483248e94077ba0b429e7d4acfb353-20200326102553 * **preconditions ：** no * **configs：** **schema.xml** ``` ``` **rule.xml** ``` ``` **server.xml** ``` ``` * **steps：** step1. explain information functions in dble such as ```...

* **dble version：** dble-9.9.9.9-9126b29739825a46313b28dab76555e1fd870996-20200310125806 * **preconditions ：** no * **configs：** **schema.xml** ``` ``` **rule.xml** ``` ``` **server.xml** ``` ``` * **steps：** step1. some can't add `'` but some must add...

Some syntax, druid parser does not recognize

10

* **dble version：** 5.6.29-dble-9.9.9.9-359645c-20181029082136 * **preconditions ：** no * **configs：** **schema.xml** ``` select user() select user() ``` **rule.xml** ``` id fixed_uniform_string id fixed_nonuniform_string id enum_integer id enum_string id range id...

steps： ``` mysql> select HEX(R_bit) like (select 1) from test_shard; +--------------------------------+ | HEX(R_bit) LIKE ( SELECT 1 ) | +--------------------------------+ | 1 | | 0 | | 0 | |...

Some administrative commands need to be added to `show @@ help`

2

* **dble version：** 5.6.29-dble-9.9.9.9-a5491f6-20181123014546 * **preconditions ：** no * **configs：** **schema.xml** ``` ``` **rule.xml** ``` ``` **server.xml** ``` ``` * **steps：** step1. * **expect result：** 1.contains all administrative commands *...

steps： ``` mysql> CREATE TABLE test_shard(`id` int(10) unsigned NOT NULL,`t_id` int(10) unsigned NOT NULL DEFAULT '0',`name` char(120) NOT NULL DEFAULT '',`pad` int(11) NOT NULL,PRIMARY KEY (`id`),KEY `k_1` (`t_id`)); Query OK,...

Incorrect result on `show table status`when using `like`

2

version: 5.6.29-dble-2.18.02.1-dev-20180427184625 steps step1:prepare table ``` mysql> create table aly_order (ID int(11),O_ORDERKEY varchar(20) primary key,O_CUSTKEY varchar(20),O_TOTALPRICE int(20),MYDATE date); Query OK, 0 rows affected (0.25 sec) mysql> create table aly_test (ID...

steps ``` mysql> select * from test_shard where 'A' in (select NAME from test_shard where id =18); ERROR 1105 (HY000): Correlated Sub Queries is not supported mysql> explain select *...