You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@calcite.apache.org by mm...@apache.org on 2017/10/02 17:08:05 UTC
svn commit: r1810559 [2/3] - in /calcite/site: docs/ downloads/ news/
news/2014/06/27/release-0.8.0-incubating/
news/2014/08/19/release-0.9.0-incubating/
news/2014/10/02/release-0.9.1-incubating/
news/2014/11/05/release-0.9.2-incubating/ news/2015/01/3...
Modified: calcite/site/docs/reference.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/reference.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/docs/reference.html (original)
+++ calcite/site/docs/reference.html Mon Oct 2 17:08:04 2017
@@ -234,7 +234,7 @@ form.</p>
<span class="o">|</span> <span class="n">query</span> <span class="k">INTERSECT</span> <span class="p">[</span> <span class="k">ALL</span> <span class="o">|</span> <span class="k">DISTINCT</span> <span class="p">]</span> <span class="n">query</span>
<span class="err">}</span>
<span class="p">[</span> <span class="k">ORDER</span> <span class="k">BY</span> <span class="n">orderItem</span> <span class="p">[,</span> <span class="n">orderItem</span> <span class="p">]</span><span class="o">*</span> <span class="p">]</span>
- <span class="p">[</span> <span class="k">LIMIT</span> <span class="err">{</span> <span class="k">count</span> <span class="o">|</span> <span class="k">ALL</span> <span class="err">}</span> <span class="p">]</span>
+ <span class="p">[</span> <span class="k">LIMIT</span> <span class="p">[</span> <span class="k">start</span><span class="p">,</span> <span class="p">]</span> <span class="err">{</span> <span class="k">count</span> <span class="o">|</span> <span class="k">ALL</span> <span class="err">}</span> <span class="p">]</span>
<span class="p">[</span> <span class="k">OFFSET</span> <span class="k">start</span> <span class="err">{</span> <span class="k">ROW</span> <span class="o">|</span> <span class="k">ROWS</span> <span class="err">}</span> <span class="p">]</span>
<span class="p">[</span> <span class="k">FETCH</span> <span class="err">{</span> <span class="k">FIRST</span> <span class="o">|</span> <span class="k">NEXT</span> <span class="err">}</span> <span class="p">[</span> <span class="k">count</span> <span class="p">]</span> <span class="err">{</span> <span class="k">ROW</span> <span class="o">|</span> <span class="k">ROWS</span> <span class="err">}</span> <span class="k">ONLY</span> <span class="p">]</span>
@@ -281,10 +281,14 @@ form.</p>
<span class="n">tablePrimary</span><span class="p">:</span>
<span class="p">[</span> <span class="p">[</span> <span class="n">catalogName</span> <span class="p">.</span> <span class="p">]</span> <span class="n">schemaName</span> <span class="p">.</span> <span class="p">]</span> <span class="n">tableName</span>
<span class="s1">'('</span> <span class="k">TABLE</span> <span class="p">[</span> <span class="p">[</span> <span class="n">catalogName</span> <span class="p">.</span> <span class="p">]</span> <span class="n">schemaName</span> <span class="p">.</span> <span class="p">]</span> <span class="n">tableName</span> <span class="s1">')'</span>
+ <span class="o">|</span> <span class="n">tablePrimary</span> <span class="p">[</span> <span class="n">EXTEND</span> <span class="p">]</span> <span class="s1">'('</span> <span class="n">columnDecl</span> <span class="p">[,</span> <span class="n">columnDecl</span> <span class="p">]</span><span class="o">*</span> <span class="s1">')'</span>
<span class="o">|</span> <span class="p">[</span> <span class="k">LATERAL</span> <span class="p">]</span> <span class="s1">'('</span> <span class="n">query</span> <span class="s1">')'</span>
<span class="o">|</span> <span class="k">UNNEST</span> <span class="s1">'('</span> <span class="n">expression</span> <span class="s1">')'</span> <span class="p">[</span> <span class="k">WITH</span> <span class="k">ORDINALITY</span> <span class="p">]</span>
<span class="o">|</span> <span class="p">[</span> <span class="k">LATERAL</span> <span class="p">]</span> <span class="k">TABLE</span> <span class="s1">'('</span> <span class="p">[</span> <span class="k">SPECIFIC</span> <span class="p">]</span> <span class="n">functionName</span> <span class="s1">'('</span> <span class="n">expression</span> <span class="p">[,</span> <span class="n">expression</span> <span class="p">]</span><span class="o">*</span> <span class="s1">')'</span> <span class="s1">')'</span>
+<span class="n">columnDecl</span><span class="p">:</span>
+ <span class="k">column</span> <span class="k">type</span> <span class="p">[</span> <span class="k">NOT</span> <span class="k">NULL</span> <span class="p">]</span>
+
<span class="k">values</span><span class="p">:</span>
<span class="k">VALUES</span> <span class="n">expression</span> <span class="p">[,</span> <span class="n">expression</span> <span class="p">]</span><span class="o">*</span>
@@ -319,6 +323,11 @@ columns as the target table, except in c
<p>In <em>merge</em>, at least one of the WHEN MATCHED and WHEN NOT MATCHED clauses must
be present.</p>
+<p><em>tablePrimary</em> may only contain an EXTEND clause in certain
+<a href="/apidocs/org/apache/calcite/sql/validate/SqlConformance.html#allowExtend--">conformance levels</a>;
+in those same conformance levels, any <em>column</em> in <em>insert</em> may be replaced by
+<em>columnDecl</em>, which has a similar effect to including it in an EXTEND clause.</p>
+
<p>In <em>orderItem</em>, if <em>expression</em> is a positive integer <em>n</em>, it denotes
the <em>n</em>th item in the SELECT clause.</p>
@@ -354,6 +363,10 @@ but is not standard SQL and is only allo
<p>CROSS APPLY and OUTER APPLY are only allowed in certain
<a href="/apidocs/org/apache/calcite/sql/validate/SqlConformance.html#isApplyAllowed--">conformance levels</a>.</p>
+<p>âLIMIT start, countâ is equivalent to âLIMIT count OFFSET startâ
+but is only allowed in certain
+<a href="/apidocs/org/apache/calcite/sql/validate/SqlConformance.html#isLimitStartCountAllowed--">conformance levels</a>.</p>
+
<h2 id="keywords">Keywords</h2>
<p>The following is a list of SQL keywords.
@@ -573,6 +586,7 @@ FRAC_SECOND,
G,
GENERAL,
GENERATED,
+GEOMETRY,
<strong>GET</strong>,
<strong>GLOBAL</strong>,
GO,
@@ -1029,7 +1043,7 @@ name will have been converted to upper c
<tr>
<th style="text-align: left">Data type</th>
<th style="text-align: left">Description</th>
- <th style="text-align: left">Range and examples</th>
+ <th style="text-align: left">Range and example literals</th>
</tr>
</thead>
<tbody>
@@ -1114,6 +1128,11 @@ name will have been converted to upper c
<td style="text-align: left">Example: TIMESTAMP â1969-07-20 20:17:40â</td>
</tr>
<tr>
+ <td style="text-align: left">TIMESTAMP WITH LOCAL TIME ZONE</td>
+ <td style="text-align: left">Date and time with local time zone</td>
+ <td style="text-align: left">Example: TIMESTAMP â1969-07-20 20:17:40 America/Los Angelesâ</td>
+ </tr>
+ <tr>
<td style="text-align: left">TIMESTAMP WITH TIME ZONE</td>
<td style="text-align: left">Date and time with time zone</td>
<td style="text-align: left">Example: TIMESTAMP â1969-07-20 20:17:40 America/Los Angelesâ</td>
@@ -1121,7 +1140,12 @@ name will have been converted to upper c
<tr>
<td style="text-align: left">INTERVAL timeUnit [ TO timeUnit ]</td>
<td style="text-align: left">Date time interval</td>
- <td style="text-align: left">Examples: INTERVAL â1:5â YEAR TO MONTH, INTERVAL â45â DAY</td>
+ <td style="text-align: left">Examples: INTERVAL â1-5â YEAR TO MONTH, INTERVAL â45â DAY, INTERVAL â1 2:34:56.789â DAY TO SECOND</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">GEOMETRY</td>
+ <td style="text-align: left">Geometry</td>
+ <td style="text-align: left">Examples: ST_GeomFromText(âPOINT (30 10)â)</td>
</tr>
</tbody>
</table>
@@ -1134,9 +1158,13 @@ name will have been converted to upper c
<p>Note:</p>
<ul>
- <li>DATE, TIME and TIMESTAMP have no time zone. There is not even an implicit
-time zone, such as UTC (as in Java) or the local time zone. It is left to
-the user or application to supply a time zone.</li>
+ <li>DATE, TIME and TIMESTAMP have no time zone. For those types, there is not
+even an implicit time zone, such as UTC (as in Java) or the local time zone.
+It is left to the user or application to supply a time zone. In turn,
+TIMESTAMP WITH LOCAL TIME ZONE does not store the time zone internally, but
+it will rely on the supplied time zone to provide correct semantics.</li>
+ <li>GEOMETRY is allowed only in certain
+<a href="/apidocs/org/apache/calcite/sql/validate/SqlConformance.html#allowGeometry--">conformance levels</a>.</li>
</ul>
<h3 id="non-scalar-types">Non-scalar types</h3>
@@ -1176,6 +1204,93 @@ the user or application to supply a time
</tbody>
</table>
+<h3 id="spatial-types">Spatial types</h3>
+
+<p>Spatial data is represented as character strings encoded as
+<a href="https://en.wikipedia.org/wiki/Well-known_text">well-known text (WKT)</a>
+or binary strings encoded as
+<a href="https://en.wikipedia.org/wiki/Well-known_binary">well-known binary (WKB)</a>.</p>
+
+<p>Where you would use a literal, apply the <code class="highlighter-rouge">ST_GeomFromText</code> function,
+for example <code class="highlighter-rouge">ST_GeomFromText('POINT (30 10)')</code>.</p>
+
+<table>
+ <thead>
+ <tr>
+ <th style="text-align: left">Data type</th>
+ <th style="text-align: left">Type code</th>
+ <th style="text-align: left">Examples in WKT</th>
+ </tr>
+ </thead>
+ <tbody>
+ <tr>
+ <td style="text-align: left">GEOMETRY</td>
+ <td style="text-align: left">0</td>
+ <td style="text-align: left">generalization of Point, Curve, Surface, GEOMETRYCOLLECTION</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">POINT</td>
+ <td style="text-align: left">1</td>
+ <td style="text-align: left"><tt>ST_GeomFromText(ââPOINT (30 10)â)</tt> is a point in 2D space; <tt>ST_GeomFromText(ââPOINT Z(30 10 2)â)</tt> is point in 3D space</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">CURVE</td>
+ <td style="text-align: left">13</td>
+ <td style="text-align: left">generalization of LINESTRING</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">LINESTRING</td>
+ <td style="text-align: left">2</td>
+ <td style="text-align: left"><tt>ST_GeomFromText(ââLINESTRING (30 10, 10 30, 40 40)â)</tt></td>
+ </tr>
+ <tr>
+ <td style="text-align: left">SURFACE</td>
+ <td style="text-align: left">14</td>
+ <td style="text-align: left">generalization of Polygon, PolyhedralSurface</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">POLYGON</td>
+ <td style="text-align: left">3</td>
+ <td style="text-align: left"><tt>ST_GeomFromText(ââPOLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))â)</tt> is a pentagon; <tt>ST_GeomFromText(ââPOLYGON ((35 10, 45 45, 15 40, 10 20, 35 10), (20 30, 35 35, 30 20, 20 30))â)</tt> is a pentagon with a quadrilateral hole</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">POLYHEDRALSURFACE</td>
+ <td style="text-align: left">15</td>
+ <td style="text-align: left">Â </td>
+ </tr>
+ <tr>
+ <td style="text-align: left">GEOMETRYCOLLECTION</td>
+ <td style="text-align: left">7</td>
+ <td style="text-align: left">a collection of zero or more GEOMETRY instances; a generalization of MULTIPOINT, MULTILINESTRING, MULTIPOLYGON</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">MULTIPOINT</td>
+ <td style="text-align: left">4</td>
+ <td style="text-align: left"><tt>ST_GeomFromText(ââMULTIPOINT ((10 40), (40 30), (20 20), (30 10))â)</tt> is equivalent to <tt>ST_GeomFromText(ââMULTIPOINT (10 40, 40 30, 20 20, 30 10)â)</tt></td>
+ </tr>
+ <tr>
+ <td style="text-align: left">MULTICURVE</td>
+ <td style="text-align: left">-</td>
+ <td style="text-align: left">generalization of MULTILINESTRING</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">MULTILINESTRING</td>
+ <td style="text-align: left">5</td>
+ <td style="text-align: left"><tt>ST_GeomFromText(ââMULTILINESTRING ((10 10, 20 20, 10 40), (40 40, 30 30, 40 20, 30 10))â)</tt></td>
+ </tr>
+ <tr>
+ <td style="text-align: left">MULTISURFACE</td>
+ <td style="text-align: left">-</td>
+ <td style="text-align: left">generalization of MULTIPOLYGON</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">MULTIPOLYGON</td>
+ <td style="text-align: left">6</td>
+ <td style="text-align: left"><tt>ST_GeomFromText(`ââMULTIPOLYGON (((30 20, 45 40, 10 40, 30 20)), ((15 5, 40 10, 10 20, 5 10, 15 5)))â)</tt></td>
+ </tr>
+ </tbody>
+</table>
+
<h2 id="operators-and-functions">Operators and functions</h2>
<h3 id="operator-precedence">Operator precedence</h3>
@@ -1203,7 +1318,7 @@ the user or application to supply a time
<td style="text-align: left">right</td>
</tr>
<tr>
- <td style="text-align: left">* /</td>
+ <td style="text-align: left">* / %</td>
<td style="text-align: left">left</td>
</tr>
<tr>
@@ -1332,12 +1447,32 @@ the user or application to supply a time
<td style="text-align: left">Whether <em>value</em> is not equal to every row returned by <em>sub-query</em></td>
</tr>
<tr>
+ <td style="text-align: left">value comparison SOME (sub-query)</td>
+ <td style="text-align: left">Whether <em>value</em> <em>comparison</em> at least one row returned by <em>sub-query</em></td>
+ </tr>
+ <tr>
+ <td style="text-align: left">value comparison ANY (sub-query)</td>
+ <td style="text-align: left">Synonym for SOME</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">value comparison ALL (sub-query)</td>
+ <td style="text-align: left">Whether <em>value</em> <em>comparison</em> every row returned by <em>sub-query</em></td>
+ </tr>
+ <tr>
<td style="text-align: left">EXISTS (sub-query)</td>
<td style="text-align: left">Whether <em>sub-query</em> returns at least one row</td>
</tr>
</tbody>
</table>
+<figure class="highlight"><pre><code class="language-sql" data-lang="sql"><span class="n">comp</span><span class="p">:</span>
+ <span class="o">=</span>
+ <span class="o">|</span> <span class="o"><></span>
+ <span class="o">|</span> <span class="o">></span>
+ <span class="o">|</span> <span class="o">>=</span>
+ <span class="o">|</span> <span class="o"><</span>
+ <span class="o">|</span> <span class="o"><=</span></code></pre></figure>
+
<h3 id="logical-operators">Logical operators</h3>
<table>
@@ -1402,7 +1537,7 @@ the user or application to supply a time
<td style="text-align: left">Returns <em>numeric</em></td>
</tr>
<tr>
- <td style="text-align: left">:- numeric</td>
+ <td style="text-align: left">- numeric</td>
<td style="text-align: left">Returns negative <em>numeric</em></td>
</tr>
<tr>
@@ -1422,6 +1557,10 @@ the user or application to supply a time
<td style="text-align: left">Returns <em>numeric1</em> divided by <em>numeric2</em></td>
</tr>
<tr>
+ <td style="text-align: left">numeric1 % numeric2</td>
+ <td style="text-align: left">As <em>MOD(numeric1, numeric2)</em> (only in certain <a href="/apidocs/org/apache/calcite/sql/validate/SqlConformance.html#isPercentRemainderAllowed--">conformance levels</a>)</td>
+ </tr>
+ <tr>
<td style="text-align: left">POWER(numeric1, numeric2)</td>
<td style="text-align: left">Returns <em>numeric1</em> raised to the power of <em>numeric2</em></td>
</tr>
@@ -1430,7 +1569,7 @@ the user or application to supply a time
<td style="text-align: left">Returns the absolute value of <em>numeric</em></td>
</tr>
<tr>
- <td style="text-align: left">MOD(numeric, numeric)</td>
+ <td style="text-align: left">MOD(numeric1, numeric2)</td>
<td style="text-align: left">Returns the remainder (modulus) of <em>numeric1</em> divided by <em>numeric2</em>. The result is negative only if <em>numeric1</em> is negative</td>
</tr>
<tr>
@@ -1502,8 +1641,8 @@ the user or application to supply a time
<td style="text-align: left">Converts <em>numeric</em> from degrees to radians</td>
</tr>
<tr>
- <td style="text-align: left">ROUND(numeric1, numeric2)</td>
- <td style="text-align: left">Rounds <em>numeric1</em> to <em>numeric2</em> places right to the decimal point</td>
+ <td style="text-align: left">ROUND(numeric1 [, numeric2])</td>
+ <td style="text-align: left">Rounds <em>numeric1</em> to optionally <em>numeric2</em> (if not specified 0) places right to the decimal point</td>
</tr>
<tr>
<td style="text-align: left">SIGN(numeric)</td>
@@ -1518,8 +1657,8 @@ the user or application to supply a time
<td style="text-align: left">Returns the tangent of <em>numeric</em></td>
</tr>
<tr>
- <td style="text-align: left">TRUNCATE(numeric1, numeric2)</td>
- <td style="text-align: left">Truncates <em>numeric1</em> to <em>numeric2</em> places right to the decimal point</td>
+ <td style="text-align: left">TRUNCATE(numeric1 [, numeric2])</td>
+ <td style="text-align: left">Truncates <em>numeric1</em> to optionally <em>numeric2</em> (if not specified 0) places right to the decimal point</td>
</tr>
</tbody>
</table>
@@ -2556,7 +2695,558 @@ by a grouped window function.</p>
</tbody>
</table>
-<h3 id="user-defined-functions">User-defined functions</h3>
+<h3 id="spatial-functions">Spatial functions</h3>
+
+<p>In the following:</p>
+
+<ul>
+ <li><em>geom</em> is a GEOMETRY;</li>
+ <li><em>geomCollection</em> is a GEOMETRYCOLLECTION;</li>
+ <li><em>point</em> is a POINT;</li>
+ <li><em>lineString</em> is a LINESTRING;</li>
+ <li><em>iMatrix</em> is a <a href="https://en.wikipedia.org/wiki/DE-9IM">DE-9IM intersection matrix</a>;</li>
+ <li><em>distance</em>, <em>tolerance</em>, <em>segmentLengthFraction</em>, <em>offsetDistance</em> are of type double;</li>
+ <li><em>dimension</em>, <em>quadSegs</em>, <em>srid</em>, <em>zoom</em> are of type integer;</li>
+ <li><em>layerType</em> is a character string;</li>
+ <li><em>gml</em> is a character string containing <a href="https://en.wikipedia.org/wiki/Geography_Markup_Language">Geography Markup Language (GML)</a>;</li>
+ <li><em>wkt</em> is a character string containing <a href="https://en.wikipedia.org/wiki/Well-known_text">well-known text (WKT)</a>;</li>
+ <li><em>wkb</em> is a binary string containing <a href="https://en.wikipedia.org/wiki/Well-known_binary">well-known binary (WKB)</a>.</li>
+</ul>
+
+<p>In the âCâ (for âcompatibilityâ) column, âoâ indicates that the function
+implements the OpenGIS Simple Features Implementation Specification for SQL,
+<a href="http://www.opengeospatial.org/standards/sfs">version 1.2.1</a>;
+âpâ indicates that the function is a
+<a href="http://www.postgis.net/docs/reference.html">PostGIS</a> extension to OpenGIS.</p>
+
+<h4 id="geometry-conversion-functions-2d">Geometry conversion functions (2D)</h4>
+
+<table>
+ <thead>
+ <tr>
+ <th style="text-align: left">C</th>
+ <th style="text-align: left">Operator syntax</th>
+ <th style="text-align: left">Description</th>
+ </tr>
+ </thead>
+ <tbody>
+ <tr>
+ <td style="text-align: left">p</td>
+ <td style="text-align: left">ST_AsText(geom)</td>
+ <td style="text-align: left">Alias for <code class="highlighter-rouge">ST_AsWKT</code></td>
+ </tr>
+ <tr>
+ <td style="text-align: left">o</td>
+ <td style="text-align: left">ST_AsWKT(geom)</td>
+ <td style="text-align: left">Converts <em>geom</em> â WKT</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">o</td>
+ <td style="text-align: left">ST_GeomFromText(wkt [, srid ])</td>
+ <td style="text-align: left">Returns a specified GEOMETRY value from WKT representation</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">o</td>
+ <td style="text-align: left">ST_LineFromText(wkt [, srid ])</td>
+ <td style="text-align: left">Converts WKT â LINESTRING</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">o</td>
+ <td style="text-align: left">ST_MLineFromText(wkt [, srid ])</td>
+ <td style="text-align: left">Converts WKT â MULTILINESTRING</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">o</td>
+ <td style="text-align: left">ST_MPointFromText(wkt [, srid ])</td>
+ <td style="text-align: left">Converts WKT â MULTIPOINT</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">o</td>
+ <td style="text-align: left">ST_MPolyFromText(wkt [, srid ]) Converts WKT â MULTIPOLYGON</td>
+ <td style="text-align: left">Â </td>
+ </tr>
+ <tr>
+ <td style="text-align: left">o</td>
+ <td style="text-align: left">ST_PointFromText(wkt [, srid ])</td>
+ <td style="text-align: left">Converts WKT â POINT</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">o</td>
+ <td style="text-align: left">ST_PolyFromText(wkt [, srid ])</td>
+ <td style="text-align: left">Converts WKT â POLYGON</td>
+ </tr>
+ </tbody>
+</table>
+
+<p>Not implemented:</p>
+
+<ul>
+ <li>ST_AsBinary(geom) GEOMETRY â WKB</li>
+ <li>ST_AsGML(geom) GEOMETRY â GML</li>
+ <li>ST_Force2D(geom) 3D GEOMETRY â 2D GEOMETRY</li>
+ <li>ST_GeomFromGML(gml [, srid ]) GML â GEOMETRY</li>
+ <li>ST_GeomFromWKB(wkb [, srid ]) WKB â GEOMETRY</li>
+ <li>ST_GoogleMapLink(geom [, layerType [, zoom ]]) GEOMETRY â Google map link</li>
+ <li>ST_LineFromWKB(wkb [, srid ]) WKB â LINESTRING</li>
+ <li>ST_OSMMapLink(geom [, marker ]) GEOMETRY â OSM map link</li>
+ <li>ST_PointFromWKB(wkb [, srid ]) WKB â POINT</li>
+ <li>ST_PolyFromWKB(wkb [, srid ]) WKB â POLYGON</li>
+ <li>ST_ToMultiLine(geom) Converts the coordinates of <em>geom</em> (which may be a GEOMETRYCOLLECTION) into a MULTILINESTRING</li>
+ <li>ST_ToMultiPoint(geom)) Converts the coordinates of <em>geom</em> (which may be a GEOMETRYCOLLECTION) into a MULTIPOINT</li>
+ <li>ST_ToMultiSegments(geom) Converts <em>geom</em> (which may be a GEOMETRYCOLLECTION) into a set of distinct segments stored in a MULTILINESTRING</li>
+</ul>
+
+<h4 id="geometry-conversion-functions-3d">Geometry conversion functions (3D)</h4>
+
+<p>Not implemented:</p>
+
+<ul>
+ <li>ST_Force3D(geom) 2D GEOMETRY â 3D GEOMETRY</li>
+</ul>
+
+<h4 id="geometry-creation-functions-2d">Geometry creation functions (2D)</h4>
+
+<table>
+ <thead>
+ <tr>
+ <th style="text-align: left">C</th>
+ <th style="text-align: left">Operator syntax</th>
+ <th style="text-align: left">Description</th>
+ </tr>
+ </thead>
+ <tbody>
+ <tr>
+ <td style="text-align: left">o</td>
+ <td style="text-align: left">ST_MakeLine(point1 [, point ]*)</td>
+ <td style="text-align: left">Creates a line-string from the given POINTs (or MULTIPOINTs)</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">p</td>
+ <td style="text-align: left">ST_MakePoint(x, y [, z ])</td>
+ <td style="text-align: left">Alias for <code class="highlighter-rouge">ST_Point</code></td>
+ </tr>
+ <tr>
+ <td style="text-align: left">o</td>
+ <td style="text-align: left">ST_Point(x, y [, z ])</td>
+ <td style="text-align: left">Constructs a point from two or three coordinates</td>
+ </tr>
+ </tbody>
+</table>
+
+<p>Not implemented:</p>
+
+<ul>
+ <li>ST_BoundingCircle(geom) Returns the minimum bounding circle of <em>geom</em></li>
+ <li>ST_Expand(geom, distance) Expands <em>geom</em>âs envelope</li>
+ <li>ST_Expand(geom, deltaX, deltaY) Expands <em>geom</em>âs envelope</li>
+ <li>ST_MakeEllipse(point, width, height) Constructs an ellipse</li>
+ <li>ST_MakeEnvelope(xMin, yMin, xMax, yMax [, srid ]) Creates a rectangular POLYGON</li>
+ <li>ST_MakeGrid(geom, deltaX, deltaY) Calculates a regular grid of POLYGONs based on <em>geom</em></li>
+ <li>ST_MakeGridPoints(geom, deltaX, deltaY) Calculates a regular grid of points based on <em>geom</em></li>
+ <li>ST_MakePolygon(lineString [, hole ]<em>) Creates a POLYGON from *lineString</em> with the given holes (which are required to be closed LINESTRINGs)</li>
+ <li>ST_MinimumDiameter(geom) Returns the minimum diameter of <em>geom</em></li>
+ <li>ST_MinimumRectangle(geom) Returns the minimum rectangle enclosing <em>geom</em></li>
+ <li>ST_OctogonalEnvelope(geom) Returns the octogonal envelope of <em>geom</em></li>
+ <li>ST_RingBuffer(geom, distance, bufferCount [, endCapStyle [, doDifference]]) Returns a MULTIPOLYGON of buffers centered at <em>geom</em> and of increasing buffer size</li>
+</ul>
+
+<h3 id="geometry-creation-functions-3d">Geometry creation functions (3D)</h3>
+
+<p>Not implemented:</p>
+
+<ul>
+ <li>ST_Extrude(geom, height [, flag]) Extrudes a GEOMETRY</li>
+ <li>ST_GeometryShadow(geom, point, height) Computes the shadow footprint of <em>geom</em></li>
+ <li>ST_GeometryShadow(geom, azimuth, altitude, height [, unify ]) Computes the shadow footprint of <em>geom</em></li>
+</ul>
+
+<h4 id="geometry-properties-2d">Geometry properties (2D)</h4>
+
+<table>
+ <thead>
+ <tr>
+ <th style="text-align: left">C</th>
+ <th style="text-align: left">Operator syntax</th>
+ <th style="text-align: left">Description</th>
+ </tr>
+ </thead>
+ <tbody>
+ <tr>
+ <td style="text-align: left">o</td>
+ <td style="text-align: left">ST_Boundary(geom [, srid ])</td>
+ <td style="text-align: left">Returns the boundary of <em>geom</em></td>
+ </tr>
+ <tr>
+ <td style="text-align: left">o</td>
+ <td style="text-align: left">ST_Distance(geom1, geom2)</td>
+ <td style="text-align: left">Returns the distance between <em>geom1</em> and <em>geom2</em></td>
+ </tr>
+ <tr>
+ <td style="text-align: left">o</td>
+ <td style="text-align: left">ST_GeometryType(geom)</td>
+ <td style="text-align: left">Returns the type of <em>geom</em></td>
+ </tr>
+ <tr>
+ <td style="text-align: left">o</td>
+ <td style="text-align: left">ST_GeometryTypeCode(geom)</td>
+ <td style="text-align: left">Returns the OGC SFS type code of <em>geom</em></td>
+ </tr>
+ <tr>
+ <td style="text-align: left">o</td>
+ <td style="text-align: left">ST_Envelope(geom [, srid ])</td>
+ <td style="text-align: left">Returns the envelope of <em>geom</em> (which may be a GEOMETRYCOLLECTION) as a GEOMETRY</td>
+ </tr>
+ </tbody>
+</table>
+
+<p>Not implemented:</p>
+
+<ul>
+ <li>ST_Centroid(geom) Returns the centroid of <em>geom</em> (which may be a GEOMETRYCOLLECTION)</li>
+ <li>ST_CompactnessRatio(polygon) Returns the square root of <em>polygon</em>âs area divided by the area of the circle with circumference equal to its perimeter</li>
+ <li>ST_CoordDim(geom) Returns the dimension of the coordinates of <em>geom</em></li>
+ <li>ST_Dimension(geom) Returns the dimension of <em>geom</em></li>
+ <li>ST_EndPoint(lineString) Returns the last coordinate of <em>lineString</em></li>
+ <li>ST_Envelope(geom [, srid ]) Returns the envelope of <em>geom</em> (which may be a GEOMETRYCOLLECTION) as a GEOMETRY</li>
+ <li>ST_Explode(query [, fieldName]) Explodes the GEOMETRYCOLLECTIONs in the <em>fieldName</em> column of a query into multiple geometries</li>
+ <li>ST_Extent(geom) Returns the minimum bounding box of <em>geom</em> (which may be a GEOMETRYCOLLECTION)</li>
+ <li>ST_ExteriorRing(polygon) Returns the exterior ring of <em>polygon</em> as a linear-ring</li>
+ <li>ST_GeometryN(geomCollection, n) Returns the <em>n</em>th GEOMETRY of <em>geomCollection</em></li>
+ <li>ST_InteriorRingN(polygon, n) Returns the <em>n</em>th interior ring of <em>polygon</em></li>
+ <li>ST_IsClosed(geom) Returns whether <em>geom</em> is a closed LINESTRING or MULTILINESTRING</li>
+ <li>ST_IsEmpty(geom) Returns whether <em>geom</em> is empty</li>
+ <li>ST_IsRectangle(geom) Returns whether <em>geom</em> is a rectangle</li>
+ <li>ST_IsRing(geom) Returns whether <em>geom</em> is a closed and simple line-string or MULTILINESTRING</li>
+ <li>ST_IsSimple(geom) Returns whether <em>geom</em> is simple</li>
+ <li>ST_IsValid(geom) Returns whether <em>geom</em> is valid</li>
+ <li>ST_IsValidDetail(geom [, selfTouchValid ]) Returns a valid detail as an array of objects</li>
+ <li>ST_IsValidReason(geom [, selfTouchValid ]) Returns text stating whether <em>geom</em> is valid, and if not valid, a reason why</li>
+ <li>ST_NPoints(geom) Returns the number of points in <em>geom</em></li>
+ <li>ST_NumGeometries(geom) Returns the number of geometries in <em>geom</em> (1 if it is not a GEOMETRYCOLLECTION)</li>
+ <li>ST_NumInteriorRing(geom) Alias for <code class="highlighter-rouge">ST_NumInteriorRings</code></li>
+ <li>ST_NumInteriorRings(geom) Returns the number of interior rings of <em>geom</em></li>
+ <li>ST_NumPoints(lineString) Returns the number of points in <em>lineString</em></li>
+ <li>ST_PointN(geom, n) Returns the <em>n</em>th point of a <em>lineString</em></li>
+ <li>ST_PointOnSurface(geom) Returns an interior or boundary point of <em>geom</em></li>
+ <li>ST_SRID(geom) Returns SRID value of <em>geom</em> or 0 if it does not have one</li>
+ <li>ST_StartPoint(lineString) Returns the first coordinate of <em>lineString</em></li>
+ <li>ST_X(geom) Returns the x-value of the first coordinate of <em>geom</em></li>
+ <li>ST_XMax(geom) Returns the maximum x-value of <em>geom</em></li>
+ <li>ST_XMin(geom) Returns the minimum x-value of <em>geom</em></li>
+ <li>ST_Y(geom) Returns the y-value of the first coordinate of <em>geom</em></li>
+ <li>ST_YMax(geom) Returns the maximum y-value of <em>geom</em></li>
+ <li>ST_YMin(geom) Returns the minimum y-value of <em>geom</em></li>
+</ul>
+
+<h4 id="geometry-properties-3d">Geometry properties (3D)</h4>
+
+<table>
+ <thead>
+ <tr>
+ <th style="text-align: left">C</th>
+ <th style="text-align: left">Operator syntax</th>
+ <th style="text-align: left">Description</th>
+ </tr>
+ </thead>
+ <tbody>
+ <tr>
+ <td style="text-align: left">p</td>
+ <td style="text-align: left">ST_Is3D(s)</td>
+ <td style="text-align: left">Returns whether <em>geom</em> has at least one z-coordinate</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">o</td>
+ <td style="text-align: left">ST_Z(geom)</td>
+ <td style="text-align: left">Returns the z-value of the first coordinate of <em>geom</em></td>
+ </tr>
+ </tbody>
+</table>
+
+<p>Not implemented:</p>
+
+<ul>
+ <li>ST_ZMax(geom) Returns the maximum z-value of <em>geom</em></li>
+ <li>ST_ZMin(geom) Returns the minimum z-value of <em>geom</em></li>
+</ul>
+
+<h3 id="geometry-predicates">Geometry predicates</h3>
+
+<table>
+ <thead>
+ <tr>
+ <th style="text-align: left">C</th>
+ <th style="text-align: left">Operator syntax</th>
+ <th style="text-align: left">Description</th>
+ </tr>
+ </thead>
+ <tbody>
+ <tr>
+ <td style="text-align: left">o</td>
+ <td style="text-align: left">ST_Contains(geom1, geom2)</td>
+ <td style="text-align: left">Returns whether <em>geom1</em> contains <em>geom2</em></td>
+ </tr>
+ <tr>
+ <td style="text-align: left">p</td>
+ <td style="text-align: left">ST_ContainsProperly(geom1, geom2)</td>
+ <td style="text-align: left">Returns whether <em>geom1</em> contains <em>geom2</em> but does not intersect its boundary</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">o</td>
+ <td style="text-align: left">ST_Crosses(geom1, geom2)</td>
+ <td style="text-align: left">Returns whether <em>geom1</em> crosses <em>geom2</em></td>
+ </tr>
+ <tr>
+ <td style="text-align: left">o</td>
+ <td style="text-align: left">ST_Disjoint(geom1, geom2)</td>
+ <td style="text-align: left">Returns whether <em>geom1</em> and <em>geom2</em> are disjoint</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">p</td>
+ <td style="text-align: left">ST_DWithin(geom1, geom2, distance)</td>
+ <td style="text-align: left">Returns whether <em>geom1</em> and <em>geom</em> are within <em>distance</em> of one another</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">o</td>
+ <td style="text-align: left">ST_EnvelopesIntersect(geom1, geom2)</td>
+ <td style="text-align: left">Returns whether the envelope of <em>geom1</em> intersects the envelope of <em>geom2</em></td>
+ </tr>
+ <tr>
+ <td style="text-align: left">o</td>
+ <td style="text-align: left">ST_Equals(geom1, geom2)</td>
+ <td style="text-align: left">Returns whether <em>geom1</em> equals <em>geom2</em></td>
+ </tr>
+ <tr>
+ <td style="text-align: left">o</td>
+ <td style="text-align: left">ST_Intersects(geom1, geom2)</td>
+ <td style="text-align: left">Returns whether <em>geom1</em> intersects <em>geom2</em></td>
+ </tr>
+ <tr>
+ <td style="text-align: left">o</td>
+ <td style="text-align: left">ST_Overlaps(geom1, geom2)</td>
+ <td style="text-align: left">Returns whether <em>geom1</em> overlaps <em>geom2</em></td>
+ </tr>
+ <tr>
+ <td style="text-align: left">o</td>
+ <td style="text-align: left">ST_Touches(geom1, geom2)</td>
+ <td style="text-align: left">Returns whether <em>geom1</em> touches <em>geom2</em></td>
+ </tr>
+ <tr>
+ <td style="text-align: left">o</td>
+ <td style="text-align: left">ST_Within(geom1, geom2)</td>
+ <td style="text-align: left">Returns whether <em>geom1</em> is within <em>geom2</em></td>
+ </tr>
+ </tbody>
+</table>
+
+<p>Not implemented:</p>
+
+<ul>
+ <li>ST_Covers(geom1, geom2) Returns whether no point in <em>geom2</em> is outside <em>geom1</em></li>
+ <li>ST_OrderingEquals(geom1, geom2) Returns whether <em>geom1</em> equals <em>geom2</em> and their coordinates and component Geometries are listed in the same order</li>
+ <li>ST_Relate(geom1, geom2) Returns the DE-9IM intersection matrix of <em>geom1</em> and <em>geom2</em></li>
+ <li>ST_Relate(geom1, geom2, iMatrix) Returns whether <em>geom1</em> and <em>geom2</em> are related by the given intersection matrix <em>iMatrix</em></li>
+</ul>
+
+<h4 id="geometry-operators-2d">Geometry operators (2D)</h4>
+
+<p>The following functions combine 2D geometries.</p>
+
+<table>
+ <thead>
+ <tr>
+ <th style="text-align: left">C</th>
+ <th style="text-align: left">Operator syntax</th>
+ <th style="text-align: left">Description</th>
+ </tr>
+ </thead>
+ <tbody>
+ <tr>
+ <td style="text-align: left">o</td>
+ <td style="text-align: left">ST_Buffer(geom, distance [, quadSegs | style ])</td>
+ <td style="text-align: left">Computes a buffer around <em>geom</em></td>
+ </tr>
+ <tr>
+ <td style="text-align: left">o</td>
+ <td style="text-align: left">ST_Union(geom1, geom2)</td>
+ <td style="text-align: left">Computes the union of <em>geom1</em> and <em>geom2</em></td>
+ </tr>
+ <tr>
+ <td style="text-align: left">o</td>
+ <td style="text-align: left">ST_Union(geomCollection)</td>
+ <td style="text-align: left">Computes the union of the geometries in <em>geomCollection</em></td>
+ </tr>
+ </tbody>
+</table>
+
+<p>See also: the <code class="highlighter-rouge">ST_Union</code> aggregate function.</p>
+
+<p>Not implemented:</p>
+
+<ul>
+ <li>ST_ConvexHull(geom) Computes the smallest convex polygon that contains all the points in <em>geom</em></li>
+ <li>ST_Difference(geom1, geom2) Computes the difference between two geometries</li>
+ <li>ST_Intersection(geom1, geom2) Computes the intersection of two geometries</li>
+ <li>ST_SymDifference(geom1, geom2) Computes the symmetric difference between two geometries</li>
+</ul>
+
+<h4 id="affine-transformation-functions-3d-and-2d">Affine transformation functions (3D and 2D)</h4>
+
+<p>Not implemented:</p>
+
+<ul>
+ <li>ST_Rotate(geom, angle [, origin | x, y]) Rotates a <em>geom</em> counter-clockwise by <em>angle</em> (in radians) about <em>origin</em> (or the point (<em>x</em>, <em>y</em>))</li>
+ <li>ST_Scale(geom, xFactor, yFactor [, zFactor ]) Scales <em>geom</em> by multiplying the ordinates by the indicated scale factors</li>
+ <li>ST_Translate(geom, x, y, [, z]) Translates <em>geom</em></li>
+</ul>
+
+<h4 id="geometry-editing-functions-2d">Geometry editing functions (2D)</h4>
+
+<p>The following functions modify 2D geometries.</p>
+
+<p>Not implemented:</p>
+
+<ul>
+ <li>ST_AddPoint(geom, point [, tolerance ]) Adds <em>point</em> to <em>geom</em> with a given <em>tolerance</em> (default 0)</li>
+ <li>ST_CollectionExtract(geom, dimension) Filters <em>geom</em>, returning a multi-geometry of those members with a given <em>dimension</em> (1 = point, 2 = line-string, 3 = polygon)</li>
+ <li>ST_Densify(geom, tolerance) Inserts extra vertices every <em>tolerance</em> along the line segments of <em>geom</em></li>
+ <li>ST_FlipCoordinates(geom) Flips the X and Y coordinates of <em>geom</em></li>
+ <li>ST_Holes(geom) Returns the holes in <em>geom</em> (which may be a GEOMETRYCOLLECTION)</li>
+ <li>ST_Normalize(geom) Converts <em>geom</em> to normal form</li>
+ <li>ST_RemoveDuplicatedCoordinates(geom) Removes duplicated coordinates from <em>geom</em></li>
+ <li>ST_RemoveHoles(geom) Removes a <em>geom</em>âs holes</li>
+ <li>ST_RemovePoints(geom, poly) Removes all coordinates of <em>geom</em> located within <em>poly</em>; null if all coordinates are removed</li>
+ <li>ST_RemoveRepeatedPoints(geom, tolerance) Removes from <em>geom</em> all repeated points (or points within <em>tolerance</em> of another point)</li>
+ <li>ST_Reverse(geom) Reverses the vertex order of <em>geom</em></li>
+</ul>
+
+<h4 id="geometry-editing-functions-3d">Geometry editing functions (3D)</h4>
+
+<p>The following functions modify 3D geometries.</p>
+
+<p>Not implemented:</p>
+
+<ul>
+ <li>ST_AddZ(geom, zToAdd) Adds <em>zToAdd</em> to the z-coordinate of <em>geom</em></li>
+ <li>ST_Interpolate3DLine(geom) Returns <em>geom</em> with a interpolation of z values, or null if it is not a line-string or MULTILINESTRING</li>
+ <li>ST_MultiplyZ(geom, zFactor) Returns <em>geom</em> with its z-values multiplied by <em>zFactor</em></li>
+ <li>ST_Reverse3DLine(geom [, sortOrder ]) Potentially reverses <em>geom</em> according to the z-values of its first and last coordinates</li>
+ <li>ST_UpdateZ(geom, newZ [, updateCondition ]) Updates the z-values of <em>geom</em></li>
+ <li>ST_ZUpdateLineExtremities(geom, startZ, endZ [, interpolate ]) Updates the start and end z-values of <em>geom</em></li>
+</ul>
+
+<h4 id="geometry-measurement-functions-2d">Geometry measurement functions (2D)</h4>
+
+<p>Not implemented:</p>
+
+<ul>
+ <li>ST_Area(geom) Returns the area of <em>geom</em> (which may be a GEOMETRYCOLLECTION)</li>
+ <li>ST_ClosestCoordinate(geom, point) Returns the coordinate(s) of <em>geom</em> closest to <em>point</em></li>
+ <li>ST_ClosestPoint(geom1, geom2) Returns the point of <em>geom1</em> closest to <em>geom2</em></li>
+ <li>ST_FurthestCoordinate(geom, point) Returns the coordinate(s) of <em>geom</em> that are furthest from <em>point</em></li>
+ <li>ST_Length(lineString) Returns the length of <em>lineString</em></li>
+ <li>ST_LocateAlong(geom, segmentLengthFraction, offsetDistance) Returns a MULTIPOINT containing points along the line segments of <em>geom</em> at <em>segmentLengthFraction</em> and <em>offsetDistance</em></li>
+ <li>ST_LongestLine(geom1, geom2) Returns the 2-dimensional longest line-string between the points of <em>geom1</em> and <em>geom2</em></li>
+ <li>ST_MaxDistance(geom1, geom2) Computes the maximum distance between <em>geom1</em> and <em>geom2</em></li>
+ <li>ST_Perimeter(polygon) Returns the length of the perimeter of <em>polygon</em> (which may be a MULTIPOLYGON)</li>
+ <li>ST_ProjectPoint(point, lineString) Projects <em>point</em> onto a <em>lineString</em> (which may be a MULTILINESTRING)</li>
+</ul>
+
+<h4 id="geometry-measurement-functions-3d">Geometry measurement functions (3D)</h4>
+
+<p>Not implemented:</p>
+
+<ul>
+ <li>ST_3DArea(geom) Return a polygonâs 3D area</li>
+ <li>ST_3DLength(geom) Returns the 3D length of a line-string</li>
+ <li>ST_3DPerimeter(geom) Returns the 3D perimeter of a polygon or MULTIPOLYGON</li>
+ <li>ST_SunPosition(point [, timestamp ]) Computes the sun position at <em>point</em> and <em>timestamp</em> (now by default)</li>
+</ul>
+
+<h4 id="geometry-processing-functions-2d">Geometry processing functions (2D)</h4>
+
+<p>The following functions process geometries.</p>
+
+<p>Not implemented:</p>
+
+<ul>
+ <li>ST_LineIntersector(geom1, geom2) Splits <em>geom1</em> (a line-string) with <em>geom2</em></li>
+ <li>ST_LineMerge(geom) Merges a collection of linear components to form a line-string of maximal length</li>
+ <li>ST_MakeValid(geom [, preserveGeomDim [, preserveDuplicateCoord [, preserveCoordDim]]]) Makes <em>geom</em> valid</li>
+ <li>ST_Polygonize(geom) Creates a MULTIPOLYGON from edges of <em>geom</em></li>
+ <li>ST_PrecisionReducer(geom, n) Reduces <em>geom</em>âs precision to <em>n</em> decimal places</li>
+ <li>ST_RingSideBuffer(geom, distance, bufferCount [, endCapStyle [, doDifference]]) Computes a ring buffer on one side</li>
+ <li>ST_SideBuffer(geom, distance [, bufferStyle ]) Compute a single buffer on one side</li>
+ <li>ST_Simplify(geom, distance) Simplifies <em>geom</em> using the <a href="https://en.wikipedia.org/wiki/Ramer%E2%80%93Douglas%E2%80%93Peucker_algorithm">Douglas-Peuker algorithm</a> with a <em>distance</em> tolerance</li>
+ <li>ST_SimplifyPreserveTopology(geom) Simplifies <em>geom</em>, preserving its topology</li>
+ <li>ST_Snap(geom1, geom2, tolerance) Snaps <em>geom1</em> and <em>geom2</em> together</li>
+ <li>ST_Split(geom1, geom2 [, tolerance]) Splits <em>geom1</em> by <em>geom2</em> using <em>tolerance</em> (default 1E-6) to determine where the point splits the line</li>
+</ul>
+
+<h4 id="geometry-projection-functions">Geometry projection functions</h4>
+
+<table>
+ <thead>
+ <tr>
+ <th style="text-align: left">C</th>
+ <th style="text-align: left">Operator syntax</th>
+ <th style="text-align: left">Description</th>
+ </tr>
+ </thead>
+ <tbody>
+ <tr>
+ <td style="text-align: left">o</td>
+ <td style="text-align: left">ST_SetSRID(geom, srid)</td>
+ <td style="text-align: left">Returns a copy of <em>geom</em> with a new SRID</td>
+ </tr>
+ <tr>
+ <td style="text-align: left">o</td>
+ <td style="text-align: left">ST_Transform(geom, srid)</td>
+ <td style="text-align: left">Transforms <em>geom</em> from one coordinate reference system (CRS) to the CRS specified by <em>srid</em></td>
+ </tr>
+ </tbody>
+</table>
+
+<h4 id="trigonometry-functions">Trigonometry functions</h4>
+
+<p>Not implemented:</p>
+
+<ul>
+ <li>ST_Azimuth(point1, point2) Return the azimuth of the segment from <em>point1</em> to <em>point2</em></li>
+</ul>
+
+<h4 id="topography-functions">Topography functions</h4>
+
+<p>Not implemented:</p>
+
+<ul>
+ <li>ST_TriangleAspect(geom) Returns the aspect of a triangle</li>
+ <li>ST_TriangleContouring(query [, z1, z2, z3 ][, varArgs]*) Splits triangles into smaller triangles according to classes</li>
+ <li>ST_TriangleDirection(geom) Computes the direction of steepest ascent of a triangle and returns it as a line-string</li>
+ <li>ST_TriangleSlope(geom) Computes the slope of a triangle as a percentage</li>
+ <li>ST_Voronoi(geom [, outDimension [, envelopePolygon ]]) Creates a Voronoi diagram</li>
+</ul>
+
+<h4 id="triangulation-functions">Triangulation functions</h4>
+
+<p>Not implemented:</p>
+
+<ul>
+ <li>ST_ConstrainedDelaunay(geom [, flag [, quality ]]) Computes a constrained Delaunay triangulation based on <em>geom</em></li>
+ <li>ST_Delaunay(geom [, flag [, quality ]]) Computes a Delaunay triangulation based on points</li>
+ <li>ST_Tessellate(polygon) Tessellates <em>polygon</em> (may be MULTIPOLYGON) with adaptive triangles</li>
+</ul>
+
+<h4 id="geometry-aggregate-functions">Geometry aggregate functions</h4>
+
+<p>Not implemented:</p>
+
+<ul>
+ <li>ST_Accum(geom) Accumulates <em>geom</em> into a GEOMETRYCOLLECTION (or MULTIPOINT, MULTILINESTRING or MULTIPOLYGON if possible)</li>
+ <li>ST_Collect(geom) Alias for <code class="highlighter-rouge">ST_Accum</code></li>
+ <li>ST_Union(geom) Computes the union of geometries</li>
+</ul>
+
+<h2 id="user-defined-functions">User-defined functions</h2>
<p>Calcite is extensible. You can define each kind of function using user code.
For each kind of function there are often several ways to define a function,
@@ -2709,6 +3399,7 @@ events in complex event processing (CEP)
<span class="o">|</span> <span class="n">SKIP</span> <span class="k">TO</span> <span class="k">variable</span> <span class="p">)</span>
<span class="p">]</span>
<span class="n">PATTERN</span> <span class="s1">'('</span> <span class="n">pattern</span> <span class="s1">')'</span>
+ <span class="p">[</span> <span class="n">WITHIN</span> <span class="n">intervalLiteral</span> <span class="p">]</span>
<span class="p">[</span> <span class="n">SUBSET</span> <span class="n">subsetItem</span> <span class="p">[,</span> <span class="n">subsetItem</span> <span class="p">]</span><span class="o">*</span> <span class="p">]</span>
<span class="n">DEFINE</span> <span class="k">variable</span> <span class="k">AS</span> <span class="n">condition</span> <span class="p">[,</span> <span class="k">variable</span> <span class="k">AS</span> <span class="n">condition</span> <span class="p">]</span><span class="o">*</span>
<span class="s1">')'</span>
@@ -2744,7 +3435,10 @@ events in complex event processing (CEP)
<span class="o">|</span> <span class="s1">'?'</span>
<span class="o">|</span> <span class="s1">'??'</span>
<span class="o">|</span> <span class="s1">'{'</span> <span class="err">{</span> <span class="p">[</span> <span class="n">minRepeat</span> <span class="p">],</span> <span class="p">[</span> <span class="n">maxRepeat</span> <span class="p">]</span> <span class="err">}</span> <span class="s1">'}'</span> <span class="p">[</span><span class="s1">'?'</span><span class="p">]</span>
- <span class="o">|</span> <span class="s1">'{'</span> <span class="n">repeat</span> <span class="s1">'}'</span></code></pre></figure>
+ <span class="o">|</span> <span class="s1">'{'</span> <span class="n">repeat</span> <span class="s1">'}'</span>
+
+<span class="n">intervalLiteral</span><span class="p">:</span>
+ <span class="n">INTERVAL</span> <span class="s1">'string'</span> <span class="n">timeUnit</span> <span class="p">[</span> <span class="k">TO</span> <span class="n">timeUnit</span> <span class="p">]</span></code></pre></figure>
<p>In <em>patternQuantifier</em>, <em>repeat</em> is a positive integer,
and <em>minRepeat</em> and <em>maxRepeat</em> are non-negative integers.</p>
@@ -2787,6 +3481,9 @@ and <em>minRepeat</em> and <em>maxRepeat
+
+
+
<div class="section-nav">
<div class="left align-right">
@@ -2866,6 +3563,16 @@ and <em>minRepeat</em> and <em>maxRepeat
+
+
+
+
+
+
+ <li class=""><a href="/docs/spatial.html">Spatial</a></li>
+
+
+
Added: calcite/site/docs/spatial.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/spatial.html?rev=1810559&view=auto
==============================================================================
--- calcite/site/docs/spatial.html (added)
+++ calcite/site/docs/spatial.html Mon Oct 2 17:08:04 2017
@@ -0,0 +1,478 @@
+<!DOCTYPE HTML>
+<html lang="en-US">
+<head>
+ <meta charset="UTF-8">
+ <title>Spatial</title>
+ <meta name="viewport" content="width=device-width,initial-scale=1">
+ <meta name="generator" content="Jekyll v3.0.3">
+ <link rel="stylesheet" href="//fonts.googleapis.com/css?family=Lato:300,300italic,400,400italic,700,700italic,900">
+ <link rel="stylesheet" href="/css/screen.css">
+ <link rel="icon" type="image/x-icon" href="/favicon.ico">
+ <!--[if lt IE 9]>
+ <script src="/js/html5shiv.min.js"></script>
+ <script src="/js/respond.min.js"></script>
+ <![endif]-->
+</head>
+
+
+<body class="wrap">
+ <header role="banner">
+ <nav class="mobile-nav show-on-mobiles">
+ <ul>
+ <li class="">
+ <a href="/">Home</a>
+ </li>
+ <li class="">
+ <a href="/downloads/">Download</a>
+ </li>
+ <li class="">
+ <a href="/community/">Community</a>
+ </li>
+ <li class="">
+ <a href="/develop/">Develop</a>
+ </li>
+ <li class="">
+ <a href="/news/">News</a>
+ </li>
+ <li class="current">
+ <a href="/docs/">Docs</a>
+ </li>
+</ul>
+
+ </nav>
+ <div class="grid">
+ <div class="unit one-third center-on-mobiles">
+ <h1>
+ <a href="/">
+ <span class="sr-only">Apache Calcite</span>
+ <img src="/img/logo.png" width="226" height="140" alt="Calcite Logo">
+ </a>
+ </h1>
+ </div>
+ <nav class="main-nav unit two-thirds hide-on-mobiles">
+ <ul>
+ <li class="">
+ <a href="/">Home</a>
+ </li>
+ <li class="">
+ <a href="/downloads/">Download</a>
+ </li>
+ <li class="">
+ <a href="/community/">Community</a>
+ </li>
+ <li class="">
+ <a href="/develop/">Develop</a>
+ </li>
+ <li class="">
+ <a href="/news/">News</a>
+ </li>
+ <li class="current">
+ <a href="/docs/">Docs</a>
+ </li>
+</ul>
+
+ </nav>
+ </div>
+</header>
+
+
+ <section class="docs">
+ <div class="grid">
+
+ <div class="docs-nav-mobile unit whole show-on-mobiles">
+ <select onchange="if (this.value) window.location.href=this.value">
+ <option value="">Navigate the docsâ¦</option>
+ <optgroup label="Overview">
+ </optgroup>
+ <optgroup label="Advanced">
+ </optgroup>
+ <optgroup label="Avatica">
+ </optgroup>
+ <optgroup label="Reference">
+ </optgroup>
+ <optgroup label="Meta">
+ </optgroup>
+
+ </select>
+</div>
+
+
+ <div class="unit four-fifths">
+ <article>
+ <h1>Spatial</h1>
+ <!--
+
+-->
+
+<p>Calcite is <a href="https://issues.apache.org/jira/browse/CALCITE-1968">aiming</a> to implement
+OpenGIS Simple Features Implementation Specification for SQL,
+<a href="http://www.opengeospatial.org/standards/sfs">version 1.2.1</a>,
+a standard implemented by spatial databases such as
+<a href="http://postgis.net/">PostGIS</a>
+and <a href="http://www.h2gis.org/">H2GIS</a>.</p>
+
+<p>We also aim to add optimizer support for
+<a href="https://issues.apache.org/jira/browse/CALCITE-1861">spatial indexes</a>
+and other forms of query optimization.</p>
+
+<ul id="markdown-toc">
+ <li><a href="#introduction" id="markdown-toc-introduction">Introduction</a></li>
+ <li><a href="#acknowledgements" id="markdown-toc-acknowledgements">Acknowledgements</a></li>
+</ul>
+
+<h2 id="introduction">Introduction</h2>
+
+<p>A spatial database is a database that is optimized for storing and query data
+that represents objects defined in a geometric space.</p>
+
+<p>Calciteâs support for spatial data includes:</p>
+
+<ul>
+ <li>A <a href="reference.html#data-types">GEOMETRY</a> data type and
+<a href="reference.html#spatial-types">sub-types</a> including <code class="highlighter-rouge">POINT</code>, <code class="highlighter-rouge">LINESTRING</code>
+and <code class="highlighter-rouge">POLYGON</code></li>
+ <li><a href="reference.html#spatial-functions">Spatial functions</a> (prefixed <code class="highlighter-rouge">ST_</code>;
+we have implemented about 35 of the 150 in the OpenGIS specification)</li>
+</ul>
+
+<p>and will at some point also include query rewrites to use spatial indexes.</p>
+
+<h2 id="acknowledgements">Acknowledgements</h2>
+
+<p>Calciteâs OpenGIS implementation uses the
+<a href="https://github.com/Esri/geometry-api-java">Esri geometry API</a>. Thanks for the
+help we received from their community.</p>
+
+<p>While developing this feature, we made extensive use of the
+PostGIS documentation and tests,
+and the H2GIS documentation, and consulted both as reference implementations
+when the specification wasnât clear. Thank you to these awesome projects.</p>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <div class="section-nav">
+ <div class="left align-right">
+
+
+
+ <a href="/docs/adapter.html" class="prev">Previous</a>
+
+ </div>
+ <div class="right align-left">
+
+
+
+ <a href="/docs/stream.html" class="next">Next</a>
+
+ </div>
+ </div>
+ <div class="clear"></div>
+
+
+ </article>
+ </div>
+
+ <div class="unit one-fifth hide-on-mobiles">
+ <aside>
+
+ <h4>Overview</h4>
+
+
+<ul>
+
+
+
+
+
+
+
+
+ <li class=""><a href="/docs/index.html">Background</a></li>
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/docs/tutorial.html">Tutorial</a></li>
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/docs/algebra.html">Algebra</a></li>
+
+
+</ul>
+
+
+ <h4>Advanced</h4>
+
+
+<ul>
+
+
+
+
+
+
+
+
+ <li class=""><a href="/docs/adapter.html">Adapters</a></li>
+
+
+
+
+
+
+
+
+
+ <li class="current"><a href="/docs/spatial.html">Spatial</a></li>
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/docs/stream.html">Streaming</a></li>
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/docs/lattice.html">Lattices</a></li>
+
+
+</ul>
+
+
+ <h4>Avatica</h4>
+
+
+<ul>
+
+
+
+
+
+
+
+
+ <li class=""><a href="/docs/avatica_overview.html">Overview</a></li>
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/docs/avatica_roadmap.html">Roadmap</a></li>
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/docs/avatica_json_reference.html">JSON Reference</a></li>
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/docs/avatica_protobuf_reference.html">Protobuf Reference</a></li>
+
+
+</ul>
+
+
+ <h4>Reference</h4>
+
+
+<ul>
+
+
+
+
+
+
+
+
+ <li class=""><a href="/docs/reference.html">SQL language</a></li>
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/docs/model.html">JSON models</a></li>
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/docs/howto.html">HOWTO</a></li>
+
+
+</ul>
+
+
+ <h4>Meta</h4>
+
+
+<ul>
+
+
+
+
+
+
+
+
+ <li class=""><a href="/docs/history.html">History</a></li>
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/docs/powered_by.html">Powered by Calcite</a></li>
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/apidocs">API</a></li>
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/testapidocs">Test API</a></li>
+
+
+</ul>
+
+
+ </aside>
+</div>
+
+
+ <div class="clear"></div>
+
+ </div>
+ </section>
+
+
+ <footer role="contentinfo">
+ <div id="poweredby">
+ <a href="http://www.apache.org/">
+ <span class="sr-only">Apache</span>
+ <img src="/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
+ </div>
+ <div id="copyright">
+ <p>The contents of this website are © 2017
+ <a href="https://www.apache.org/">Apache Software Foundation</a>
+ under the terms of
+ the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
+ Apache License v2</a>. Apache Calcite and its logo are
+ trademarks of the Apache Software Foundation.</p>
+ </div>
+</footer>
+
+ <script>
+ var anchorForId = function (id) {
+ var anchor = document.createElement("a");
+ anchor.className = "header-link";
+ anchor.href = "#" + id;
+ anchor.innerHTML = "<span class=\"sr-only\">Permalink</span><i class=\"fa fa-link\"></i>";
+ anchor.title = "Permalink";
+ return anchor;
+ };
+
+ var linkifyAnchors = function (level, containingElement) {
+ var headers = containingElement.getElementsByTagName("h" + level);
+ for (var h = 0; h < headers.length; h++) {
+ var header = headers[h];
+
+ if (typeof header.id !== "undefined" && header.id !== "") {
+ header.appendChild(anchorForId(header.id));
+ }
+ }
+ };
+
+ document.onreadystatechange = function () {
+ if (this.readyState === "complete") {
+ var contentBlock = document.getElementsByClassName("docs")[0] || document.getElementsByClassName("news")[0];
+ if (!contentBlock) {
+ return;
+ }
+ for (var level = 1; level <= 6; level++) {
+ linkifyAnchors(level, contentBlock);
+ }
+ }
+ };
+</script>
+
+
+</body>
+</html>
Modified: calcite/site/docs/stream.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/stream.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/docs/stream.html (original)
+++ calcite/site/docs/stream.html Mon Oct 2 17:08:04 2017
@@ -1119,12 +1119,15 @@ MillWheel: Fault-Tolerant Stream Process
+
+
+
<div class="section-nav">
<div class="left align-right">
- <a href="/docs/adapter.html" class="prev">Previous</a>
+ <a href="/docs/spatial.html" class="prev">Previous</a>
</div>
<div class="right align-left">
@@ -1198,6 +1201,16 @@ MillWheel: Fault-Tolerant Stream Process
+
+
+
+
+
+
+ <li class=""><a href="/docs/spatial.html">Spatial</a></li>
+
+
+
Modified: calcite/site/docs/tutorial.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/tutorial.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/docs/tutorial.html (original)
+++ calcite/site/docs/tutorial.html Mon Oct 2 17:08:04 2017
@@ -894,6 +894,16 @@ relational operators?</p>
+ <li class=""><a href="/docs/spatial.html">Spatial</a></li>
+
+
+
+
+
+
+
+
+
<li class=""><a href="/docs/stream.html">Streaming</a></li>
Modified: calcite/site/downloads/index.html
URL: http://svn.apache.org/viewvc/calcite/site/downloads/index.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/downloads/index.html (original)
+++ calcite/site/downloads/index.html Mon Oct 2 17:08:04 2017
@@ -101,34 +101,40 @@
</thead>
<tbody>
<tr>
+ <td style="text-align: left"><a href="/docs/history.html#v1-14-0">1.14.0</a></td>
+ <td style="text-align: left">02 Oct 2017</td>
+ <td style="text-align: left"><a href="https://github.com/apache/calcite/commit/7426eef84">7426eef84</a></td>
+ <td style="text-align: left"><a href="http://www.apache.org/dyn/closer.lua?filename=calcite/apache-calcite-1.14.0/apache-calcite-1.14.0-src.tar.gz&action=download">tar</a> (<a href="https://www.apache.org/dist/calcite/apache-calcite-1.14.0/apache-calcite-1.14.0-src.tar.gz.sha256">digest</a> <a href="https://www.apache.org/dist/calcite/apache-calcite-1.14.0/apache-calcite-1.14.0-src.tar.gz.asc">pgp</a>) <br /> <a href="http://www.apache.org/dyn/closer.lua?filename=calcite/apache-calcite-1.14.0/apache-calcite-1.14.0-src.zip&action=download">zip</a> (<a href="https://www.apache.org/dist/calcite/apache-calcite-1.14.0/apache-calcite-1.14.0-src.zip.sha256">digest</a> <a href="https://www.apache.org/dist/calcite/apache-calcite-1.14.0/apache-calcite-1.14.0-src.zip.asc">pgp</a>)</td>
+ </tr>
+ <tr>
<td style="text-align: left"><a href="/docs/history.html#v1-13-0">1.13.0</a></td>
<td style="text-align: left">26 Jun 2017</td>
<td style="text-align: left"><a href="https://github.com/apache/calcite/commit/54b9823">54b9823</a></td>
- <td style="text-align: left"><a href="http://www.apache.org/dyn/closer.lua?filename=calcite/apache-calcite-1.13.0/apache-calcite-1.13.0-src.tar.gz&action=download">tar</a> (<a href="https://www.apache.org/dist/calcite/apache-calcite-1.13.0/apache-calcite-1.13.0-src.tar.gz.mds">digest</a> <a href="https://www.apache.org/dist/calcite/apache-calcite-1.13.0/apache-calcite-1.13.0-src.tar.gz.asc">pgp</a>) <br /> <a href="http://www.apache.org/dyn/closer.lua?filename=calcite/apache-calcite-1.13.0/apache-calcite-1.13.0-src.zip&action=download">zip</a> (<a href="https://www.apache.org/dist/calcite/apache-calcite-1.13.0/apache-calcite-1.13.0-src.zip.mds">digest</a> <a href="https://www.apache.org/dist/calcite/apache-calcite-1.13.0/apache-calcite-1.13.0-src.zip.asc">pgp</a>)</td>
+ <td style="text-align: left"><a href="http://archive.apache.org/dist/calcite/apache-calcite-1.13.0/apache-calcite-1.13.0-src.tar.gz">tar</a> (<a href="https://archive.apache.org/dist/calcite/apache-calcite-1.13.0/apache-calcite-1.13.0-src.tar.gz.md5">digest</a> <a href="https://archive.apache.org/dist/calcite/apache-calcite-1.13.0/apache-calcite-1.13.0-src.tar.gz.asc">pgp</a>) <br /> <a href="http://archive.apache.org/dist/calcite/apache-calcite-1.13.0/apache-calcite-1.13.0-src.zip">zip</a> (<a href="https://archive.apache.org/dist/calcite/apache-calcite-1.13.0/apache-calcite-1.13.0-src.zip.md5">digest</a> <a href="https://archive.apache.org/dist/calcite/apache-calcite-1.13.0/apache-calcite-1.13.0-src.zip.asc">pgp</a>)</td>
</tr>
<tr>
<td style="text-align: left"><a href="/docs/history.html#v1-12-0">1.12.0</a></td>
<td style="text-align: left">24 Mar 2017</td>
<td style="text-align: left"><a href="https://github.com/apache/calcite/commit/ea7ace1">ea7ace1</a></td>
- <td style="text-align: left"><a href="http://archive.apache.org/dist/calcite/apache-calcite-1.12.0/apache-calcite-1.12.0-src.tar.gz">tar</a> (<a href="https://archive.apache.org/dist/calcite/apache-calcite-1.12.0/apache-calcite-1.12.0-src.tar.gz.mds">digest</a> <a href="https://archive.apache.org/dist/calcite/apache-calcite-1.12.0/apache-calcite-1.12.0-src.tar.gz.asc">pgp</a>) <br /> <a href="http://archive.apache.org/dist/calcite/apache-calcite-1.12.0/apache-calcite-1.12.0-src.zip">zip</a> (<a href="https://archive.apache.org/dist/calcite/apache-calcite-1.12.0/apache-calcite-1.12.0-src.zip.mds">digest</a> <a href="https://archive.apache.org/dist/calcite/apache-calcite-1.12.0/apache-calcite-1.12.0-src.zip.asc">pgp</a>)</td>
+ <td style="text-align: left"><a href="http://archive.apache.org/dist/calcite/apache-calcite-1.12.0/apache-calcite-1.12.0-src.tar.gz">tar</a> (<a href="https://archive.apache.org/dist/calcite/apache-calcite-1.12.0/apache-calcite-1.12.0-src.tar.gz.md5">digest</a> <a href="https://archive.apache.org/dist/calcite/apache-calcite-1.12.0/apache-calcite-1.12.0-src.tar.gz.asc">pgp</a>) <br /> <a href="http://archive.apache.org/dist/calcite/apache-calcite-1.12.0/apache-calcite-1.12.0-src.zip">zip</a> (<a href="https://archive.apache.org/dist/calcite/apache-calcite-1.12.0/apache-calcite-1.12.0-src.zip.md5">digest</a> <a href="https://archive.apache.org/dist/calcite/apache-calcite-1.12.0/apache-calcite-1.12.0-src.zip.asc">pgp</a>)</td>
</tr>
<tr>
<td style="text-align: left"><a href="/docs/history.html#v1-11-0">1.11.0</a></td>
<td style="text-align: left">09 Jan 2017</td>
<td style="text-align: left"><a href="https://github.com/apache/calcite/commit/f8ba670">f8ba670</a></td>
- <td style="text-align: left"><a href="http://archive.apache.org/dist/calcite/apache-calcite-1.11.0/apache-calcite-1.11.0-src.tar.gz">tar</a> (<a href="https://archive.apache.org/dist/calcite/apache-calcite-1.11.0/apache-calcite-1.11.0-src.tar.gz.mds">digest</a> <a href="https://archive.apache.org/dist/calcite/apache-calcite-1.11.0/apache-calcite-1.11.0-src.tar.gz.asc">pgp</a>) <br /> <a href="http://archive.apache.org/dist/calcite/apache-calcite-1.11.0/apache-calcite-1.11.0-src.zip">zip</a> (<a href="https://archive.apache.org/dist/calcite/apache-calcite-1.11.0/apache-calcite-1.11.0-src.zip.mds">digest</a> <a href="https://archive.apache.org/dist/calcite/apache-calcite-1.11.0/apache-calcite-1.11.0-src.zip.asc">pgp</a>)</td>
+ <td style="text-align: left"><a href="http://archive.apache.org/dist/calcite/apache-calcite-1.11.0/apache-calcite-1.11.0-src.tar.gz">tar</a> (<a href="https://archive.apache.org/dist/calcite/apache-calcite-1.11.0/apache-calcite-1.11.0-src.tar.gz.md5">digest</a> <a href="https://archive.apache.org/dist/calcite/apache-calcite-1.11.0/apache-calcite-1.11.0-src.tar.gz.asc">pgp</a>) <br /> <a href="http://archive.apache.org/dist/calcite/apache-calcite-1.11.0/apache-calcite-1.11.0-src.zip">zip</a> (<a href="https://archive.apache.org/dist/calcite/apache-calcite-1.11.0/apache-calcite-1.11.0-src.zip.md5">digest</a> <a href="https://archive.apache.org/dist/calcite/apache-calcite-1.11.0/apache-calcite-1.11.0-src.zip.asc">pgp</a>)</td>
</tr>
<tr>
<td style="text-align: left"><a href="/docs/history.html#v1-10-0">1.10.0</a></td>
<td style="text-align: left">12 Oct 2016</td>
<td style="text-align: left"><a href="https://github.com/apache/calcite/commit/448dd85">448dd85</a></td>
- <td style="text-align: left"><a href="http://archive.apache.org/dist/calcite/apache-calcite-1.10.0/apache-calcite-1.10.0-src.tar.gz">tar</a> (<a href="https://archive.apache.org/dist/calcite/apache-calcite-1.10.0/apache-calcite-1.10.0-src.tar.gz.mds">digest</a> <a href="https://archive.apache.org/dist/calcite/apache-calcite-1.10.0/apache-calcite-1.10.0-src.tar.gz.asc">pgp</a>) <br /> <a href="http://archive.apache.org/dist/calcite/apache-calcite-1.10.0/apache-calcite-1.10.0-src.zip">zip</a> (<a href="https://archive.apache.org/dist/calcite/apache-calcite-1.10.0/apache-calcite-1.10.0-src.zip.mds">digest</a> <a href="https://archive.apache.org/dist/calcite/apache-calcite-1.10.0/apache-calcite-1.10.0-src.zip.asc">pgp</a>)</td>
+ <td style="text-align: left"><a href="http://archive.apache.org/dist/calcite/apache-calcite-1.10.0/apache-calcite-1.10.0-src.tar.gz">tar</a> (<a href="https://archive.apache.org/dist/calcite/apache-calcite-1.10.0/apache-calcite-1.10.0-src.tar.gz.md5">digest</a> <a href="https://archive.apache.org/dist/calcite/apache-calcite-1.10.0/apache-calcite-1.10.0-src.tar.gz.asc">pgp</a>) <br /> <a href="http://archive.apache.org/dist/calcite/apache-calcite-1.10.0/apache-calcite-1.10.0-src.zip">zip</a> (<a href="https://archive.apache.org/dist/calcite/apache-calcite-1.10.0/apache-calcite-1.10.0-src.zip.md5">digest</a> <a href="https://archive.apache.org/dist/calcite/apache-calcite-1.10.0/apache-calcite-1.10.0-src.zip.asc">pgp</a>)</td>
</tr>
<tr>
<td style="text-align: left"><a href="/docs/history.html#v1-9-0">1.9.0</a></td>
<td style="text-align: left">22 Sep 2016</td>
<td style="text-align: left"><a href="https://github.com/apache/calcite/commit/08c56b1">08c56b1</a></td>
- <td style="text-align: left"><a href="http://archive.apache.org/dist/calcite/apache-calcite-1.9.0/apache-calcite-1.9.0-src.tar.gz">tar</a> (<a href="https://archive.apache.org/dist/calcite/apache-calcite-1.9.0/apache-calcite-1.9.0-src.tar.gz.mds">digest</a> <a href="https://archive.apache.org/dist/calcite/apache-calcite-1.9.0/apache-calcite-1.9.0-src.tar.gz.asc">pgp</a>) <br /> <a href="http://archive.apache.org/dist/calcite/apache-calcite-1.9.0/apache-calcite-1.9.0-src.zip">zip</a> (<a href="https://archive.apache.org/dist/calcite/apache-calcite-1.9.0/apache-calcite-1.9.0-src.zip.mds">digest</a> <a href="https://archive.apache.org/dist/calcite/apache-calcite-1.9.0/apache-calcite-1.9.0-src.zip.asc">pgp</a>)</td>
+ <td style="text-align: left"><a href="http://archive.apache.org/dist/calcite/apache-calcite-1.9.0/apache-calcite-1.9.0-src.tar.gz">tar</a> (<a href="https://archive.apache.org/dist/calcite/apache-calcite-1.9.0/apache-calcite-1.9.0-src.tar.gz.md5">digest</a> <a href="https://archive.apache.org/dist/calcite/apache-calcite-1.9.0/apache-calcite-1.9.0-src.tar.gz.asc">pgp</a>) <br /> <a href="http://archive.apache.org/dist/calcite/apache-calcite-1.9.0/apache-calcite-1.9.0-src.zip">zip</a> (<a href="https://archive.apache.org/dist/calcite/apache-calcite-1.9.0/apache-calcite-1.9.0-src.zip.md5">digest</a> <a href="https://archive.apache.org/dist/calcite/apache-calcite-1.9.0/apache-calcite-1.9.0-src.zip.asc">pgp</a>)</td>
</tr>
<tr>
<td style="text-align: left"><a href="/docs/history.html#v1-8-0">1.8.0</a></td>
@@ -236,7 +242,7 @@ succeed.</p>
<span class="nt"><dependency></span>
<span class="nt"><groupId></span>org.apache.calcite<span class="nt"></groupId></span>
<span class="nt"><artifactId></span>calcite-core<span class="nt"></artifactId></span>
- <span class="nt"><version></span>1.13.0<span class="nt"></version></span>
+ <span class="nt"><version></span>1.14.0<span class="nt"></version></span>
<span class="nt"></dependency></span>
<span class="nt"></dependencies></span></code></pre></figure>
Modified: calcite/site/news/2014/06/27/release-0.8.0-incubating/index.html
URL: http://svn.apache.org/viewvc/calcite/site/news/2014/06/27/release-0.8.0-incubating/index.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/news/2014/06/27/release-0.8.0-incubating/index.html (original)
+++ calcite/site/news/2014/06/27/release-0.8.0-incubating/index.html Mon Oct 2 17:08:04 2017
@@ -84,7 +84,8 @@
<option value="">Navigate the blogâ¦</option>
<option value="/news/">Home</option>
<optgroup label="v1.x">
- <option value="/news/2017/06/26/release-1.13.0/">Release 1.13.0</option>
+ <option value="/news/2017/10/02/release-1.14.0/">Release 1.14.0</option>
+ <option value="/news/2017/06/26/release-1.13.0/">Release 1.13.0</option>
<option value="/news/2017/03/31/new-avatica-repository/">New Avatica Repository</option>
<option value="/news/2017/03/24/release-1.12.0/">Release 1.12.0</option>
<option value="/news/2017/01/09/release-1.11.0/">Release 1.11.0</option>
@@ -174,6 +175,10 @@ new utility, <code class="highlighter-ro
<ul>
<li class="">
+ <a href="/news/2017/10/02/release-1.14.0/">1.14.0</a>
+ </li>
+
+ <li class="">
<a href="/news/2017/06/26/release-1.13.0/">1.13.0</a>
</li>
@@ -189,10 +194,6 @@ new utility, <code class="highlighter-ro
<a href="/news/2016/10/12/release-1.10.0/">1.10.0</a>
</li>
- <li class="">
- <a href="/news/2016/09/22/release-1.9.0/">1.9.0</a>
- </li>
-
</ul>
<h4>Other News</h4>
<ul>
Modified: calcite/site/news/2014/08/19/release-0.9.0-incubating/index.html
URL: http://svn.apache.org/viewvc/calcite/site/news/2014/08/19/release-0.9.0-incubating/index.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/news/2014/08/19/release-0.9.0-incubating/index.html (original)
+++ calcite/site/news/2014/08/19/release-0.9.0-incubating/index.html Mon Oct 2 17:08:04 2017
@@ -84,7 +84,8 @@
<option value="">Navigate the blogâ¦</option>
<option value="/news/">Home</option>
<optgroup label="v1.x">
- <option value="/news/2017/06/26/release-1.13.0/">Release 1.13.0</option>
+ <option value="/news/2017/10/02/release-1.14.0/">Release 1.14.0</option>
+ <option value="/news/2017/06/26/release-1.13.0/">Release 1.13.0</option>
<option value="/news/2017/03/31/new-avatica-repository/">New Avatica Repository</option>
<option value="/news/2017/03/24/release-1.12.0/">Release 1.12.0</option>
<option value="/news/2017/01/09/release-1.11.0/">Release 1.11.0</option>
@@ -172,6 +173,10 @@
<ul>
<li class="">
+ <a href="/news/2017/10/02/release-1.14.0/">1.14.0</a>
+ </li>
+
+ <li class="">
<a href="/news/2017/06/26/release-1.13.0/">1.13.0</a>
</li>
@@ -187,10 +192,6 @@
<a href="/news/2016/10/12/release-1.10.0/">1.10.0</a>
</li>
- <li class="">
- <a href="/news/2016/09/22/release-1.9.0/">1.9.0</a>
- </li>
-
</ul>
<h4>Other News</h4>
<ul>
Modified: calcite/site/news/2014/10/02/release-0.9.1-incubating/index.html
URL: http://svn.apache.org/viewvc/calcite/site/news/2014/10/02/release-0.9.1-incubating/index.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/news/2014/10/02/release-0.9.1-incubating/index.html (original)
+++ calcite/site/news/2014/10/02/release-0.9.1-incubating/index.html Mon Oct 2 17:08:04 2017
@@ -84,7 +84,8 @@
<option value="">Navigate the blogâ¦</option>
<option value="/news/">Home</option>
<optgroup label="v1.x">
- <option value="/news/2017/06/26/release-1.13.0/">Release 1.13.0</option>
+ <option value="/news/2017/10/02/release-1.14.0/">Release 1.14.0</option>
+ <option value="/news/2017/06/26/release-1.13.0/">Release 1.13.0</option>
<option value="/news/2017/03/31/new-avatica-repository/">New Avatica Repository</option>
<option value="/news/2017/03/24/release-1.12.0/">Release 1.12.0</option>
<option value="/news/2017/01/09/release-1.11.0/">Release 1.11.0</option>
@@ -172,6 +173,10 @@
<ul>
<li class="">
+ <a href="/news/2017/10/02/release-1.14.0/">1.14.0</a>
+ </li>
+
+ <li class="">
<a href="/news/2017/06/26/release-1.13.0/">1.13.0</a>
</li>
@@ -187,10 +192,6 @@
<a href="/news/2016/10/12/release-1.10.0/">1.10.0</a>
</li>
- <li class="">
- <a href="/news/2016/09/22/release-1.9.0/">1.9.0</a>
- </li>
-
</ul>
<h4>Other News</h4>
<ul>
Modified: calcite/site/news/2014/11/05/release-0.9.2-incubating/index.html
URL: http://svn.apache.org/viewvc/calcite/site/news/2014/11/05/release-0.9.2-incubating/index.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/news/2014/11/05/release-0.9.2-incubating/index.html (original)
+++ calcite/site/news/2014/11/05/release-0.9.2-incubating/index.html Mon Oct 2 17:08:04 2017
@@ -84,7 +84,8 @@
<option value="">Navigate the blogâ¦</option>
<option value="/news/">Home</option>
<optgroup label="v1.x">
- <option value="/news/2017/06/26/release-1.13.0/">Release 1.13.0</option>
+ <option value="/news/2017/10/02/release-1.14.0/">Release 1.14.0</option>
+ <option value="/news/2017/06/26/release-1.13.0/">Release 1.13.0</option>
<option value="/news/2017/03/31/new-avatica-repository/">New Avatica Repository</option>
<option value="/news/2017/03/24/release-1.12.0/">Release 1.12.0</option>
<option value="/news/2017/01/09/release-1.11.0/">Release 1.11.0</option>
@@ -175,6 +176,10 @@ before you move on to 1.0.</p>
<ul>
<li class="">
+ <a href="/news/2017/10/02/release-1.14.0/">1.14.0</a>
+ </li>
+
+ <li class="">
<a href="/news/2017/06/26/release-1.13.0/">1.13.0</a>
</li>
@@ -190,10 +195,6 @@ before you move on to 1.0.</p>
<a href="/news/2016/10/12/release-1.10.0/">1.10.0</a>
</li>
- <li class="">
- <a href="/news/2016/09/22/release-1.9.0/">1.9.0</a>
- </li>
-
</ul>
<h4>Other News</h4>
<ul>
Modified: calcite/site/news/2015/01/31/release-1.0.0-incubating/index.html
URL: http://svn.apache.org/viewvc/calcite/site/news/2015/01/31/release-1.0.0-incubating/index.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/news/2015/01/31/release-1.0.0-incubating/index.html (original)
+++ calcite/site/news/2015/01/31/release-1.0.0-incubating/index.html Mon Oct 2 17:08:04 2017
@@ -84,7 +84,8 @@
<option value="">Navigate the blogâ¦</option>
<option value="/news/">Home</option>
<optgroup label="v1.x">
- <option value="/news/2017/06/26/release-1.13.0/">Release 1.13.0</option>
+ <option value="/news/2017/10/02/release-1.14.0/">Release 1.14.0</option>
+ <option value="/news/2017/06/26/release-1.13.0/">Release 1.13.0</option>
<option value="/news/2017/03/31/new-avatica-repository/">New Avatica Repository</option>
<option value="/news/2017/03/24/release-1.12.0/">Release 1.12.0</option>
<option value="/news/2017/01/09/release-1.11.0/">Release 1.11.0</option>
@@ -185,6 +186,10 @@ and fixes about 30 bugs.</p>
<ul>
<li class="">
+ <a href="/news/2017/10/02/release-1.14.0/">1.14.0</a>
+ </li>
+
+ <li class="">
<a href="/news/2017/06/26/release-1.13.0/">1.13.0</a>
</li>
@@ -200,10 +205,6 @@ and fixes about 30 bugs.</p>
<a href="/news/2016/10/12/release-1.10.0/">1.10.0</a>
</li>
- <li class="">
- <a href="/news/2016/09/22/release-1.9.0/">1.9.0</a>
- </li>
-
</ul>
<h4>Other News</h4>
<ul>
Modified: calcite/site/news/2015/03/13/release-1.1.0-incubating/index.html
URL: http://svn.apache.org/viewvc/calcite/site/news/2015/03/13/release-1.1.0-incubating/index.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/news/2015/03/13/release-1.1.0-incubating/index.html (original)
+++ calcite/site/news/2015/03/13/release-1.1.0-incubating/index.html Mon Oct 2 17:08:04 2017
@@ -84,7 +84,8 @@
<option value="">Navigate the blogâ¦</option>
<option value="/news/">Home</option>
<optgroup label="v1.x">
- <option value="/news/2017/06/26/release-1.13.0/">Release 1.13.0</option>
+ <option value="/news/2017/10/02/release-1.14.0/">Release 1.14.0</option>
+ <option value="/news/2017/06/26/release-1.13.0/">Release 1.13.0</option>
<option value="/news/2017/03/31/new-avatica-repository/">New Avatica Repository</option>
<option value="/news/2017/03/24/release-1.12.0/">Release 1.12.0</option>
<option value="/news/2017/01/09/release-1.11.0/">Release 1.11.0</option>
@@ -184,6 +185,10 @@ calling constructors directly.</p>
<ul>
<li class="">
+ <a href="/news/2017/10/02/release-1.14.0/">1.14.0</a>
+ </li>
+
+ <li class="">
<a href="/news/2017/06/26/release-1.13.0/">1.13.0</a>
</li>
@@ -199,10 +204,6 @@ calling constructors directly.</p>
<a href="/news/2016/10/12/release-1.10.0/">1.10.0</a>
</li>
- <li class="">
- <a href="/news/2016/09/22/release-1.9.0/">1.9.0</a>
- </li>
-
</ul>
<h4>Other News</h4>
<ul>
Modified: calcite/site/news/2015/04/07/release-1.2.0-incubating/index.html
URL: http://svn.apache.org/viewvc/calcite/site/news/2015/04/07/release-1.2.0-incubating/index.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/news/2015/04/07/release-1.2.0-incubating/index.html (original)
+++ calcite/site/news/2015/04/07/release-1.2.0-incubating/index.html Mon Oct 2 17:08:04 2017
@@ -84,7 +84,8 @@
<option value="">Navigate the blogâ¦</option>
<option value="/news/">Home</option>
<optgroup label="v1.x">
- <option value="/news/2017/06/26/release-1.13.0/">Release 1.13.0</option>
+ <option value="/news/2017/10/02/release-1.14.0/">Release 1.14.0</option>
+ <option value="/news/2017/06/26/release-1.13.0/">Release 1.13.0</option>
<option value="/news/2017/03/31/new-avatica-repository/">New Avatica Repository</option>
<option value="/news/2017/03/24/release-1.12.0/">Release 1.12.0</option>
<option value="/news/2017/01/09/release-1.11.0/">Release 1.11.0</option>
@@ -184,6 +185,10 @@ improve implicit and explicit conversion
<ul>
<li class="">
+ <a href="/news/2017/10/02/release-1.14.0/">1.14.0</a>
+ </li>
+
+ <li class="">
<a href="/news/2017/06/26/release-1.13.0/">1.13.0</a>
</li>
@@ -199,10 +204,6 @@ improve implicit and explicit conversion
<a href="/news/2016/10/12/release-1.10.0/">1.10.0</a>
</li>
- <li class="">
- <a href="/news/2016/09/22/release-1.9.0/">1.9.0</a>
- </li>
-
</ul>
<h4>Other News</h4>
<ul>
Modified: calcite/site/news/2015/04/24/new-committers/index.html
URL: http://svn.apache.org/viewvc/calcite/site/news/2015/04/24/new-committers/index.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/news/2015/04/24/new-committers/index.html (original)
+++ calcite/site/news/2015/04/24/new-committers/index.html Mon Oct 2 17:08:04 2017
@@ -84,7 +84,8 @@
<option value="">Navigate the blogâ¦</option>
<option value="/news/">Home</option>
<optgroup label="v1.x">
- <option value="/news/2017/06/26/release-1.13.0/">Release 1.13.0</option>
+ <option value="/news/2017/10/02/release-1.14.0/">Release 1.14.0</option>
+ <option value="/news/2017/06/26/release-1.13.0/">Release 1.13.0</option>
<option value="/news/2017/03/31/new-avatica-repository/">New Avatica Repository</option>
<option value="/news/2017/03/24/release-1.12.0/">Release 1.12.0</option>
<option value="/news/2017/01/09/release-1.11.0/">Release 1.11.0</option>
@@ -178,6 +179,10 @@ committers for their work on Calcite. We
<ul>
<li class="">
+ <a href="/news/2017/10/02/release-1.14.0/">1.14.0</a>
+ </li>
+
+ <li class="">
<a href="/news/2017/06/26/release-1.13.0/">1.13.0</a>
</li>
@@ -193,10 +198,6 @@ committers for their work on Calcite. We
<a href="/news/2016/10/12/release-1.10.0/">1.10.0</a>
</li>
- <li class="">
- <a href="/news/2016/09/22/release-1.9.0/">1.9.0</a>
- </li>
-
</ul>
<h4>Other News</h4>
<ul>
Modified: calcite/site/news/2015/05/30/release-1.3.0-incubating/index.html
URL: http://svn.apache.org/viewvc/calcite/site/news/2015/05/30/release-1.3.0-incubating/index.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/news/2015/05/30/release-1.3.0-incubating/index.html (original)
+++ calcite/site/news/2015/05/30/release-1.3.0-incubating/index.html Mon Oct 2 17:08:04 2017
@@ -84,7 +84,8 @@
<option value="">Navigate the blogâ¦</option>
<option value="/news/">Home</option>
<optgroup label="v1.x">
- <option value="/news/2017/06/26/release-1.13.0/">Release 1.13.0</option>
+ <option value="/news/2017/10/02/release-1.14.0/">Release 1.14.0</option>
+ <option value="/news/2017/06/26/release-1.13.0/">Release 1.13.0</option>
<option value="/news/2017/03/31/new-avatica-repository/">New Avatica Repository</option>
<option value="/news/2017/03/24/release-1.12.0/">Release 1.12.0</option>
<option value="/news/2017/01/09/release-1.11.0/">Release 1.11.0</option>
@@ -176,6 +177,10 @@ and various improvements to Avatica.</p>
<ul>
<li class="">
+ <a href="/news/2017/10/02/release-1.14.0/">1.14.0</a>
+ </li>
+
+ <li class="">
<a href="/news/2017/06/26/release-1.13.0/">1.13.0</a>
</li>
@@ -191,10 +196,6 @@ and various improvements to Avatica.</p>
<a href="/news/2016/10/12/release-1.10.0/">1.10.0</a>
</li>
- <li class="">
- <a href="/news/2016/09/22/release-1.9.0/">1.9.0</a>
- </li>
-
</ul>
<h4>Other News</h4>
<ul>
Modified: calcite/site/news/2015/06/05/algebra-builder/index.html
URL: http://svn.apache.org/viewvc/calcite/site/news/2015/06/05/algebra-builder/index.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/news/2015/06/05/algebra-builder/index.html (original)
+++ calcite/site/news/2015/06/05/algebra-builder/index.html Mon Oct 2 17:08:04 2017
@@ -84,7 +84,8 @@
<option value="">Navigate the blogâ¦</option>
<option value="/news/">Home</option>
<optgroup label="v1.x">
- <option value="/news/2017/06/26/release-1.13.0/">Release 1.13.0</option>
+ <option value="/news/2017/10/02/release-1.14.0/">Release 1.14.0</option>
+ <option value="/news/2017/06/26/release-1.13.0/">Release 1.13.0</option>
<option value="/news/2017/03/31/new-avatica-repository/">New Avatica Repository</option>
<option value="/news/2017/03/24/release-1.12.0/">Release 1.12.0</option>
<option value="/news/2017/01/09/release-1.11.0/">Release 1.11.0</option>
@@ -223,6 +224,10 @@ extensive set of query-optimization rule
<ul>
<li class="">
+ <a href="/news/2017/10/02/release-1.14.0/">1.14.0</a>
+ </li>
+
+ <li class="">
<a href="/news/2017/06/26/release-1.13.0/">1.13.0</a>
</li>
@@ -238,10 +243,6 @@ extensive set of query-optimization rule
<a href="/news/2016/10/12/release-1.10.0/">1.10.0</a>
</li>
- <li class="">
- <a href="/news/2016/09/22/release-1.9.0/">1.9.0</a>
- </li>
-
</ul>
<h4>Other News</h4>
<ul>
Modified: calcite/site/news/2015/07/31/xldb-best-lightning-talk/index.html
URL: http://svn.apache.org/viewvc/calcite/site/news/2015/07/31/xldb-best-lightning-talk/index.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/news/2015/07/31/xldb-best-lightning-talk/index.html (original)
+++ calcite/site/news/2015/07/31/xldb-best-lightning-talk/index.html Mon Oct 2 17:08:04 2017
@@ -84,7 +84,8 @@
<option value="">Navigate the blogâ¦</option>
<option value="/news/">Home</option>
<optgroup label="v1.x">
- <option value="/news/2017/06/26/release-1.13.0/">Release 1.13.0</option>
+ <option value="/news/2017/10/02/release-1.14.0/">Release 1.14.0</option>
+ <option value="/news/2017/06/26/release-1.13.0/">Release 1.13.0</option>
<option value="/news/2017/03/31/new-avatica-repository/">New Avatica Repository</option>
<option value="/news/2017/03/24/release-1.12.0/">Release 1.12.0</option>
<option value="/news/2017/01/09/release-1.11.0/">Release 1.11.0</option>
@@ -183,6 +184,10 @@ and <a href="https://www.youtube.com/wat
<ul>
<li class="">
+ <a href="/news/2017/10/02/release-1.14.0/">1.14.0</a>
+ </li>
+
+ <li class="">
<a href="/news/2017/06/26/release-1.13.0/">1.13.0</a>
</li>
@@ -198,10 +203,6 @@ and <a href="https://www.youtube.com/wat
<a href="/news/2016/10/12/release-1.10.0/">1.10.0</a>
</li>
- <li class="">
- <a href="/news/2016/09/22/release-1.9.0/">1.9.0</a>
- </li>
-
</ul>
<h4>Other News</h4>
<ul>
Modified: calcite/site/news/2015/09/02/release-1.4.0-incubating/index.html
URL: http://svn.apache.org/viewvc/calcite/site/news/2015/09/02/release-1.4.0-incubating/index.html?rev=1810559&r1=1810558&r2=1810559&view=diff
==============================================================================
--- calcite/site/news/2015/09/02/release-1.4.0-incubating/index.html (original)
+++ calcite/site/news/2015/09/02/release-1.4.0-incubating/index.html Mon Oct 2 17:08:04 2017
@@ -84,7 +84,8 @@
<option value="">Navigate the blogâ¦</option>
<option value="/news/">Home</option>
<optgroup label="v1.x">
- <option value="/news/2017/06/26/release-1.13.0/">Release 1.13.0</option>
+ <option value="/news/2017/10/02/release-1.14.0/">Release 1.14.0</option>
+ <option value="/news/2017/06/26/release-1.13.0/">Release 1.13.0</option>
<option value="/news/2017/03/31/new-avatica-repository/">New Avatica Repository</option>
<option value="/news/2017/03/24/release-1.12.0/">Release 1.12.0</option>
<option value="/news/2017/01/09/release-1.11.0/">Release 1.11.0</option>
@@ -182,6 +183,10 @@ so that you can easily create relational
<ul>
<li class="">
+ <a href="/news/2017/10/02/release-1.14.0/">1.14.0</a>
+ </li>
+
+ <li class="">
<a href="/news/2017/06/26/release-1.13.0/">1.13.0</a>
</li>
@@ -197,10 +202,6 @@ so that you can easily create relational
<a href="/news/2016/10/12/release-1.10.0/">1.10.0</a>
</li>
- <li class="">
- <a href="/news/2016/09/22/release-1.9.0/">1.9.0</a>
- </li>
-
</ul>
<h4>Other News</h4>
<ul>