dynamobi/dynamobi — Issue #543: [FRG-329] Farrago uses nonstandard POW keyword to refer to power function, SQL2003 standard is POWER
Author: dynamobi-build
Created: 2011-12-30 03:34:31+00:00
State: open
Labels: FRG, SQL Parser

[reporter="emcdermid", created="Fri, 8 Aug 2008 08:47:43 -0500 (GMT-05:00)"]
Per the SQL2003 spec (ref section 6.27, , specifically ), the keyword for the power function is POWER. Using POWER in farrago raises an error, but POW works.

values POW(3,2);

+---------+

| EXPR$0 |

+---------+

| 9.0 |

+---------+

values POWER(2,3);

Error: From line 1, column 8 to line 1, column 17: No match found for function signature POWER(, ) (state=,code=0)