Skip to content

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

@mvachette

Description

@mvachette

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions