Lukas Eder created IGNITE-14041:
-----------------------------------
Summary: Misleading error message when trying out CREATE statements
Key: IGNITE-14041
URL: https://issues.apache.org/jira/browse/IGNITE-14041
Project: Ignite
Issue Type: Bug
Components: sql
Affects Versions: 2.9.1
Reporter: Lukas Eder
When exploring what's there, I tried:
{code:java}
CREATE DATABASE s;{code}
I got this error message:
{quote}SQL Error [1001] [42000]: Failed to parse query. Syntax error in SQL
statement "CREATE DATABASE[*] S "; expected "OR, FORCE, VIEW, ALIAS, SEQUENCE,
USER, TRIGGER, ROLE, SCHEMA, CONSTANT, DOMAIN, TYPE, DATATYPE, AGGREGATE,
LINKED, MEMORY, CACHED, LOCAL, GLOBAL, TEMP, TEMPORARY, TABLE, SYNONYM,
PRIMARY, UNIQUE, HASH, SPATIAL, INDEX"; SQL statement:
CREATE DATABASE s [42001-197]
{quote}
So, I thought, cool! Ignite has (undocumented) support for sequences and many
other things? So I tried to create one:
{code:java}
CREATE SEQUENCE s;{code}
But:
{quote}SQL Error [1002] [0A000]: Unsupported statement: CREATE SEQUENCE s
{quote}
I'd say the first message is misleading here... It shouldn't offer keywords
that aren't really supported
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
