Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-36564

Sequence name must be different

    Details

    • Type: Bug
    • Status: Verified
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 12.0, 19.0
    • Fix Version/s: 12.0, 19.0
    • Component/s: None
    • Labels:
    • 12 status:
      Resolved
    • Previous Issue Keys:
      SAM-3333
    • Test Plan:
      Hide

      Please add a Test Plan here.

      Show
      Please add a Test Plan here.

      Description

      The hibernate file use the same sequence name in Oracle for two different tables: SAM_ITEMTAG_T and SAM_PUBLISHEDITEMTAG_T. In MySQL this value is not used and the autoincrement columns follow their own order but in oracle this name is used to create a sequence so both columns will share values and I guess this is not on purpose.

      https://github.com/sakaiproject/sakai/blob/master/samigo/samigo-hibernate/src/java/org/sakaiproject/tool/assessment/data/dao/assessment/PublishedItemData.hbm.xml#L98

      https://github.com/sakaiproject/sakai/blob/master/samigo/samigo-hibernate/src/java/org/sakaiproject/tool/assessment/data/dao/assessment/ItemData.hbm.xml#L107

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                maintenanceteam Core Team
                Reporter:
                jjmerono@um.es Juan José Meroño Sánchez
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Git Source Code