group-by-distinct-after.svg 2.8 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253
  1. <?xml version="1.0" encoding="UTF-8" standalone="no"?>
  2. <!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN"
  3. "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd">
  4. <!-- Generated by graphviz version 2.43.0 (0)
  5. -->
  6. <!-- Title: G Pages: 1 -->
  7. <svg width="479pt" height="300pt"
  8. viewBox="0.00 0.00 479.00 299.59" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink">
  9. <g id="graph0" class="graph" transform="scale(1 1) rotate(0) translate(4 295.59)">
  10. <title>G</title>
  11. <polygon fill="white" stroke="transparent" points="-4,4 -4,-295.59 475,-295.59 475,4 -4,4"/>
  12. <text text-anchor="middle" x="161" y="-7.8" font-family="Times,serif" font-size="14.00">select a from a group by a; (after rewrites)</text>
  13. <g id="clust1" class="cluster">
  14. <title>cluster3</title>
  15. <polygon fill="none" stroke="black" points="21,-125 21,-283.59 463,-283.59 463,-125 21,-125"/>
  16. <text text-anchor="middle" x="71.5" y="-268.39" font-family="Times,serif" font-size="14.00">Box3:Select</text>
  17. </g>
  18. <g id="clust3" class="cluster">
  19. <title>cluster1</title>
  20. <polygon fill="none" stroke="black" points="8,-31 8,-117 170,-117 170,-31 8,-31"/>
  21. <text text-anchor="middle" x="80" y="-101.8" font-family="Times,serif" font-size="14.00">Box1:BaseTable A</text>
  22. </g>
  23. <!-- boxhead3 -->
  24. <g id="node1" class="node">
  25. <title>boxhead3</title>
  26. <polygon fill="none" stroke="black" points="166.5,-158.29 166.5,-227.29 455.5,-227.29 455.5,-158.29 166.5,-158.29"/>
  27. <text text-anchor="middle" x="311" y="-212.09" font-family="Times,serif" font-size="14.00">Distinct: Enforce</text>
  28. <polyline fill="none" stroke="black" points="166.5,-204.29 455.5,-204.29 "/>
  29. <text text-anchor="middle" x="311" y="-189.09" font-family="Times,serif" font-size="14.00">0: Q0.c0 as A</text>
  30. <polyline fill="none" stroke="black" points="166.5,-181.29 455.5,-181.29 "/>
  31. <text text-anchor="middle" x="311" y="-166.09" font-family="Times,serif" font-size="14.00">UNIQUE KEY [0]</text>
  32. </g>
  33. <!-- Q0 -->
  34. <g id="node2" class="node">
  35. <title>Q0</title>
  36. <ellipse fill="none" stroke="black" cx="89" cy="-192.79" rx="59.59" ry="59.59"/>
  37. <text text-anchor="middle" x="89" y="-189.09" font-family="Times,serif" font-size="14.00">Q0(F) as A</text>
  38. </g>
  39. <!-- boxhead1 -->
  40. <g id="node3" class="node">
  41. <title>boxhead1</title>
  42. <polygon fill="none" stroke="black" points="16,-39.5 16,-85.5 162,-85.5 162,-39.5 16,-39.5"/>
  43. <text text-anchor="middle" x="89" y="-70.3" font-family="Times,serif" font-size="14.00">Distinct: Preserve</text>
  44. <polyline fill="none" stroke="black" points="16,-62.5 162,-62.5 "/>
  45. <text text-anchor="middle" x="89" y="-47.3" font-family="Times,serif" font-size="14.00">0: c0 as A</text>
  46. </g>
  47. <!-- Q0&#45;&gt;boxhead1 -->
  48. <g id="edge1" class="edge">
  49. <title>Q0&#45;&gt;boxhead1</title>
  50. <path fill="none" stroke="black" stroke-dasharray="5,2" d="M89,-132.9C89,-127.6 89,-122.25 89,-117"/>
  51. </g>
  52. </g>
  53. </svg>