Wonderful, test cases are good enough and the pull request have already merged. Maybe we can release distinct feature soon. ------------------
Liang Zhang (John) Apache ShardingSphere & Dubbo juan pan <[email protected]> 于2018年12月27日周四 上午11:01写道： > Hi, everybody > > Here is the progress of this plan, click PR > <https://github.com/sharding-sphere/sharding-sphere/pull/1685> for more > detail. Maybe this plan can be finished before the due date, i guess. > --------------------------------- > Juan Pan (Trista) > Apache ShardingSphere > > > juan pan <[email protected]> 于2018年12月25日周二 下午12:58写道： > > > Hi, all > > > > As a distributed database middleware, ShardingSphere is on the way to > > support all the SQL syntax as possible as we can. > > > > This current supporting detail of `DISTINCT` syntax is as follows, > > > > *Available SQL Of ShardingSphere* > > SELECT DISTINCT * FROM tbl_name WHERE col1 = ? > > SELECT DISTINCT col1 FROM tbl_name > > SELECT DISTINCT col1, col2, col3 FROM tbl_name > > SELECT COUNT(DISTINCT col1) FROM tbl_name > > SELECT SUM(DISTINCT col1) FROM tbl_name > > SELECT DISTINCT col1 FROM tbl_name ORDER BY col1 > > SELECT DISTINCT col1 FROM tbl_name ORDER BY col2 > > SELECT COUNT(DISTINCT col1) FROM tbl_name GROUP BY col1 > > SELECT COUNT(DISTINCT col1), col1 FROM tbl_name GROUP BY col1 > > > > *Unavailable SQL Of ShardingSphere* > > SELECT DISTINCT(col1) FROM tbl_name > > SELECT COUNT(DISTINCT col1 + col2) FROM tbl_name > > SELECT AVG(DISTINCT col1) FROM tbl_name > > SELECT COUNT(DISTINCT col1), SUM(DISTINCT col1) FROM tbl_name > > SELECT col1, COUNT(DISTINCT col2) FROM tbl_name GROUP BY col1 > > SELECT SUM(DISTINCT col1), SUM(col1) FROM tbl_name > > > > The next step planned is to support 1st, 2nd, 3rd, 5th, 6th of > *Unavailable > > SQL*, and add unit cases for them as well. The expected end time of this > > task is about before January 4, 2019. > > More details will be presented on the issues and Prs on gitHub, and any > > progress will also be updated afterward here. > > > > Welcome your suggestions, and wish you *merry **Christmas* > > > > --------------------------------- > > Juan Pan (Trista) > > Apache ShardingSphere > > >
