Weekly Report of ShardingSphere (2019.4.8 to 2019.4.12)

[Harper0122]

This report is to review recent changes and developments of ShardingSphere.

Basic Data

Basic data shows how the watch, star and fork have changed during the past week.

Watch	Star	Fork
863	7511	2618

This Week's Development

This part is to show new developments of ShardingSphere during the past week.

Feature Development

New Feature Development

1. Sharding-Proxy's support for storage process and transparent transmission of self-defined functions in non-sharding cases (Support Stored Procedure for Sharding-Proxy IF not sharding #2195, done).
2. Configured Sharding-Proxy with multi-user and user's administration control functions (ShardingProxy supports multiple users and authorizedSchemas #2232, done).

Feature Optimization & Refactoring

1. Replaced the parsing engine from its second generation to the third (Use 3rd generation parse engine instead of 2nd generation parse engine #2084 doing).
2. Data masking example (MySQL encrypt test #2191, doing).
3. Optimized Antlr parsing document structure for MySQL DCL (Review the DCL Parsing rules for different databases #2214 doing).
4. Optimized DDL Antlr parsing document structure (Review the DDL Parsing rules for different databases #2276, doing)
5. Refactored sql-revert module (shardingsphere-spi-impl JPA与Sharding-JDBC的兼容问题。JPA会自动增加SELECT的列别名，导致ORDER BY只能通过别名，而非列名称获取ResultSet的数据。 #38 done).
6. Refactored transaction-base-saga (shardingsphere-spi-impl 提供使用暗示(Hint)方式注册分片键值并进行SQL路由功能 #39 done).
7. Tested sharding-transaction-spring module (done).
8. sharding-transaction-spring module example (incubator-shardingsphere-example#134, done).

Problem Fix

1. OpenTracing will throw exception with SQL parameter being empty (OpenTracingSQLExecutionHook.toStringList NullPointerException #2142, done).
2. Error report in the use of auto-augment key when the last value is empty (insert with generated keys,when the last column value is null，cause NullPointerException #2252, doing).
3. Generated SQL takes functions as character strings because of error parsing functions (shardingsphere4.0.0-RC1,Incorrect datetime value: 'now()' for column 'create_time' at row  #2253, done).

Release

1. Finished the first Apache release 4.0.0-RC1 (https://lists.apache.org/thread.html/30d83a212413cc50125279e0ccfe36b6eff06228e3156d4cc2d173dc@%3Cgeneral.incubator.apache.org%3E).

ShardingSphere Ecology Construction

Official Website Construction

1. Added download document (update from origin #160, done).
2. Updated the release guidance according to the incubator mail-list (https://lists.apache.org/thread.html/e13cee0d69af52c4732dab10d7e0d12382aa40ba4afebbf42c151502@%3Cdev.shardingsphere.apache.org%3E).
3. Updated sharding-transaction-spring documents (incubator-shardingsphere-doc 分布式主键算法实现 #162, done).
4. Synchronized ShardingSphere's codes and introduction on Gitee (https://gitee.com/Sharding-Sphere).

Publicity

1. Announcement of 4.0.0-RC1 release on Official WeChat Account (https://mp.weixin.qq.com/s/9xulPQG6Bu8_wxKzH-HsvA).

Others

1. Revised test examples of SkyWalking plug-in (Provide plugin for ShardingSphere skywalking#1934, doing).

Next Week's Plan

This part is to show ShardingSphere's plan for the next week.

Feature Development

Feature Optimization & Refactoring

1. Replace the parsing engine from its second generation to the third (Use 3rd generation parse engine instead of 2nd generation parse engine #2084).
2. Data masking test examples (MySQL encrypt test #2191).
3. Review and refactor relevant logic codes in SQLToken parsing & rewrite module (Reconstruct rewriting module #2275).
4. Optimize DDL Antlr parsing document structure (Review the DDL Parsing rules for different databases #2276).

Problem Investigation

1. Error report in the use of auto-augment key when the last value is empty (insert with generated keys,when the last column value is null，cause NullPointerException #2252).
2. The use of spring-boot starter to inject JDNI data source (How to config JNDI in datasource #2260).

ShardingSphere Ecology Construction

Others

1. Revise test examples of SkyWalking plug-in (Provide plugin for ShardingSphere skywalking#1934).

Available Tasks for Community Committers

Issue #2154, #1907 and #1775.