You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Daniel John Debrunner (JIRA)" <de...@db.apache.org> on 2005/09/29 23:38:47 UTC
[jira] Created: (DERBY-592) Expand table driven system function defintion added in DERBY-475 to allow definition of JDBC escaped functions.
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
Reporter: Daniel John Debrunner
Assigned to: 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
[jira] Resolved: (DERBY-592) Expand table driven system function
defintion added in DERBY-475 to allow definition of JDBC escaped functions.
Posted by "Daniel John Debrunner (JIRA)" <de...@db.apache.org>.
[ 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
[jira] Updated: (DERBY-592) Expand table driven system function
defintion added in DERBY-475 to allow definition of JDBC escaped functions.
Posted by "Mike Matrigali (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-592?page=all ]
Mike Matrigali updated DERBY-592:
---------------------------------
Component: JDBC
SQL
making this one jdbc/sql not really sure what is right component.
> 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
[jira] Closed: (DERBY-592) Expand table driven system function
defintion added in DERBY-475 to allow definition of JDBC escaped functions.
Posted by "Daniel John Debrunner (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-592?page=all ]
Daniel John Debrunner closed DERBY-592:
---------------------------------------
> 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