• last updated 11 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Fixes for Oracle 19c: fix syntax and handling of boolean values

This change fixes the following problems:

Errors for PACKAGE ACS_EVENT:

LINE/COL ERROR

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

3/5 PL/SQL: Declaration ignored

43/39 PLS-00302: component 'LOCATIONREDIRECT_TO_REL_LINK_P' must be

declared

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY ACS_EVENT:

LINE/COL ERROR

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

19/2 PLS-00103: Encountered the symbol "RELATED_LINK_URL" when

expecting one of the following:

) , * & = - + < / > at in is mod remainder not rem

<an exponent (**)> <> or != or ~= >= <= <> and or like like2

like4 likec between || multiset member submultiset

The symbol "," was substituted for "RELATED_LINK_URL" to

continue.

296/29 PLS-00103: Encountered the symbol "(" when expecting one of the

following:

mod <an identifier> <a double-quoted delimited-identifier>

LINE/COL ERROR

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

<a bind variable> continue current sql execute forall merge

pipe purge json_exists json_value json_query json_object

json_array

Rename constraints to follow coding standards (fixes automated test datamodel__named_constraints)

Renaming constraints on Postgres without dropping/rebuilding requires version >= 9.2

    • -0
    • +10
    ./upgrade/upgrade-0.6.2d4-0.6.2d5.sql
  1. … 4 more files in changeset.
Trim whitespace

add forgotton fields related_link_url, related_link_text, redirect_to_rel_link_p to acs_event.new() and friends.

These files are part of the datamodel since many years, but someone forgot to adapt DB API for it.

VS: ----------------------------------------------------------------------

    • -0
    • +237
    ./upgrade/upgrade-0.6.2d0-0.6.2d1.sql
    • -0
    • +756
    ./upgrade/upgrade-0.6.2d1-0.6.2d2.sql
  1. … 3 more files in changeset.
fix type reference for oracle

Add field "location" to acs_events: an event has now a place and a time.

This is a prerequisite for adding a "location" to the calendar.

- add location to acs_attributes

- recreate views "acs_events_dates" and "acs_events_activities"

to return location

- extend "acs_event__new()" (pg) and "acs_event.new()" (ora)

to accept location

- let handle "acs_event.new_instance()" the location attribute

- bump version number to 0.6.2d1

    • -0
    • +579
    ./upgrade/upgrade-0.6.2d0-0.6.2d1.sql
  1. … 3 more files in changeset.
Fix typos

  1. … 14 more files in changeset.
Merged changes to HEAD ...

    • -0
    • +748
    ./upgrade/upgrade-0.6d1-0.6d2.sql
  1. … 1555 more files in changeset.
Fixed typo in daveb's change

Make sure "this event" is updated when editing a reucrrence and applying

to this event and all future events

  1. … 2 more files in changeset.
file upgrade-0.6d1-0.6d2.sql was initially added on branch oacs-5-3.

    • -0
    • +0
    ./upgrade/upgrade-0.6d1-0.6d2.sql
All editing only future events of a recurrence

    • -0
    • +748
    ./upgrade/upgrade-0.6d1-0.6d2.sql
  1. … 2 more files in changeset.
First shot at merging oacs-5-2 apps used in .LRN to HEAD.

    • -378
    • +377
    ./upgrade/upgrade-0.3d-0.4d.sql
  1. … 2477 more files in changeset.
typo fix, add a missing comma

Rearranging definition order to fix compilation bugs. Now the all of the package definitions come first, the bodies second.

    • -388
    • +387
    ./upgrade/upgrade-0.3d-0.4d.sql
  1. … 1 more file in changeset.
Rearranging definition order to fix compilation bugs. Now the all of the package definitions come first, the bodies second.

    • -388
    • +387
    ./upgrade/upgrade-0.3d-0.4d.sql
  1. … 1 more file in changeset.
fix pacakge -> package typo

  1. … 9 more files in changeset.
propigate package_id to acs_objects, make __new a 14 param function and add backwards compatible version, bump package version, upgrades for oracle and pg, oracle untested

    • -0
    • +737
    ./upgrade/upgrade-0.5d2-0.5d3.sql
  1. … 3 more files in changeset.
Remerge Timo's changes for tip 42,43, cf tip 53

    • -0
    • +631
    ./upgrade/upgrade-0.4d-0.4d1.sql
  1. … 95 more files in changeset.
rollback of Timo's name, package_id commit; see TIP 53

    • -631
    • +0
    ./upgrade/upgrade-0.4d-0.4d1.sql
  1. … 94 more files in changeset.
TIP#42,43: adding package_id and title to acs_objects table

    • -0
    • +631
    ./upgrade/upgrade-0.4d-0.4d1.sql
  1. … 94 more files in changeset.
Added upgrade to upgrade to changes made for Oracle 9i support

    • -0
    • +1732
    ./upgrade/upgrade-0.3d-0.4d.sql
  1. … 23 more files in changeset.
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)

  1. … 270 more files in changeset.
added upgrade script for index creation on start_date (see bug #634)

    • -0
    • +1
    ./upgrade/upgrade-0.2d-0.3d.sql
  1. … 1 more file in changeset.
1. removed some errant log statemets previously inserted when debugging

2. sql/common/*sql files weren't being displayed by the APM, are now

3. added index on start_date in timespan-create after user reported

very slow calendar queries in .LRN

  1. … 7 more files in changeset.
merge from oacs-4-6

  1. … 110 more files in changeset.
- Upgrade scripts for acs-content-repository, acs-events, acs-kernel, acs-mail, acs-service-contract, bookmarks, faq, file-storage, news and search

- Bumped version of above packages to 4.6

- Fixed the view/sequence hack in apm-create so that APM package edit UI works in PG 7.2

  1. … 30 more files in changeset.
- Converted inneficient query to INNER JOINs.

- Added Oracle upgrade script.

    • -0
    • +740
    ./upgrade/upgrade-0.1d-0.2d.sql
  1. … 1 more file in changeset.
added support for editing time intervals

  1. … 1 more file in changeset.

Added some stuff to acs-events, like an html_p arg to "new" to set this

existing but unused table column.

  1. … 3 more files in changeset.