<p dir="auto">Hi community,</p>
<p dir="auto">I am glad to announce that ShardingSphere will provide an independent SQL parser engine for parsing SQLs!<br>
I believe you will have some of the scenarios or use the SQL parser engine to get a parsed AST. From now on, you will have another option for your cases. Here are some of the advantages for ShardingSphere parser engine.</p>
<h3 dir="auto">Advantages</h3>
<ul dir="auto">
<li>Mostly perfect SQL statements supported for MySQL database</li>
<li>Mostly perfect SQL statements supported  for PostgreSQL database</li>
<li>Basically SQL statements supported  for SQLServer database</li>
<li>Basically SQL statements supported  for Oracle database</li>
<li>Basically SQL statements supported  for SQL92</li>
<li>SQL parsed result cache for the parsing performance</li>
<li>AST parsed result and SQLStatement parsed result are provided meanwhile</li>
<li>Simple extension approach for SQLStatement visitors</li>
<li>Simple supplement approach and for SQL definition</li>
<li>Continuous improvement for the much better feature in the future.</li>
</ul>
<p dir="auto">5.x release will include this one, please wait for our good news! <g-emoji class="g-emoji" alias="wink" fallback-src="https://github.githubassets.com/images/icons/emoji/unicode/1f609.png">😉</g-emoji></p>
<h2 dir="auto">Bug Report</h2>
<p dir="auto">Scene: 2 libraries, two tables<br>
Yesterday I did a test, I opened 4 threads, each thread inserts 1 million pieces of data, about 1 hour and a half of insertion, check the data, the data in the library has no problem, the id is not repeated, but in There is a problem when querying, please see the code.<br>
<a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/3363025/49778184-d8afce00-fd3e-11e8-9f3e-8a0c9a883617.png"><img src="https://user-images.githubusercontent.com/3363025/49778184-d8afce00-fd3e-11e8-9f3e-8a0c9a883617.png" alt="image" style="max-width: 100%;"></a><br>
Query password 0 has a record, a total of 12, this is because I started three times when testing, so there will be 12 records, id is not repeated, please see the database record:<br>
Database 0: user_info_0<br>
<a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/3363025/49778190-e2d1cc80-fd3e-11e8-96eb-767ce6784c3d.png"><img src="https://user-images.githubusercontent.com/3363025/49778190-e2d1cc80-fd3e-11e8-96eb-767ce6784c3d.png" alt="image" style="max-width: 100%;"></a><br>
user_info_1:<br>
<a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/3363025/49778199-ea917100-fd3e-11e8-95e7-a2539f597743.png"><img src="https://user-images.githubusercontent.com/3363025/49778199-ea917100-fd3e-11e8-95e7-a2539f597743.png" alt="image" style="max-width: 100%;"></a><br>
Database 1: user_info_0：<br>
<a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/3363025/49778207-f54c0600-fd3e-11e8-9b7b-6833e17e106f.png"><img src="https://user-images.githubusercontent.com/3363025/49778207-f54c0600-fd3e-11e8-9b7b-6833e17e106f.png" alt="image" style="max-width: 100%;"></a><br>
user_info_1:<br>
<a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/3363025/49778214-fda44100-fd3e-11e8-9c02-92bcdec8b8aa.png"><img src="https://user-images.githubusercontent.com/3363025/49778214-fda44100-fd3e-11e8-9c02-92bcdec8b8aa.png" alt="image" style="max-width: 100%;"></a><br>
Just 12 records, so once again stressed that there is no problem with the warehousing data, now look at the query results:<br>
<a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/3363025/49778223-072da900-fd3f-11e8-9dea-a79df00a3705.png"><img src="https://user-images.githubusercontent.com/3363025/49778223-072da900-fd3f-11e8-9dea-a79df00a3705.png" alt="image" style="max-width: 100%;"></a></p>
<p dir="auto">The sharding key is user_id, but with time query, sql statement prints out, check four tables, sql statement is no problem.</p>
<p dir="auto">And the following four data appear user_id: 279023793651843070, this id is not a record in the database</p>
<p dir="auto">The result is that the user_id is duplicated, using the mybatis framework, please take the time to reply as soon as possible, thank you.</p>