I seem to be having some problems with the CONCAT function. At first, I was using the ORacle shortcut of a||b||c, but jsqlparser could not parse that. So, I changed it to CONCAT(a, CONCAT(b,c)) since Oracle's CONCAT can only take two args. jsqlparser doesn't seem to be able to handle nested functions.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
hi
you can use "||" for your concat.
just extend the BinaryExpression class, overriding the getStringPresentation() to return a string "||"
then add "||" operator( near "+" and "-") to JSqlParser.jj file.
and you can write a || b || c instead of CONCAT(a, CONCAT(b,c))
br
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I seem to be having some problems with the CONCAT function. At first, I was using the ORacle shortcut of a||b||c, but jsqlparser could not parse that. So, I changed it to CONCAT(a, CONCAT(b,c)) since Oracle's CONCAT can only take two args. jsqlparser doesn't seem to be able to handle nested functions.
Nevermind on the handling of nested functions. That was my fault.
hi
you can use "||" for your concat.
just extend the BinaryExpression class, overriding the getStringPresentation() to return a string "||"
then add "||" operator( near "+" and "-") to JSqlParser.jj file.
and you can write a || b || c instead of CONCAT(a, CONCAT(b,c))
br
Would'nt it be a better approach to add || to the grammer itself?
added || to the grammar, please check version 0.6.6