Materialize/doc/developer/design/static/qgm/group-by-distinct-before.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="821pt" height="584pt"
 viewBox="0.00 0.00 821.00 583.68" 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 579.68)">
<title>G</title>
<polygon fill="white" stroke="transparent" points="-4,4 -4,-579.68 817,-579.68 817,4 -4,4"/>
<text text-anchor="middle" x="166.5" y="-7.8" font-family="Times,serif" font-size="14.00">select a from a group by a; (before rewrites)</text>
<g id="clust1" class="cluster">
<title>cluster3</title>
<polygon fill="none" stroke="black" points="399,-454.59 399,-567.68 805,-567.68 805,-454.59 399,-454.59"/>
<text text-anchor="middle" x="449.5" y="-552.48" 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="195,-314.59 195,-446.59 601,-446.59 601,-314.59 195,-314.59"/>
<text text-anchor="middle" x="257" y="-431.39" 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="21,-148 21,-306.59 321,-306.59 321,-148 21,-148"/>
<text text-anchor="middle" x="71.5" y="-291.39" 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,-140 170,-140 170,-31 8,-31"/>
<text text-anchor="middle" x="80" y="-124.8" font-family="Times,serif" font-size="14.00">Box1:BaseTable A</text>
</g>
<!-- boxhead3 -->
<g id="node1" class="node">
<title>boxhead3</title>
<polygon fill="none" stroke="black" points="499.5,-465.14 499.5,-534.14 796.5,-534.14 796.5,-465.14 499.5,-465.14"/>
<text text-anchor="middle" x="648" y="-518.94" font-family="Times,serif" font-size="14.00">Distinct: Preserve</text>
<polyline fill="none" stroke="black" points="499.5,-511.14 796.5,-511.14 "/>
<text text-anchor="middle" x="648" y="-495.94" font-family="Times,serif" font-size="14.00">0: Q2.c0 as A</text>
<polyline fill="none" stroke="black" points="499.5,-488.14 796.5,-488.14 "/>
<text text-anchor="middle" x="648" y="-472.94" 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="444" cy="-499.64" rx="37.09" ry="37.09"/>
<text text-anchor="middle" x="444" y="-495.94" font-family="Times,serif" font-size="14.00">Q2(F)</text>
</g>
<!-- boxhead2 -->
<g id="node3" class="node">
<title>boxhead2</title>
<polygon fill="none" stroke="black" points="295.5,-323.09 295.5,-415.09 592.5,-415.09 592.5,-323.09 295.5,-323.09"/>
<text text-anchor="middle" x="444" y="-399.89" font-family="Times,serif" font-size="14.00">Distinct: Preserve</text>
<polyline fill="none" stroke="black" points="295.5,-392.09 592.5,-392.09 "/>
<text text-anchor="middle" x="444" y="-376.89" font-family="Times,serif" font-size="14.00">0: Q1.c0 as A</text>
<polyline fill="none" stroke="black" points="295.5,-369.09 592.5,-369.09 "/>
<text text-anchor="middle" x="444" y="-353.89" font-family="Times,serif" font-size="14.00">GROUP Q1.c0 Ascending</text>
<polyline fill="none" stroke="black" points="295.5,-346.09 592.5,-346.09 "/>
<text text-anchor="middle" x="444" y="-330.89" font-family="Times,serif" font-size="14.00">UNIQUE KEY [0]</text>
</g>
<!-- Q2&#45;&gt;boxhead2 -->
<g id="edge1" class="edge">
<title>Q2&#45;&gt;boxhead2</title>
<path fill="none" stroke="black" stroke-dasharray="5,2" d="M444,-462.49C444,-457.42 444,-452.07 444,-446.59"/>
</g>
<!-- Q1 -->
<g id="node4" class="node">
<title>Q1</title>
<ellipse fill="none" stroke="black" cx="240" cy="-369.09" rx="37.09" ry="37.09"/>
<text text-anchor="middle" x="240" y="-365.39" 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="167,-181.29 167,-250.29 313,-250.29 313,-181.29 167,-181.29"/>
<text text-anchor="middle" x="240" y="-235.09" font-family="Times,serif" font-size="14.00">Distinct: Preserve</text>
<polyline fill="none" stroke="black" points="167,-227.29 313,-227.29 "/>
<text text-anchor="middle" x="240" y="-212.09" font-family="Times,serif" font-size="14.00">0: Q0.c0 as A</text>
<polyline fill="none" stroke="black" points="167,-204.29 313,-204.29 "/>
<text text-anchor="middle" x="240" y="-189.09" font-family="Times,serif" font-size="14.00">1: Q0.c1 as B</text>
</g>
<!-- Q1&#45;&gt;boxhead0 -->
<g id="edge2" class="edge">
<title>Q1&#45;&gt;boxhead0</title>
<path fill="none" stroke="black" stroke-dasharray="5,2" d="M240,-331.85C240,-324.04 240,-315.45 240,-306.59"/>
</g>
<!-- Q0 -->
<g id="node6" class="node">
<title>Q0</title>
<ellipse fill="none" stroke="black" cx="89" cy="-215.79" rx="59.59" ry="59.59"/>
<text text-anchor="middle" x="89" y="-212.09" font-family="Times,serif" font-size="14.00">Q0(F) as A</text>
</g>
<!-- boxhead1 -->
<g id="node7" class="node">
<title>boxhead1</title>
<polygon fill="none" stroke="black" points="16,-39.5 16,-108.5 162,-108.5 162,-39.5 16,-39.5"/>
<text text-anchor="middle" x="89" y="-93.3" font-family="Times,serif" font-size="14.00">Distinct: Preserve</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">0: c0 as A</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">1: c1 as B</text>
</g>
<!-- Q0&#45;&gt;boxhead1 -->
<g id="edge3" class="edge">
<title>Q0&#45;&gt;boxhead1</title>
<path fill="none" stroke="black" stroke-dasharray="5,2" d="M89,-155.91C89,-150.65 89,-145.31 89,-140"/>
</g>
</g>
</svg>