ActionTech-bot

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`

JVM GC algorithm choice

1

Raised by: chenshujun Make a guide of testing and observing on GC algorithm choice.

composite primary key is not supported

1

Raised by: @sevenFH As titled.

Raised by: helingyun **Steps:** 1. concurrently Query: ``` set autocommit = 0; update test_global1 set k=k-1 where id = 1; update test1 set k=k+1 where id = 666; commit; ```...

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

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

Raised by: @FlyingMao **Steps:** 1. Prepare a vm with 4-core 2. Start dble 3. Sysbench 100-threads test with following lua: ``` function event(thread_id) local table_name local a=sb_rand(1, oltp_table_size-1) local b=a+1...

Backend socket error, and client hang

1

Raised by: @yanhuqing666 As titled.

Raised by: @zhunina 1. server.xml, ``` 0 ``` It should be `useGlobalTableCheck` 2. There are "加班" in the comments 3. server.xml, `sequnceHandlerType` should be `sequenceHandlerType` 4. cacheservice.properties, `EnchachePooFactory ` should...

query select with large result set in stress test, dble restart or abort client connection

1

Raised by: helingyun **Steps:** 1. Sysbench makes stress test * SQL: ``` case1 : select a.k from test1 a inner join test2 b where a.k = b.k limit 4000000 case2...