[OASIS Issue Tracker] Updated: (OFFICE-3372) 19.33db:table-column-increment

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

     [ http://tools.oasis-open.org/issues/browse/OFFICE-3372?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Patrick Durusau updated OFFICE-3372:
------------------------------------

       Proposal: 
The db:additional-column-statement attribute specifies the value for an AUTO_INCREMENT variable in an SQL statement. 

Correction:

The db:additional-column-statement attribute specifies the auto-increment keyword of an SQL create statement and any start value.

Note: The auto increment keyword, optional start value and the format of the string specifying them are database specific.

  was:The db:additional-column-statement attribute specifies the value for an AUTO_INCREMENT variable in an SQL statement. 

    Description: 
19.33 reads: The db:additional-column-statement attribute specifies a statement, which is placed after the column part of a "CREATE TABLE" SQL-statement, for a column whose value should be automatically incremented by the database engine upon data insertion.

After discussions with Ocke on 12.10 <db:auto-increment>, suggest:


The db:additional-column-statement attribute specifies the value for an AUTO_INCREMENT variable in an SQL statement. 

This avoids commenting on how to perform the SQL operation. 

********************
Correction:

This attribute specifies an auto-increment keyword and an optional start value, both of which are database specific.

  was:
19.33 reads: The db:additional-column-statement attribute specifies a statement, which is placed after the column part of a "CREATE TABLE" SQL-statement, for a column whose value should be automatically incremented by the database engine upon data insertion.

After discussions with Ocke on 12.10 <db:auto-increment>, suggest:


The db:additional-column-statement attribute specifies the value for an AUTO_INCREMENT variable in an SQL statement. 

This avoids commenting on how to perform the SQL operation. 

     Resolution: 
The db:additional-column-statement attribute specifies the value for an AUTO_INCREMENT variable in an SQL statement. 

********************
Correction:

The db:additional-column-statement attribute specifies the auto-increment keyword of an SQL create statement and any start value.

Note: The auto increment keyword, optional start value and the format of the string specifying them are database specific.


  was:The db:additional-column-statement attribute specifies the value for an AUTO_INCREMENT variable in an SQL statement. 


Updated the issue, proposal and correction to show the correct resolution of this issue. 

> 19.33 db:table-column-increment
> -------------------------------
>
>                 Key: OFFICE-3372
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-3372
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: Table
>    Affects Versions: ODF 1.2 CD 05
>            Reporter: Patrick Durusau
>            Assignee: Patrick Durusau
>            Priority: Minor
>             Fix For: ODF 1.2 CD 06
>
>
> 19.33 reads: The db:additional-column-statement attribute specifies a statement, which is placed after the column part of a "CREATE TABLE" SQL-statement, for a column whose value should be automatically incremented by the database engine upon data insertion.
> After discussions with Ocke on 12.10 <db:auto-increment>, suggest:
> The db:additional-column-statement attribute specifies the value for an AUTO_INCREMENT variable in an SQL statement. 
> This avoids commenting on how to perform the SQL operation. 
> ********************
> Correction:
> This attribute specifies an auto-increment keyword and an optional start value, both of which are database specific.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira