[ 
https://issues.apache.org/jira/browse/DERBY-712?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12787462#action_12787462
 ] 

Kristian Waagan commented on DERBY-712:
---------------------------------------

Patch 'derby-712-02-aa-privilegeNodeCleanup.diff' introduces a 
SanityManager.THROWASSERT which isn't guarded by an "if (SanityManager.DEBUG)". 
This causes the SanityManager class to be included in the insane builds, which 
again chokes maven2/SetDerbyVersion.java (I just committed it).

>From PrivilegeNode:
+
+        default:
+                SanityManager.THROWASSERT( "Invalid privilege objectType: " + 
this.objectType);


> Support for sequences
> ---------------------
>
>                 Key: DERBY-712
>                 URL: https://issues.apache.org/jira/browse/DERBY-712
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>         Environment: feature request 
>            Reporter: Tony Dahbura
>            Assignee: Suran Jayathilaka
>             Fix For: 10.6.0.0
>
>         Attachments: altertable.diff, catalogs_a.patch, catalogs_b.patch, 
> catalogs_c.patch, catalogs_d.patch, catalogs_e.patch, catalogs_f.patch, 
> catalogs_f_2.patch, catalogs_g.diff, catalogs_h.diff, 
> create_drop_sequence_a.patch, create_drop_sequence_b.patch, 
> create_drop_sequence_c.patch, create_drop_sequence_d.patch, 
> create_sequence_a.patch, derby-712-02-aa-privilegeNodeCleanup.diff, 
> SequenceGenerator.html
>
>
> Would like to see support added for sequences.  This would permit a select 
> against the sequence to always obtain a ever increasing/decreasing value.  
> The identity column works fine but there are times for applications where the 
> application needs to obtain the sequence number and use it prior to the 
> database write.  Subsequent calls to the table/column would result in a new 
> number on each call.
> SQL such as the following:
> SELECT NEXT VALUE FOR sequence_name FROM sometable ; would result in a next 
> value.

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

Reply via email to