db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-3570) Implement DETERMINISTIC keyword for procedures and functions
Date Fri, 26 Sep 2008 23:19:44 GMT

     [ https://issues.apache.org/jira/browse/DERBY-3570?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Rick Hillegas updated DERBY-3570:
---------------------------------

    Attachment: derby-3570-02-aa-grammar.diff

Attaching derby-3570-02-aa-grammar.diff. This patch adds the DETERMINISTIC clause to the CREATE
FUNCTION/PROCEDURE statements. Touches the following files:

M      java/engine/org/apache/derby/impl/sql/compile/sqlgrammar.jj

Adds a new non-reserved keyword, DETERMINISTIC. Adds new clauses to the CREATE FUNCTION/PROCEDURE
statements.


M      java/engine/org/apache/derby/catalog/types/RoutineAliasInfo.java

Changes the toString() method to emit a DETERMINISTIC clause when the routine is deterministic.
This, in turn, causes the dblook output to faithfully reproduce the DDL for deterministic
routines.


M      java/testing/org/apache/derbyTesting/functionTests/tests/lang/GeneratedColumnsTest.java

Adds positive and negative tests for the new DDL.


M      java/testing/org/apache/derbyTesting/functionTests/tests/upgradeTests/Changes10_5.java

Verifies that the new clauses are recognized only after hard upgrade to 10.5.


M      java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_makeDB.sql

Adds routines with DETERMINISTIC and NOT DETERMINISTIC clauses to verify that dblook faithfully
emits DDL for  these routines.


M      java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/dblook_test_net.out
M      java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/dblook_test_net_territory.out
M      java/testing/org/apache/derbyTesting/functionTests/master/dblook_test_territory.out
M      java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/dblook_test_net.out
M      java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/dblook_test_net_territory.out
M      java/testing/org/apache/derbyTesting/functionTests/master/dblook_test.out

Canons accompanying the new ddl added to dblook_makeDB.sql.



> Implement DETERMINISTIC keyword for procedures and functions
> ------------------------------------------------------------
>
>                 Key: DERBY-3570
>                 URL: https://issues.apache.org/jira/browse/DERBY-3570
>             Project: Derby
>          Issue Type: New Feature
>          Components: SQL
>            Reporter: Rick Hillegas
>         Attachments: derby-3570-01-aa-introduceDeterminismField.diff, derby-3570-01-ab-introduceDeterminismField.diff,
derby-3570-02-aa-grammar.diff
>
>
> We will need DETERMINISTIC functions when we implement generated columns (DERBY-481).
The syntax and behavior of the DETERMINISTIC keyword are defined in the functional spec attached
to DERBY-481.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message