| <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> |
| <!-- NewPage --> |
| <html lang="en"> |
| <head> |
| <!-- Generated by javadoc --> |
| <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> |
| <title>MysqlSqlDialect (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="MysqlSqlDialect (Apache Calcite calcite API)"; |
| } |
| } |
| catch(err) { |
| } |
| //--> |
| var methods = {"i0":10,"i1":10,"i2":10,"i3":10,"i4":10,"i5":10,"i6":10,"i7":10,"i8":10,"i9":10,"i10":10,"i11":10,"i12":10}; |
| var tabs = {65535:["t0","All Methods"],2:["t2","Instance Methods"],8:["t4","Concrete Methods"]}; |
| var altColor = "altColor"; |
| var rowColor = "rowColor"; |
| var tableTab = "tableTab"; |
| var activeTableTab = "activeTableTab"; |
| </script> |
| <noscript> |
| <div>JavaScript is disabled on your browser.</div> |
| </noscript> |
| <!-- ========= START OF TOP NAVBAR ======= --> |
| <div class="topNav"><a name="navbar.top"> |
| <!-- --> |
| </a> |
| <div class="skipNav"><a href="#skip.navbar.top" title="Skip navigation links">Skip navigation links</a></div> |
| <a name="navbar.top.firstrow"> |
| <!-- --> |
| </a> |
| <ul class="navList" title="Navigation"> |
| <li><a href="../../../../../overview-summary.html">Overview</a></li> |
| <li><a href="package-summary.html">Package</a></li> |
| <li class="navBarCell1Rev">Class</li> |
| <li><a href="package-tree.html">Tree</a></li> |
| <li><a href="../../../../../deprecated-list.html">Deprecated</a></li> |
| <li><a href="../../../../../index-all.html">Index</a></li> |
| <li><a href="../../../../../help-doc.html">Help</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/dialect/MssqlSqlDialect.html" title="class in org.apache.calcite.sql.dialect"><span class="typeNameLink">Prev Class</span></a></li> |
| <li><a href="../../../../../org/apache/calcite/sql/dialect/NeoviewSqlDialect.html" title="class in org.apache.calcite.sql.dialect"><span class="typeNameLink">Next Class</span></a></li> |
| </ul> |
| <ul class="navList"> |
| <li><a href="../../../../../index.html?org/apache/calcite/sql/dialect/MysqlSqlDialect.html" target="_top">Frames</a></li> |
| <li><a href="MysqlSqlDialect.html" target="_top">No Frames</a></li> |
| </ul> |
| <ul class="navList" id="allclasses_navbar_top"> |
| <li><a href="../../../../../allclasses-noframe.html">All Classes</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>Summary: </li> |
| <li><a href="#nested.classes.inherited.from.class.org.apache.calcite.sql.SqlDialect">Nested</a> | </li> |
| <li><a href="#field.summary">Field</a> | </li> |
| <li><a href="#constructor.summary">Constr</a> | </li> |
| <li><a href="#method.summary">Method</a></li> |
| </ul> |
| <ul class="subNavList"> |
| <li>Detail: </li> |
| <li><a href="#field.detail">Field</a> | </li> |
| <li><a href="#constructor.detail">Constr</a> | </li> |
| <li><a href="#method.detail">Method</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.dialect</div> |
| <h2 title="Class MysqlSqlDialect" class="title">Class MysqlSqlDialect</h2> |
| </div> |
| <div class="contentContainer"> |
| <ul class="inheritance"> |
| <li><a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">java.lang.Object</a></li> |
| <li> |
| <ul class="inheritance"> |
| <li><a href="../../../../../org/apache/calcite/sql/SqlDialect.html" title="class in org.apache.calcite.sql">org.apache.calcite.sql.SqlDialect</a></li> |
| <li> |
| <ul class="inheritance"> |
| <li>org.apache.calcite.sql.dialect.MysqlSqlDialect</li> |
| </ul> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| <div class="description"> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <hr> |
| <br> |
| <pre>public class <span class="typeNameLabel">MysqlSqlDialect</span> |
| extends <a href="../../../../../org/apache/calcite/sql/SqlDialect.html" title="class in org.apache.calcite.sql">SqlDialect</a></pre> |
| <div class="block">A <code>SqlDialect</code> implementation for the MySQL database.</div> |
| </li> |
| </ul> |
| </div> |
| <div class="summary"> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <!-- ======== NESTED CLASS SUMMARY ======== --> |
| <ul class="blockList"> |
| <li class="blockList"><a name="nested.class.summary"> |
| <!-- --> |
| </a> |
| <h3>Nested Class Summary</h3> |
| <ul class="blockList"> |
| <li class="blockList"><a name="nested.classes.inherited.from.class.org.apache.calcite.sql.SqlDialect"> |
| <!-- --> |
| </a> |
| <h3>Nested classes/interfaces inherited from class org.apache.calcite.sql.<a href="../../../../../org/apache/calcite/sql/SqlDialect.html" title="class in org.apache.calcite.sql">SqlDialect</a></h3> |
| <code><a href="../../../../../org/apache/calcite/sql/SqlDialect.CalendarPolicy.html" title="enum in org.apache.calcite.sql">SqlDialect.CalendarPolicy</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.Context.html" title="interface in org.apache.calcite.sql">SqlDialect.Context</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.DatabaseProduct.html" title="enum in org.apache.calcite.sql">SqlDialect.DatabaseProduct</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.FakeUtil.html" title="class in org.apache.calcite.sql">SqlDialect.FakeUtil</a></code></li> |
| </ul> |
| </li> |
| </ul> |
| <!-- =========== FIELD SUMMARY =========== --> |
| <ul class="blockList"> |
| <li class="blockList"><a name="field.summary"> |
| <!-- --> |
| </a> |
| <h3>Field Summary</h3> |
| <table class="memberSummary" border="0" cellpadding="3" cellspacing="0" summary="Field Summary table, listing fields, and an explanation"> |
| <caption><span>Fields</span><span class="tabEnd"> </span></caption> |
| <tr> |
| <th class="colFirst" scope="col">Modifier and Type</th> |
| <th class="colLast" scope="col">Field and Description</th> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlDialect.html" title="class in org.apache.calcite.sql">SqlDialect</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/dialect/MysqlSqlDialect.html#DEFAULT">DEFAULT</a></span></code> </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlDialect.Context.html" title="interface in org.apache.calcite.sql">SqlDialect.Context</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/dialect/MysqlSqlDialect.html#DEFAULT_CONTEXT">DEFAULT_CONTEXT</a></span></code> </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/dialect/MysqlSqlDialect.html#ISNULL_FUNCTION">ISNULL_FUNCTION</a></span></code> |
| <div class="block">MySQL specific function.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/rel/type/RelDataTypeSystem.html" title="interface in org.apache.calcite.rel.type">RelDataTypeSystem</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/dialect/MysqlSqlDialect.html#MYSQL_TYPE_SYSTEM">MYSQL_TYPE_SYSTEM</a></span></code> |
| <div class="block">MySQL type system.</div> |
| </td> |
| </tr> |
| </table> |
| <ul class="blockList"> |
| <li class="blockList"><a name="fields.inherited.from.class.org.apache.calcite.sql.SqlDialect"> |
| <!-- --> |
| </a> |
| <h3>Fields inherited from class org.apache.calcite.sql.<a href="../../../../../org/apache/calcite/sql/SqlDialect.html" title="class in org.apache.calcite.sql">SqlDialect</a></h3> |
| <code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html#BUILT_IN_OPERATORS_LIST">BUILT_IN_OPERATORS_LIST</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#CALCITE">CALCITE</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#DUMMY">DUMMY</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#EMPTY_CONTEXT">EMPTY_CONTEXT</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#identifierEndQuoteString">identifierEndQuoteString</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#identifierEscapedQuote">identifierEscapedQuote</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#identifierQuoteString">identifierQuoteString</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#literalEndQuoteString">literalEndQuoteString</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#literalEscapedQuote">literalEscapedQuote</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#literalQuoteString">literalQuoteString</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#LOGGER">LOGGER</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#nullCollation">nullCollation</a></code></li> |
| </ul> |
| </li> |
| </ul> |
| <!-- ======== CONSTRUCTOR SUMMARY ======== --> |
| <ul class="blockList"> |
| <li class="blockList"><a name="constructor.summary"> |
| <!-- --> |
| </a> |
| <h3>Constructor Summary</h3> |
| <table class="memberSummary" border="0" cellpadding="3" cellspacing="0" summary="Constructor Summary table, listing constructors, and an explanation"> |
| <caption><span>Constructors</span><span class="tabEnd"> </span></caption> |
| <tr> |
| <th class="colOne" scope="col">Constructor and Description</th> |
| </tr> |
| <tr class="altColor"> |
| <td class="colOne"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/dialect/MysqlSqlDialect.html#MysqlSqlDialect-org.apache.calcite.sql.SqlDialect.Context-">MysqlSqlDialect</a></span>(<a href="../../../../../org/apache/calcite/sql/SqlDialect.Context.html" title="interface in org.apache.calcite.sql">SqlDialect.Context</a> context)</code> |
| <div class="block">Creates a MysqlSqlDialect.</div> |
| </td> |
| </tr> |
| </table> |
| </li> |
| </ul> |
| <!-- ========== METHOD SUMMARY =========== --> |
| <ul class="blockList"> |
| <li class="blockList"><a name="method.summary"> |
| <!-- --> |
| </a> |
| <h3>Method Summary</h3> |
| <table class="memberSummary" border="0" cellpadding="3" cellspacing="0" summary="Method Summary table, listing methods, and an explanation"> |
| <caption><span id="t0" class="activeTableTab"><span>All Methods</span><span class="tabEnd"> </span></span><span id="t2" class="tableTab"><span><a href="javascript:show(2);">Instance Methods</a></span><span class="tabEnd"> </span></span><span id="t4" class="tableTab"><span><a href="javascript:show(8);">Concrete Methods</a></span><span class="tabEnd"> </span></span></caption> |
| <tr> |
| <th class="colFirst" scope="col">Modifier and Type</th> |
| <th class="colLast" scope="col">Method and Description</th> |
| </tr> |
| <tr id="i0" class="altColor"> |
| <td class="colFirst"><code><a href="../../../../../org/apache/calcite/sql/SqlNode.html" title="class in org.apache.calcite.sql">SqlNode</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/dialect/MysqlSqlDialect.html#emulateNullDirection-org.apache.calcite.sql.SqlNode-boolean-boolean-">emulateNullDirection</a></span>(<a href="../../../../../org/apache/calcite/sql/SqlNode.html" title="class in org.apache.calcite.sql">SqlNode</a> node, |
| boolean nullsFirst, |
| boolean desc)</code> |
| <div class="block">Returns the SqlNode for emulating the null direction for the given field |
| or <code>null</code> if no emulation needs to be done.</div> |
| </td> |
| </tr> |
| <tr id="i1" class="rowColor"> |
| <td class="colFirst"><code><a href="../../../../../org/apache/calcite/sql/SqlDialect.CalendarPolicy.html" title="enum in org.apache.calcite.sql">SqlDialect.CalendarPolicy</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/dialect/MysqlSqlDialect.html#getCalendarPolicy--">getCalendarPolicy</a></span>()</code> </td> |
| </tr> |
| <tr id="i2" class="altColor"> |
| <td class="colFirst"><code><a href="../../../../../org/apache/calcite/sql/SqlNode.html" title="class in org.apache.calcite.sql">SqlNode</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/dialect/MysqlSqlDialect.html#getCastSpec-org.apache.calcite.rel.type.RelDataType-">getCastSpec</a></span>(<a href="../../../../../org/apache/calcite/rel/type/RelDataType.html" title="interface in org.apache.calcite.rel.type">RelDataType</a> type)</code> |
| <div class="block">Returns SqlNode for type in "cast(column as type)", which might be |
| different between databases by type name, precision etc.</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/dialect/MysqlSqlDialect.html#requiresAliasForFromItems--">requiresAliasForFromItems</a></span>()</code> |
| <div class="block">Whether a sub-query in the FROM clause must have an alias.</div> |
| </td> |
| </tr> |
| <tr id="i4" class="altColor"> |
| <td class="colFirst"><code><a href="../../../../../org/apache/calcite/sql/SqlNode.html" title="class in org.apache.calcite.sql">SqlNode</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/dialect/MysqlSqlDialect.html#rewriteSingleValueExpr-org.apache.calcite.sql.SqlNode-">rewriteSingleValueExpr</a></span>(<a href="../../../../../org/apache/calcite/sql/SqlNode.html" title="class in org.apache.calcite.sql">SqlNode</a> aggCall)</code> |
| <div class="block">Rewrite SINGLE_VALUE into expression based on database variants |
| E.g.</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/dialect/MysqlSqlDialect.html#supportsAggregateFunction-org.apache.calcite.sql.SqlKind-">supportsAggregateFunction</a></span>(<a href="../../../../../org/apache/calcite/sql/SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> kind)</code> </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/dialect/MysqlSqlDialect.html#supportsAliasedValues--">supportsAliasedValues</a></span>()</code> |
| <div class="block">Returns whether the dialect supports VALUES in a sub-query with |
| and an "AS t(column, ...)" values to define column names.</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/dialect/MysqlSqlDialect.html#supportsCharSet--">supportsCharSet</a></span>()</code> |
| <div class="block">Returns whether the dialect supports character set names as part of a |
| data type, for instance <code>VARCHAR(30) CHARACTER SET `ISO-8859-1`</code>.</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/dialect/MysqlSqlDialect.html#supportsGroupByWithRollup--">supportsGroupByWithRollup</a></span>()</code> |
| <div class="block">Returns whether this dialect supports "WITH ROLLUP" in the "GROUP BY" |
| clause.</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/dialect/MysqlSqlDialect.html#supportsNestedAggregations--">supportsNestedAggregations</a></span>()</code> |
| <div class="block">Returns whether the dialect supports nested aggregations, for instance |
| <code>SELECT SUM(SUM(1)) </code>.</div> |
| </td> |
| </tr> |
| <tr id="i10" class="altColor"> |
| <td class="colFirst"><code>void</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/dialect/MysqlSqlDialect.html#unparseCall-org.apache.calcite.sql.SqlWriter-org.apache.calcite.sql.SqlCall-int-int-">unparseCall</a></span>(<a href="../../../../../org/apache/calcite/sql/SqlWriter.html" title="interface in org.apache.calcite.sql">SqlWriter</a> writer, |
| <a href="../../../../../org/apache/calcite/sql/SqlCall.html" title="class in org.apache.calcite.sql">SqlCall</a> call, |
| int leftPrec, |
| int rightPrec)</code> </td> |
| </tr> |
| <tr id="i11" class="rowColor"> |
| <td class="colFirst"><code>void</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/dialect/MysqlSqlDialect.html#unparseOffsetFetch-org.apache.calcite.sql.SqlWriter-org.apache.calcite.sql.SqlNode-org.apache.calcite.sql.SqlNode-">unparseOffsetFetch</a></span>(<a href="../../../../../org/apache/calcite/sql/SqlWriter.html" title="interface in org.apache.calcite.sql">SqlWriter</a> writer, |
| <a href="../../../../../org/apache/calcite/sql/SqlNode.html" title="class in org.apache.calcite.sql">SqlNode</a> offset, |
| <a href="../../../../../org/apache/calcite/sql/SqlNode.html" title="class in org.apache.calcite.sql">SqlNode</a> fetch)</code> |
| <div class="block">Converts an offset and fetch into SQL.</div> |
| </td> |
| </tr> |
| <tr id="i12" class="altColor"> |
| <td class="colFirst"><code>void</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/dialect/MysqlSqlDialect.html#unparseSqlIntervalQualifier-org.apache.calcite.sql.SqlWriter-org.apache.calcite.sql.SqlIntervalQualifier-org.apache.calcite.rel.type.RelDataTypeSystem-">unparseSqlIntervalQualifier</a></span>(<a href="../../../../../org/apache/calcite/sql/SqlWriter.html" title="interface in org.apache.calcite.sql">SqlWriter</a> writer, |
| <a href="../../../../../org/apache/calcite/sql/SqlIntervalQualifier.html" title="class in org.apache.calcite.sql">SqlIntervalQualifier</a> qualifier, |
| <a href="../../../../../org/apache/calcite/rel/type/RelDataTypeSystem.html" title="interface in org.apache.calcite.rel.type">RelDataTypeSystem</a> typeSystem)</code> |
| <div class="block">Converts an interval qualifier to a SQL string.</div> |
| </td> |
| </tr> |
| </table> |
| <ul class="blockList"> |
| <li class="blockList"><a name="methods.inherited.from.class.org.apache.calcite.sql.SqlDialect"> |
| <!-- --> |
| </a> |
| <h3>Methods inherited from class org.apache.calcite.sql.<a href="../../../../../org/apache/calcite/sql/SqlDialect.html" title="class in org.apache.calcite.sql">SqlDialect</a></h3> |
| <code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html#allowsAs--">allowsAs</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#configureParser-org.apache.calcite.sql.parser.SqlParser.ConfigBuilder-">configureParser</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#containsNonAscii-java.lang.String-">containsNonAscii</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#create-java.sql.DatabaseMetaData-">create</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#defaultNullDirection-org.apache.calcite.rel.RelFieldCollation.Direction-">defaultNullDirection</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#emulateJoinTypeForCrossJoin--">emulateJoinTypeForCrossJoin</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#emulateNullDirectionWithIsNull-org.apache.calcite.sql.SqlNode-boolean-boolean-">emulateNullDirectionWithIsNull</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#getConformance--">getConformance</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#getDatabaseProduct--">getDatabaseProduct</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#getNullCollation--">getNullCollation</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#getProduct-java.lang.String-java.lang.String-">getProduct</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#getQuotedCasing--">getQuotedCasing</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#getQuoting--">getQuoting</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#getSingleRowTableName--">getSingleRowTableName</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#getTypeSystem--">getTypeSystem</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#getUnquotedCasing--">getUnquotedCasing</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#hasImplicitTableAlias--">hasImplicitTableAlias</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#identifierNeedsQuote-java.lang.String-">identifierNeedsQuote</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#isCaseSensitive--">isCaseSensitive</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#quoteIdentifier-java.lang.String-">quoteIdentifier</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#quoteIdentifier-java.lang.StringBuilder-java.util.List-">quoteIdentifier</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#quoteIdentifier-java.lang.StringBuilder-java.lang.String-">quoteIdentifier</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#quoteStringLiteral-java.lang.String-">quoteStringLiteral</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#quoteStringLiteral-java.lang.StringBuilder-java.lang.String-java.lang.String-">quoteStringLiteral</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#quoteStringLiteralUnicode-java.lang.StringBuilder-java.lang.String-">quoteStringLiteralUnicode</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#quoteTimestampLiteral-java.sql.Timestamp-">quoteTimestampLiteral</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#supportsDataType-org.apache.calcite.rel.type.RelDataType-">supportsDataType</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#supportsFunction-org.apache.calcite.sql.SqlOperator-org.apache.calcite.rel.type.RelDataType-java.util.List-">supportsFunction</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#supportsGroupByWithCube--">supportsGroupByWithCube</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#supportsImplicitTypeCoercion-org.apache.calcite.rex.RexCall-">supportsImplicitTypeCoercion</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#supportsOffsetFetch--">supportsOffsetFetch</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#supportsWindowFunctions--">supportsWindowFunctions</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#unparseDateTimeLiteral-org.apache.calcite.sql.SqlWriter-org.apache.calcite.sql.SqlAbstractDateTimeLiteral-int-int-">unparseDateTimeLiteral</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#unparseFetchUsingAnsi-org.apache.calcite.sql.SqlWriter-org.apache.calcite.sql.SqlNode-org.apache.calcite.sql.SqlNode-">unparseFetchUsingAnsi</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#unparseFetchUsingLimit-org.apache.calcite.sql.SqlWriter-org.apache.calcite.sql.SqlNode-org.apache.calcite.sql.SqlNode-">unparseFetchUsingLimit</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#unparseLimit-org.apache.calcite.sql.SqlWriter-org.apache.calcite.sql.SqlNode-">unparseLimit</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#unparseOffset-org.apache.calcite.sql.SqlWriter-org.apache.calcite.sql.SqlNode-">unparseOffset</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#unparseSqlDatetimeArithmetic-org.apache.calcite.sql.SqlWriter-org.apache.calcite.sql.SqlCall-org.apache.calcite.sql.SqlKind-int-int-">unparseSqlDatetimeArithmetic</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#unparseSqlIntervalLiteral-org.apache.calcite.sql.SqlWriter-org.apache.calcite.sql.SqlIntervalLiteral-int-int-">unparseSqlIntervalLiteral</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#unparseTopN-org.apache.calcite.sql.SqlWriter-org.apache.calcite.sql.SqlNode-org.apache.calcite.sql.SqlNode-">unparseTopN</a>, <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#unquoteStringLiteral-java.lang.String-">unquoteStringLiteral</a></code></li> |
| </ul> |
| <ul class="blockList"> |
| <li class="blockList"><a name="methods.inherited.from.class.java.lang.Object"> |
| <!-- --> |
| </a> |
| <h3>Methods inherited from class java.lang.<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a></h3> |
| <code><a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#clone--" title="class or interface in java.lang">clone</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#equals-java.lang.Object-" title="class or interface in java.lang">equals</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#finalize--" title="class or interface in java.lang">finalize</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#getClass--" title="class or interface in java.lang">getClass</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#hashCode--" title="class or interface in java.lang">hashCode</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#notify--" title="class or interface in java.lang">notify</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#notifyAll--" title="class or interface in java.lang">notifyAll</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#toString--" title="class or interface in java.lang">toString</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#wait--" title="class or interface in java.lang">wait</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#wait-long-" title="class or interface in java.lang">wait</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#wait-long-int-" title="class or interface in java.lang">wait</a></code></li> |
| </ul> |
| </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>Field Detail</h3> |
| <a name="MYSQL_TYPE_SYSTEM"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>MYSQL_TYPE_SYSTEM</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/rel/type/RelDataTypeSystem.html" title="interface in org.apache.calcite.rel.type">RelDataTypeSystem</a> MYSQL_TYPE_SYSTEM</pre> |
| <div class="block">MySQL type system.</div> |
| </li> |
| </ul> |
| <a name="DEFAULT_CONTEXT"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>DEFAULT_CONTEXT</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlDialect.Context.html" title="interface in org.apache.calcite.sql">SqlDialect.Context</a> DEFAULT_CONTEXT</pre> |
| </li> |
| </ul> |
| <a name="DEFAULT"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>DEFAULT</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlDialect.html" title="class in org.apache.calcite.sql">SqlDialect</a> DEFAULT</pre> |
| </li> |
| </ul> |
| <a name="ISNULL_FUNCTION"> |
| <!-- --> |
| </a> |
| <ul class="blockListLast"> |
| <li class="blockList"> |
| <h4>ISNULL_FUNCTION</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> ISNULL_FUNCTION</pre> |
| <div class="block">MySQL specific function.</div> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| <!-- ========= CONSTRUCTOR DETAIL ======== --> |
| <ul class="blockList"> |
| <li class="blockList"><a name="constructor.detail"> |
| <!-- --> |
| </a> |
| <h3>Constructor Detail</h3> |
| <a name="MysqlSqlDialect-org.apache.calcite.sql.SqlDialect.Context-"> |
| <!-- --> |
| </a> |
| <ul class="blockListLast"> |
| <li class="blockList"> |
| <h4>MysqlSqlDialect</h4> |
| <pre>public MysqlSqlDialect(<a href="../../../../../org/apache/calcite/sql/SqlDialect.Context.html" title="interface in org.apache.calcite.sql">SqlDialect.Context</a> context)</pre> |
| <div class="block">Creates a MysqlSqlDialect.</div> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| <!-- ============ METHOD DETAIL ========== --> |
| <ul class="blockList"> |
| <li class="blockList"><a name="method.detail"> |
| <!-- --> |
| </a> |
| <h3>Method Detail</h3> |
| <a name="supportsCharSet--"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>supportsCharSet</h4> |
| <pre>public boolean supportsCharSet()</pre> |
| <div class="block"><span class="descfrmTypeLabel">Description copied from class: <code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html#supportsCharSet--">SqlDialect</a></code></span></div> |
| <div class="block">Returns whether the dialect supports character set names as part of a |
| data type, for instance <code>VARCHAR(30) CHARACTER SET `ISO-8859-1`</code>.</div> |
| <dl> |
| <dt><span class="overrideSpecifyLabel">Overrides:</span></dt> |
| <dd><code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html#supportsCharSet--">supportsCharSet</a></code> in class <code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html" title="class in org.apache.calcite.sql">SqlDialect</a></code></dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="requiresAliasForFromItems--"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>requiresAliasForFromItems</h4> |
| <pre>public boolean requiresAliasForFromItems()</pre> |
| <div class="block"><span class="descfrmTypeLabel">Description copied from class: <code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html#requiresAliasForFromItems--">SqlDialect</a></code></span></div> |
| <div class="block">Whether a sub-query in the FROM clause must have an alias. |
| |
| <p>For example, in PostgreSQL, this query is legal: |
| |
| <blockquote><code>SELECT * FROM (SELECT * FROM Emp) As e</code></blockquote> |
| |
| <p>but remove the alias <code>e</code> and it is not: |
| |
| <blockquote><code>SELECT * FROM (SELECT * FROM Emp)</code></blockquote> |
| |
| <p>In Oracle, both queries are legal.</div> |
| <dl> |
| <dt><span class="overrideSpecifyLabel">Overrides:</span></dt> |
| <dd><code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html#requiresAliasForFromItems--">requiresAliasForFromItems</a></code> in class <code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html" title="class in org.apache.calcite.sql">SqlDialect</a></code></dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="supportsAliasedValues--"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>supportsAliasedValues</h4> |
| <pre>public boolean supportsAliasedValues()</pre> |
| <div class="block"><span class="descfrmTypeLabel">Description copied from class: <code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html#supportsAliasedValues--">SqlDialect</a></code></span></div> |
| <div class="block">Returns whether the dialect supports VALUES in a sub-query with |
| and an "AS t(column, ...)" values to define column names. |
| |
| <p>Currently, only Oracle does not. For this, we generate "SELECT v0 AS c0, |
| v1 AS c1 ... UNION ALL ...". We may need to refactor this method when we |
| support VALUES for other dialects.</div> |
| <dl> |
| <dt><span class="overrideSpecifyLabel">Overrides:</span></dt> |
| <dd><code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html#supportsAliasedValues--">supportsAliasedValues</a></code> in class <code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html" title="class in org.apache.calcite.sql">SqlDialect</a></code></dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="unparseOffsetFetch-org.apache.calcite.sql.SqlWriter-org.apache.calcite.sql.SqlNode-org.apache.calcite.sql.SqlNode-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>unparseOffsetFetch</h4> |
| <pre>public void unparseOffsetFetch(<a href="../../../../../org/apache/calcite/sql/SqlWriter.html" title="interface in org.apache.calcite.sql">SqlWriter</a> writer, |
| <a href="../../../../../org/apache/calcite/sql/SqlNode.html" title="class in org.apache.calcite.sql">SqlNode</a> offset, |
| <a href="../../../../../org/apache/calcite/sql/SqlNode.html" title="class in org.apache.calcite.sql">SqlNode</a> fetch)</pre> |
| <div class="block"><span class="descfrmTypeLabel">Description copied from class: <code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html#unparseOffsetFetch-org.apache.calcite.sql.SqlWriter-org.apache.calcite.sql.SqlNode-org.apache.calcite.sql.SqlNode-">SqlDialect</a></code></span></div> |
| <div class="block">Converts an offset and fetch into SQL. |
| |
| <p>At least one of <code>offset</code> and <code>fetch</code> must be provided. |
| |
| <p>Common options: |
| <ul> |
| <li><code>OFFSET offset ROWS FETCH NEXT fetch ROWS ONLY</code> |
| (ANSI standard SQL, Oracle, PostgreSQL, and the default) |
| <li><code>LIMIT fetch OFFSET offset</code> (Apache Hive, MySQL, Redshift) |
| </ul></div> |
| <dl> |
| <dt><span class="overrideSpecifyLabel">Overrides:</span></dt> |
| <dd><code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html#unparseOffsetFetch-org.apache.calcite.sql.SqlWriter-org.apache.calcite.sql.SqlNode-org.apache.calcite.sql.SqlNode-">unparseOffsetFetch</a></code> in class <code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html" title="class in org.apache.calcite.sql">SqlDialect</a></code></dd> |
| <dt><span class="paramLabel">Parameters:</span></dt> |
| <dd><code>writer</code> - Writer</dd> |
| <dd><code>offset</code> - Number of rows to skip before emitting, or null</dd> |
| <dd><code>fetch</code> - Number of rows to fetch, or null</dd> |
| <dt><span class="seeLabel">See Also:</span></dt> |
| <dd><a href="../../../../../org/apache/calcite/sql/SqlDialect.html#unparseFetchUsingAnsi-org.apache.calcite.sql.SqlWriter-org.apache.calcite.sql.SqlNode-org.apache.calcite.sql.SqlNode-"><code>SqlDialect.unparseFetchUsingAnsi(SqlWriter, SqlNode, SqlNode)</code></a>, |
| <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#unparseFetchUsingLimit-org.apache.calcite.sql.SqlWriter-org.apache.calcite.sql.SqlNode-org.apache.calcite.sql.SqlNode-"><code>SqlDialect.unparseFetchUsingLimit(SqlWriter, SqlNode, SqlNode)</code></a></dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="emulateNullDirection-org.apache.calcite.sql.SqlNode-boolean-boolean-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>emulateNullDirection</h4> |
| <pre>public <a href="../../../../../org/apache/calcite/sql/SqlNode.html" title="class in org.apache.calcite.sql">SqlNode</a> emulateNullDirection(<a href="../../../../../org/apache/calcite/sql/SqlNode.html" title="class in org.apache.calcite.sql">SqlNode</a> node, |
| boolean nullsFirst, |
| boolean desc)</pre> |
| <div class="block"><span class="descfrmTypeLabel">Description copied from class: <code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html#emulateNullDirection-org.apache.calcite.sql.SqlNode-boolean-boolean-">SqlDialect</a></code></span></div> |
| <div class="block">Returns the SqlNode for emulating the null direction for the given field |
| or <code>null</code> if no emulation needs to be done.</div> |
| <dl> |
| <dt><span class="overrideSpecifyLabel">Overrides:</span></dt> |
| <dd><code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html#emulateNullDirection-org.apache.calcite.sql.SqlNode-boolean-boolean-">emulateNullDirection</a></code> in class <code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html" title="class in org.apache.calcite.sql">SqlDialect</a></code></dd> |
| <dt><span class="paramLabel">Parameters:</span></dt> |
| <dd><code>node</code> - The SqlNode representing the expression</dd> |
| <dd><code>nullsFirst</code> - Whether nulls should come first</dd> |
| <dd><code>desc</code> - Whether the sort direction is |
| <a href="../../../../../org/apache/calcite/rel/RelFieldCollation.Direction.html#DESCENDING"><code>RelFieldCollation.Direction.DESCENDING</code></a> or |
| <a href="../../../../../org/apache/calcite/rel/RelFieldCollation.Direction.html#STRICTLY_DESCENDING"><code>RelFieldCollation.Direction.STRICTLY_DESCENDING</code></a></dd> |
| <dt><span class="returnLabel">Returns:</span></dt> |
| <dd>A SqlNode for null direction emulation or <code>null</code> if not required</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="supportsAggregateFunction-org.apache.calcite.sql.SqlKind-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>supportsAggregateFunction</h4> |
| <pre>public boolean supportsAggregateFunction(<a href="../../../../../org/apache/calcite/sql/SqlKind.html" title="enum in org.apache.calcite.sql">SqlKind</a> kind)</pre> |
| <dl> |
| <dt><span class="overrideSpecifyLabel">Overrides:</span></dt> |
| <dd><code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html#supportsAggregateFunction-org.apache.calcite.sql.SqlKind-">supportsAggregateFunction</a></code> in class <code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html" title="class in org.apache.calcite.sql">SqlDialect</a></code></dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="supportsNestedAggregations--"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>supportsNestedAggregations</h4> |
| <pre>public boolean supportsNestedAggregations()</pre> |
| <div class="block"><span class="descfrmTypeLabel">Description copied from class: <code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html#supportsNestedAggregations--">SqlDialect</a></code></span></div> |
| <div class="block">Returns whether the dialect supports nested aggregations, for instance |
| <code>SELECT SUM(SUM(1)) </code>.</div> |
| <dl> |
| <dt><span class="overrideSpecifyLabel">Overrides:</span></dt> |
| <dd><code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html#supportsNestedAggregations--">supportsNestedAggregations</a></code> in class <code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html" title="class in org.apache.calcite.sql">SqlDialect</a></code></dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="supportsGroupByWithRollup--"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>supportsGroupByWithRollup</h4> |
| <pre>public boolean supportsGroupByWithRollup()</pre> |
| <div class="block"><span class="descfrmTypeLabel">Description copied from class: <code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html#supportsGroupByWithRollup--">SqlDialect</a></code></span></div> |
| <div class="block">Returns whether this dialect supports "WITH ROLLUP" in the "GROUP BY" |
| clause. |
| |
| <p>For instance, in MySQL version 5, |
| |
| <blockquote> |
| <code> |
| SELECT deptno, job, COUNT(*) AS c |
| FROM emp |
| GROUP BY deptno, job WITH ROLLUP |
| </code> |
| </blockquote> |
| |
| <p>is equivalent to standard SQL |
| |
| <blockquote> |
| <code> |
| SELECT deptno, job, COUNT(*) AS c |
| FROM emp |
| GROUP BY ROLLUP(deptno, job) |
| ORDER BY deptno, job |
| </code> |
| </blockquote> |
| |
| <p>The "WITH ROLLUP" clause was introduced in MySQL and is not standard |
| SQL. |
| |
| <p>See also <a href="../../../../../org/apache/calcite/sql/SqlDialect.html#supportsAggregateFunction-org.apache.calcite.sql.SqlKind-"><code>SqlDialect.supportsAggregateFunction(SqlKind)</code></a> applied to |
| <a href="../../../../../org/apache/calcite/sql/SqlKind.html#ROLLUP"><code>SqlKind.ROLLUP</code></a>, which returns true in MySQL 8 and higher.</div> |
| <dl> |
| <dt><span class="overrideSpecifyLabel">Overrides:</span></dt> |
| <dd><code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html#supportsGroupByWithRollup--">supportsGroupByWithRollup</a></code> in class <code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html" title="class in org.apache.calcite.sql">SqlDialect</a></code></dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="getCalendarPolicy--"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>getCalendarPolicy</h4> |
| <pre>public <a href="../../../../../org/apache/calcite/sql/SqlDialect.CalendarPolicy.html" title="enum in org.apache.calcite.sql">SqlDialect.CalendarPolicy</a> getCalendarPolicy()</pre> |
| <dl> |
| <dt><span class="overrideSpecifyLabel">Overrides:</span></dt> |
| <dd><code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html#getCalendarPolicy--">getCalendarPolicy</a></code> in class <code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html" title="class in org.apache.calcite.sql">SqlDialect</a></code></dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="getCastSpec-org.apache.calcite.rel.type.RelDataType-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>getCastSpec</h4> |
| <pre>public <a href="../../../../../org/apache/calcite/sql/SqlNode.html" title="class in org.apache.calcite.sql">SqlNode</a> getCastSpec(<a href="../../../../../org/apache/calcite/rel/type/RelDataType.html" title="interface in org.apache.calcite.rel.type">RelDataType</a> type)</pre> |
| <div class="block"><span class="descfrmTypeLabel">Description copied from class: <code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html#getCastSpec-org.apache.calcite.rel.type.RelDataType-">SqlDialect</a></code></span></div> |
| <div class="block">Returns SqlNode for type in "cast(column as type)", which might be |
| different between databases by type name, precision etc.</div> |
| <dl> |
| <dt><span class="overrideSpecifyLabel">Overrides:</span></dt> |
| <dd><code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html#getCastSpec-org.apache.calcite.rel.type.RelDataType-">getCastSpec</a></code> in class <code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html" title="class in org.apache.calcite.sql">SqlDialect</a></code></dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="rewriteSingleValueExpr-org.apache.calcite.sql.SqlNode-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>rewriteSingleValueExpr</h4> |
| <pre>public <a href="../../../../../org/apache/calcite/sql/SqlNode.html" title="class in org.apache.calcite.sql">SqlNode</a> rewriteSingleValueExpr(<a href="../../../../../org/apache/calcite/sql/SqlNode.html" title="class in org.apache.calcite.sql">SqlNode</a> aggCall)</pre> |
| <div class="block"><span class="descfrmTypeLabel">Description copied from class: <code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html#rewriteSingleValueExpr-org.apache.calcite.sql.SqlNode-">SqlDialect</a></code></span></div> |
| <div class="block">Rewrite SINGLE_VALUE into expression based on database variants |
| E.g. HSQLDB, MYSQL, ORACLE, etc</div> |
| <dl> |
| <dt><span class="overrideSpecifyLabel">Overrides:</span></dt> |
| <dd><code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html#rewriteSingleValueExpr-org.apache.calcite.sql.SqlNode-">rewriteSingleValueExpr</a></code> in class <code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html" title="class in org.apache.calcite.sql">SqlDialect</a></code></dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="unparseCall-org.apache.calcite.sql.SqlWriter-org.apache.calcite.sql.SqlCall-int-int-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>unparseCall</h4> |
| <pre>public void unparseCall(<a href="../../../../../org/apache/calcite/sql/SqlWriter.html" title="interface in org.apache.calcite.sql">SqlWriter</a> writer, |
| <a href="../../../../../org/apache/calcite/sql/SqlCall.html" title="class in org.apache.calcite.sql">SqlCall</a> call, |
| int leftPrec, |
| int rightPrec)</pre> |
| <dl> |
| <dt><span class="overrideSpecifyLabel">Overrides:</span></dt> |
| <dd><code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html#unparseCall-org.apache.calcite.sql.SqlWriter-org.apache.calcite.sql.SqlCall-int-int-">unparseCall</a></code> in class <code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html" title="class in org.apache.calcite.sql">SqlDialect</a></code></dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="unparseSqlIntervalQualifier-org.apache.calcite.sql.SqlWriter-org.apache.calcite.sql.SqlIntervalQualifier-org.apache.calcite.rel.type.RelDataTypeSystem-"> |
| <!-- --> |
| </a> |
| <ul class="blockListLast"> |
| <li class="blockList"> |
| <h4>unparseSqlIntervalQualifier</h4> |
| <pre>public void unparseSqlIntervalQualifier(<a href="../../../../../org/apache/calcite/sql/SqlWriter.html" title="interface in org.apache.calcite.sql">SqlWriter</a> writer, |
| <a href="../../../../../org/apache/calcite/sql/SqlIntervalQualifier.html" title="class in org.apache.calcite.sql">SqlIntervalQualifier</a> qualifier, |
| <a href="../../../../../org/apache/calcite/rel/type/RelDataTypeSystem.html" title="interface in org.apache.calcite.rel.type">RelDataTypeSystem</a> typeSystem)</pre> |
| <div class="block"><span class="descfrmTypeLabel">Description copied from class: <code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html#unparseSqlIntervalQualifier-org.apache.calcite.sql.SqlWriter-org.apache.calcite.sql.SqlIntervalQualifier-org.apache.calcite.rel.type.RelDataTypeSystem-">SqlDialect</a></code></span></div> |
| <div class="block">Converts an interval qualifier to a SQL string. The default implementation |
| returns strings such as |
| <code>INTERVAL '1 2:3:4' DAY(4) TO SECOND(4)</code>.</div> |
| <dl> |
| <dt><span class="overrideSpecifyLabel">Overrides:</span></dt> |
| <dd><code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html#unparseSqlIntervalQualifier-org.apache.calcite.sql.SqlWriter-org.apache.calcite.sql.SqlIntervalQualifier-org.apache.calcite.rel.type.RelDataTypeSystem-">unparseSqlIntervalQualifier</a></code> in class <code><a href="../../../../../org/apache/calcite/sql/SqlDialect.html" title="class in org.apache.calcite.sql">SqlDialect</a></code></dd> |
| </dl> |
| </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="Skip navigation links">Skip navigation links</a></div> |
| <a name="navbar.bottom.firstrow"> |
| <!-- --> |
| </a> |
| <ul class="navList" title="Navigation"> |
| <li><a href="../../../../../overview-summary.html">Overview</a></li> |
| <li><a href="package-summary.html">Package</a></li> |
| <li class="navBarCell1Rev">Class</li> |
| <li><a href="package-tree.html">Tree</a></li> |
| <li><a href="../../../../../deprecated-list.html">Deprecated</a></li> |
| <li><a href="../../../../../index-all.html">Index</a></li> |
| <li><a href="../../../../../help-doc.html">Help</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/dialect/MssqlSqlDialect.html" title="class in org.apache.calcite.sql.dialect"><span class="typeNameLink">Prev Class</span></a></li> |
| <li><a href="../../../../../org/apache/calcite/sql/dialect/NeoviewSqlDialect.html" title="class in org.apache.calcite.sql.dialect"><span class="typeNameLink">Next Class</span></a></li> |
| </ul> |
| <ul class="navList"> |
| <li><a href="../../../../../index.html?org/apache/calcite/sql/dialect/MysqlSqlDialect.html" target="_top">Frames</a></li> |
| <li><a href="MysqlSqlDialect.html" target="_top">No Frames</a></li> |
| </ul> |
| <ul class="navList" id="allclasses_navbar_bottom"> |
| <li><a href="../../../../../allclasses-noframe.html">All Classes</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>Summary: </li> |
| <li><a href="#nested.classes.inherited.from.class.org.apache.calcite.sql.SqlDialect">Nested</a> | </li> |
| <li><a href="#field.summary">Field</a> | </li> |
| <li><a href="#constructor.summary">Constr</a> | </li> |
| <li><a href="#method.summary">Method</a></li> |
| </ul> |
| <ul class="subNavList"> |
| <li>Detail: </li> |
| <li><a href="#field.detail">Field</a> | </li> |
| <li><a href="#constructor.detail">Constr</a> | </li> |
| <li><a href="#method.detail">Method</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> |
