Support expressions with ":".

[LonwoLonwo]

Describe the bug
Some Databases, like Informix, have a sign ":" as delimiter name of the database and schema name.
https://www.ibm.com/support/knowledgecenter/en/SSGU8G_14.1.0/com.ibm.sqls.doc/ids_sqs_1652.htm
This is not a completely accurate link, but here the use of a colon is mentioned.

To Reproduce
Steps to reproduce the behavior:
use "SELECT * FROM stores_demo:informix.accounts;" with Informix database and get

net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: ":" ":"
    at line 2, column 17.
at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:26538)
	at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:26377)
	at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:91)

dbeaver/dbeaver#11590

Expected behavior
Please add colon support as a separator between the database name and the schema name.

System

• Informix Dynamic Server 14.10.FC4W1
• jsqlparser:4.0

[wumpz]

I kind of introduced this parsing half way. Now you are able to parse it, but the deparser is not there. Producing the source SQL results in the point way again.

[wumpz]

@LonwoLonwo Does it work?

[LonwoLonwo]

Hello, @wumpz
Sorry for late response.
Yes, it works for parsing.
I don't now your workflow, so I just say - ticket can be closed.

[manticore-projects]

Closed on behalf of the author.