Uploaded image for project: 'RAML Module Builder'
  1. RAML Module Builder
  2. RMB-583

Move f_unaccent and concat* from public to schema, fix search_path

    XMLWordPrintable

Details

    • CP: sprint 84
    • 4
    • Core: Platform

    Description

      Currently general_functions.ftl defines public.f_unaccent, this is dangerous and should be in ${myuniversity}_${mymodule}.f_unaccent to prevent any other module from tampering.
      Also fix "SET search_path" in main.ftl and elsewhere to ensure that ${myuniversity}_${mymodule}.* takes precendence over public.*.
      Ensure proper upgrading.
      Make proper upgrading also for concat_space_sql and concat_array_object_values and concat_array_object that were moved from public schema to ${myuniversity}_${mymodule schema in 29.3.0: https://github.com/folio-org/raml-module-builder/commit/872c1f80da4c8d49e6836ca9221f637dc5e7420b

      TestRail: Results

        Attachments

          Issue Links

            blocks

            New Feature - New feature requests MODINVSTOR-413 add "isbn" normalised index

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

            New Feature - New feature requests RMB-575 add "sqlExpressionQuery" parameter

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

            Bug - A problem which impairs or prevents the functions of the product. RMB-584 Make "public" schema read-only (CVE-2018-1058)

            • P2 - normal priority level, must be included in the current development cycle
            • Closed
            relates to

            Bug - A problem which impairs or prevents the functions of the product. MODINVSTOR-513 hitcount estimation degeneration when upgrading MIS 19.1.2 (fameflower) -> MIS 19.2.0-SNAPSHOT (RMB30)

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

            New Feature - New feature requests RMB-568 Add JSON object array helper functions

            • TBD - To be determined
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. RMB-587 Do not use public schema, remove it from search_path

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

            Bug - A problem which impairs or prevents the functions of the product. MODINVSTOR-455 keyword search slow / times out

            • P1 - highest priority item, drop everything else before this is resolved, reserved for critical bugfixes
            • Closed

            Activity

              People

                julianladisch Julian Ladisch
                julianladisch Julian Ladisch
                Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases