• last updated a few minutes 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

Fix acs_activity__edit (TODO: upgrade script)

Fix typos

  1. … 8 more files in changeset.
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
    ./oracle/upgrade/upgrade-0.6.2d4-0.6.2d5.sql
    • -0
    • +10
    ./postgresql/upgrade/upgrade-0.6.2d4-0.6.2d5.sql
  1. … 1 more file in changeset.
Trim whitespace

    • -190
    • +189
    ./oracle/acs-events-create.sql
Whitespace trimming

    • -23
    • +18
    ./postgresql/activity-create.sql
    • -122
    • +121
    ./postgresql/acs-events-create.sql
Align case of acs_object_type with that of the actual table (fixes automated tests)

This change intentionally ingores Oracle, as its behavior with respect to case is not clear to me.

    • -0
    • +8
    ./postgresql/upgrade/upgrade-0.6.2d3-0.6.2d4.sql
  1. … 1 more file in changeset.
Change declared acs_attribute datatype to boolean for boolean columns

    • -0
    • +19
    ./postgresql/upgrade/upgrade-0.6.2d2-0.6.2d3.sql
  1. … 1 more file in changeset.
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
    ./oracle/upgrade/upgrade-0.6.2d0-0.6.2d1.sql
    • -0
    • +756
    ./oracle/upgrade/upgrade-0.6.2d1-0.6.2d2.sql
    • -16
    • +21
    ./postgresql/acs-events-create.sql
    • -0
    • +139
    ./postgresql/upgrade/upgrade-0.6.2d1-0.6.2d2.sql
  1. … 1 more file in changeset.
fix type reference for oracle

Fix typos

  1. … 11 more files in changeset.
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
    ./oracle/upgrade/upgrade-0.6.2d0-0.6.2d1.sql
    • -18
    • +41
    ./postgresql/acs-events-create.sql
    • -0
    • +180
    ./postgresql/upgrade/upgrade-0.6.2d0-0.6.2d1.sql
  1. … 1 more file in changeset.
Improve spellinig

improve indentation

    • -14
    • +14
    ./postgresql/oracle-compat-create.sql
Fix typos

    • -2
    • +2
    ./postgresql/test/time_intervals-test.sql
  1. … 61 more files in changeset.
Fix typos

  1. … 12 more files in changeset.
Added missing index creation statment; Fixed typo in index name

    • -0
    • +5
    ./postgresql/upgrade/upgrade-0.6-0.6.1.sql
  1. … 1 more file in changeset.
fix typos

  1. … 3 more files in changeset.
merged changes from the oacs-5-9 branch and resolved conflicts

  1. … 7832 more files in changeset.
Fix spelling errors

  1. … 11 more files in changeset.
- add function args missed by earlier upgrades

- bump version numbers

    • -0
    • +48
    ./postgresql/upgrade/upgrade-0.6d7-0.6d8.sql
  1. … 9 more files in changeset.
Merging back to HEAD all changes that happened in branch oacs-5-8 between tags: vg-merge-oacs-5-8-from-20141027 and vg-merge-oacs-5-8-from-20150427

  1. … 520 more files in changeset.
- add missing index (important for large sites)

  1. … 1 more file in changeset.
file upgrade-0.6d6-0.6d7.sql was initially added on branch oacs-5-8.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.6d6-0.6d7.sql
Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

  1. … 2546 more files in changeset.
- add still missing function args

  1. … 1 more file in changeset.
file upgrade-0.6d5-0.6d6.sql was initially added on branch oacs-5-8.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.6d5-0.6d6.sql
- update postgres function to modern style plpgsql definitions, avoid backslash escaping

- add missing function_args

    • -646
    • +762
    ./postgresql/acs-events-create.sql
    • -192
    • +229
    ./postgresql/activity-create.sql
    • -125
    • +163
    ./postgresql/oracle-compat-create.sql
    • -51
    • +62
    ./postgresql/recurrence-create.sql
    • -638
    • +804
    ./postgresql/timespan-create.sql
    • -299
    • +322
    ./postgresql/test/acs-events-test.sql
    • -225
    • +277
    ./postgresql/test/time_intervals-test.sql
    • -208
    • +291
    ./postgresql/test/timespan-test.sql
    • -403
    • +487
    ./postgresql/test/utest-create.sql
    • -150
    • +157
    ./postgresql/test/utest.sql
    • -26
    • +22
    ./postgresql/upgrade/upgrade-0.1d-0.2d.sql
    • -127
    • +77
    ./postgresql/upgrade/upgrade-0.4d-0.4d1.sql
    • -22
    • +20
    ./postgresql/upgrade/upgrade-0.5d1-0.5d2.sql
    • -86
    • +54
    ./postgresql/upgrade/upgrade-0.5d2-0.5d3.sql
    • -136
    • +78
    ./postgresql/upgrade/upgrade-0.6d1-0.6d2.sql
    • -89
    • +55
    ./postgresql/upgrade/upgrade-0.6d2-0.6d3.sql
    • -79
    • +59
    ./postgresql/upgrade/upgrade-0.6d3-0.6d4.sql
PG 9.0 compatibility. Changes regarding usage of sequences. Deleting unused views and sequences.

    • -0
    • +149
    ./postgresql/upgrade/upgrade-0.6d3-0.6d4.sql
  1. … 1 more file in changeset.
More fixes to timespan calculaton to handle timezone (DST) spanning recurring events.

  1. … 1 more file in changeset.