dble

dble copied to clipboard

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

FlyingMao

remind message should display in dble.log when slow query was not written into slowlogs because of Authority or dir not exist

1

* **dble version: 5.6.29-dble-9.9.9.9-60c3ca8-20180912064213** server.xml ``` druidparser utf-8 1 5 1 ./slowlogs slow-query 1 10 5 ``` * **steps：** step1. restart dble step 2 chmod 000 slowlogs or rm -rf...

yexiaoli88

druid wrong when execute related sql

3

* **dble version：version: 5.6.29-dble-9.9.9.9-8303bcf-20180821024605** * **configs：** **rule.xml** ``` id sharding 4 1 ``` **schema.xml** ``` ``` * **steps：** 1. dble return wrong when executing following sqls ``` mysql> select *...

yexiaoli88

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

FlyingMao

“flushSlowLogPeriod” in server.xml does not work for slow query log

1

* **dble version：version: 5.6.29-dble-9.9.9.9-4ecbd6a-20180907104021** * **preconditions ：** ``` create table test (id int,name varchar(20)); ``` * **configs：** **schema.xml** ``` ``` **rule.xml** ``` id hashmod 4 1 ``` **server.xml** ``` druidparser...

yexiaoli88

expect return "syntax error" message when executing sql like 'select *,select ... from...'

2

* **dble version：5.6.29-dble-9.9.9.9-c51d005-20180927104851** * **steps：** step1. query in dble ``` mysql> select *, select 3 from a_test order by id; ERROR 1242 (HY000): Subquery returns more than 1 row ```...

yexiaoli88

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

irene-coming

misbehave on `select xxx group by having`

1

Raised by: helingyun SQL: `select my_max_money from user_creditcard_info where id between 1 and 100 group by my_creditcard having my_comsume_money>=8` Query on Dble succeed while it failed on MySQL. Found: Dble...

actiontech-bot

'select syntax' results in implicit submission with ddl on no-sharding-tables preceding

1

``` mysql> begin; Query OK, 0 rows affected (0.00 sec) mysql> select * from t5 limit 1 for update; +--------------------+------+------+ | id | name | sex | +--------------------+------+------+ | 940051999573934080...

zhunina

Error when `sql_small_result`/`sql_big_result+distinct`/`distinctrow`

1

Raised by: @FlyingMao **Steps:** 1. Query: `select sql_big_result distinct pad from sbtest1;` Return: ``` You have an error in your SQL syntax; check the manual that corresponds to your MySQL...

actiontech-bot