[jira] [Created] (IGNITE-14041) Misleading error message when trying out CREATE statements

["Lukas Eder (Jira)" <ji...@apache.org>]

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)