db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel John Debrunner (JIRA)" <derby-...@db.apache.org>
Subject [jira] Resolved: (DERBY-592) Expand table driven system function defintion added in DERBY-475 to allow definition of JDBC escaped functions.
Date Thu, 02 Feb 2006 19:54:04 GMT
     [ http://issues.apache.org/jira/browse/DERBY-592?page=all ]
     
Daniel John Debrunner resolved DERBY-592:
-----------------------------------------

    Resolution: Fixed

SImplified the solution to have a list in the parser of escaped functions that map directly
to builting SYSFUN functions. Decided this was the simplest approach with the smallest amount
of code. Since the list of escape functions is static, coming from ODBC a very flexible scheme
would have been overkill.

JDBC escape functions added are:

ACOS, ASIN, ATAN, COS, SIN, TAN, PI
DEGREES, RADIANS, EXP, LOG, LOG10, CEILING, FLOOR

> Expand table driven system function defintion added in DERBY-475 to allow definition
of JDBC escaped functions.
> ---------------------------------------------------------------------------------------------------------------
>
>          Key: DERBY-592
>          URL: http://issues.apache.org/jira/browse/DERBY-592
>      Project: Derby
>         Type: Improvement
>   Components: JDBC, SQL
>     Reporter: Daniel John Debrunner
>     Assignee: Daniel John Debrunner
>     Priority: Minor
>      Fix For: 10.2.0.0

>
> Since the functions added in DERBY-475 overlap with the numeric scaler functions defined
in section C.1 of JDBC 3.0 it would be benfiical to expand the table to indicate if the function
can be used as a JDBC escaped scaler as well.
> Plus adding all the code to find them and call them etc. :-)
> I'll add a comment later to show which JDBC escape functions this would add.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message