Materialize/doc/developer/design/static/qgm/simple-in-select.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="614pt" height="555pt"
 viewBox="0.00 0.00 614.00 554.98" 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 550.98)">
<title>G</title>
<polygon fill="white" stroke="transparent" points="-4,4 -4,-550.98 610,-550.98 610,4 -4,4"/>
<text text-anchor="middle" x="238" y="-7.8" font-family="Times,serif" font-size="14.00">select * from t1 where f1 in (select f1 from t2); (before rewrites)</text>
<g id="clust1" class="cluster">
<title>cluster0</title>
<polygon fill="none" stroke="black" points="70,-369.99 70,-538.98 598,-538.98 598,-369.99 70,-369.99"/>
<text text-anchor="middle" x="120.5" y="-523.78" 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,-182 178,-350.99 488,-350.99 488,-182 178,-182"/>
<text text-anchor="middle" x="228.5" y="-335.79" 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="170,-31 170,-163 332,-163 332,-31 170,-31"/>
<text text-anchor="middle" x="246" y="-147.8" font-family="Times,serif" font-size="14.00">Box3:BaseTable T2</text>
</g>
<g id="clust7" class="cluster">
<title>cluster1</title>
<polygon fill="none" stroke="black" points="8,-200.49 8,-332.49 170,-332.49 170,-200.49 8,-200.49"/>
<text text-anchor="middle" x="84" y="-317.29" font-family="Times,serif" font-size="14.00">Box1:BaseTable T1</text>
</g>
<!-- boxhead0 -->
<g id="node1" class="node">
<title>boxhead0</title>
<polygon fill="none" stroke="black" points="444,-396.98 444,-488.98 590,-488.98 590,-396.98 444,-396.98"/>
<text text-anchor="middle" x="517" y="-473.78" font-family="Times,serif" font-size="14.00">Distinct: Preserve</text>
<polyline fill="none" stroke="black" points="444,-465.98 590,-465.98 "/>
<text text-anchor="middle" x="517" y="-450.78" font-family="Times,serif" font-size="14.00">0: Q0.c0 as F1</text>
<polyline fill="none" stroke="black" points="444,-442.98 590,-442.98 "/>
<text text-anchor="middle" x="517" y="-427.78" font-family="Times,serif" font-size="14.00">1: Q0.c1 as F2</text>
<polyline fill="none" stroke="black" points="444,-419.98 590,-419.98 "/>
<text text-anchor="middle" x="517" y="-404.78" font-family="Times,serif" font-size="14.00">2: Q0.c2 as F3</text>
</g>
<!-- Q0 -->
<g id="node2" class="node">
<title>Q0</title>
<ellipse fill="none" stroke="black" cx="143" cy="-442.98" rx="64.99" ry="64.99"/>
<text text-anchor="middle" x="143" y="-439.28" font-family="Times,serif" font-size="14.00">Q0(F) as T1</text>
</g>
<!-- Q2 -->
<g id="node3" class="node">
<title>Q2</title>
<ellipse fill="none" stroke="black" cx="388" cy="-442.98" rx="37.89" ry="37.89"/>
<text text-anchor="middle" x="388" y="-439.28" font-family="Times,serif" font-size="14.00">Q2(E)</text>
</g>
<!-- Q0&#45;&gt;Q2 -->
<g id="edge1" class="edge">
<title>Q0&#45;&gt;Q2</title>
<path fill="none" stroke="black" d="M208.01,-442.98C253.38,-442.98 312.34,-442.98 350.19,-442.98"/>
<text text-anchor="middle" x="279.15" y="-449.78" font-family="Times,serif" font-size="14.00">(Q0.c0) = (Q2.c0)</text>
</g>
<!-- boxhead1 -->
<g id="node7" class="node">
<title>boxhead1</title>
<polygon fill="none" stroke="black" points="16,-208.99 16,-300.99 162,-300.99 162,-208.99 16,-208.99"/>
<text text-anchor="middle" x="89" y="-285.79" font-family="Times,serif" font-size="14.00">Distinct: Preserve</text>
<polyline fill="none" stroke="black" points="16,-277.99 162,-277.99 "/>
<text text-anchor="middle" x="89" y="-262.79" font-family="Times,serif" font-size="14.00">0: c0 as F1</text>
<polyline fill="none" stroke="black" points="16,-254.99 162,-254.99 "/>
<text text-anchor="middle" x="89" y="-239.79" font-family="Times,serif" font-size="14.00">1: c1 as F2</text>
<polyline fill="none" stroke="black" points="16,-231.99 162,-231.99 "/>
<text text-anchor="middle" x="89" y="-216.79" font-family="Times,serif" font-size="14.00">2: c2 as F3</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="M125.09,-380.31C120.65,-365 115.83,-348.42 111.21,-332.49"/>
</g>
<!-- boxhead2 -->
<g id="node4" class="node">
<title>boxhead2</title>
<polygon fill="none" stroke="black" points="334,-231.99 334,-277.99 480,-277.99 480,-231.99 334,-231.99"/>
<text text-anchor="middle" x="407" y="-262.79" font-family="Times,serif" font-size="14.00">Distinct: Preserve</text>
<polyline fill="none" stroke="black" points="334,-254.99 480,-254.99 "/>
<text text-anchor="middle" x="407" y="-239.79" font-family="Times,serif" font-size="14.00">0: Q1.c0 as F1</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="M391.75,-405.24C393.36,-389.49 395.32,-370.3 397.3,-350.99"/>
</g>
<!-- Q1 -->
<g id="node5" class="node">
<title>Q1</title>
<ellipse fill="none" stroke="black" cx="251" cy="-254.99" rx="64.99" ry="64.99"/>
<text text-anchor="middle" x="251" y="-251.29" font-family="Times,serif" font-size="14.00">Q1(F) as T2</text>
</g>
<!-- boxhead3 -->
<g id="node6" class="node">
<title>boxhead3</title>
<polygon fill="none" stroke="black" points="178,-39.5 178,-131.5 324,-131.5 324,-39.5 178,-39.5"/>
<text text-anchor="middle" x="251" y="-116.3" font-family="Times,serif" font-size="14.00">Distinct: Preserve</text>
<polyline fill="none" stroke="black" points="178,-108.5 324,-108.5 "/>
<text text-anchor="middle" x="251" y="-93.3" font-family="Times,serif" font-size="14.00">0: c0 as F1</text>
<polyline fill="none" stroke="black" points="178,-85.5 324,-85.5 "/>
<text text-anchor="middle" x="251" y="-70.3" font-family="Times,serif" font-size="14.00">1: c1 as F2</text>
<polyline fill="none" stroke="black" points="178,-62.5 324,-62.5 "/>
<text text-anchor="middle" x="251" y="-47.3" font-family="Times,serif" font-size="14.00">2: c2 as F3</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="M251,-189.72C251,-180.97 251,-171.93 251,-163"/>
</g>
</g>
</svg>