nevereverever opened a new issue #4565: distinct returns wrong result URL: https://github.com/apache/incubator-shardingsphere/issues/4565 sharding-proxy version:4.0.0 I insert some rows to sharding-proxy by my custom hash algorithm. person_id|name|last_update_time|account|which data node -|-|-|-|-| 174fd27ef0f34fd5b9296f102ffdbd47| liuqiang| 2020-02-12 20:47:10 |3|ds_0 4295029899a64d1bbfc5b4d37b628f0c| wangwu| 2020-02-12 20:28:22| 2|ds_0 a672ba34d2f14f4d8e3ee9e8ccfd6ca5| liyi| 2020-02-12 20:47:16| 1|ds_0 bf840dc0eaf64f7a8a7493c3ffea8799| huangyao| 2020-02-12 20:28:38| 3|ds_0 c63b749e981a4dc6b4942b18978e0d08| lisi| 2020-02-12 20:28:17| 2|ds_0 e28da7bc9ddc45bdb2974041ed564fc3| zhangsan| 2020-02-12 20:27:48| 1|ds_0 f741d4fb69f14b869dac11e2889fe8c1| penggang| 2020-02-12 20:28:34| 3|ds_0 0596342115c14328b2b0458d0860a90c| lingang| 2020-02-12 20:28:47| 3|ds_1 2f8b95104c114cc5a8ab6bc86ef9ab62| luyang| 2020-02-12 20:28:50| 2|ds_1 4397392fb6274bf2bfcfc41ae1da55a5| tangliang |2020-02-12 20:28:42| 1|ds_1 c57c358c49cc4da6b98477ad8a55db3f| help| 2020-02-13 16:01:28| 3|ds_1 d9edd130ab8241f6be4b96a12cdb0404| zhaoliu| 2020-02-12 20:28:26| 2|ds_1 f97ea21d03124aa8b59a23bad5585e81| wanger| 2020-02-12 20:28:29| 1|ds_1 then,I execute this SQL: ```SQL select distinct account from tbperson; ``` result is : account -| 3| 2| 1| 3| 2| 1| right result gonna be: account -| 3| 2| 1| look forward to your reply.
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
