dble

dble copied to clipboard

Merge with hint

10

I. What Changed: when route with hint, there are two sql statement: one is hint sql, the other is real sql. first, get the route from hint sql, and save...

cloudfirst

* **dble version：** 5.7.21-dble-3.21.06.0-9c90cabacaa870e85742d8e5014101661c014f4b-20210812071129 * **preconditions ：** no * **configs：** **user.xml** ```xml true ``` * **steps：** step1. exec cmd ```sql mysqldump -h10.186.65.78 -utest -P7131 -p111111 --default-character-set=utf8mb4 --master-data=2 --single-transaction --set-gtid-purged=off --hex-blob...

wjl1619

DfakeMySQLVersion 问题

5

dble version：dble-3.21.02.1-20210528041415-linux.tar.gz 数据库 mysql8.0.22 在配置文件bootstrap.cnf配置了参数DfakeMySQLVersion=8.0.22 dble可以启动不会报错，但Navicat连接dble就报错不能连接，把DfakeMySQLVersion改回DfakeMySQLVersion=5.7.23 就不报错了

wuwengjin

when i upload a picture to mysql,first i turn this pic file into byte[] data , but when the byte[] data insert into mysql,it change.what happend is the byte[] data...

pangtouyuyyf

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

irene-coming

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...

irene-coming

* **dble version：** 3.20.07.0 * **preconditions ：** mysql5.7 * **configs：** * **steps：** step1. The data table has JSON fields step2. Query error * **expect result：** 1. Query success * **real...

popfaker

E-R, cannot insert multi records to sub-table

1

Raised by: @sevenFH Steps: 1. Insert data to E-R sub-table: `insert into district (d_w_id, number, name) values (001,2,'aaa'),(002,3,'bbb');` 2. Got error: `ERROR 1064 (HY000): ChildTable multi insert not provided`

actiontech-bot

* **dble version：any version,use develop version as example ** * **preconditions ：** * **configs：** **sharding.xml** ``` 2 0:2 ``` * **steps：** step1: drop table if exists schema1. sharding_4_t1; create table...

PanternBao

# backgroud In practical, we cannot avoid using complex SQL on dble. Complex SQLs, such as multi-node join and aggregate function, are always different to their BASE SQLs. For example,...

Lordess