• last updated 11 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
merge from oacs-5-10

    • -30
    • +24
    ./postgresql/acs-events-create.sql
    • -46
    • +37
    ./postgresql/timespan-create.sql
    • -0
    • +184
    ./postgresql/upgrade/upgrade-0.6.2d7-0.6.2d8.sql
  1. … 8092 more files in changeset.
Apply last upgrade also to the creation script

    • -14
    • +12
    ./postgresql/timespan-create.sql
Fixed variable names for SQL functions to allow to call these directly from Tcl

---

--- Fix SQL function that were defined with the same number of

--- arguments and the same argument names, but receiving different

--- types (integers vs. timespans). This is fine, as long the

--- functions are only called from SQL and positional arguments. When

--- calling from Tcl, this does not work.

---

--- This change uses in cases, where offsets are specified as

--- intervals the suffix "_interval" for the variable names, keeping

--- the names without this suffix for integer arguments (for Oracle

--- compatibility).

    • -30
    • +22
    ./postgresql/acs-events-create.sql
    • -29
    • +22
    ./postgresql/timespan-create.sql
    • -0
    • +184
    ./postgresql/upgrade/upgrade-0.6.2d7-0.6.2d8.sql
  1. … 1 more file in changeset.
file upgrade-0.6.2d7-0.6.2d8.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.6.2d7-0.6.2d8.sql
file upgrade-0.6.2d6-0.6.2d7.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.6.2d6-0.6.2d7.sql
added missing function args

  1. … 1 more file in changeset.
Fix for define_function_args for time_interval__overlaps_p

- Define always SQL function with the longest argument list

- Bumped version number to 0.6.2d6

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

    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.6.2d5-0.6.2d6.sql
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.