Materialize/doc/developer/design/static/qgm/simple-values-with-alias.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="469pt" height="490pt"
 viewBox="0.00 0.00 469.00 489.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 485.68)">
<title>G</title>
<polygon fill="white" stroke="transparent" points="-4,4 -4,-485.68 465,-485.68 465,4 -4,4"/>
<text text-anchor="middle" x="226" y="-7.8" font-family="Times,serif" font-size="14.00">select * from (values(1, 2), (3, 4)) as a(b, c); (before rewrites)</text>
<g id="clust1" class="cluster">
<title>cluster0</title>
<polygon fill="none" stroke="black" points="153,-315.09 153,-473.68 453,-473.68 453,-315.09 153,-315.09"/>
<text text-anchor="middle" x="203.5" y="-458.48" 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="48,-194 48,-307.09 302,-307.09 302,-194 48,-194"/>
<text text-anchor="middle" x="98.5" y="-291.89" font-family="Times,serif" font-size="14.00">Box2:Select</text>
</g>
<g id="clust5" class="cluster">
<title>cluster1</title>
<polygon fill="none" stroke="black" points="8,-31 8,-186 178,-186 178,-31 8,-31"/>
<text text-anchor="middle" x="60" y="-170.8" font-family="Times,serif" font-size="14.00">Box1:Values</text>
</g>
<!-- boxhead0 -->
<g id="node1" class="node">
<title>boxhead0</title>
<polygon fill="none" stroke="black" points="299,-348.39 299,-417.39 445,-417.39 445,-348.39 299,-348.39"/>
<text text-anchor="middle" x="372" y="-402.19" font-family="Times,serif" font-size="14.00">Distinct: Preserve</text>
<polyline fill="none" stroke="black" points="299,-394.39 445,-394.39 "/>
<text text-anchor="middle" x="372" y="-379.19" font-family="Times,serif" font-size="14.00">0: Q1.c0 as B</text>
<polyline fill="none" stroke="black" points="299,-371.39 445,-371.39 "/>
<text text-anchor="middle" x="372" y="-356.19" font-family="Times,serif" font-size="14.00">1: Q1.c1 as C</text>
</g>
<!-- Q1 -->
<g id="node2" class="node">
<title>Q1</title>
<ellipse fill="none" stroke="black" cx="221" cy="-382.89" rx="59.59" ry="59.59"/>
<text text-anchor="middle" x="221" y="-379.19" font-family="Times,serif" font-size="14.00">Q1(F) as A</text>
</g>
<!-- boxhead2 -->
<g id="node3" class="node">
<title>boxhead2</title>
<polygon fill="none" stroke="black" points="148,-204.55 148,-273.55 294,-273.55 294,-204.55 148,-204.55"/>
<text text-anchor="middle" x="221" y="-258.35" font-family="Times,serif" font-size="14.00">Distinct: Preserve</text>
<polyline fill="none" stroke="black" points="148,-250.55 294,-250.55 "/>
<text text-anchor="middle" x="221" y="-235.35" font-family="Times,serif" font-size="14.00">0: Q0.c0 as B</text>
<polyline fill="none" stroke="black" points="148,-227.55 294,-227.55 "/>
<text text-anchor="middle" x="221" y="-212.35" font-family="Times,serif" font-size="14.00">1: Q0.c1 as C</text>
</g>
<!-- Q1&#45;&gt;boxhead2 -->
<g id="edge1" class="edge">
<title>Q1&#45;&gt;boxhead2</title>
<path fill="none" stroke="black" stroke-dasharray="5,2" d="M221,-322.97C221,-317.73 221,-312.39 221,-307.09"/>
</g>
<!-- Q0 -->
<g id="node4" class="node">
<title>Q0</title>
<ellipse fill="none" stroke="black" cx="93" cy="-239.05" rx="37.09" ry="37.09"/>
<text text-anchor="middle" x="93" y="-235.35" font-family="Times,serif" font-size="14.00">Q0(F)</text>
</g>
<!-- boxhead1 -->
<g id="node5" class="node">
<title>boxhead1</title>
<polygon fill="none" stroke="black" points="16.5,-39.5 16.5,-154.5 169.5,-154.5 169.5,-39.5 16.5,-39.5"/>
<text text-anchor="middle" x="93" y="-139.3" font-family="Times,serif" font-size="14.00">Distinct: Preserve</text>
<polyline fill="none" stroke="black" points="16.5,-131.5 169.5,-131.5 "/>
<text text-anchor="middle" x="93" y="-116.3" font-family="Times,serif" font-size="14.00">0: c0 as COLUMN1</text>
<polyline fill="none" stroke="black" points="16.5,-108.5 169.5,-108.5 "/>
<text text-anchor="middle" x="93" y="-93.3" font-family="Times,serif" font-size="14.00">1: c1 as COLUMN2</text>
<polyline fill="none" stroke="black" points="16.5,-85.5 169.5,-85.5 "/>
<text text-anchor="middle" x="93" y="-70.3" font-family="Times,serif" font-size="14.00">1, 2</text>
<polyline fill="none" stroke="black" points="16.5,-62.5 169.5,-62.5 "/>
<text text-anchor="middle" x="93" y="-47.3" font-family="Times,serif" font-size="14.00">3, 4</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="M93,-201.98C93,-196.91 93,-191.54 93,-186"/>
</g>
</g>
</svg>