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 "Rick Hillegas (JIRA)" <ji...@apache.org> on 2010/02/05 19:58:28 UTC
[jira] Created: (DERBY-4539) Make it possible to put the optional
clauses of a CREATE SEQUENCE statement in the arbitrary order allowed by
the SQL Standard
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
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.
[jira] Resolved: (DERBY-4539) Make it possible to put the optional
clauses of a CREATE SEQUENCE statement in the arbitrary order allowed by
the SQL Standard
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas resolved DERBY-4539.
----------------------------------
Resolution: Fixed
Tests passed cleanly. Committed derby-4539-01-aa-arbitraryOrder.diff at subversion revision 909633.
> 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
> Assignee: 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.
[jira] Updated: (DERBY-4539) Make it possible to put the optional
clauses of a CREATE SEQUENCE statement in the arbitrary order allowed by
the SQL Standard
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Assigned: (DERBY-4539) Make it possible to put the optional
clauses of a CREATE SEQUENCE statement in the arbitrary order allowed by
the SQL Standard
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas reassigned DERBY-4539:
------------------------------------
Assignee: Rick Hillegas
> 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
> Assignee: 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.
[jira] Closed: (DERBY-4539) Make it possible to put the optional
clauses of a CREATE SEQUENCE statement in the arbitrary order allowed by
the SQL Standard
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas closed DERBY-4539.
--------------------------------
> 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.1.0
> Reporter: Rick Hillegas
> Assignee: 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.
[jira] Updated: (DERBY-4539) Make it possible to put the optional
clauses of a CREATE SEQUENCE statement in the arbitrary order allowed by
the SQL Standard
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas updated DERBY-4539:
---------------------------------
Issue & fix info: [Newcomer, Patch Available] (was: [Newcomer])
> 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
> Assignee: 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.