Parse JdbcNamedParameters with the same name as a keyword

[chrycheng]

An example statement is select * from t where c = :from. Attached is the output of a test with parser debugging enabled. I'm not really familiar with JavaCC but from what I can tell from JdbcNamedParameter's definition in JSqlParserCC.jjt, it's expected to be composed of a : and an S_IDENTIFIER. S_IDENTIFIER's definition itself seems to have no restriction regarding keywords. Please correct me if I'm wrong.

[wumpz]

Unfortunately you are wrong. That is a common problem of those kind of parser generators. The on front running tokenizer delivers at that point in the grammar the k_from token. The best fitting token is deliverered. The tokenizing is done before the grammar rules are being processed.

[chrycheng]

Do you mean this is a limitation of JavaCC which we cannot fix or work around?

[wumpz]

No. I meant you cannot expect a char literal at this position. One could improve by using RelObjectName which includes already a lot of keywords.