Uploaded image for project: 'Cayenne'
  1. Cayenne
  2. CAY-960

Incorrect logging when generated primary keys are used.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 3.0
    • 3.0
    • Core Library
    • None
    • All

    Description

      With the logging changes, an INSERT will incorrectly log the primary key column when the value is generated (auto-increment/identity). This value must be obtained from the database after the INSERT has completed. The current code prints this column, but shows the next parameter value, skewing the entire logged entry after the primary key.

      For auto-generated keys on INSERT-only (show key value on DELETE, SELECT, UPDATE), do not show the auto-generated key in the log (since it doesn't exist yet).

      Attachments

        Activity

          People

            blacknext Michael Gentry
            blacknext Michael Gentry
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: