Repository navigation
parse "CURRENT_TIMESTAMP(3)" error #1507
Description
CCJSqlParserUtil.parse("update btrip_payment set update_time = CURRENT_TIMESTAMP(3) where id = 1");
version:4.2
{{ message }}
CCJSqlParserUtil.parse("update btrip_payment set update_time = CURRENT_TIMESTAMP(3) where id = 1");
version:4.2
Activity
wumpz commentedon Apr 9, 2022
JSqlParser only supports
CURRENT_TIMESTAMPwithout parameters. Which database supports this?patinousward commentedon Apr 11, 2022
mysql support
wumpz commentedon Apr 11, 2022
Any chance you want to provide a PR?
manticore-projects commentedon Jun 4, 2022
Actually, it is just a Keyword problem again: When
<K_TIME_KEY_EXPR>was explicitly allowed as Function Name, thenCURRENT_TIMESTAMP(3)would be read as a Function and parsed properly.The Keyword PR #1382 solves this problem.
fix: White-list CURRENT_DATE and CURRENT_TIMESTAMP tokens
Assorted fixes (#1666)