| <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> |
| <!-- NewPage --> |
| <html lang="zh"> |
| <head> |
| <!-- Generated by javadoc --> |
| <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> |
| <title>SqlConformance (Apache Calcite calcite API)</title> |
| <link rel="stylesheet" type="text/css" href="../../../../../stylesheet.css" title="Style"> |
| <script type="text/javascript" src="../../../../../script.js"></script> |
| </head> |
| <body> |
| <script type="text/javascript"><!-- |
| try { |
| if (location.href.indexOf('is-external=true') == -1) { |
| parent.document.title="SqlConformance (Apache Calcite calcite API)"; |
| } |
| } |
| catch(err) { |
| } |
| //--> |
| var methods = {"i0":6,"i1":6,"i2":6,"i3":6,"i4":6,"i5":6,"i6":6,"i7":6,"i8":6,"i9":6,"i10":6,"i11":6,"i12":6,"i13":6,"i14":6,"i15":6,"i16":6,"i17":6,"i18":6,"i19":6,"i20":6,"i21":6}; |
| var tabs = {65535:["t0","所有方法"],2:["t2","实例方法"],4:["t3","抽象方法"]}; |
| var altColor = "altColor"; |
| var rowColor = "rowColor"; |
| var tableTab = "tableTab"; |
| var activeTableTab = "activeTableTab"; |
| </script> |
| <noscript> |
| <div>您的浏览器已禁用 JavaScript。</div> |
| </noscript> |
| <!-- ========= START OF TOP NAVBAR ======= --> |
| <div class="topNav"><a name="navbar.top"> |
| <!-- --> |
| </a> |
| <div class="skipNav"><a href="#skip.navbar.top" title="跳过导航链接">跳过导航链接</a></div> |
| <a name="navbar.top.firstrow"> |
| <!-- --> |
| </a> |
| <ul class="navList" title="导航"> |
| <li><a href="../../../../../overview-summary.html">概览</a></li> |
| <li><a href="package-summary.html">程序包</a></li> |
| <li class="navBarCell1Rev">类</li> |
| <li><a href="package-tree.html">树</a></li> |
| <li><a href="../../../../../deprecated-list.html">已过时</a></li> |
| <li><a href="../../../../../index-all.html">索引</a></li> |
| <li><a href="../../../../../help-doc.html">帮助</a></li> |
| </ul> |
| <div class="aboutLanguage"><b>Apache Calcite</b></div> |
| </div> |
| <div class="subNav"> |
| <ul class="navList"> |
| <li><a href="../../../../../org/apache/calcite/sql/validate/SqlAbstractConformance.html" title="org.apache.calcite.sql.validate中的类"><span class="typeNameLink">上一个类</span></a></li> |
| <li><a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html" title="org.apache.calcite.sql.validate中的枚举"><span class="typeNameLink">下一个类</span></a></li> |
| </ul> |
| <ul class="navList"> |
| <li><a href="../../../../../index.html?org/apache/calcite/sql/validate/SqlConformance.html" target="_top">框架</a></li> |
| <li><a href="SqlConformance.html" target="_top">无框架</a></li> |
| </ul> |
| <ul class="navList" id="allclasses_navbar_top"> |
| <li><a href="../../../../../allclasses-noframe.html">所有类</a></li> |
| </ul> |
| <div> |
| <script type="text/javascript"><!-- |
| allClassesLink = document.getElementById("allclasses_navbar_top"); |
| if(window==top) { |
| allClassesLink.style.display = "block"; |
| } |
| else { |
| allClassesLink.style.display = "none"; |
| } |
| //--> |
| </script> |
| </div> |
| <div> |
| <ul class="subNavList"> |
| <li>概要: </li> |
| <li>嵌套 | </li> |
| <li><a href="#field.summary">字段</a> | </li> |
| <li>构造器 | </li> |
| <li><a href="#method.summary">方法</a></li> |
| </ul> |
| <ul class="subNavList"> |
| <li>详细资料: </li> |
| <li><a href="#field.detail">字段</a> | </li> |
| <li>构造器 | </li> |
| <li><a href="#method.detail">方法</a></li> |
| </ul> |
| </div> |
| <a name="skip.navbar.top"> |
| <!-- --> |
| </a></div> |
| <!-- ========= END OF TOP NAVBAR ========= --> |
| <!-- ======== START OF CLASS DATA ======== --> |
| <div class="header"> |
| <div class="subTitle">org.apache.calcite.sql.validate</div> |
| <h2 title="接口 SqlConformance" class="title">接口 SqlConformance</h2> |
| </div> |
| <div class="contentContainer"> |
| <div class="description"> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <dl> |
| <dt>所有已知实现类:</dt> |
| <dd><a href="../../../../../org/apache/calcite/sql/validate/SqlAbstractConformance.html" title="org.apache.calcite.sql.validate中的类">SqlAbstractConformance</a>, <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html" title="org.apache.calcite.sql.validate中的枚举">SqlConformanceEnum</a>, <a href="../../../../../org/apache/calcite/sql/validate/SqlDelegatingConformance.html" title="org.apache.calcite.sql.validate中的类">SqlDelegatingConformance</a></dd> |
| </dl> |
| <hr> |
| <br> |
| <pre>public interface <span class="typeNameLabel">SqlConformance</span></pre> |
| <div class="block">Enumeration of valid SQL compatibility modes. |
| |
| <p>For most purposes, one of the built-in compatibility modes in enum |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html" title="org.apache.calcite.sql.validate中的枚举"><code>SqlConformanceEnum</code></a> will suffice. |
| |
| <p>If you wish to implement this interface to build your own conformance, |
| we strongly recommend that you extend <a href="../../../../../org/apache/calcite/sql/validate/SqlAbstractConformance.html" title="org.apache.calcite.sql.validate中的类"><code>SqlAbstractConformance</code></a>, |
| or use a <a href="../../../../../org/apache/calcite/sql/validate/SqlDelegatingConformance.html" title="org.apache.calcite.sql.validate中的类"><code>SqlDelegatingConformance</code></a>, |
| so that you won't be broken by future changes.</div> |
| <dl> |
| <dt><span class="seeLabel">另请参阅:</span></dt> |
| <dd><a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html" title="org.apache.calcite.sql.validate中的枚举"><code>SqlConformanceEnum</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlAbstractConformance.html" title="org.apache.calcite.sql.validate中的类"><code>SqlAbstractConformance</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlDelegatingConformance.html" title="org.apache.calcite.sql.validate中的类"><code>SqlDelegatingConformance</code></a></dd> |
| </dl> |
| </li> |
| </ul> |
| </div> |
| <div class="summary"> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <!-- =========== FIELD SUMMARY =========== --> |
| <ul class="blockList"> |
| <li class="blockList"><a name="field.summary"> |
| <!-- --> |
| </a> |
| <h3>字段概要</h3> |
| <table class="memberSummary" border="0" cellpadding="3" cellspacing="0" summary="字段概要表, 列表字段和解释"> |
| <caption><span>字段</span><span class="tabEnd"> </span></caption> |
| <tr> |
| <th class="colFirst" scope="col">限定符和类型</th> |
| <th class="colLast" scope="col">字段和说明</th> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html" title="org.apache.calcite.sql.validate中的枚举">SqlConformanceEnum</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/validate/SqlConformance.html#DEFAULT">DEFAULT</a></span></code> |
| <div class="block"><span class="deprecatedLabel">已过时。</span> </div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html" title="org.apache.calcite.sql.validate中的枚举">SqlConformanceEnum</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/validate/SqlConformance.html#ORACLE_10">ORACLE_10</a></span></code> |
| <div class="block"><span class="deprecatedLabel">已过时。</span> </div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html" title="org.apache.calcite.sql.validate中的枚举">SqlConformanceEnum</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/validate/SqlConformance.html#PRAGMATIC_2003">PRAGMATIC_2003</a></span></code> |
| <div class="block"><span class="deprecatedLabel">已过时。</span> </div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html" title="org.apache.calcite.sql.validate中的枚举">SqlConformanceEnum</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/validate/SqlConformance.html#PRAGMATIC_99">PRAGMATIC_99</a></span></code> |
| <div class="block"><span class="deprecatedLabel">已过时。</span> </div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html" title="org.apache.calcite.sql.validate中的枚举">SqlConformanceEnum</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/validate/SqlConformance.html#STRICT_2003">STRICT_2003</a></span></code> |
| <div class="block"><span class="deprecatedLabel">已过时。</span> </div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html" title="org.apache.calcite.sql.validate中的枚举">SqlConformanceEnum</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/validate/SqlConformance.html#STRICT_92">STRICT_92</a></span></code> |
| <div class="block"><span class="deprecatedLabel">已过时。</span> </div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html" title="org.apache.calcite.sql.validate中的枚举">SqlConformanceEnum</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/validate/SqlConformance.html#STRICT_99">STRICT_99</a></span></code> |
| <div class="block"><span class="deprecatedLabel">已过时。</span> </div> |
| </td> |
| </tr> |
| </table> |
| </li> |
| </ul> |
| <!-- ========== METHOD SUMMARY =========== --> |
| <ul class="blockList"> |
| <li class="blockList"><a name="method.summary"> |
| <!-- --> |
| </a> |
| <h3>方法概要</h3> |
| <table class="memberSummary" border="0" cellpadding="3" cellspacing="0" summary="方法概要表, 列表方法和解释"> |
| <caption><span id="t0" class="activeTableTab"><span>所有方法</span><span class="tabEnd"> </span></span><span id="t2" class="tableTab"><span><a href="javascript:show(2);">实例方法</a></span><span class="tabEnd"> </span></span><span id="t3" class="tableTab"><span><a href="javascript:show(4);">抽象方法</a></span><span class="tabEnd"> </span></span></caption> |
| <tr> |
| <th class="colFirst" scope="col">限定符和类型</th> |
| <th class="colLast" scope="col">方法和说明</th> |
| </tr> |
| <tr id="i0" class="altColor"> |
| <td class="colFirst"><code>boolean</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/validate/SqlConformance.html#allowExplicitRowValueConstructor--">allowExplicitRowValueConstructor</a></span>()</code> |
| <div class="block">Whether to allow SQL syntax "<code>ROW(expr1, expr2, expr3)</code>".</div> |
| </td> |
| </tr> |
| <tr id="i1" class="rowColor"> |
| <td class="colFirst"><code>boolean</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/validate/SqlConformance.html#allowExtend--">allowExtend</a></span>()</code> |
| <div class="block">Whether to allow mixing table columns with extended columns in |
| <code>INSERT</code> (or <code>UPSERT</code>).</div> |
| </td> |
| </tr> |
| <tr id="i2" class="altColor"> |
| <td class="colFirst"><code>boolean</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/validate/SqlConformance.html#allowExtendedTrim--">allowExtendedTrim</a></span>()</code> |
| <div class="block">Whether TRIM should support more than one trim character.</div> |
| </td> |
| </tr> |
| <tr id="i3" class="rowColor"> |
| <td class="colFirst"><code>boolean</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/validate/SqlConformance.html#allowGeometry--">allowGeometry</a></span>()</code> |
| <div class="block">Whether to allow geo-spatial extensions, including the GEOMETRY type.</div> |
| </td> |
| </tr> |
| <tr id="i4" class="altColor"> |
| <td class="colFirst"><code>boolean</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/validate/SqlConformance.html#allowNiladicParentheses--">allowNiladicParentheses</a></span>()</code> |
| <div class="block">Whether to allow parentheses to be specified in calls to niladic functions |
| and procedures (that is, functions and procedures with no parameters).</div> |
| </td> |
| </tr> |
| <tr id="i5" class="rowColor"> |
| <td class="colFirst"><code>boolean</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/validate/SqlConformance.html#allowPluralTimeUnits--">allowPluralTimeUnits</a></span>()</code> |
| <div class="block">Whether interval literals should allow plural time units |
| such as "YEARS" and "DAYS" in interval literals.</div> |
| </td> |
| </tr> |
| <tr id="i6" class="altColor"> |
| <td class="colFirst"><code>boolean</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/validate/SqlConformance.html#allowQualifyingCommonColumn--">allowQualifyingCommonColumn</a></span>()</code> |
| <div class="block">Whether to allow a qualified common column in a query that has a |
| NATURAL join or a join with a USING clause.</div> |
| </td> |
| </tr> |
| <tr id="i7" class="rowColor"> |
| <td class="colFirst"><code>boolean</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/validate/SqlConformance.html#isApplyAllowed--">isApplyAllowed</a></span>()</code> |
| <div class="block">Whether <code>CROSS APPLY</code> and <code>OUTER APPLY</code> operators are allowed |
| in the parser.</div> |
| </td> |
| </tr> |
| <tr id="i8" class="altColor"> |
| <td class="colFirst"><code>boolean</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/validate/SqlConformance.html#isBangEqualAllowed--">isBangEqualAllowed</a></span>()</code> |
| <div class="block">Whether the bang-equal token !</div> |
| </td> |
| </tr> |
| <tr id="i9" class="rowColor"> |
| <td class="colFirst"><code>boolean</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/validate/SqlConformance.html#isFromRequired--">isFromRequired</a></span>()</code> |
| <div class="block">Whether <code>FROM</code> clause is required in a <code>SELECT</code> statement.</div> |
| </td> |
| </tr> |
| <tr id="i10" class="altColor"> |
| <td class="colFirst"><code>boolean</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/validate/SqlConformance.html#isGroupByAlias--">isGroupByAlias</a></span>()</code> |
| <div class="block">Whether to allow aliases from the <code>SELECT</code> clause to be used as |
| column names in the <code>GROUP BY</code> clause.</div> |
| </td> |
| </tr> |
| <tr id="i11" class="rowColor"> |
| <td class="colFirst"><code>boolean</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/validate/SqlConformance.html#isGroupByOrdinal--">isGroupByOrdinal</a></span>()</code> |
| <div class="block">Whether <code>GROUP BY 2</code> is interpreted to mean 'group by the 2nd column |
| in the select list'.</div> |
| </td> |
| </tr> |
| <tr id="i12" class="altColor"> |
| <td class="colFirst"><code>boolean</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/validate/SqlConformance.html#isHavingAlias--">isHavingAlias</a></span>()</code> |
| <div class="block">Whether to allow aliases from the <code>SELECT</code> clause to be used as |
| column names in the <code>HAVING</code> clause.</div> |
| </td> |
| </tr> |
| <tr id="i13" class="rowColor"> |
| <td class="colFirst"><code>boolean</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/validate/SqlConformance.html#isInsertSubsetColumnsAllowed--">isInsertSubsetColumnsAllowed</a></span>()</code> |
| <div class="block">Whether to allow <code>INSERT</code> (or <code>UPSERT</code>) with no column list |
| but fewer values than the target table.</div> |
| </td> |
| </tr> |
| <tr id="i14" class="altColor"> |
| <td class="colFirst"><code>boolean</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/validate/SqlConformance.html#isLiberal--">isLiberal</a></span>()</code> |
| <div class="block">Whether this dialect supports features from a wide variety of |
| dialects.</div> |
| </td> |
| </tr> |
| <tr id="i15" class="rowColor"> |
| <td class="colFirst"><code>boolean</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/validate/SqlConformance.html#isLimitStartCountAllowed--">isLimitStartCountAllowed</a></span>()</code> |
| <div class="block">Whether to allow the SQL syntax "<code>LIMIT start, count</code>".</div> |
| </td> |
| </tr> |
| <tr id="i16" class="altColor"> |
| <td class="colFirst"><code>boolean</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/validate/SqlConformance.html#isMinusAllowed--">isMinusAllowed</a></span>()</code> |
| <div class="block">Whether <code>MINUS</code> is allowed as an alternative to <code>EXCEPT</code> in |
| the parser.</div> |
| </td> |
| </tr> |
| <tr id="i17" class="rowColor"> |
| <td class="colFirst"><code>boolean</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/validate/SqlConformance.html#isPercentRemainderAllowed--">isPercentRemainderAllowed</a></span>()</code> |
| <div class="block">Whether the "%" operator is allowed by the parser as an alternative to the |
| <code>mod</code> function.</div> |
| </td> |
| </tr> |
| <tr id="i18" class="altColor"> |
| <td class="colFirst"><code>boolean</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/validate/SqlConformance.html#isSortByAlias--">isSortByAlias</a></span>()</code> |
| <div class="block">Whether '<code>ORDER BY x</code>' is interpreted to mean 'sort by the select |
| list item whose alias is x' even if there is a column called x.</div> |
| </td> |
| </tr> |
| <tr id="i19" class="rowColor"> |
| <td class="colFirst"><code>boolean</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/validate/SqlConformance.html#isSortByAliasObscures--">isSortByAliasObscures</a></span>()</code> |
| <div class="block">Whether "empno" is invalid in "select empno as x from emp order by empno" |
| because the alias "x" obscures it.</div> |
| </td> |
| </tr> |
| <tr id="i20" class="altColor"> |
| <td class="colFirst"><code>boolean</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/validate/SqlConformance.html#isSortByOrdinal--">isSortByOrdinal</a></span>()</code> |
| <div class="block">Whether '<code>ORDER BY 2</code>' is interpreted to mean 'sort by the 2nd |
| column in the select list'.</div> |
| </td> |
| </tr> |
| <tr id="i21" class="rowColor"> |
| <td class="colFirst"><code>boolean</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/validate/SqlConformance.html#shouldConvertRaggedUnionTypesToVarying--">shouldConvertRaggedUnionTypesToVarying</a></span>()</code> |
| <div class="block">Whether the least restrictive type of a number of CHAR types of different |
| lengths should be a VARCHAR type.</div> |
| </td> |
| </tr> |
| </table> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| </div> |
| <div class="details"> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <!-- ============ FIELD DETAIL =========== --> |
| <ul class="blockList"> |
| <li class="blockList"><a name="field.detail"> |
| <!-- --> |
| </a> |
| <h3>字段详细资料</h3> |
| <a name="DEFAULT"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>DEFAULT</h4> |
| <pre><a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Deprecated.html?is-external=true" title="java.lang中的类或接口">@Deprecated</a> |
| static final <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html" title="org.apache.calcite.sql.validate中的枚举">SqlConformanceEnum</a> DEFAULT</pre> |
| <div class="block"><span class="deprecatedLabel">已过时。</span> </div> |
| <div class="block">Short-cut for <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#DEFAULT"><code>SqlConformanceEnum.DEFAULT</code></a>.</div> |
| </li> |
| </ul> |
| <a name="STRICT_92"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>STRICT_92</h4> |
| <pre><a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Deprecated.html?is-external=true" title="java.lang中的类或接口">@Deprecated</a> |
| static final <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html" title="org.apache.calcite.sql.validate中的枚举">SqlConformanceEnum</a> STRICT_92</pre> |
| <div class="block"><span class="deprecatedLabel">已过时。</span> </div> |
| <div class="block">Short-cut for <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#STRICT_92"><code>SqlConformanceEnum.STRICT_92</code></a>.</div> |
| </li> |
| </ul> |
| <a name="STRICT_99"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>STRICT_99</h4> |
| <pre><a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Deprecated.html?is-external=true" title="java.lang中的类或接口">@Deprecated</a> |
| static final <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html" title="org.apache.calcite.sql.validate中的枚举">SqlConformanceEnum</a> STRICT_99</pre> |
| <div class="block"><span class="deprecatedLabel">已过时。</span> </div> |
| <div class="block">Short-cut for <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#STRICT_99"><code>SqlConformanceEnum.STRICT_99</code></a>.</div> |
| </li> |
| </ul> |
| <a name="PRAGMATIC_99"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>PRAGMATIC_99</h4> |
| <pre><a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Deprecated.html?is-external=true" title="java.lang中的类或接口">@Deprecated</a> |
| static final <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html" title="org.apache.calcite.sql.validate中的枚举">SqlConformanceEnum</a> PRAGMATIC_99</pre> |
| <div class="block"><span class="deprecatedLabel">已过时。</span> </div> |
| <div class="block">Short-cut for <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#PRAGMATIC_99"><code>SqlConformanceEnum.PRAGMATIC_99</code></a>.</div> |
| </li> |
| </ul> |
| <a name="ORACLE_10"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>ORACLE_10</h4> |
| <pre><a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Deprecated.html?is-external=true" title="java.lang中的类或接口">@Deprecated</a> |
| static final <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html" title="org.apache.calcite.sql.validate中的枚举">SqlConformanceEnum</a> ORACLE_10</pre> |
| <div class="block"><span class="deprecatedLabel">已过时。</span> </div> |
| <div class="block">Short-cut for <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#ORACLE_10"><code>SqlConformanceEnum.ORACLE_10</code></a>.</div> |
| </li> |
| </ul> |
| <a name="STRICT_2003"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>STRICT_2003</h4> |
| <pre><a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Deprecated.html?is-external=true" title="java.lang中的类或接口">@Deprecated</a> |
| static final <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html" title="org.apache.calcite.sql.validate中的枚举">SqlConformanceEnum</a> STRICT_2003</pre> |
| <div class="block"><span class="deprecatedLabel">已过时。</span> </div> |
| <div class="block">Short-cut for <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#STRICT_2003"><code>SqlConformanceEnum.STRICT_2003</code></a>.</div> |
| </li> |
| </ul> |
| <a name="PRAGMATIC_2003"> |
| <!-- --> |
| </a> |
| <ul class="blockListLast"> |
| <li class="blockList"> |
| <h4>PRAGMATIC_2003</h4> |
| <pre><a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Deprecated.html?is-external=true" title="java.lang中的类或接口">@Deprecated</a> |
| static final <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html" title="org.apache.calcite.sql.validate中的枚举">SqlConformanceEnum</a> PRAGMATIC_2003</pre> |
| <div class="block"><span class="deprecatedLabel">已过时。</span> </div> |
| <div class="block">Short-cut for <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#PRAGMATIC_2003"><code>SqlConformanceEnum.PRAGMATIC_2003</code></a>.</div> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| <!-- ============ METHOD DETAIL ========== --> |
| <ul class="blockList"> |
| <li class="blockList"><a name="method.detail"> |
| <!-- --> |
| </a> |
| <h3>方法详细资料</h3> |
| <a name="isLiberal--"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>isLiberal</h4> |
| <pre>boolean isLiberal()</pre> |
| <div class="block">Whether this dialect supports features from a wide variety of |
| dialects. This is enabled for the Babel parser, disabled otherwise.</div> |
| </li> |
| </ul> |
| <a name="isGroupByAlias--"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>isGroupByAlias</h4> |
| <pre>boolean isGroupByAlias()</pre> |
| <div class="block">Whether to allow aliases from the <code>SELECT</code> clause to be used as |
| column names in the <code>GROUP BY</code> clause. |
| |
| <p>Among the built-in conformance levels, true in |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#BABEL"><code>SqlConformanceEnum.BABEL</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#LENIENT"><code>SqlConformanceEnum.LENIENT</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#BIG_QUERY"><code>SqlConformanceEnum.BIG_QUERY</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#MYSQL_5"><code>SqlConformanceEnum.MYSQL_5</code></a>; |
| false otherwise.</div> |
| </li> |
| </ul> |
| <a name="isGroupByOrdinal--"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>isGroupByOrdinal</h4> |
| <pre>boolean isGroupByOrdinal()</pre> |
| <div class="block">Whether <code>GROUP BY 2</code> is interpreted to mean 'group by the 2nd column |
| in the select list'. |
| |
| <p>Among the built-in conformance levels, true in |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#BABEL"><code>SqlConformanceEnum.BABEL</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#LENIENT"><code>SqlConformanceEnum.LENIENT</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#MYSQL_5"><code>SqlConformanceEnum.MYSQL_5</code></a>; |
| false otherwise.</div> |
| </li> |
| </ul> |
| <a name="isHavingAlias--"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>isHavingAlias</h4> |
| <pre>boolean isHavingAlias()</pre> |
| <div class="block">Whether to allow aliases from the <code>SELECT</code> clause to be used as |
| column names in the <code>HAVING</code> clause. |
| |
| <p>Among the built-in conformance levels, true in |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#BABEL"><code>SqlConformanceEnum.BABEL</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#LENIENT"><code>SqlConformanceEnum.LENIENT</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#BIG_QUERY"><code>SqlConformanceEnum.BIG_QUERY</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#MYSQL_5"><code>SqlConformanceEnum.MYSQL_5</code></a>; |
| false otherwise.</div> |
| </li> |
| </ul> |
| <a name="isSortByOrdinal--"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>isSortByOrdinal</h4> |
| <pre>boolean isSortByOrdinal()</pre> |
| <div class="block">Whether '<code>ORDER BY 2</code>' is interpreted to mean 'sort by the 2nd |
| column in the select list'. |
| |
| <p>Among the built-in conformance levels, true in |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#DEFAULT"><code>SqlConformanceEnum.DEFAULT</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#BABEL"><code>SqlConformanceEnum.BABEL</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#LENIENT"><code>SqlConformanceEnum.LENIENT</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#MYSQL_5"><code>SqlConformanceEnum.MYSQL_5</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#ORACLE_10"><code>SqlConformanceEnum.ORACLE_10</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#ORACLE_12"><code>SqlConformanceEnum.ORACLE_12</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#STRICT_92"><code>SqlConformanceEnum.STRICT_92</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#PRAGMATIC_99"><code>SqlConformanceEnum.PRAGMATIC_99</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#PRAGMATIC_2003"><code>SqlConformanceEnum.PRAGMATIC_2003</code></a>; |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#SQL_SERVER_2008"><code>SqlConformanceEnum.SQL_SERVER_2008</code></a>; |
| false otherwise.</div> |
| </li> |
| </ul> |
| <a name="isSortByAlias--"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>isSortByAlias</h4> |
| <pre>boolean isSortByAlias()</pre> |
| <div class="block">Whether '<code>ORDER BY x</code>' is interpreted to mean 'sort by the select |
| list item whose alias is x' even if there is a column called x. |
| |
| <p>Among the built-in conformance levels, true in |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#DEFAULT"><code>SqlConformanceEnum.DEFAULT</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#BABEL"><code>SqlConformanceEnum.BABEL</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#LENIENT"><code>SqlConformanceEnum.LENIENT</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#MYSQL_5"><code>SqlConformanceEnum.MYSQL_5</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#ORACLE_10"><code>SqlConformanceEnum.ORACLE_10</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#ORACLE_12"><code>SqlConformanceEnum.ORACLE_12</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#STRICT_92"><code>SqlConformanceEnum.STRICT_92</code></a>; |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#SQL_SERVER_2008"><code>SqlConformanceEnum.SQL_SERVER_2008</code></a>; |
| false otherwise.</div> |
| </li> |
| </ul> |
| <a name="isSortByAliasObscures--"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>isSortByAliasObscures</h4> |
| <pre>boolean isSortByAliasObscures()</pre> |
| <div class="block">Whether "empno" is invalid in "select empno as x from emp order by empno" |
| because the alias "x" obscures it. |
| |
| <p>Among the built-in conformance levels, true in |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#STRICT_92"><code>SqlConformanceEnum.STRICT_92</code></a>; |
| false otherwise.</div> |
| </li> |
| </ul> |
| <a name="isFromRequired--"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>isFromRequired</h4> |
| <pre>boolean isFromRequired()</pre> |
| <div class="block">Whether <code>FROM</code> clause is required in a <code>SELECT</code> statement. |
| |
| <p>Among the built-in conformance levels, true in |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#ORACLE_10"><code>SqlConformanceEnum.ORACLE_10</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#ORACLE_12"><code>SqlConformanceEnum.ORACLE_12</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#STRICT_92"><code>SqlConformanceEnum.STRICT_92</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#STRICT_99"><code>SqlConformanceEnum.STRICT_99</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#STRICT_2003"><code>SqlConformanceEnum.STRICT_2003</code></a>; |
| false otherwise.</div> |
| </li> |
| </ul> |
| <a name="isBangEqualAllowed--"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>isBangEqualAllowed</h4> |
| <pre>boolean isBangEqualAllowed()</pre> |
| <div class="block">Whether the bang-equal token != is allowed as an alternative to <> in |
| the parser. |
| |
| <p>Among the built-in conformance levels, true in |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#BABEL"><code>SqlConformanceEnum.BABEL</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#LENIENT"><code>SqlConformanceEnum.LENIENT</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#MYSQL_5"><code>SqlConformanceEnum.MYSQL_5</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#ORACLE_10"><code>SqlConformanceEnum.ORACLE_10</code></a>; |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#ORACLE_12"><code>SqlConformanceEnum.ORACLE_12</code></a>; |
| false otherwise.</div> |
| </li> |
| </ul> |
| <a name="isPercentRemainderAllowed--"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>isPercentRemainderAllowed</h4> |
| <pre>boolean isPercentRemainderAllowed()</pre> |
| <div class="block">Whether the "%" operator is allowed by the parser as an alternative to the |
| <code>mod</code> function. |
| |
| <p>Among the built-in conformance levels, true in |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#BABEL"><code>SqlConformanceEnum.BABEL</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#LENIENT"><code>SqlConformanceEnum.LENIENT</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#MYSQL_5"><code>SqlConformanceEnum.MYSQL_5</code></a>; |
| false otherwise.</div> |
| </li> |
| </ul> |
| <a name="isMinusAllowed--"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>isMinusAllowed</h4> |
| <pre>boolean isMinusAllowed()</pre> |
| <div class="block">Whether <code>MINUS</code> is allowed as an alternative to <code>EXCEPT</code> in |
| the parser. |
| |
| <p>Among the built-in conformance levels, true in |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#BABEL"><code>SqlConformanceEnum.BABEL</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#LENIENT"><code>SqlConformanceEnum.LENIENT</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#ORACLE_10"><code>SqlConformanceEnum.ORACLE_10</code></a>; |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#ORACLE_12"><code>SqlConformanceEnum.ORACLE_12</code></a>; |
| false otherwise. |
| |
| <p>Note: MySQL does not support <code>MINUS</code> or <code>EXCEPT</code> (as of |
| version 5.5).</div> |
| </li> |
| </ul> |
| <a name="isApplyAllowed--"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>isApplyAllowed</h4> |
| <pre>boolean isApplyAllowed()</pre> |
| <div class="block">Whether <code>CROSS APPLY</code> and <code>OUTER APPLY</code> operators are allowed |
| in the parser. |
| |
| <p><code>APPLY</code> invokes a table-valued function for each row returned |
| by a table expression. It is syntactic sugar:<ul> |
| |
| <li><code>SELECT * FROM emp CROSS APPLY TABLE(promote(empno)</code><br> |
| is equivalent to<br> |
| <code>SELECT * FROM emp CROSS JOIN LATERAL TABLE(promote(empno)</code> |
| |
| <li><code>SELECT * FROM emp OUTER APPLY TABLE(promote(empno)</code><br> |
| is equivalent to<br> |
| <code>SELECT * FROM emp LEFT JOIN LATERAL TABLE(promote(empno)</code> ON true |
| </ul> |
| |
| <p>Among the built-in conformance levels, true in |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#BABEL"><code>SqlConformanceEnum.BABEL</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#LENIENT"><code>SqlConformanceEnum.LENIENT</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#SQL_SERVER_2008"><code>SqlConformanceEnum.SQL_SERVER_2008</code></a>; |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#ORACLE_12"><code>SqlConformanceEnum.ORACLE_12</code></a>; |
| false otherwise.</div> |
| </li> |
| </ul> |
| <a name="isInsertSubsetColumnsAllowed--"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>isInsertSubsetColumnsAllowed</h4> |
| <pre>boolean isInsertSubsetColumnsAllowed()</pre> |
| <div class="block">Whether to allow <code>INSERT</code> (or <code>UPSERT</code>) with no column list |
| but fewer values than the target table. |
| |
| <p>The N values provided are assumed to match the first N columns of the |
| table, and for each of the remaining columns, the default value of the |
| column is used. It is an error if any of these columns has no default |
| value. |
| |
| <p>The default value of a column is specified by the <code>DEFAULT</code> |
| clause in the <code>CREATE TABLE</code> statement, or is <code>NULL</code> if the |
| column is not declared <code>NOT NULL</code>. |
| |
| <p>Among the built-in conformance levels, true in |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#BABEL"><code>SqlConformanceEnum.BABEL</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#LENIENT"><code>SqlConformanceEnum.LENIENT</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#PRAGMATIC_99"><code>SqlConformanceEnum.PRAGMATIC_99</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#PRAGMATIC_2003"><code>SqlConformanceEnum.PRAGMATIC_2003</code></a>; |
| false otherwise.</div> |
| </li> |
| </ul> |
| <a name="allowNiladicParentheses--"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>allowNiladicParentheses</h4> |
| <pre>boolean allowNiladicParentheses()</pre> |
| <div class="block">Whether to allow parentheses to be specified in calls to niladic functions |
| and procedures (that is, functions and procedures with no parameters). |
| |
| <p>For example, <code>CURRENT_DATE</code> is a niladic system function. In |
| standard SQL it must be invoked without parentheses: |
| |
| <blockquote><code>VALUES CURRENT_DATE</code></blockquote> |
| |
| <p>If <code>allowNiladicParentheses</code>, the following syntax is also valid: |
| |
| <blockquote><code>VALUES CURRENT_DATE()</code></blockquote> |
| |
| <p>Of the popular databases, MySQL, Apache Phoenix and VoltDB allow this |
| behavior; |
| Apache Hive, HSQLDB, IBM DB2, Microsoft SQL Server, Oracle, PostgreSQL do |
| not. |
| |
| <p>Among the built-in conformance levels, true in |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#BABEL"><code>SqlConformanceEnum.BABEL</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#LENIENT"><code>SqlConformanceEnum.LENIENT</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#MYSQL_5"><code>SqlConformanceEnum.MYSQL_5</code></a>; |
| false otherwise.</div> |
| </li> |
| </ul> |
| <a name="allowExplicitRowValueConstructor--"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>allowExplicitRowValueConstructor</h4> |
| <pre>boolean allowExplicitRowValueConstructor()</pre> |
| <div class="block">Whether to allow SQL syntax "<code>ROW(expr1, expr2, expr3)</code>". |
| <p>The equivalent syntax in standard SQL is |
| "<code>(expr1, expr2, expr3)</code>". |
| |
| <p>Standard SQL does not allow this because the type is not |
| well-defined. However, PostgreSQL allows this behavior. |
| |
| <p>Standard SQL allows row expressions in other contexts, for instance |
| inside <code>VALUES</code> clause. |
| |
| <p>Among the built-in conformance levels, true in |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#DEFAULT"><code>SqlConformanceEnum.DEFAULT</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#LENIENT"><code>SqlConformanceEnum.LENIENT</code></a>; |
| false otherwise.</div> |
| </li> |
| </ul> |
| <a name="allowExtend--"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>allowExtend</h4> |
| <pre>boolean allowExtend()</pre> |
| <div class="block">Whether to allow mixing table columns with extended columns in |
| <code>INSERT</code> (or <code>UPSERT</code>). |
| |
| <p>For example, suppose that the declaration of table <code>T</code> has columns |
| <code>A</code> and <code>B</code>, and you want to insert data of column |
| <code>C INTEGER</code> not present in the table declaration as an extended |
| column. You can specify the columns in an <code>INSERT</code> statement as |
| follows: |
| |
| <blockquote> |
| <code>INSERT INTO T (A, B, C INTEGER) VALUES (1, 2, 3)</code> |
| </blockquote> |
| |
| <p>Among the built-in conformance levels, true in |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#BABEL"><code>SqlConformanceEnum.BABEL</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#LENIENT"><code>SqlConformanceEnum.LENIENT</code></a>; |
| false otherwise.</div> |
| </li> |
| </ul> |
| <a name="isLimitStartCountAllowed--"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>isLimitStartCountAllowed</h4> |
| <pre>boolean isLimitStartCountAllowed()</pre> |
| <div class="block">Whether to allow the SQL syntax "<code>LIMIT start, count</code>". |
| |
| <p>The equivalent syntax in standard SQL is |
| "<code>OFFSET start ROW FETCH FIRST count ROWS ONLY</code>", |
| and in PostgreSQL "<code>LIMIT count OFFSET start</code>". |
| |
| <p>MySQL and CUBRID allow this behavior. |
| |
| <p>Among the built-in conformance levels, true in |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#BABEL"><code>SqlConformanceEnum.BABEL</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#LENIENT"><code>SqlConformanceEnum.LENIENT</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#MYSQL_5"><code>SqlConformanceEnum.MYSQL_5</code></a>; |
| false otherwise.</div> |
| </li> |
| </ul> |
| <a name="allowGeometry--"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>allowGeometry</h4> |
| <pre>boolean allowGeometry()</pre> |
| <div class="block">Whether to allow geo-spatial extensions, including the GEOMETRY type. |
| |
| <p>Among the built-in conformance levels, true in |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#BABEL"><code>SqlConformanceEnum.BABEL</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#LENIENT"><code>SqlConformanceEnum.LENIENT</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#MYSQL_5"><code>SqlConformanceEnum.MYSQL_5</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#SQL_SERVER_2008"><code>SqlConformanceEnum.SQL_SERVER_2008</code></a>; |
| false otherwise.</div> |
| </li> |
| </ul> |
| <a name="shouldConvertRaggedUnionTypesToVarying--"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>shouldConvertRaggedUnionTypesToVarying</h4> |
| <pre>boolean shouldConvertRaggedUnionTypesToVarying()</pre> |
| <div class="block">Whether the least restrictive type of a number of CHAR types of different |
| lengths should be a VARCHAR type. And similarly BINARY to VARBINARY. |
| |
| <p>For example, consider the query |
| |
| <blockquote><pre>SELECT 'abcde' UNION SELECT 'xyz'</pre></blockquote> |
| |
| <p>The input columns have types <code>CHAR(5)</code> and <code>CHAR(3)</code>, and |
| we need a result type that is large enough for both: |
| <ul> |
| <li>Under strict SQL:2003 behavior, its column has type <code>CHAR(5)</code>, |
| and the value in the second row will have trailing spaces. |
| <li>With lenient behavior, its column has type <code>VARCHAR(5)</code>, and the |
| values have no trailing spaces. |
| </ul> |
| |
| <p>Among the built-in conformance levels, true in |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#PRAGMATIC_99"><code>SqlConformanceEnum.PRAGMATIC_99</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#PRAGMATIC_2003"><code>SqlConformanceEnum.PRAGMATIC_2003</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#MYSQL_5"><code>SqlConformanceEnum.MYSQL_5</code></a>; |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#ORACLE_10"><code>SqlConformanceEnum.ORACLE_10</code></a>; |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#ORACLE_12"><code>SqlConformanceEnum.ORACLE_12</code></a>; |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#SQL_SERVER_2008"><code>SqlConformanceEnum.SQL_SERVER_2008</code></a>; |
| false otherwise.</div> |
| </li> |
| </ul> |
| <a name="allowExtendedTrim--"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>allowExtendedTrim</h4> |
| <pre>boolean allowExtendedTrim()</pre> |
| <div class="block">Whether TRIM should support more than one trim character. |
| |
| <p>For example, consider the query |
| |
| <blockquote><pre>SELECT TRIM('eh' FROM 'hehe__hehe')</pre></blockquote> |
| |
| <p>Under strict behavior, if the length of trim character is not 1, |
| TRIM throws an exception, and the query fails. |
| However many implementations (in databases such as MySQL and SQL Server) |
| trim all the characters, resulting in a return value of '__'. |
| |
| <p>Among the built-in conformance levels, true in |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#BABEL"><code>SqlConformanceEnum.BABEL</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#LENIENT"><code>SqlConformanceEnum.LENIENT</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#MYSQL_5"><code>SqlConformanceEnum.MYSQL_5</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#SQL_SERVER_2008"><code>SqlConformanceEnum.SQL_SERVER_2008</code></a>; |
| false otherwise.</div> |
| </li> |
| </ul> |
| <a name="allowPluralTimeUnits--"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>allowPluralTimeUnits</h4> |
| <pre>boolean allowPluralTimeUnits()</pre> |
| <div class="block">Whether interval literals should allow plural time units |
| such as "YEARS" and "DAYS" in interval literals. |
| |
| <p>Under strict behavior, <code>INTERVAL '2' DAY</code> is valid |
| and <code>INTERVAL '2' DAYS</code> is invalid; |
| PostgreSQL allows both; Oracle only allows singular time units. |
| |
| <p>Among the built-in conformance levels, true in |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#BABEL"><code>SqlConformanceEnum.BABEL</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#LENIENT"><code>SqlConformanceEnum.LENIENT</code></a>; |
| false otherwise.</div> |
| </li> |
| </ul> |
| <a name="allowQualifyingCommonColumn--"> |
| <!-- --> |
| </a> |
| <ul class="blockListLast"> |
| <li class="blockList"> |
| <h4>allowQualifyingCommonColumn</h4> |
| <pre>boolean allowQualifyingCommonColumn()</pre> |
| <div class="block">Whether to allow a qualified common column in a query that has a |
| NATURAL join or a join with a USING clause. |
| |
| <p>For example, in the query |
| |
| <blockquote><pre>SELECT emp.deptno |
| FROM emp |
| JOIN dept USING (deptno)</pre></blockquote> |
| |
| <p><code>deptno</code> is the common column. A qualified common column |
| such as <code>emp.deptno</code> is not allowed in Oracle, but is allowed |
| in PostgreSQL. |
| |
| <p>Among the built-in conformance levels, false in |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#STRICT_92"><code>SqlConformanceEnum.STRICT_92</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#STRICT_99"><code>SqlConformanceEnum.STRICT_99</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#STRICT_2003"><code>SqlConformanceEnum.STRICT_2003</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#ORACLE_10"><code>SqlConformanceEnum.ORACLE_10</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html#ORACLE_12"><code>SqlConformanceEnum.ORACLE_12</code></a>; |
| true otherwise.</div> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| </div> |
| </div> |
| <!-- ========= END OF CLASS DATA ========= --> |
| <!-- ======= START OF BOTTOM NAVBAR ====== --> |
| <div class="bottomNav"><a name="navbar.bottom"> |
| <!-- --> |
| </a> |
| <div class="skipNav"><a href="#skip.navbar.bottom" title="跳过导航链接">跳过导航链接</a></div> |
| <a name="navbar.bottom.firstrow"> |
| <!-- --> |
| </a> |
| <ul class="navList" title="导航"> |
| <li><a href="../../../../../overview-summary.html">概览</a></li> |
| <li><a href="package-summary.html">程序包</a></li> |
| <li class="navBarCell1Rev">类</li> |
| <li><a href="package-tree.html">树</a></li> |
| <li><a href="../../../../../deprecated-list.html">已过时</a></li> |
| <li><a href="../../../../../index-all.html">索引</a></li> |
| <li><a href="../../../../../help-doc.html">帮助</a></li> |
| </ul> |
| <div class="aboutLanguage"><b>Apache Calcite</b></div> |
| </div> |
| <div class="subNav"> |
| <ul class="navList"> |
| <li><a href="../../../../../org/apache/calcite/sql/validate/SqlAbstractConformance.html" title="org.apache.calcite.sql.validate中的类"><span class="typeNameLink">上一个类</span></a></li> |
| <li><a href="../../../../../org/apache/calcite/sql/validate/SqlConformanceEnum.html" title="org.apache.calcite.sql.validate中的枚举"><span class="typeNameLink">下一个类</span></a></li> |
| </ul> |
| <ul class="navList"> |
| <li><a href="../../../../../index.html?org/apache/calcite/sql/validate/SqlConformance.html" target="_top">框架</a></li> |
| <li><a href="SqlConformance.html" target="_top">无框架</a></li> |
| </ul> |
| <ul class="navList" id="allclasses_navbar_bottom"> |
| <li><a href="../../../../../allclasses-noframe.html">所有类</a></li> |
| </ul> |
| <div> |
| <script type="text/javascript"><!-- |
| allClassesLink = document.getElementById("allclasses_navbar_bottom"); |
| if(window==top) { |
| allClassesLink.style.display = "block"; |
| } |
| else { |
| allClassesLink.style.display = "none"; |
| } |
| //--> |
| </script> |
| </div> |
| <div> |
| <ul class="subNavList"> |
| <li>概要: </li> |
| <li>嵌套 | </li> |
| <li><a href="#field.summary">字段</a> | </li> |
| <li>构造器 | </li> |
| <li><a href="#method.summary">方法</a></li> |
| </ul> |
| <ul class="subNavList"> |
| <li>详细资料: </li> |
| <li><a href="#field.detail">字段</a> | </li> |
| <li>构造器 | </li> |
| <li><a href="#method.detail">方法</a></li> |
| </ul> |
| </div> |
| <a name="skip.navbar.bottom"> |
| <!-- --> |
| </a></div> |
| <!-- ======== END OF BOTTOM NAVBAR ======= --> |
| <p class="legalCopy"><small>Copyright © 2012-2020 Apache Software Foundation. All Rights Reserved.</small></p> |
| </body> |
| </html> |