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-2798

12.10 <db:auto-increment> description is apparently incorrect

    XMLWordPrintable

    Details

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

      The <db:auto-increment> element specifies SQL statements to retrieve auto-generated row values and to set AUTO_INCREMENT values for columns.

      Show
      The <db:auto-increment> element specifies SQL statements to retrieve auto-generated row values and to set AUTO_INCREMENT values for columns.
    • Resolution:
      Hide

      The <db:auto-increment> element specifies SQL statements to retrieve auto-generated row values and to set AUTO_INCREMENT values for columns.

      Show
      The <db:auto-increment> element specifies SQL statements to retrieve auto-generated row values and to set AUTO_INCREMENT values for columns.

      Description

      Reads in full:

      "The <db:auto-increment> element is a container for information related to dealing with auto-increment values and table columns."

      The two attributes of this element are: db:additional-column-statement (19.33) and db:row-retrieving-statement (19.77)

      19.33 - says - 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.

      19.77 - says - The db:row-retrieving-statement attribute specifies an SQL statement, which is executed to retrieve auto generated values after inserting a new row.

      No sure how this fits the description. (there are other issues on 19.33 but I will post those separately)

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: