<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"><a class="commit-link" data-hovercard-type="commit" data-hovercard-url="https://github.com/apache/shardingsphere/commit/792829660d2bf7b2dbc7890d8431242a47541333/hovercard" href="https://github.com/apache/shardingsphere/commit/792829660d2bf7b2dbc7890d8431242a47541333"><tt>7928296</tt></a></p>
<h3 dir="auto">Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?</h3>
<p dir="auto">ShardingSphere-Proxy</p>
<h3 dir="auto">Expected behavior</h3>
<p dir="auto">SS have same performance</p>
<h3 dir="auto">Actual behavior</h3>
<h4 dir="auto">proxy</h4>
<p dir="auto"><a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/86462784/203500635-2c3114f1-4cdc-4f5d-a10d-36072ee1377a.png"><img width="946" alt="image" src="https://user-images.githubusercontent.com/86462784/203500635-2c3114f1-4cdc-4f5d-a10d-36072ee1377a.png" style="max-width: 100%;"></a></p>
<p dir="auto"><a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/86462784/203501908-a576fbf0-838a-41c5-ac03-d45404be316a.png"><img width="607" alt="image" src="https://user-images.githubusercontent.com/86462784/203501908-a576fbf0-838a-41c5-ac03-d45404be316a.png" style="max-width: 100%;"></a></p>
<h4 dir="auto">DB</h4>
<p dir="auto"><a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/86462784/203501741-df7bc353-734c-48df-84c0-39321f58326c.png"><img width="853" alt="image" src="https://user-images.githubusercontent.com/86462784/203501741-df7bc353-734c-48df-84c0-39321f58326c.png" style="max-width: 100%;"></a></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>
<p dir="auto">case like <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="1447831237" data-permission-text="Title is private" data-url="https://github.com/apache/shardingsphere/issues/22170" data-hovercard-type="issue" data-hovercard-url="/apache/shardingsphere/issues/22170/hovercard" href="https://github.com/apache/shardingsphere/issues/22170">#22170</a></p>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="test=&gt; \d t_ssdb_tb
      Table &quot;public.t_ssdb_tb&quot;
 Column |     Type      | Modifiers
--------+---------------+-----------
 id     | integer       |
 c_id   | integer       |
 a      | integer       |
 b      | character(10) |"><pre class="notranslate"><code class="notranslate">test=&gt; \d t_ssdb_tb
      Table "public.t_ssdb_tb"
 Column |     Type      | Modifiers
--------+---------------+-----------
 id     | integer       |
 c_id   | integer       |
 a      | integer       |
 b      | character(10) |
</code></pre></div>
<h3 dir="auto">Example codes for reproduce this issue (such as a github link).</h3>
<p dir="auto">The IT result is different with load data from database.</p>
<p dir="auto">Case name: SELECT AVG(user_id) AS user_id_avg FROM t_order<br>
Expected: is "19"<br>
but: was "19.5000"</p>
<p dir="auto">Please see:</p>
<ol dir="auto">
<li><code class="notranslate">dql-integration-test-cases.xml</code> and search <code class="notranslate">FIXME #15593</code></li>
<li><code class="notranslate">BaseDQLIT</code> and search <code class="notranslate">// FIXME #15593 verify accurate data types</code>, please remove the try catch to reproduce the issue</li>
</ol>