<p dir="auto">Hi, we are glad you can fix this issue to become a contributor to Apache Sharding Sphere.<br>
Welcome! <g-emoji class="g-emoji" alias="smiley" fallback-src="https://github.githubassets.com/images/icons/emoji/unicode/1f603.png">😃</g-emoji></p>
<p dir="auto">By doing this assignment, you can learn more about how a query SQL is parsed and how to verify the parsing result of a SQL in Apache ShardingSphere.</p>
<p dir="auto">This issue is to add the parsing assertion for <code class="notranslate">ParameterMarkerExpression</code> by adding the start-index and stop-index attributes in parsing-result.xml.</p>
<p dir="auto">It is not difficult, and the following comment also gives you the detailed instruction. BTW, if you need any help, please be free to reply to this one.</p>
<h2 dir="auto">Bug Report</h2>
<div class="snippet-clipboard-content notranslate position-relative overflow-auto" data-snippet-clipboard-copy-content="SELECT region, SUM(population), SUM(area) FROM bbc GROUP BY region HAVING SUM(area)&gt;1000000.
"><pre class="notranslate"><code class="notranslate">SELECT region, SUM(population), SUM(area) FROM bbc GROUP BY region HAVING SUM(area)&gt;1000000.

</code></pre></div>
<p dir="auto">Parse the sql to get  statement, there is not info about <code class="notranslate">having</code>.</p>
<h3 dir="auto">Which version of ShardingSphere did you use?</h3>
<p dir="auto">5.0.0-alpha</p>
<h3 dir="auto">Expected behavior</h3>
<p dir="auto">we can get info about <code class="notranslate">having</code> in the statement.</p>
<h3 dir="auto">Actual behavior</h3>
<p dir="auto">there is no info about <code class="notranslate">having</code> in the statement.</p>