You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Julian Hyde (JIRA)" <ji...@apache.org> on 2016/03/03 20:04:18 UTC
[jira] [Commented] (CALCITE-1120) Support SELECT without FROM
syntax (similar to MySQL)
[ https://issues.apache.org/jira/browse/CALCITE-1120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15178383#comment-15178383 ]
Julian Hyde commented on CALCITE-1120:
--------------------------------------
SELECT without a FROM clause is not standard SQL. Calcite supports the standard syntax
{code}VALUES 2 + 2{code}
We could consider adding support for {{SELECT <expression-list>}}, which we would allow in MySQL and Postgres compatibility mode.
We could also allow {{SELECT 2 + 2 FROM dual}} in Oracle compatibility mode.
> Support SELECT without FROM syntax (similar to MySQL)
> -----------------------------------------------------
>
> Key: CALCITE-1120
> URL: https://issues.apache.org/jira/browse/CALCITE-1120
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.4.0-incubating
> Environment: 1.4.0-incubating
> Reporter: Shyam
> Assignee: Julian Hyde
> Labels: dialect
>
> Calcite is unable to parse "select 2+2;"
> when i try to parse the below query
> {code}
> select 2+2;
> {code}
> Me getting error as below
> {noformat}
> org.apache.calcite.sql.parser.impl.ParseException: Encountered "<EOF>" at line 1, column 22.
> Was expecting one of:
> "FROM" ...
> "," ...
> "AS" ...
> <IDENTIFIER> ...
> <QUOTED_IDENTIFIER> ...
> <BACK_QUOTED_IDENTIFIER> ...
> <BRACKET_QUOTED_IDENTIFIER> ...
> <UNICODE_QUOTED_IDENTIFIER> ...
> "A" ...
> "ABSOLUTE" ...
> "ACTION" ...
> "ADA" ...
> "ADD" ...
> "ADMIN" ...
> "AFTER" ...
> "ALWAYS" ...
> "ASC" ...
> "ASSERTION" ...
> "ASSIGNMENT" ...
> "ATTRIBUTE" ...
> "ATTRIBUTES" ...
> "BEFORE" ...
> "BERNOULLI" ...
> "BREADTH" ...
> "C" ...
> "CASCADE" ...
> "CATALOG" ...
> "CATALOG_NAME" ...
> "CHAIN" ...
> "CHARACTER_SET_CATALOG" ...
> "CHARACTER_SET_NAME" ...
> "CHARACTER_SET_SCHEMA" ...
> "CHARACTERISTICTS" ...
> "CHARACTERS" ...
> "CLASS_ORIGIN" ...
> "COBOL" ...
> "COLLATION" ...
> "COLLATION_CATALOG" ...
> "COLLATION_NAME" ...
> "COLLATION_SCHEMA" ...
> "COLUMN_NAME" ...
> "COMMAND_FUNCTION" ...
> "COMMAND_FUNCTION_CODE" ...
> "COMMITTED" ...
> "CONDITION_NUMBER" ...
> "CONNECTION" ...
> "CONNECTION_NAME" ...
> "CONSTRAINT_CATALOG" ...
> "CONSTRAINT_NAME" ...
> "CONSTRAINT_SCHEMA" ...
> "CONSTRAINTS" ...
> "CONSTRUCTOR" ...
> "CONTAINS" ...
> "CONTINUE" ...
> "CURSOR_NAME" ...
> "DATA" ...
> "DATETIME_INTERVAL_CODE" ...
> "DATETIME_INTERVAL_PRECISION" ...
> "DEFAULTS" ...
> "DEFERRABLE" ...
> "DEFERRED" ...
> "DEFINED" ...
> "DEFINER" ...
> "DEGREE" ...
> "DEPTH" ...
> "DERIVED" ...
> "DESC" ...
> "DESCRIPTION" ...
> "DESCRIPTOR" ...
> "DIAGNOSTICS" ...
> "DISPATCH" ...
> "DOMAIN" ...
> "DYNAMIC_FUNCTION" ...
> "DYNAMIC_FUNCTION_CODE" ...
> "EQUALS" ...
> "EXCEPTION" ...
> "EXCLUDE" ...
> "EXCLUDING" ...
> "FINAL" ...
> "FIRST" ...
> "FOLLOWING" ...
> "FORTRAN" ...
> "FOUND" ...
> "G" ...
> "GENERAL" ...
> "GENERATED" ...
> "GO" ...
> "GOTO" ...
> "GRANTED" ...
> "HIERARCHY" ...
> "IMMEDIATE" ...
> "IMPLEMENTATION" ...
> "INCLUDING" ...
> "INCREMENT" ...
> "INITIALLY" ...
> "INPUT" ...
> "INSTANCE" ...
> "INSTANTIABLE" ...
> "INVOKER" ...
> "ISOLATION" ...
> "JAVA" ...
> "K" ...
> "KEY" ...
> "KEY_MEMBER" ...
> "KEY_TYPE" ...
> "LABEL" ...
> "LAST" ...
> "LENGTH" ...
> "LEVEL" ...
> "LIBRARY" ...
> "LOCATOR" ...
> "M" ...
> "MAP" ...
> "MATCHED" ...
> "MAXVALUE" ...
> "MESSAGE_LENGTH" ...
> "MESSAGE_OCTET_LENGTH" ...
> "MESSAGE_TEXT" ...
> "MINVALUE" ...
> "MORE" ...
> "MUMPS" ...
> "NAME" ...
> "NAMES" ...
> "NESTING" ...
> "NORMALIZED" ...
> "NULLABLE" ...
> "NULLS" ...
> "NUMBER" ...
> "OBJECT" ...
> "OCTETS" ...
> "OPTION" ...
> "OPTIONS" ...
> "ORDERING" ...
> "ORDINALITY" ...
> "OTHERS" ...
> "OUTPUT" ...
> "OVERRIDING" ...
> "PAD" ...
> "PARAMETER_MODE" ...
> "PARAMETER_NAME" ...
> "PARAMETER_ORDINAL_POSITION" ...
> "PARAMETER_SPECIFIC_CATALOG" ...
> "PARAMETER_SPECIFIC_NAME" ...
> "PARAMETER_SPECIFIC_SCHEMA" ...
> "PARTIAL" ...
> "PASCAL" ...
> "PASSTHROUGH" ...
> "PATH" ...
> "PLACING" ...
> "PLAN" ...
> "PLI" ...
> "PRECEDING" ...
> "PRESERVE" ...
> "PRIOR" ...
> "PRIVILEGES" ...
> "PUBLIC" ...
> "READ" ...
> "RELATIVE" ...
> "REPEATABLE" ...
> "RESTART" ...
> "RESTRICT" ...
> "RETURNED_CARDINALITY" ...
> "RETURNED_LENGTH" ...
> "RETURNED_OCTET_LENGTH" ...
> "RETURNED_SQLSTATE" ...
> "ROLE" ...
> "ROUTINE" ...
> "ROUTINE_CATALOG" ...
> "ROUTINE_NAME" ...
> "ROUTINE_SCHEMA" ...
> "ROW_COUNT" ...
> "SCALE" ...
> "SCHEMA" ...
> "SCHEMA_NAME" ...
> "SCOPE_CATALOGS" ...
> "SCOPE_NAME" ...
> "SCOPE_SCHEMA" ...
> "SECTION" ...
> "SECURITY" ...
> "SELF" ...
> "SEQUENCE" ...
> "SERIALIZABLE" ...
> "SERVER" ...
> "SERVER_NAME" ...
> "SESSION" ...
> "SETS" ...
> "SIMPLE" ...
> "SIZE" ...
> "SOURCE" ...
> "SPACE" ...
> "SPECIFIC_NAME" ...
> "STATE" ...
> "STATEMENT" ...
> "STRUCTURE" ...
> "STYLE" ...
> "SUBCLASS_ORIGIN" ...
> "SUBSTITUTE" ...
> "TABLE_NAME" ...
> "TEMPORARY" ...
> "TIES" ...
> "TOP_LEVEL_COUNT" ...
> "TRANSACTION" ...
> "TRANSACTIONS_ACTIVE" ...
> "TRANSACTIONS_COMMITTED" ...
> "TRANSACTIONS_ROLLED_BACK" ...
> "TRANSFORM" ...
> "TRANSFORMS" ...
> "TRIGGER_CATALOG" ...
> "TRIGGER_NAME" ...
> "TRIGGER_SCHEMA" ...
> "TYPE" ...
> "UNBOUNDED" ...
> "UNCOMMITTED" ...
> "UNDER" ...
> "UNNAMED" ...
> "USAGE" ...
> "USER_DEFINED_TYPE_CATALOG" ...
> "USER_DEFINED_TYPE_CODE" ...
> "USER_DEFINED_TYPE_NAME" ...
> "USER_DEFINED_TYPE_SCHEMA" ...
> "VERSION" ...
> "VIEW" ...
> "WRAPPER" ...
> "WORK" ...
> "WRITE" ...
> "XML" ...
> "ZONE" ...
> "NOT" ...
> "IN" ...
> "BETWEEN" ...
> "LIKE" ...
> "SIMILAR" ...
> "=" ...
> ">" ...
> "<" ...
> "<=" ...
> ">=" ...
> "<>" ...
> "+" ...
> "-" ...
> "*" ...
> "/" ...
> "||" ...
> "AND" ...
> "OR" ...
> "IS" ...
> "MEMBER" ...
> "SUBMULTISET" ...
> "MULTISET" ...
> "[" ...
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)