Repository navigation
CREATE TABLE doesn't allow to have column names in quotes #4
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>
+ )
Activity
wumpz commentedon May 25, 2012
Maybe you should use RelObjectName() instead of your production.
wumpz commentedon May 26, 2012
After investigating I must say, your solution is better. But you have to change more than one occurance of <S_IDENTIFIER> in this production.
vasilievip commentedon May 27, 2012
yep, thanks
wumpz commentedon May 28, 2012
I have included this in my fork. Additional I corrected the CreateTableDeParser.
Assorted Fixes #4 (#1676)