svn commit: r1717733 - /calcite/site/docs/reference.html

[jh...@apache.org]

Author: jhyde
Date: Thu Dec  3 10:31:41 2015
New Revision: 1717733

URL: http://svn.apache.org/viewvc?rev=1717733&view=rev
Log:
[CALCITE-997] Document keywords

Modified:
    calcite/site/docs/reference.html

Modified: calcite/site/docs/reference.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/reference.html?rev=1717733&r1=1717732&r2=1717733&view=diff
==============================================================================
--- calcite/site/docs/reference.html (original)
+++ calcite/site/docs/reference.html Thu Dec  3 10:31:41 2015
@@ -799,6 +799,537 @@ and EXISTS expressions.  A sub-query tha
 EXISTS expressions may be correlated; that is, refer to tables in
 the FROM clause of an enclosing query.</p>
 
+<h2 id="keywords">Keywords</h2>
+
+<p>The following is a list of SQL keywords.
+Reserved keywords are <strong>bold</strong>.</p>
+
+<p>A,
+<strong>ABS</strong>,
+ABSOLUTE,
+ACTION,
+ADA,
+ADD,
+ADMIN,
+AFTER,
+<strong>ALL</strong>,
+<strong>ALLOCATE</strong>,
+<strong>ALLOW</strong>,
+<strong>ALTER</strong>,
+ALWAYS,
+<strong>AND</strong>,
+<strong>ANY</strong>,
+<strong>ARE</strong>,
+<strong>ARRAY</strong>,
+<strong>AS</strong>,
+ASC,
+<strong>ASENSITIVE</strong>,
+ASSERTION,
+ASSIGNMENT,
+<strong>ASYMMETRIC</strong>,
+<strong>AT</strong>,
+<strong>ATOMIC</strong>,
+ATTRIBUTE,
+ATTRIBUTES,
+<strong>AUTHORIZATION</strong>,
+<strong>AVG</strong>,
+BEFORE,
+<strong>BEGIN</strong>,
+BERNOULLI,
+<strong>BETWEEN</strong>,
+<strong>BIGINT</strong>,
+<strong>BINARY</strong>,
+<strong>BIT</strong>,
+<strong>BLOB</strong>,
+<strong>BOOLEAN</strong>,
+<strong>BOTH</strong>,
+BREADTH,
+<strong>BY</strong>,
+C,
+<strong>CALL</strong>,
+<strong>CALLED</strong>,
+<strong>CARDINALITY</strong>,
+CASCADE,
+<strong>CASCADED</strong>,
+<strong>CASE</strong>,
+<strong>CAST</strong>,
+CATALOG,
+CATALOG_NAME,
+<strong>CEIL</strong>,
+<strong>CEILING</strong>,
+CHAIN,
+<strong>CHAR</strong>,
+<strong>CHARACTER</strong>,
+CHARACTERISTICTS,
+CHARACTERS,
+<strong>CHARACTER_LENGTH</strong>,
+CHARACTER_SET_CATALOG,
+CHARACTER_SET_NAME,
+CHARACTER_SET_SCHEMA,
+<strong>CHAR_LENGTH</strong>,
+<strong>CHECK</strong>,
+CLASS_ORIGIN,
+<strong>CLOB</strong>,
+<strong>CLOSE</strong>,
+<strong>COALESCE</strong>,
+COBOL,
+<strong>COLLATE</strong>,
+COLLATION,
+COLLATION_CATALOG,
+COLLATION_NAME,
+COLLATION_SCHEMA,
+<strong>COLLECT</strong>,
+<strong>COLUMN</strong>,
+COLUMN_NAME,
+COMMAND_FUNCTION,
+COMMAND_FUNCTION_CODE,
+<strong>COMMIT</strong>,
+COMMITTED,
+<strong>CONDITION</strong>,
+CONDITION_NUMBER,
+<strong>CONNECT</strong>,
+CONNECTION,
+CONNECTION_NAME,
+<strong>CONSTRAINT</strong>,
+CONSTRAINTS,
+CONSTRAINT_CATALOG,
+CONSTRAINT_NAME,
+CONSTRAINT_SCHEMA,
+CONSTRUCTOR,
+CONTAINS,
+CONTINUE,
+<strong>CONVERT</strong>,
+<strong>CORR</strong>,
+<strong>CORRESPONDING</strong>,
+<strong>COUNT</strong>,
+<strong>COVAR_POP</strong>,
+<strong>COVAR_SAMP</strong>,
+<strong>CREATE</strong>,
+<strong>CROSS</strong>,
+<strong>CUBE</strong>,
+<strong>CUME_DIST</strong>,
+<strong>CURRENT</strong>,
+<strong>CURRENT_CATALOG</strong>,
+<strong>CURRENT_DATE</strong>,
+<strong>CURRENT_DEFAULT_TRANSFORM_GROUP</strong>,
+<strong>CURRENT_PATH</strong>,
+<strong>CURRENT_ROLE</strong>,
+<strong>CURRENT_SCHEMA</strong>,
+<strong>CURRENT_TIME</strong>,
+<strong>CURRENT_TIMESTAMP</strong>,
+<strong>CURRENT_TRANSFORM_GROUP_FOR_TYPE</strong>,
+<strong>CURRENT_USER</strong>,
+<strong>CURSOR</strong>,
+CURSOR_NAME,
+<strong>CYCLE</strong>,
+DATA,
+<strong>DATE</strong>,
+DATETIME_INTERVAL_CODE,
+DATETIME_INTERVAL_PRECISION,
+<strong>DAY</strong>,
+<strong>DEALLOCATE</strong>,
+<strong>DEC</strong>,
+<strong>DECIMAL</strong>,
+<strong>DECLARE</strong>,
+<strong>DEFAULT</strong>,
+DEFAULTS,
+DEFERRABLE,
+DEFERRED,
+DEFINED,
+DEFINER,
+DEGREE,
+<strong>DELETE</strong>,
+<strong>DENSE_RANK</strong>,
+DEPTH,
+<strong>DEREF</strong>,
+DERIVED,
+DESC,
+<strong>DESCRIBE</strong>,
+DESCRIPTION,
+DESCRIPTOR,
+<strong>DETERMINISTIC</strong>,
+DIAGNOSTICS,
+<strong>DISALLOW</strong>,
+<strong>DISCONNECT</strong>,
+DISPATCH,
+<strong>DISTINCT</strong>,
+DOMAIN,
+<strong>DOUBLE</strong>,
+<strong>DROP</strong>,
+<strong>DYNAMIC</strong>,
+DYNAMIC_FUNCTION,
+DYNAMIC_FUNCTION_CODE,
+<strong>EACH</strong>,
+<strong>ELEMENT</strong>,
+<strong>ELSE</strong>,
+<strong>END</strong>,
+<strong>END-EXEC</strong>,
+EQUALS,
+<strong>ESCAPE</strong>,
+<strong>EVERY</strong>,
+<strong>EXCEPT</strong>,
+EXCEPTION,
+EXCLUDE,
+EXCLUDING,
+<strong>EXEC</strong>,
+<strong>EXECUTE</strong>,
+<strong>EXISTS</strong>,
+<strong>EXP</strong>,
+<strong>EXPLAIN</strong>,
+<strong>EXTEND</strong>,
+<strong>EXTERNAL</strong>,
+<strong>EXTRACT</strong>,
+<strong>FALSE</strong>,
+<strong>FETCH</strong>,
+<strong>FILTER</strong>,
+FINAL,
+FIRST,
+<strong>FIRST_VALUE</strong>,
+<strong>FLOAT</strong>,
+<strong>FLOOR</strong>,
+FOLLOWING,
+<strong>FOR</strong>,
+<strong>FOREIGN</strong>,
+FORTRAN,
+FOUND,
+<strong>FREE</strong>,
+<strong>FROM</strong>,
+<strong>FULL</strong>,
+<strong>FUNCTION</strong>,
+<strong>FUSION</strong>,
+G,
+GENERAL,
+GENERATED,
+<strong>GET</strong>,
+<strong>GLOBAL</strong>,
+GO,
+GOTO,
+<strong>GRANT</strong>,
+GRANTED,
+<strong>GROUP</strong>,
+<strong>GROUPING</strong>,
+<strong>HAVING</strong>,
+HIERARCHY,
+<strong>HOLD</strong>,
+<strong>HOUR</strong>,
+<strong>IDENTITY</strong>,
+IMMEDIATE,
+IMPLEMENTATION,
+<strong>IMPORT</strong>,
+<strong>IN</strong>,
+INCLUDING,
+INCREMENT,
+<strong>INDICATOR</strong>,
+INITIALLY,
+<strong>INNER</strong>,
+<strong>INOUT</strong>,
+INPUT,
+<strong>INSENSITIVE</strong>,
+<strong>INSERT</strong>,
+INSTANCE,
+INSTANTIABLE,
+<strong>INT</strong>,
+<strong>INTEGER</strong>,
+<strong>INTERSECT</strong>,
+<strong>INTERSECTION</strong>,
+<strong>INTERVAL</strong>,
+<strong>INTO</strong>,
+INVOKER,
+<strong>IS</strong>,
+ISOLATION,
+JAVA,
+<strong>JOIN</strong>,
+K,
+KEY,
+KEY_MEMBER,
+KEY_TYPE,
+LABEL,
+<strong>LANGUAGE</strong>,
+<strong>LARGE</strong>,
+LAST,
+<strong>LAST_VALUE</strong>,
+<strong>LATERAL</strong>,
+<strong>LEADING</strong>,
+<strong>LEFT</strong>,
+LENGTH,
+LEVEL,
+LIBRARY,
+<strong>LIKE</strong>,
+<strong>LIMIT</strong>,
+<strong>LN</strong>,
+<strong>LOCAL</strong>,
+<strong>LOCALTIME</strong>,
+<strong>LOCALTIMESTAMP</strong>,
+LOCATOR,
+<strong>LOWER</strong>,
+M,
+MAP,
+<strong>MATCH</strong>,
+MATCHED,
+<strong>MAX</strong>,
+MAXVALUE,
+<strong>MEMBER</strong>,
+<strong>MERGE</strong>,
+MESSAGE_LENGTH,
+MESSAGE_OCTET_LENGTH,
+MESSAGE_TEXT,
+<strong>METHOD</strong>,
+<strong>MIN</strong>,
+<strong>MINUTE</strong>,
+MINVALUE,
+<strong>MOD</strong>,
+<strong>MODIFIES</strong>,
+<strong>MODULE</strong>,
+<strong>MONTH</strong>,
+MORE,
+<strong>MULTISET</strong>,
+MUMPS,
+NAME,
+NAMES,
+<strong>NATIONAL</strong>,
+<strong>NATURAL</strong>,
+<strong>NCHAR</strong>,
+<strong>NCLOB</strong>,
+NESTING,
+<strong>NEW</strong>,
+<strong>NEXT</strong>,
+<strong>NO</strong>,
+<strong>NONE</strong>,
+<strong>NORMALIZE</strong>,
+NORMALIZED,
+<strong>NOT</strong>,
+<strong>NULL</strong>,
+NULLABLE,
+<strong>NULLIF</strong>,
+NULLS,
+NUMBER,
+<strong>NUMERIC</strong>,
+OBJECT,
+OCTETS,
+<strong>OCTET_LENGTH</strong>,
+<strong>OF</strong>,
+<strong>OFFSET</strong>,
+<strong>OLD</strong>,
+<strong>ON</strong>,
+<strong>ONLY</strong>,
+<strong>OPEN</strong>,
+OPTION,
+OPTIONS,
+<strong>OR</strong>,
+<strong>ORDER</strong>,
+ORDERING,
+ORDINALITY,
+OTHERS,
+<strong>OUT</strong>,
+<strong>OUTER</strong>,
+OUTPUT,
+<strong>OVER</strong>,
+<strong>OVERLAPS</strong>,
+<strong>OVERLAY</strong>,
+OVERRIDING,
+PAD,
+<strong>PARAMETER</strong>,
+PARAMETER_MODE,
+PARAMETER_NAME,
+PARAMETER_ORDINAL_POSITION,
+PARAMETER_SPECIFIC_CATALOG,
+PARAMETER_SPECIFIC_NAME,
+PARAMETER_SPECIFIC_SCHEMA,
+PARTIAL,
+<strong>PARTITION</strong>,
+PASCAL,
+PASSTHROUGH,
+PATH,
+<strong>PERCENTILE_CONT</strong>,
+<strong>PERCENTILE_DISC</strong>,
+<strong>PERCENT_RANK</strong>,
+PLACING,
+PLAN,
+PLI,
+<strong>POSITION</strong>,
+<strong>POWER</strong>,
+PRECEDING,
+<strong>PRECISION</strong>,
+<strong>PREPARE</strong>,
+PRESERVE,
+<strong>PRIMARY</strong>,
+PRIOR,
+PRIVILEGES,
+<strong>PROCEDURE</strong>,
+PUBLIC,
+<strong>RANGE</strong>,
+<strong>RANK</strong>,
+READ,
+<strong>READS</strong>,
+<strong>REAL</strong>,
+<strong>RECURSIVE</strong>,
+<strong>REF</strong>,
+<strong>REFERENCES</strong>,
+<strong>REFERENCING</strong>,
+<strong>REGR_AVGX</strong>,
+<strong>REGR_AVGY</strong>,
+<strong>REGR_COUNT</strong>,
+<strong>REGR_INTERCEPT</strong>,
+<strong>REGR_R2</strong>,
+<strong>REGR_SLOPE</strong>,
+<strong>REGR_SXX</strong>,
+<strong>REGR_SXY</strong>,
+<strong>REGR_SYY</strong>,
+RELATIVE,
+<strong>RELEASE</strong>,
+REPEATABLE,
+<strong>RESET</strong>,
+RESTART,
+RESTRICT,
+<strong>RESULT</strong>,
+<strong>RETURN</strong>,
+RETURNED_CARDINALITY,
+RETURNED_LENGTH,
+RETURNED_OCTET_LENGTH,
+RETURNED_SQLSTATE,
+<strong>RETURNS</strong>,
+<strong>REVOKE</strong>,
+<strong>RIGHT</strong>,
+ROLE,
+<strong>ROLLBACK</strong>,
+<strong>ROLLUP</strong>,
+ROUTINE,
+ROUTINE_CATALOG,
+ROUTINE_NAME,
+ROUTINE_SCHEMA,
+<strong>ROW</strong>,
+<strong>ROWS</strong>,
+ROW_COUNT,
+<strong>ROW_NUMBER</strong>,
+<strong>SAVEPOINT</strong>,
+SCALE,
+SCHEMA,
+SCHEMA_NAME,
+<strong>SCOPE</strong>,
+SCOPE_CATALOGS,
+SCOPE_NAME,
+SCOPE_SCHEMA,
+<strong>SCROLL</strong>,
+<strong>SEARCH</strong>,
+<strong>SECOND</strong>,
+SECTION,
+SECURITY,
+<strong>SELECT</strong>,
+SELF,
+<strong>SENSITIVE</strong>,
+SEQUENCE,
+SERIALIZABLE,
+SERVER,
+SERVER_NAME,
+SESSION,
+<strong>SESSION_USER</strong>,
+<strong>SET</strong>,
+SETS,
+<strong>SIMILAR</strong>,
+SIMPLE,
+SIZE,
+<strong>SMALLINT</strong>,
+<strong>SOME</strong>,
+SOURCE,
+SPACE,
+<strong>SPECIFIC</strong>,
+<strong>SPECIFICTYPE</strong>,
+SPECIFIC_NAME,
+<strong>SQL</strong>,
+<strong>SQLEXCEPTION</strong>,
+<strong>SQLSTATE</strong>,
+<strong>SQLWARNING</strong>,
+<strong>SQRT</strong>,
+<strong>START</strong>,
+STATE,
+STATEMENT,
+<strong>STATIC</strong>,
+<strong>STDDEV_POP</strong>,
+<strong>STDDEV_SAMP</strong>,
+<strong>STREAM</strong>,
+STRUCTURE,
+STYLE,
+SUBCLASS_ORIGIN,
+<strong>SUBMULTISET</strong>,
+SUBSTITUTE,
+<strong>SUBSTRING</strong>,
+<strong>SUM</strong>,
+<strong>SYMMETRIC</strong>,
+<strong>SYSTEM</strong>,
+<strong>SYSTEM_USER</strong>,
+<strong>TABLE</strong>,
+<strong>TABLESAMPLE</strong>,
+TABLE_NAME,
+TEMPORARY,
+<strong>THEN</strong>,
+TIES,
+<strong>TIME</strong>,
+<strong>TIMESTAMP</strong>,
+<strong>TIMEZONE_HOUR</strong>,
+<strong>TIMEZONE_MINUTE</strong>,
+<strong>TINYINT</strong>,
+<strong>TO</strong>,
+TOP_LEVEL_COUNT,
+<strong>TRAILING</strong>,
+TRANSACTION,
+TRANSACTIONS_ACTIVE,
+TRANSACTIONS_COMMITTED,
+TRANSACTIONS_ROLLED_BACK,
+TRANSFORM,
+TRANSFORMS,
+<strong>TRANSLATE</strong>,
+<strong>TRANSLATION</strong>,
+<strong>TREAT</strong>,
+<strong>TRIGGER</strong>,
+TRIGGER_CATALOG,
+TRIGGER_NAME,
+TRIGGER_SCHEMA,
+<strong>TRIM</strong>,
+<strong>TRUE</strong>,
+TYPE,
+<strong>UESCAPE</strong>,
+UNBOUNDED,
+UNCOMMITTED,
+UNDER,
+<strong>UNION</strong>,
+<strong>UNIQUE</strong>,
+<strong>UNKNOWN</strong>,
+UNNAMED,
+<strong>UNNEST</strong>,
+<strong>UPDATE</strong>,
+<strong>UPPER</strong>,
+<strong>UPSERT</strong>,
+USAGE,
+<strong>USER</strong>,
+USER_DEFINED_TYPE_CATALOG,
+USER_DEFINED_TYPE_CODE,
+USER_DEFINED_TYPE_NAME,
+USER_DEFINED_TYPE_SCHEMA,
+<strong>USING</strong>,
+<strong>VALUE</strong>,
+<strong>VALUES</strong>,
+<strong>VARBINARY</strong>,
+<strong>VARCHAR</strong>,
+<strong>VARYING</strong>,
+<strong>VAR_POP</strong>,
+<strong>VAR_SAMP</strong>,
+VERSION,
+VIEW,
+<strong>WHEN</strong>,
+<strong>WHENEVER</strong>,
+<strong>WHERE</strong>,
+<strong>WIDTH_BUCKET</strong>,
+<strong>WINDOW</strong>,
+<strong>WITH</strong>,
+<strong>WITHIN</strong>,
+<strong>WITHOUT</strong>,
+WORK,
+WRAPPER,
+WRITE,
+XML,
+<strong>YEAR</strong>,
+ZONE.</p>
+
 <h2 id="identifiers">Identifiers</h2>
 
 <p>Identifiers are the names of tables, columns and other metadata