current_date function does not work with parentheses

[Padraig O'Sullivan]

server revision: 1824

employees=> select current_date;
 _SQL_COL_1
------------
 2012-07-02
(1 row)

employees=> select current_date();
ERROR: Encountered " "(" "( "" at line 1, column 20.
Was expecting one of:
    <EOF>
    "and" ...
    "collate" ...
    "except" ...
    "fetch" ...
    "for" ...
    "from" ...
    "group" ...
    "having" ...
    "intersect" ...
    "is" ...
    "or" ...
    "order" ...
    "union" ...
    "where" ...
    "window" ...
    "with" ...
    "offset" ...
    "limit" ...
    "," ...
    ";" ...

LINE 1: select current_date();
                           ^
employees=>

[Timothy Wegner (timmwegner)]

Proserv does not believe this is an urgent requirement so have marked as moderate.

[Vy Nguyen (oontvoo)]

This is in the parser. Probably just adding '<RIGHT_PAREN><LEFT_PAREN>' after the node would fix this.

[Mike McMahon (mmcm)]

This is a MySQL compatibility issue. CURRENT_DATE is a special "column" in standard SQL.

[Vy Nguyen (oontvoo)]

Mike, so should I fix it? Maybe doing a LOOKAHEAD(mysqlParensFollow()) .... ?

[Vy Nguyen (oontvoo)]

Note: The feature is disabled by default. To turn it on, use:
SET columnAsFunc TO 'true'