Skip to content

Can't parse type in Oracle's varchar2 #273

Description

@vincent-fuchs

Hi,

Using v0.9.5, parsing this valid Oracle statement, I'm getting an error :

CREATE TABLE IF NOT EXISTS "TABLE_OK"  ("SOME_FIELD"    VARCHAR2(256 BYTE));

error :

Caused by: net.sf.jsqlparser.parser.ParseException: Encountered " <S_IDENTIFIER> "BYTE "" at line   1, column 70.
Was expecting one of:
<S_LONG> ...
<S_CHAR_LITERAL> ...

If I don't specify BYTE, it works.

Note : both BYTE and CHAR should be accepted : https://docs.oracle.com/cd/B28359_01/server.111/b28318/datatype.htm#i1835

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions