<p dir="auto">The coverage of Sharding-Proxy is 45.64% now. It's necessary to improve the coverage now.</p>
<ul class="contains-task-list">
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox"> sharding-proxy-backend</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox"> sharding-proxy-bootstrap</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox"> sharding-proxy-common</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> sharding-proxy-frontend-core</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> sharding-proxy-frontend-mysql</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox"> sharding-proxy-frontend-postgresql</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox"> sharding-proxy-frontend-spi</li>
</ul>
<h2 dir="auto">Bug Report</h2>
<p dir="auto"><strong>For English only</strong>, other languages will not accept.</p>
<p dir="auto">Before report a bug, make sure you have:</p>
<ul dir="auto">
<li>Searched open and closed <a href="https://github.com/apache/shardingsphere/issues">GitHub issues</a>.</li>
<li>Read documentation: <a href="https://shardingsphere.apache.org/document/current/en/overview" rel="nofollow">ShardingSphere Doc</a>.</li>
</ul>
<p dir="auto">Please pay attention on issues you submitted, because we maybe need more details.<br>
If no response anymore and we cannot reproduce it on current information, we will <strong>close it</strong>.</p>
<p dir="auto">Please answer these questions before submitting your issue. Thanks!</p>
<h3 dir="auto">Which version of ShardingSphere did you use?</h3>
<p dir="auto">SS 5.0</p>
<h3 dir="auto">Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?</h3>
<p dir="auto">ShardingSphere-JDBC</p>
<h3 dir="auto">Expected behavior</h3>
<h3 dir="auto">Actual behavior</h3>
<p dir="auto">java.sql.SQLException:Error while preparing seatment</p>
<p dir="auto">SELECT dd.FullDateAlternateKey dataTime, IFNULL(rr.innum,0) innum, IFNULL(rr.jkl,0.00) jkl<br>
FROM dimdate dd<br>
LEFT JOIN<br>
(SELECT SUM(rsd.innum) innum,ROUND(SUM(rsd.innum)/SUM(rsd.area),2) jkl,rsd.datatime datatime<br>
FROM report_site_day rsd<br>
LEFT JOIN site_relation sr ON sr.childId=rsd.relationId<br>
LEFT JOIN project_status ps ON rsd.relationId=ps.site_id<br>
LEFT JOIN site_all_info sai ON rsd.relationId=sai.SiteId<br>
LEFT JOIN privilege_userssite AS pu ON pu.sitekey = sai.siteid<br>
LEFT JOIN userinsmallprogram AS us ON us.userid = pu.userid<br>
WHERE<br>
us.openid = ?<br>
AND sr.id =?<br>
AND ps.status=1<br>
AND rsd.dataTime BETWEEN ? AND ?<br>
GROUP BY rsd.datatime<br>
)rr<br>
ON dd.FullDateAlternateKey=rr.datatime<br>
WHERE dd.FullDateAlternateKey BETWEEN ? AND ?<br>
ORDER BY dd.FullDateAlternateKey ASC</p>
<h3 dir="auto">Reason analyze (If you can)</h3>
<h3 dir="auto">Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.</h3>
<h3 dir="auto">Example codes for reproduce this issue (such as a github link).</h3>