Thanks a lot Clemens ! Thanks a lot :) On Mon, Sep 21, 2015 at 2:58 PM, Clemens Ladisch <clemens at ladisch.de> wrote:
> Prakash Premkumar wrote: > > Can you please tell me which grammar rule in parse.y file parses > aggregate > > function ? > > As you already were told, there are rules that parse _all_ functions: > > expr(A) ::= id(X) LP distinct(D) exprlist(Y) RP(E). > expr(A) ::= id(X) LP STAR RP(E). > > Due to the sharing of these rules, the parser allows DISTINCT and * to > be used with non-aggregate functions: > > sqlite> SELECT date(); > 2015-09-21 > sqlite> SELECT date(DISTINCT); > 2015-09-21 > sqlite> SELECT date(*); > 2015-09-21 > > (But it wouldn't be a good idea to rely on this implementation ...) > > > Regards, > Clemens > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
