Tobias
Tobias
So why not. But as @manticore-projects already explained, the parser is what it is. Even if your RAND_STRING does produce some kind of valid SQL, if JSqlParser throws an Exception,...
Only a special expression of XMLSERIALIZE is supported at the moment ```sql SELECT xmlserialize(xmlagg(xmltext(COMMENT_LINE) ORDER BY COMMENT_SEQUENCE) AS varchar (1024)) FROM mytable GROUP BY COMMENT_NUMBER ```
JSqlParserCC.jjt line 4675
You could use the *concat* function of mysql. This has the advantage to be implemented in multiple database types. ```sql select * from user_info where flag = 1 and login_name...
Double quotation marks are not allowed there for Oracle and Postgresql. **concat** is a two parameter function in Oracle, therefore: ```sql concat(concat('%', ?), '%') ``` should do the trick.
Since there is not action for over a year ...
Unnamed indexes are not allowed but named are: ```sql ALTER TABLE table_name8 ADD index myidx (column_1) ```
**double precision** is definitly supported ```sql select 1::double precision ``` however, this syntax `double precision '1' `is not.
As always the connection to ASTNodes was request driven (and is). Unfortunately JavaCC does not provide some kind of automatism to achieve that. Therefore we have to construct this manually....
As far as I know is the modify command not supported (yet). Do you want to provide a PR with an initial start supporting this?