ActionTech-bot

subquery improvement

1

Raised by: @yanhuqing666 - support more subqueries - non-semi-join which cannot be converted to join - subquery in select

`STD()`/`STDDEV()`/`STDDEV_POP()`/`STDDEV_SAMP()`/`VAR_POP()`/`VAR_SAMP()`/`VARIANCE()` result precision is not correct

1

Raised by: @FlyingMao **Steps:** 1. Dble:  2. MySQL: 

Raised by: @FlyingMao **Steps:** 1. Prepare: `sbtest1` is hash sharding table 2. `begin;` 3. `insert into sbtest1 values(1,1,1,1),(2,2,2,2),(3,3,3,3),(4,4,4,4);` 4. Block a data-node by firewall 5. Wait 10 min, and Unblock...

Raised by: helingyun **Steps:** 1. Prepare: physical sever, 2 data-nodes, 2 tables on each node, 50000000 rows in each table 2. Sysbench 500 threads, sql: ``` select k as "sort_k"...

Raised by: @sevenFH As titled.

Raised by: @FlyingMao **Steps:** 1. `lock table sbtest1 read;` 2. `select * from sbtest2;` 3. `select * from sbtest2;` 4. `unlock tables;` 5. `select * from sbtest2;` Returns: `Error 1105（HY000）：MySQL...

support function/event/user/privileges/produce/trigger/views

3

**Is your feature request related to a problem? Please describe.** No **Describe the solution you'd like** support: - [x] function - [x] user/privileges - [x] produce - [ ] trigger...

target send 15%+ data to source, which doesn't make sense

1

**Description** **Steps to reproduce the issue:** 1. set up a replication 2. monitor on network **Describe the results you received:** 1. found target send 15%+ of data back to source,...

Aggregation: multiple MySQL tables are merged into a single MySQL+DDL - which does not support partition types : alter xx drop xx partition xx

1

**Problem Description:** when execute the statement of 'alter xx drop xx partition xx' on the two source database at the same time, the job will be 'shut down'. **Version: (git:...

Aggregation: multiple MySQL tables are merged into a single MySQL+DDL - which does not support partition types : alter xx add xx partition xx

1

**Problem Description:** when execute the statement of 'alter xx drop xx partition xx' on the two source database at the same time, the job will be 'shut down'. **Version: (git:...