JSqlParser icon indicating copy to clipboard operation
JSqlParser copied to clipboard

parse "CURRENT_TIMESTAMP(3)" error

Open patinousward opened this issue 3 years ago • 4 comments

CCJSqlParserUtil.parse("update btrip_payment set update_time = CURRENT_TIMESTAMP(3) where id = 1");

version:4.2

image

patinousward avatar Apr 08 '22 15:04 patinousward

JSqlParser only supports CURRENT_TIMESTAMP without parameters. Which database supports this?

wumpz avatar Apr 09 '22 21:04 wumpz

JSqlParser only supports CURRENT_TIMESTAMP without parameters. Which database supports this?

mysql support

patinousward avatar Apr 11 '22 05:04 patinousward

Any chance you want to provide a PR?

wumpz avatar Apr 11 '22 07:04 wumpz

Actually, it is just a Keyword problem again: When <K_TIME_KEY_EXPR> was explicitly allowed as Function Name, then CURRENT_TIMESTAMP(3) would be read as a Function and parsed properly.

The Keyword PR #1382 solves this problem.

manticore-projects avatar Jun 04 '22 08:06 manticore-projects