Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

CURRENT_TIMESTAMP is detected as a reserved word an generate errors when used in JOIN clause #368

Open
mvachette opened this issue Nov 14, 2022 · 0 comments

Comments

@mvachette
Copy link

The following code will produce an error

$sql = "SELECT foo FROM barTable LEFT JOIN bazTable ON barTable.a = bazTable.a AND bazTable.d <= CURRENT_TIMESTAMP"; 

$parser = new PHPSQLParser();
$creator = new PHPSQLCreator();

$parser->parse($sql);

$creator->create($parser->parsed);

Error : PHPSQLParser\exceptions\UnableToCreateSQLException : unknown [expr_type] = reserved in "expression ref_clause" [6]

This is due to the fact that "CURRENT_TIMESTAMP" is not detected as a function.

I managed to solve this by adding "CURRENT_TIMESTAMP" to the list of functions in the PHPSQLParserConstants class. I will propose a PR with this fix.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant