yexiaoli88

load data returns error when separate line "\" in file

3

* **dble version：Server version: 5.6.23-dble-2.19.05.2-14700a8a98c7f8d8081a78942b804bf65abdb5e5-20191030095612** * **preconditions ：** 1.create table test_shard: ``` CREATE TABLE `test_shard` ( `CLAIM_ID` decimal(19,0) NOT NULL, `POLICY_ID` decimal(19,0) DEFAULT NULL, `CHANNEL_CLAIM_NO` varchar(64) DEFAULT NULL, `CHANNEL_POLICY_NO` varchar(64)...

* **dble version：5.6.29-dble-9.9.9.9-884fc6b612d64cc22101226536f8fd1d24580857-20190221031624** * preconditions *： ``` create table sharding_four(id int, c varchar(10)) charset utf8mb4; insert into sharding_four values(1, 'a'),(2, '吃'),(3,'啊'),(4,'吧'),(1004,'吃'); ``` schema.xml ``` ``` * **steps：** step1. execute sqls...

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

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

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

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