Uploaded image for project: 'OASIS Open Document Format for Office Applications (OpenDocument) TC'
  1. OASIS Open Document Format for Office Applications (OpenDocument) TC
  2. OFFICE-3372

19.33 db:table-column-increment

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Applied
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: ODF 1.2 CD 05
    • Fix Version/s: ODF 1.2 CD 06
    • Component/s: Public Review
    • Labels:
      None
    • Proposal:
      Hide

      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.

      Show
      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.
    • Resolution:
      Hide

      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.

      Show
      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.

      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.

        Attachments

          Activity

            People

            • Assignee:
              Patrick Patrick Durusau
              Reporter:
              Patrick Patrick Durusau
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: