Materialize/doc/developer/design/static/qgm/subquery-all.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="615pt" height="511pt"
 viewBox="0.00 0.00 615.00 511.18" 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 507.18)">
<title>G</title>
<polygon fill="white" stroke="transparent" points="-4,4 -4,-507.18 611,-507.18 611,4 -4,4"/>
<text text-anchor="middle" x="244" y="-7.8" font-family="Times,serif" font-size="14.00">select * from a where a &gt;= ALL(select c from c); (before rewrites)</text>
<g id="clust1" class="cluster">
<title>cluster0</title>
<polygon fill="none" stroke="black" points="59,-336.59 59,-495.18 599,-495.18 599,-336.59 59,-336.59"/>
<text text-anchor="middle" x="109.5" y="-479.98" font-family="Times,serif" font-size="14.00">Box0:Select</text>
</g>
<g id="clust3" class="cluster">
<title>cluster2</title>
<polygon fill="none" stroke="black" points="178,-159 178,-317.59 478,-317.59 478,-159 178,-159"/>
<text text-anchor="middle" x="228.5" y="-302.39" font-family="Times,serif" font-size="14.00">Box2:Select</text>
</g>
<g id="clust5" class="cluster">
<title>cluster3</title>
<polygon fill="none" stroke="black" points="165,-31 165,-140 327,-140 327,-31 165,-31"/>
<text text-anchor="middle" x="237.5" y="-124.8" font-family="Times,serif" font-size="14.00">Box3:BaseTable C</text>
</g>
<g id="clust7" class="cluster">
<title>cluster1</title>
<polygon fill="none" stroke="black" points="8,-183.79 8,-292.79 170,-292.79 170,-183.79 8,-183.79"/>
<text text-anchor="middle" x="80" y="-277.59" 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="445,-369.88 445,-438.88 591,-438.88 591,-369.88 445,-369.88"/>
<text text-anchor="middle" x="518" y="-423.68" font-family="Times,serif" font-size="14.00">Distinct: Preserve</text>
<polyline fill="none" stroke="black" points="445,-415.88 591,-415.88 "/>
<text text-anchor="middle" x="518" y="-400.68" font-family="Times,serif" font-size="14.00">0: Q0.c0 as A</text>
<polyline fill="none" stroke="black" points="445,-392.88 591,-392.88 "/>
<text text-anchor="middle" x="518" y="-377.68" font-family="Times,serif" font-size="14.00">1: Q0.c1 as B</text>
</g>
<!-- Q0 -->
<g id="node2" class="node">
<title>Q0</title>
<ellipse fill="none" stroke="black" cx="127" cy="-404.38" rx="59.59" ry="59.59"/>
<text text-anchor="middle" x="127" y="-400.68" font-family="Times,serif" font-size="14.00">Q0(F) as A</text>
</g>
<!-- Q2 -->
<g id="node3" class="node">
<title>Q2</title>
<ellipse fill="none" stroke="black" cx="384" cy="-404.38" rx="42.79" ry="42.79"/>
<text text-anchor="middle" x="384" y="-400.68" font-family="Times,serif" font-size="14.00">Q2(All)</text>
</g>
<!-- Q0&#45;&gt;Q2 -->
<g id="edge1" class="edge">
<title>Q0&#45;&gt;Q2</title>
<path fill="none" stroke="black" d="M186.93,-404.38C234.1,-404.38 298.7,-404.38 340.88,-404.38"/>
<text text-anchor="middle" x="263.95" y="-411.18" font-family="Times,serif" font-size="14.00">(Q0.c0) &gt;= (Q2.c0)</text>
</g>
<!-- boxhead1 -->
<g id="node7" class="node">
<title>boxhead1</title>
<polygon fill="none" stroke="black" points="16,-192.29 16,-261.29 162,-261.29 162,-192.29 16,-192.29"/>
<text text-anchor="middle" x="89" y="-246.09" font-family="Times,serif" font-size="14.00">Distinct: Preserve</text>
<polyline fill="none" stroke="black" points="16,-238.29 162,-238.29 "/>
<text text-anchor="middle" x="89" y="-223.09" font-family="Times,serif" font-size="14.00">0: c0 as A</text>
<polyline fill="none" stroke="black" points="16,-215.29 162,-215.29 "/>
<text text-anchor="middle" x="89" y="-200.09" font-family="Times,serif" font-size="14.00">1: c1 as B</text>
</g>
<!-- Q0&#45;&gt;boxhead1 -->
<g id="edge2" class="edge">
<title>Q0&#45;&gt;boxhead1</title>
<path fill="none" stroke="black" stroke-dasharray="5,2" d="M114.56,-345.89C110.88,-328.91 106.84,-310.21 103.07,-292.79"/>
</g>
<!-- boxhead2 -->
<g id="node4" class="node">
<title>boxhead2</title>
<polygon fill="none" stroke="black" points="324,-203.79 324,-249.79 470,-249.79 470,-203.79 324,-203.79"/>
<text text-anchor="middle" x="397" y="-234.59" font-family="Times,serif" font-size="14.00">Distinct: Preserve</text>
<polyline fill="none" stroke="black" points="324,-226.79 470,-226.79 "/>
<text text-anchor="middle" x="397" y="-211.59" font-family="Times,serif" font-size="14.00">0: Q1.c0 as C</text>
</g>
<!-- Q2&#45;&gt;boxhead2 -->
<g id="edge3" class="edge">
<title>Q2&#45;&gt;boxhead2</title>
<path fill="none" stroke="black" stroke-dasharray="5,2" d="M387.11,-361.33C388.1,-348.06 389.22,-332.86 390.35,-317.59"/>
</g>
<!-- Q1 -->
<g id="node5" class="node">
<title>Q1</title>
<ellipse fill="none" stroke="black" cx="246" cy="-226.79" rx="59.59" ry="59.59"/>
<text text-anchor="middle" x="246" y="-223.09" font-family="Times,serif" font-size="14.00">Q1(F) as C</text>
</g>
<!-- boxhead3 -->
<g id="node6" class="node">
<title>boxhead3</title>
<polygon fill="none" stroke="black" points="173,-39.5 173,-108.5 319,-108.5 319,-39.5 173,-39.5"/>
<text text-anchor="middle" x="246" y="-93.3" font-family="Times,serif" font-size="14.00">Distinct: Preserve</text>
<polyline fill="none" stroke="black" points="173,-85.5 319,-85.5 "/>
<text text-anchor="middle" x="246" y="-70.3" font-family="Times,serif" font-size="14.00">0: c0 as C</text>
<polyline fill="none" stroke="black" points="173,-62.5 319,-62.5 "/>
<text text-anchor="middle" x="246" y="-47.3" font-family="Times,serif" font-size="14.00">1: c1 as D</text>
</g>
<!-- Q1&#45;&gt;boxhead3 -->
<g id="edge4" class="edge">
<title>Q1&#45;&gt;boxhead3</title>
<path fill="none" stroke="black" stroke-dasharray="5,2" d="M246,-166.63C246,-157.89 246,-148.85 246,-140"/>
</g>
</g>
</svg>