Materialize/doc/developer/design/static/qgm/subquery-any.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="621pt" height="511pt"
 viewBox="0.00 0.00 621.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 617,-507.18 617,4 -4,4"/>
<text text-anchor="middle" x="245.5" y="-7.8" font-family="Times,serif" font-size="14.00">select * from a where a &gt;= ANY(select c from c); (before rewrites)</text>
<g id="clust1" class="cluster">
<title>cluster0</title>
<polygon fill="none" stroke="black" points="55,-336.59 55,-495.18 605,-495.18 605,-336.59 55,-336.59"/>
<text text-anchor="middle" x="105.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="451,-369.88 451,-438.88 597,-438.88 597,-369.88 451,-369.88"/>
<text text-anchor="middle" x="524" y="-423.68" font-family="Times,serif" font-size="14.00">Distinct: Preserve</text>
<polyline fill="none" stroke="black" points="451,-415.88 597,-415.88 "/>
<text text-anchor="middle" x="524" y="-400.68" font-family="Times,serif" font-size="14.00">0: Q0.c0 as A</text>
<polyline fill="none" stroke="black" points="451,-392.88 597,-392.88 "/>
<text text-anchor="middle" x="524" 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="123" cy="-404.38" rx="59.59" ry="59.59"/>
<text text-anchor="middle" x="123" 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="385" cy="-404.38" rx="48.19" ry="48.19"/>
<text text-anchor="middle" x="385" y="-400.68" font-family="Times,serif" font-size="14.00">Q2(Any)</text>
</g>
<!-- Q0&#45;&gt;Q2 -->
<g id="edge1" class="edge">
<title>Q0&#45;&gt;Q2</title>
<path fill="none" stroke="black" d="M183.11,-404.38C229.64,-404.38 293.25,-404.38 336.55,-404.38"/>
<text text-anchor="middle" x="259.85" 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="M111.77,-345.4C108.51,-328.55 104.93,-310.04 101.59,-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="M388.22,-356.33C389.04,-344.31 389.95,-330.98 390.86,-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>