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

    • -30
    • +24
    ./sql/postgresql/acs-events-create.sql
    • -46
    • +37
    ./sql/postgresql/timespan-create.sql
  1. … 8088 more files in changeset.
release work

  1. … 78 more files in changeset.
bumped version number from development version to release version

  1. … 93 more files in changeset.
regenerated documentation

  1. … 438 more files in changeset.
Apply last upgrade also to the creation script

    • -14
    • +12
    ./sql/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
    ./sql/postgresql/acs-events-create.sql
    • -29
    • +22
    ./sql/postgresql/timespan-create.sql
file upgrade-0.6.2d7-0.6.2d8.sql was initially added on branch oacs-5-10.

    • -0
    • +0
    ./sql/postgresql/upgrade/upgrade-0.6.2d7-0.6.2d8.sql
regenreated documentation (with non-finished release notes)

  1. … 146 more files in changeset.
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