Materialize/doc/developer/design/static/qgm/simple-group-by-having.svg

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN"
 "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd">
<!-- Generated by graphviz version 2.43.0 (0)
 -->
<!-- Title: G Pages: 1 -->
<svg width="940pt" height="638pt"
 viewBox="0.00 0.00 940.00 638.38" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink">
<g id="graph0" class="graph" transform="scale(1 1) rotate(0) translate(4 634.38)">
<title>G</title>
<polygon fill="white" stroke="transparent" points="-4,4 -4,-634.38 936,-634.38 936,4 -4,4"/>
<text text-anchor="middle" x="226.5" y="-7.8" font-family="Times,serif" font-size="14.00">select f1 from t group by f1 having f1 &gt; 10; (before rewrites)</text>
<g id="clust1" class="cluster">
<title>cluster3</title>
<polygon fill="none" stroke="black" points="398,-509.29 398,-622.38 924,-622.38 924,-509.29 398,-509.29"/>
<text text-anchor="middle" x="448.5" y="-607.18" font-family="Times,serif" font-size="14.00">Box3:Select</text>
</g>
<g id="clust3" class="cluster">
<title>cluster2</title>
<polygon fill="none" stroke="black" points="194,-358.29 194,-490.29 600,-490.29 600,-358.29 194,-358.29"/>
<text text-anchor="middle" x="256" y="-475.09" font-family="Times,serif" font-size="14.00">Box2:Grouping</text>
</g>
<g id="clust5" class="cluster">
<title>cluster0</title>
<polygon fill="none" stroke="black" points="22,-182 22,-339.29 320,-339.29 320,-182 22,-182"/>
<text text-anchor="middle" x="72.5" y="-324.09" font-family="Times,serif" font-size="14.00">Box0:Select</text>
</g>
<g id="clust7" class="cluster">
<title>cluster1</title>
<polygon fill="none" stroke="black" points="8,-31 8,-163 170,-163 170,-31 8,-31"/>
<text text-anchor="middle" x="79.5" y="-147.8" font-family="Times,serif" font-size="14.00">Box1:BaseTable T</text>
</g>
<!-- boxhead3 -->
<g id="node1" class="node">
<title>boxhead3</title>
<polygon fill="none" stroke="black" points="618.5,-519.84 618.5,-588.84 915.5,-588.84 915.5,-519.84 618.5,-519.84"/>
<text text-anchor="middle" x="767" y="-573.64" font-family="Times,serif" font-size="14.00">Distinct: Preserve</text>
<polyline fill="none" stroke="black" points="618.5,-565.84 915.5,-565.84 "/>
<text text-anchor="middle" x="767" y="-550.64" font-family="Times,serif" font-size="14.00">0: Q2.c0 as F1</text>
<polyline fill="none" stroke="black" points="618.5,-542.84 915.5,-542.84 "/>
<text text-anchor="middle" x="767" y="-527.64" font-family="Times,serif" font-size="14.00">UNIQUE KEY [0]</text>
</g>
<!-- Q2 -->
<g id="node2" class="node">
<title>Q2</title>
<ellipse fill="none" stroke="black" cx="443" cy="-554.34" rx="37.09" ry="37.09"/>
<text text-anchor="middle" x="443" y="-550.64" font-family="Times,serif" font-size="14.00">Q2(F)</text>
</g>
<!-- Q2&#45;&gt;Q2 -->
<g id="edge1" class="edge">
<title>Q2&#45;&gt;Q2</title>
<path fill="none" stroke="black" d="M478.74,-564.45C489.58,-564.19 498.05,-560.82 498.05,-554.34 498.05,-547.85 489.58,-544.48 478.74,-544.23"/>
<text text-anchor="middle" x="549.05" y="-550.64" font-family="Times,serif" font-size="14.00">(Q2.c0) &gt; (10)</text>
</g>
<!-- boxhead2 -->
<g id="node3" class="node">
<title>boxhead2</title>
<polygon fill="none" stroke="black" points="294.5,-366.79 294.5,-458.79 591.5,-458.79 591.5,-366.79 294.5,-366.79"/>
<text text-anchor="middle" x="443" y="-443.59" font-family="Times,serif" font-size="14.00">Distinct: Preserve</text>
<polyline fill="none" stroke="black" points="294.5,-435.79 591.5,-435.79 "/>
<text text-anchor="middle" x="443" y="-420.59" font-family="Times,serif" font-size="14.00">0: Q1.c0 as F1</text>
<polyline fill="none" stroke="black" points="294.5,-412.79 591.5,-412.79 "/>
<text text-anchor="middle" x="443" y="-397.59" font-family="Times,serif" font-size="14.00">GROUP Q1.c0 Ascending</text>
<polyline fill="none" stroke="black" points="294.5,-389.79 591.5,-389.79 "/>
<text text-anchor="middle" x="443" y="-374.59" font-family="Times,serif" font-size="14.00">UNIQUE KEY [0]</text>
</g>
<!-- Q2&#45;&gt;boxhead2 -->
<g id="edge2" class="edge">
<title>Q2&#45;&gt;boxhead2</title>
<path fill="none" stroke="black" stroke-dasharray="5,2" d="M443,-517.04C443,-508.73 443,-499.59 443,-490.29"/>
</g>
<!-- Q1 -->
<g id="node4" class="node">
<title>Q1</title>
<ellipse fill="none" stroke="black" cx="239" cy="-412.79" rx="37.09" ry="37.09"/>
<text text-anchor="middle" x="239" y="-409.09" font-family="Times,serif" font-size="14.00">Q1(F)</text>
</g>
<!-- boxhead0 -->
<g id="node5" class="node">
<title>boxhead0</title>
<polygon fill="none" stroke="black" points="166,-203.14 166,-295.14 312,-295.14 312,-203.14 166,-203.14"/>
<text text-anchor="middle" x="239" y="-279.94" font-family="Times,serif" font-size="14.00">Distinct: Preserve</text>
<polyline fill="none" stroke="black" points="166,-272.14 312,-272.14 "/>
<text text-anchor="middle" x="239" y="-256.94" font-family="Times,serif" font-size="14.00">0: Q0.c0 as F1</text>
<polyline fill="none" stroke="black" points="166,-249.14 312,-249.14 "/>
<text text-anchor="middle" x="239" y="-233.94" font-family="Times,serif" font-size="14.00">1: Q0.c1 as F2</text>
<polyline fill="none" stroke="black" points="166,-226.14 312,-226.14 "/>
<text text-anchor="middle" x="239" y="-210.94" font-family="Times,serif" font-size="14.00">2: Q0.c2 as F3</text>
</g>
<!-- Q1&#45;&gt;boxhead0 -->
<g id="edge3" class="edge">
<title>Q1&#45;&gt;boxhead0</title>
<path fill="none" stroke="black" stroke-dasharray="5,2" d="M239,-375.51C239,-364.59 239,-352.08 239,-339.29"/>
</g>
<!-- Q0 -->
<g id="node6" class="node">
<title>Q0</title>
<ellipse fill="none" stroke="black" cx="89" cy="-249.14" rx="59.29" ry="59.29"/>
<text text-anchor="middle" x="89" y="-245.44" font-family="Times,serif" font-size="14.00">Q0(F) as T</text>
</g>
<!-- boxhead1 -->
<g id="node7" class="node">
<title>boxhead1</title>
<polygon fill="none" stroke="black" points="16,-39.5 16,-131.5 162,-131.5 162,-39.5 16,-39.5"/>
<text text-anchor="middle" x="89" y="-116.3" font-family="Times,serif" font-size="14.00">Distinct: Preserve</text>
<polyline fill="none" stroke="black" points="16,-108.5 162,-108.5 "/>
<text text-anchor="middle" x="89" y="-93.3" font-family="Times,serif" font-size="14.00">0: c0 as F1</text>
<polyline fill="none" stroke="black" points="16,-85.5 162,-85.5 "/>
<text text-anchor="middle" x="89" y="-70.3" font-family="Times,serif" font-size="14.00">1: c1 as F2</text>
<polyline fill="none" stroke="black" points="16,-62.5 162,-62.5 "/>
<text text-anchor="middle" x="89" y="-47.3" font-family="Times,serif" font-size="14.00">2: c2 as F3</text>
</g>
<!-- Q0&#45;&gt;boxhead1 -->
<g id="edge4" class="edge">
<title>Q0&#45;&gt;boxhead1</title>
<path fill="none" stroke="black" stroke-dasharray="5,2" d="M89,-189.79C89,-181.08 89,-172.01 89,-163"/>
</g>
</g>
</svg>