Uploaded image for project: 'mod-source-record-storage'
  1. mod-source-record-storage
  2. MODSOURCE-238

Unable to run sql script using Liquibase tool

    XMLWordPrintable

Details

    • Story
    • Status: Closed (View Workflow)
    • P2
    • Resolution: Done
    • None
    • 5.0.0
    • None
    • Concorde - Sprint 106
    • 3
    • Concorde

    Description

      Problem:
      The given sql script fails if to run it using the Liquebase tool.
      The script is written here https://wiki.folio.org/display/DD/Search+in+Source+Record+Storage,
      see "Create table SQL statement" section on this page

      Exception:

      Reason: liquibase.exception.DatabaseException: ERROR: syntax error at or near "partition"
  Position: 179 [Failed SQL: (0) CREATE TABLE marc_indexers (field_no VARCHAR(3) NOT NULL, ind1 VARCHAR(1) NOT NULL, ind2 VARCHAR(1) NOT NULL, subfield_no VARCHAR(1) NOT NULL, value TEXT, marc_id UUID NOT NULL) partition by list(field_no)]

      TestRail: Results

        Attachments

          Issue Links

            blocks

            Story - Created by Jira Software - do not edit or delete. Issue type for a user story. MODSOURCE-221 Implement database changes for MARC search functionality.

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed
            defines

            Umbrella - MODSOURCE-215 MARC search functionality - tech part

            • P2 - normal priority level, must be included in the current development cycle
            • Open

            Activity

              People

                Igor_Gorchakov Igor Gorchakov
                Igor_Gorchakov Igor Gorchakov
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases