Skip to content

CREATE TABLE doesn't allow to have column names in quotes #4

Closed
@vasilievip

Description

http://sourceforge.net/tracker/?func=detail&aid=3068961&group_id=104597&atid=638634

Since this "hub" doesn't allow attachments, here is the change which works for me

--- a/src/main/javacc/net/sf/jsqlparser/parser/JSqlParserCC.jj
+++ b/src/main/javacc/net/sf/jsqlparser/parser/JSqlParserCC.jj
@@ -1523,7 +1523,11 @@ CreateTable CreateTable():
    [
        "("

-       columnName=<S_IDENTIFIER>
+       (
+           columnName=<S_IDENTIFIER>
+           |
+           columnName=<S_QUOTED_IDENTIFIER>
+       )
        colDataType = ColDataType()
        {
            columnSpecs = new ArrayList();
@@ -1582,7 +1586,11 @@ CreateTable CreateTable():
                )
                |
                (
-                   columnName=<S_IDENTIFIER> 
+                    (
+                        columnName=<S_IDENTIFIER>
+                        |
+                        columnName=<S_QUOTED_IDENTIFIER>
+                    )

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions