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 >
