search-packages-create.sql

  • last updated 22 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Fixes during the creation of the search observer queue for Oracle 19c:

In essence, the change repairs the following error:

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY SEARCH_OBSERVER:

LINE/COL ERROR

-------- -----------------------------------------------------------------

16/7 PL/SQL: SQL Statement ignored

16/40 PL/SQL: ORA-00933: SQL command not properly ended

remove spurious parens

  1. … 1 more file in changeset.
Handle potential race condition in search observer queue maintenance

In some cases, when e.g. objects are quicky deleted after updates, the

object might be already be deleted when being tried to trigger a

DELETE operation in the search queue. as a consequence, one can sometimes

observer errors like the one below. The new code double-checks now,

if the object for the DELETE operation still exists.

ERROR: insert or update on table "search_observer_queue" violates foreign key constraint "search_observer_queue_object_id_fk"

: DETAIL: Key (object_id)=(497509146) is not present in table "acs_objects".

: CONTEXT: SQL statement "insert into search_observer_queue (

  1. … 4 more files in changeset.
Merged from 5.4.2

  1. … 283 more files in changeset.
Found some more intermedia stuff to remove.

  1. … 1 more file in changeset.
Remove intermedia specific files

  1. … 7 more files in changeset.
Remove 'exit' lines that caused datamodel to be incompletely installed. Comment out creation of triggers for forums, static-portal, acs-events, faq, survey and photobook (should go in their own package)

    • -180
    • +179
    ./search-packages-create.sql
  1. … 10 more files in changeset.
commiting search work from sloan

    • -270
    • +266
    ./search-packages-create.sql
  1. … 41 more files in changeset.
first draft for .lrn search. run load-site-wide-search shell script to install

  1. … 10 more files in changeset.
the package is 99% ported to oracle. the only file that still requires a

little porting is www/search.tcl

now all someone needs to do is write the FtsEngineDriver for Oracle. i didn't

do it since i didn't need site-wide-search quite yet.

    • -0
    • +59
    ./search-packages-create.sql
  1. … 16 more files in changeset.