ActionTech-bot comments

Results 7 comments of


                                            ActionTech-bot

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

By @ditdb **Analysis** 1. MySQL uses recurrence formula, while Dble use the sum of squares, which causes the precision misbehave on two similar number subtraction (refer to ). In MySQL,...

subquery improvement

By @yanhuqing666 Refer to Orthogonal_Optimization_of_Subqueries_and_Aggregation.pdf

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

By @yanhuqing666 1. `distinctrow` case should be fixed. 2. Parser support only `select distinct sql_small_result`. When parsing `select sql_small_result distinct column`, `distinct` will be treated as column name, and `column`...

Spend too much time on INFO log

![image](https://user-images.githubusercontent.com/31302839/29711415-44ca8144-89c7-11e7-805f-5074d21f247e.png)

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

Case1 found2 log attached: [hs_err_pid79463.log.zip](https://github.com/actiontech/dble/files/1250758/hs_err_pid79463.log.zip)

composite primary key is not supported

``` ```

Backend socket error, and client hang

By @yanhuqing666 Cannot reproduce it.