[GitHub] [incubator-shardingsphere] geomonlin edited a comment on issue #4565: distinct returns wrong result

[GitBox]

geomonlin edited a comment on issue #4565: distinct returns wrong result
URL: 
https://github.com/apache/incubator-shardingsphere/issues/4565#issuecomment-593724603
 
 
   I test it with mysql, eg: table: t_order `CREATE TABLE IF NOT EXISTS t_order 
(order_id BIGINT NOT NULL AUTO_INCREMENT, user_id INT NOT NULL, status 
VARCHAR(50), PRIMARY KEY (order_id));`
   The inserted user_id  contains
   **6
   2
   2
   2
   6
   4
   2
   2
   3
   3
   1
   3
   3**
   When exec "SELECT distinct user_id from t_order", the output resutl is 
Duplicate data，
   **3
   1
   3
   4
   6
   4
   2
   6
   2**
   When exec `SELECT distinct user_id from t_order GROUP BY user_id`, the 
resutl is Correct.
   **1
   2
   3
   4
   6**
   

----------------------------------------------------------------
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:
us...@infra.apache.org


With regards,
Apache Git Services