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

    • Type: Story
    • Status: Closed (View Workflow)
    • Priority: P2
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 5.0.0
    • Labels:
      None
    • Template:
    • Sprint:
      Concorde - Sprint 106
    • Story Points:
      3
    • Development Team:
      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

              Activity

                People

                Assignee:
                Igor_Gorchakov Igor Gorchakov
                Reporter:
                Igor_Gorchakov Igor Gorchakov
                Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases