<p dir="auto">[ERROR] 09:41:15.943 [pool-16-thread-1] o.a.s.s.f.c.CommandExecutorTask - Exception occur:<br>
java.lang.IllegalArgumentException: Cannot find JDBC type '2003' in PostgreSQL column type</p>
<p dir="auto">This report is to review recent changes and developments of ShardingSphere.</p>
<h2 dir="auto">Basic Data</h2>
<p dir="auto">Basic data shows how the watch, star and fork have changed during the past week.</p>
<table role="table">
<thead>
<tr>
<th>Watch</th>
<th>Star</th>
<th>Fork</th>
</tr>
</thead>
<tbody>
<tr>
<td>865</td>
<td>7647</td>
<td>2657</td>
</tr>
</tbody>
</table>
<h2 dir="auto">This Week's Development</h2>
<p dir="auto">This part is to show new developments of ShardingSphere during the past week.</p>
<h3 dir="auto">Feature Development</h3>
<h4 dir="auto">Feature Optimization &amp; Refactoring</h4>
<ol dir="auto">
<li>Replaced the parsing engine from its second generation to the third (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="424774993" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/2084" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/2084/hovercard" href="https://github.com/apache/shardingsphere/issues/2084">#2084</a> doing).</li>
<li>The support of sharding-jdbc-spring-boot-start for JNDI data source configuration (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="436553578" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/2260" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/2260/hovercard" href="https://github.com/apache/shardingsphere/issues/2260">#2260</a>, done).</li>
<li>Added RoutingHook in BaseShardingEngine (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="437487015" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/2273" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/2273/hovercard" href="https://github.com/apache/shardingsphere/issues/2273">#2273</a>, done).</li>
<li>Optimized SQLToken and refactored the rewrite engine (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="437490289" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/2275" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/2275/hovercard" href="https://github.com/apache/shardingsphere/issues/2275">#2275</a>, done).</li>
<li>Optimized MySQL&amp;Oracle&amp;Postgres&amp;SQLServer DDL Antlr parsing document structure (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="437520857" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/2276" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/2276/hovercard" href="https://github.com/apache/shardingsphere/issues/2276">#2276</a>, done).</li>
<li>COM_STMT_RESET and proxy were available to use preare statement through python client (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="438282175" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/2303" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/2303/hovercard" href="https://github.com/apache/shardingsphere/issues/2303">#2303</a>, done).</li>
<li>Sharding for MySQL REPLACE statement (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="440275444" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/2315" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/2315/hovercard" href="https://github.com/apache/shardingsphere/issues/2315">#2315</a>, done).</li>
<li>Reviewed the problem that  <code class="notranslate">insert</code> with auto-increment key cannot be reverted (#shardingsphere-spi-impl <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="144515582" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/44" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/44/hovercard" href="https://github.com/apache/shardingsphere/issues/44">#44</a>, done).</li>
<li>Reviewed the problem that Saga cannot be recovered once it is down (#shardingsphere-spi-impl <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="144623403" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/45" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/45/hovercard" href="https://github.com/apache/shardingsphere/issues/45">#45</a>, done).</li>
</ol>
<h4 dir="auto">Problem Fix</h4>
<ol dir="auto">
<li>"Unable to serialize" exception after inserting any text field (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="387660903" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/1567" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/1567/hovercard" href="https://github.com/apache/shardingsphere/issues/1567">#1567</a>, doing).</li>
<li>Wrong null value in Sharding-Proxy (MySQL) query result (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="434555892" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/2224" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/2224/hovercard" href="https://github.com/apache/shardingsphere/issues/2224">#2224</a>, done).</li>
<li>Metadata was not refreshed after executing ALTER TABLE (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="434567334" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/2226" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/2226/hovercard" href="https://github.com/apache/shardingsphere/issues/2226">#2226</a>, done).</li>
<li>Null value alert after the use of preparedStatemt and Insert Values(  ) (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="436182652" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/2252" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/2252/hovercard" href="https://github.com/apache/shardingsphere/issues/2252">#2252</a>, done).</li>
<li><code class="notranslate">INSERT ... ON DUPLICATE KEY UPDATE</code> execution error (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="437125399" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/2271" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/2271/hovercard" href="https://github.com/apache/shardingsphere/issues/2271">#2271</a>, done).</li>
<li>Not enough parsing information in UpdateStatement (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="437530417" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/2278" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/2278/hovercard" href="https://github.com/apache/shardingsphere/issues/2278">#2278</a>, done).</li>
<li>Self-defined load balance strategy could not take effect in sharding+master-slave (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="438623395" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/2306" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/2306/hovercard" href="https://github.com/apache/shardingsphere/issues/2306">#2306</a>, done).</li>
<li>Rewrite error caused by index name with \ (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="439089125" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/2312" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/2312/hovercard" href="https://github.com/apache/shardingsphere/issues/2312">#2312</a>, done).</li>
<li>MYSQL function name parsing error (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="440465554" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/2324" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/2324/hovercard" href="https://github.com/apache/shardingsphere/issues/2324">#2324</a>, done).</li>
<li>Error report of using Insert Set under Sharding (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="440594068" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/2329" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/2329/hovercard" href="https://github.com/apache/shardingsphere/issues/2329">#2329</a>, done).</li>
<li>Sharding-Proxy (PostgreSQL) did not support Chinese (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="441492115" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/2343" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/2343/hovercard" href="https://github.com/apache/shardingsphere/issues/2343">#2343</a>, done).</li>
<li>Transactions could not take effect after python client connecting proxy (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="442001651" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/2356" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/2356/hovercard" href="https://github.com/apache/shardingsphere/issues/2356">#2356</a>, done).</li>
</ol>
<h3 dir="auto">ShardingSphere Ecology Construction</h3>
<h4 dir="auto">Official Website</h4>
<ol dir="auto">
<li>Optimized Sharding-Proxy documents (incubator-shardingsphere-doc <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="185555546" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/164" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/164/hovercard" href="https://github.com/apache/shardingsphere/issues/164">#164</a>).</li>
<li>Updated Rewritten Engine, Execution Engine and Merger Engine English documents (incubator-shardingsphere-doc <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="186237493" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/168" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/168/hovercard" href="https://github.com/apache/shardingsphere/issues/168">#168</a>, incubator-shardingsphere-doc <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="188404904" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/171" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/171/hovercard" href="https://github.com/apache/shardingsphere/issues/171">#171</a> and incubator-shardingsphere-doc <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="188697763" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/173" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/173/hovercard" href="https://github.com/apache/shardingsphere/issues/173">#173</a>).</li>
<li>Added sharding-jdbc-spring-boot-start JNDI data source configuration documents (incubator-shardingsphere-doc <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="189065575" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/174" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/174/hovercard" href="https://github.com/apache/shardingsphere/issues/174">#174</a>).</li>
</ol>
<h4 dir="auto">Cooperation</h4>
<ol dir="auto">
<li>Reached an agreement with Seata; prepared for the integration (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="440979038" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/2335" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/2335/hovercard" href="https://github.com/apache/shardingsphere/issues/2335">#2335</a>, doing).</li>
<li>StreamBasedSaga Community discussion (#shardingsphere-spi-impl <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="144174699" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/43" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/43/hovercard" href="https://github.com/apache/shardingsphere/issues/43">#43</a>, done).</li>
<li>Optimized SkyWalking plug-in test example (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="382043486" data-permission-text="Title is private" data-url="https://github.com/apache/skywalking/issues/1934" data-hovercard-type="pull_request" data-hovercard-url="/apache/skywalking/pull/1934/hovercard" href="https://github.com/apache/skywalking/pull/1934">apache/skywalking#1934</a>, done).</li>
</ol>
<h4 dir="auto">Publicity</h4>
<ol dir="auto">
<li><em>Apache ShardingSphere's Development</em> at DTCC2019.</li>
</ol>
<h4 dir="auto">Community</h4>
<ol dir="auto">
<li>Thanks for codes contributed by <a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="/users/weiyuc/hovercard" data-octo-click="hovercard-link-click" data-octo-dimensions="link_type:self" href="https://github.com/weiyuc">@weiyuc</a> (PR <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="440398277" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/2320" data-hovercard-type="pull_request" data-hovercard-url="/apache/shardingsphere/pull/2320/hovercard" href="https://github.com/apache/shardingsphere/pull/2320">#2320</a>).</li>
</ol>
<h2 dir="auto">Next Week's Plan</h2>
<p dir="auto">This part is to show  ShardingSphere's plan for the next week.</p>
<h3 dir="auto">Feature Development</h3>
<h4 dir="auto">New Module Development</h4>
<ol dir="auto">
<li>Replace the parsing engine from its second generation to the third (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="424774993" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/2084" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/2084/hovercard" href="https://github.com/apache/shardingsphere/issues/2084">#2084</a>).</li>
<li>Investigate ShardingSphere's integration of seata (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="440979038" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/2335" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/2335/hovercard" href="https://github.com/apache/shardingsphere/issues/2335">#2335</a>).</li>
</ol>
<h4 dir="auto">Problem Investigation</h4>
<ol dir="auto">
<li>"Unable to serialize" exception after inserting any text field (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="387660903" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/1567" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/1567/hovercard" href="https://github.com/apache/shardingsphere/issues/1567">#1567</a>).</li>
<li>Wrong show tables returned (<a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="440612296" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/2331" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/2331/hovercard" href="https://github.com/apache/shardingsphere/issues/2331">#2331</a>).</li>
</ol>
<h2 dir="auto">Available Tasks for Community Committers</h2>
<p dir="auto">Issue <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="400563299" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/1775" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/1775/hovercard" href="https://github.com/apache/shardingsphere/issues/1775">#1775</a>, <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="413227508" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/1907" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/1907/hovercard" href="https://github.com/apache/shardingsphere/issues/1907">#1907</a> and <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="428529921" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/2154" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/2154/hovercard" href="https://github.com/apache/shardingsphere/issues/2154">#2154</a>.</p>