Valid SQL marked as erroneous

GoogleCodeExporter commented 9 years ago

The SQL editor flags valid SQL as erroneous. I will attach a screenshot of the 
problem. It contains the following script (I will attach the original as well). 
I have surrounded the characters which have a red squiggle under them in the 
editor with tildes here:

CREATE ~S~EQUENCE RCMSDN_INST.SIGNED_MESSAGE_ID_SEQUENCE MINVALUE 1
  MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 600 CACHE 20
  NOORDER NOCYCLE;

GRANT SELECT ~O~N RCMSDN_INST.DEPOSIT_AGREEMENT_ID_SEQUENCE TO RCMSDN~;~

The message for the S is: "expected one of the following: FORCE NO OR VIEW", 
for the O it is: "expected one of the following: ( * + - CASE CURSOR DENSE_RANK 
NEW NULL PRIOR REF REPLACE ROWID ROWNUM function identifier unknown" and for 
the ";" it is: "expected one of the following:  INTERSECT MINUS ORDER UNION".

It seems to be using the wrong SQL dialect (but I can't find a way to configure 
the dialect), or not supporting DDL statements or something like that. I don't 
think these are IntelliJ messages I'm seeing, as the SQL inspections are all 
turned off.

Original issue reported on code.google.com by Pepijn.S...@gmail.com on 9 Jan 2013 at 10:54

Attachments:

GoogleCodeExporter commented 9 years ago

See attached file. I get "expected: ;" just before the "(" of 

OtherPackage.SomeProcedure();

Original comment by michael....@gmail.com on 1 Mar 2013 at 3:57

Attachments:

test.bdy

GoogleCodeExporter commented 9 years ago

 - support for "create sequence" statement added.
 - issue with parameterless function calls fixed (test.bdy)

NOTE: ddl language support is work in progress. so far only view and sequence 
are supported.

Original comment by cioca...@googlemail.com on 4 Mar 2013 at 9:26

Changed state: Started

VISTALL / database-navigator

Valid SQL marked as erroneous #17