Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects versions: 3.6.1
    • Fix versions: None
    • Components: None
    • Environment:

      Using maven build to Oracle 12c database

    • Sprint:

      Description

      My changeset file looks as follows:

      databaseChangeLog: 
        - changeSet: 
            author: Raymond Rabu
            id: 197e720
            comment: https://mason.usask.ca/csd/job/shared%20dev%20-%20Oracle/5/
            sqlFile: 
              encoding: utf8
              endDelimiter: ;
              path: changelog/CSD-2874-grant-refresh.sql
              splitStatements: true
              stripComments: false
      

      When I run the build, I see the following info:

      [INFO] ChangeSet build/CSD-2874-grant-refresh.sql.yaml::Infinity::Raymond Rabu ran successfully in 35ms
      [INFO] SELECT MAX(ORDEREXECUTED) FROM CS_SHARED.DATABASECHANGELOG
      [INFO] INSERT INTO CS_SHARED.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('Infinity', 'Raymond Rabu', 'build/CSD-2874-grant-refresh.sql.yaml', SYSTIMESTAMP, 33, '8:e281187903c3e1c47d2972fd76560bfc', 'sqlFile', 'https://mason.usask.ca/csd/job/shared%20dev%20-%20Oracle/4/', 'EXECUTED', NULL, NULL, '3.6.1', '0195368040')
      

      And querying the databasechangelog table confirms that the ID is Infinity instead of 197e720.

      In the build, I have lots of other changes and all of their IDs are set correctly. Only this one went in weird. Any ideas?

        Attachments

          Activity

            People

            • Reporter:
              raymond.rabu Raymond Rabu
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: