[
https://issues.apache.org/jira/browse/DERBY-4539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rick Hillegas updated DERBY-4539:
---------------------------------
Attachment: derby-4539-01-aa-arbitraryOrder.diff
Attaching derby-4539-01-aa-arbitraryOrder.diff. This patch makes it possible to
state the optional clauses of the CREATE SEQUENCE statement in arbitrary
orders. Duplicate clauses raise an exception. Regression tests are running.
Touches the following files:
-----------
M java/engine/org/apache/derby/impl/sql/compile/sqlgrammar.jj
Grammar changes allowing clauses to occur in any order.
-----------
M java/engine/org/apache/derby/impl/sql/compile/CreateSequenceNode.java
Fixed a bug which forced the step size to fall between the max and min values
for the generator.
-----------
M java/engine/org/apache/derby/loc/messages.xml
M java/shared/org/apache/derby/shared/common/reference/SQLState.java
New message for duplicate clause condition.
-----------
M
java/testing/org/apache/derbyTesting/functionTests/tests/lang/GeneratedColumnsHelper.java
M
java/testing/org/apache/derbyTesting/functionTests/tests/lang/SequenceTest.java
Regression tests.
> Make it possible to put the optional clauses of a CREATE SEQUENCE statement
> in the arbitrary order allowed by the SQL Standard
> ------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-4539
> URL: https://issues.apache.org/jira/browse/DERBY-4539
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.6.0.0
> Reporter: Rick Hillegas
> Priority: Minor
> Attachments: derby-4539-01-aa-arbitraryOrder.diff
>
>
> The current syntax for CREATE SEQUENCE requires that the optional clauses
> appear in a fixed order. The SQL Standard is more flexible here.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
