OpenACS / openacs-4 / packages / search / sql

oracle

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 8
Last Commit: 21 Nov
Commits this week: 0
Total Lines of Code (LoC): 474
Net change in LoC this week: 0

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated 18 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Sunday 13 Feb 2022
1:10 pm

gustafn

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

Options
    • -4
    • +5
    ./search-packages-create.sql
Tuesday 02 Mar 2021
9:08 am

gustafn

remove spurious parens

Options
    • -2
    • +2
    ./search-packages-create.sql
    • -1
    • +1
    ./upgrade/upgrade-5.10.0d3-5.10.0d4.sql
Monday 01 Mar 2021
7:20 pm

gustafn

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 (

Options
    • -1
    • +16
    ./search-packages-create.sql
    • -0
    • +50
    ./upgrade/upgrade-5.10.0d3-5.10.0d4.sql
  3. … 3 more files in changeset.
7:20 pm

gustafn

file upgrade-5.10.0d3-5.10.0d4.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.10.0d3-5.10.0d4.sql
  2. … 1 more file in changeset.
Friday 01 Aug 2008
10:51 am

emmar

Files removed on oacs-5-4, not removed on HEAD by the last merge

Options
    • -52
    • +0
    ./load-site-wide-search
    • -39
    • +0
    ./search-ctxsys.sql
    • -152
    • +0
    ./search-im-convert.sql
    • -51
    • +0
    ./search-index-create.sql
    • -30
    • +0
    ./search-index-drop.sql
    • -15
    • +0
    ./search-index-from-scratch.sql
Saturday 07 Jun 2008
10:28 pm

donb

Merged from 5.4.2

Options
    • -409
    • +1
    ./search-packages-create.sql
    • -44
    • +1
    ./search-tables-create.sql
  3. … 282 more files in changeset.
Wednesday 16 Apr 2008
3:01 pm

daveb

Found some more intermedia stuff to remove.

Options
    • -164
    • +1
    ./search-packages-create.sql
    • -11
    • +1
    ./search-tables-create.sql
2:41 pm

daveb

Remove intermedia specific files

Options
    • -52
    • +0
    ./load-site-wide-search
    • -39
    • +0
    ./search-ctxsys.sql
    • -152
    • +0
    ./search-im-convert.sql
    • -51
    • +0
    ./search-index-create.sql
    • -30
    • +0
    ./search-index-drop.sql
    • -15
    • +0
    ./search-index-from-scratch.sql
    • -246
    • +1
    ./search-packages-create.sql
    • -34
    • +1
    ./search-tables-create.sql
Thursday 31 Aug 2006
9:31 am

emmar

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)

Options
    • -0
    • +1
    ./search-create.sql
    • -3
    • +1
    ./search-ctxsys.sql
    • -7
    • +1
    ./search-from-scratch.sql
    • -2
    • +1
    ./search-index-create.sql
    • -3
    • +1
    ./search-index-drop.sql
    • -5
    • +0
    ./search-index-from-scratch.sql
    • -180
    • +179
    ./search-packages-create.sql
    • -2
    • +0
    ./search-sc-create.sql
    • -2
    • +1
    ./search-tables-create.sql
    • -3
    • +2
    ./syndication-create.sql
    • -2
    • +0
    ./syndication-drop.sql
Thursday 10 Aug 2006
6:01 pm

daveb

Remove reference to dotlrn

Options
    • -5
    • +7
    ./search-tables-create.sql
Tuesday 08 Nov 2005
7:24 pm

dirkg

commiting search work from sloan

Options
    • -2
    • +6
    ./load-site-wide-search
    • -1
    • +0
    ./search-create.sql
    • -14
    • +27
    ./search-from-scratch.sql
    • -4
    • +13
    ./search-index-create.sql
    • -2
    • +2
    ./search-index-drop.sql
    • -270
    • +266
    ./search-packages-create.sql
    • -24
    • +2
    ./search-packages-drop.sql
    • -0
    • +2
    ./search-sc-create.sql
    • -14
    • +32
    ./search-tables-create.sql
    • -6
    • +0
    ./search-tables-drop.sql
    • -0
    • +2
    ./syndication-create.sql
    • -0
    • +3
    ./syndication-drop.sql
  13. … 30 more files in changeset.
Tuesday 07 Jun 2005
9:58 pm

dirkg

Added package_id to site_wide_index table

Options
    • -1
    • +8
    ./search-tables-create.sql
9:00 pm

dirkg

Added indexed_content field to the site_wide_index table. This

field will hold "textualized" content of binaries.

Options
    • -1
    • +2
    ./search-tables-create.sql
Saturday 21 May 2005
1:34 pm

dirkg

first draft for .lrn search. run load-site-wide-search shell script to install

Options
    • -0
    • +48
    ./load-site-wide-search
    • -0
    • +41
    ./search-ctxsys.sql
    • -0
    • +49
    ./search-from-scratch.sql
    • -0
    • +152
    ./search-im-convert.sql
    • -0
    • +43
    ./search-index-create.sql
    • -0
    • +32
    ./search-index-drop.sql
    • -0
    • +20
    ./search-index-from-scratch.sql
    • -44
    • +476
    ./search-packages-create.sql
    • -2
    • +24
    ./search-packages-drop.sql
    • -7
    • +48
    ./search-tables-create.sql
    • -0
    • +6
    ./search-tables-drop.sql
Monday 26 Jul 2004
3:04 pm

jeffd

add a syndication table which holds xml fragments which can be assembled to create rss feeds

Options
    • -0
    • +1
    ./search-create.sql
    • -0
    • +15
    ./syndication-create.sql
    • -0
    • +3
    ./upgrade/upgrade-5.2.0d2-5.2.0d3.sql
  4. … 4 more files in changeset.
Tuesday 30 Sep 2003
2:10 pm

mohanp

Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

Options
    • -18
    • +18
    ./search-sc-drop.sql
  2. … 275 more files in changeset.
Tuesday 02 Jul 2002
3:52 am

yon

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.

Options
    • -0
    • +3
    ./search-create.sql
    • -0
    • +3
    ./search-drop.sql
    • -0
    • +59
    ./search-packages-create.sql
    • -0
    • +2
    ./search-packages-drop.sql
    • -0
    • +185
    ./search-sc-create.sql
    • -0
    • +26
    ./search-sc-drop.sql
    • -0
    • +8
    ./search-tables-create.sql
    • -0
    • +1
    ./search-tables-drop.sql
  9. … 9 more files in changeset.