Materialize/doc/developer/design/static/qgm/simple-distinct.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="479pt" height="323pt"
 viewBox="0.00 0.00 479.00 322.59" 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 318.59)">
<title>G</title>
<polygon fill="white" stroke="transparent" points="-4,4 -4,-318.59 475,-318.59 475,4 -4,4"/>
<text text-anchor="middle" x="155.5" y="-7.8" font-family="Times,serif" font-size="14.00">select distinct a from a; (before rewrites)</text>
<g id="clust1" class="cluster">
<title>cluster0</title>
<polygon fill="none" stroke="black" points="21,-148 21,-306.59 463,-306.59 463,-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="clust3" 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>
<!-- boxhead0 -->
<g id="node1" class="node">
<title>boxhead0</title>
<polygon fill="none" stroke="black" points="166.5,-181.29 166.5,-250.29 455.5,-250.29 455.5,-181.29 166.5,-181.29"/>
<text text-anchor="middle" x="311" y="-235.09" font-family="Times,serif" font-size="14.00">Distinct: Enforce</text>
<polyline fill="none" stroke="black" points="166.5,-227.29 455.5,-227.29 "/>
<text text-anchor="middle" x="311" y="-212.09" font-family="Times,serif" font-size="14.00">0: Q0.c0 as A</text>
<polyline fill="none" stroke="black" points="166.5,-204.29 455.5,-204.29 "/>
<text text-anchor="middle" x="311" y="-189.09" font-family="Times,serif" font-size="14.00">UNIQUE KEY [0]</text>
</g>
<!-- Q0 -->
<g id="node2" 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="node3" 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="edge1" 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>