Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-14041

Misleading error message when trying out CREATE statements

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.9.1
    • Fix Version/s: None
    • Component/s: sql
    • Labels:
      None
    • Ignite Flags:
      Docs Required, Release Notes Required

      Description

      When exploring what's there, I tried:

      CREATE DATABASE s;

      I got this error message:

      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]

      So, I thought, cool! Ignite has (undocumented) support for sequences and many other things? So I tried to create one:

      CREATE SEQUENCE s;

      But:

      SQL Error [1002] [0A000]: Unsupported statement: CREATE SEQUENCE s

      I'd say the first message is misleading here... It shouldn't offer keywords that aren't really supported

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              lukas.eder Lukas Eder
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: