• last updated 1 hour ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
file upgrade-0.6.2d6-0.6.2d7.sql was initially added on branch oacs-5-10.

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

    • -1
    • +3
    ./sql/postgresql/acs-events-create.sql
bumped version numbers to 5.10.1b1

  1. … 85 more files in changeset.
regenerated documentation

  1. … 295 more files 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

file upgrade-0.6.2d5-0.6.2d6.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./sql/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 release dates in .info files

  1. … 82 more files in changeset.
release work

  1. … 203 more files in changeset.
regenerated documentation, including change log

  1. … 117 more files in changeset.
regenerated documentation

  1. … 466 more files in changeset.
bump version numbers of 5.9|5.10 packages to 5.10.0b1

adjust dependencies

  1. … 87 more files in changeset.
Fix acs_activity__edit (TODO: upgrade script)

Fix typos

    • -2
    • +2
    ./sql/postgresql/test/timespan-test.sql
  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
    ./sql/oracle/upgrade/upgrade-0.6.2d4-0.6.2d5.sql
    • -3
    • +3
    ./sql/postgresql/acs-events-create.sql
    • -0
    • +10
    ./sql/postgresql/upgrade/upgrade-0.6.2d4-0.6.2d5.sql
Trim whitespace

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

Whitespace trimming

    • -23
    • +18
    ./sql/postgresql/activity-create.sql
    • -122
    • +121
    ./sql/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.

    • -5
    • +5
    ./sql/postgresql/acs-events-create.sql
    • -0
    • +8
    ./sql/postgresql/upgrade/upgrade-0.6.2d3-0.6.2d4.sql
Change declared acs_attribute datatype to boolean for boolean columns

    • -3
    • +3
    ./sql/postgresql/acs-events-create.sql
    • -0
    • +19
    ./sql/postgresql/upgrade/upgrade-0.6.2d2-0.6.2d3.sql
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: ----------------------------------------------------------------------

    • -44
    • +61
    ./sql/oracle/acs-events-create.sql
    • -0
    • +237
    ./sql/oracle/upgrade/upgrade-0.6.2d0-0.6.2d1.sql
    • -0
    • +756
    ./sql/oracle/upgrade/upgrade-0.6.2d1-0.6.2d2.sql
    • -16
    • +21
    ./sql/postgresql/acs-events-create.sql
    • -0
    • +139
    ./sql/postgresql/upgrade/upgrade-0.6.2d1-0.6.2d2.sql
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
    ./sql/oracle/upgrade/upgrade-0.6.2d0-0.6.2d1.sql
    • -18
    • +41
    ./sql/postgresql/acs-events-create.sql
    • -0
    • +180
    ./sql/postgresql/upgrade/upgrade-0.6.2d0-0.6.2d1.sql
Improve spellinig

improve indentation

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

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

    • -2
    • +2
    ./sql/postgresql/recurrence-create.sql
    • -2
    • +2
    ./sql/postgresql/test/acs-events-test.sql
  1. … 12 more files in changeset.
Fixed package version numbering

Added missing index creation statment; Fixed typo in index name

    • -2
    • +4
    ./sql/postgresql/acs-events-create.sql
    • -0
    • +5
    ./sql/postgresql/upgrade/upgrade-0.6-0.6.1.sql