zhaohongjie

* **dble version：** 2.19.03.0 * **related bugs list：** 1. ALTER TABLE test1 KEY_BLOCK_SIZE = 1000; /label ~BUG

where condition [on a.id = b.id where a.id =1 and b.id=1] can be optimized

1

* **dble version：** 5.6.29-dble-2.20.04.99-997ff15fc20aaea4b1a0b5625619764dd22613a2-20200512052042 * **preconditions ：** * **configs：** **schema.xml** ``` ``` **rule.xml** ``` ``` **server.xml** ``` ``` * **steps：** step1. explain in dble ```mysql mysql> explain select * from...

with enum sharding:if insert into enum column with index value will leading error sharding action

2

* **dble version：** 5.6.29-dble-9.9.9.9-08136d5-20181106070356 * **preconditions ：** no * **configs：** **schema.xml** ``` ``` **rule.xml** ``` id enum_integer enum-integer.txt 0 1 ``` * **steps：** step1. execute sql with dble: ```mysql mysql>CREATE...

* **dble version：** 5.6.29-dble-9.9.9.9-78a278906811927e31ad0cdc0cc19c2379963992-20191012125722 * **preconditions ：** no * **configs：** **schema.xml** ``` ``` **rule.xml** ``` ``` **server.xml** ``` ``` * **steps：** step1. query in dble ```mysql mysql> create table sharding_2_t1(id...

dble seems not support [mysql_stmt_result_metadata()] function

1

version:5.6.29-dble-2.18.02.0-dev-20180327092843 steps: 1, rename the attachment file to main.cpp 2, g++ -g main.cpp -o ps.o -I/opt/mysql/include -L/opt/mysql/lib -lmysqlclient 3,run [./ps.o] (ps:run [./ps.o debug] will get the result connecting directly to...

"select *, select 3 from table_a" expect syntax error, but get resultset

1

* **dble version：** 5.6.29-dble-9.9.9.9-287a2f4-20180921052651 * **preconditions ：** no * **configs：** **schema.xml** ``` ``` * **steps：** step1. with dble and compare mysql execute sqls to prepare env: ```mysql create table table_a(id...

version: 5.6.29-dble-2.18.02.0-dev-20180321063015 expect: switch useSqlStat state in server.xml can work by "reload @@config_all" or sth like.

version:2.19.09.0 eg: heartbeat timeout default 0