• last updated 13 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Fixes for Oracle 19c boolean types in query

This fixes the following bug for Oracle:

: SQL:

: select locale

: from ad_locales l

: where language = :language

: and enabled_p

: !>>>!and (default_p or not exists (select 1 from ad_locales

: where language = :language

: and locale <> l.locale))

:

improving Oracle upgrade scripts

Oracle has no "ALTER TABLE ADD COLUMN ...."

Oracle has no "ALTER TABLE ADD COLUMN if exists .."

  1. … 8 more files in changeset.
fixes for Oracle 19c

  1. … 5 more files in changeset.
Reduce need for xql

Cleanup hacks addressing #2011927 bug in Oracle: this has been supposedly addressed in version 9i, already EOL

See http://oracle-docs.dartmouth.edu/dba-docs/patchset_9.2.0.4.htm

Fix acs-lang.test_message_register automated test:

when checking if a message should be created or updated, do not trust the nsv, which won't be there for messages that have been soft-deleted and go to the db instead. When a message is soft deleted, cleanup the nsv cache.

Expose a bug in the message key registration:

when a message key is soft-deleted and the server is restarted, upon re-registration the nsv that signals its presence won't be found and an insertion will be attempted. However, as the db entry is there, a primary key constraint will be triggered.

    • -1
    • +35
    ./tcl/test/acs-lang-message-procs.tcl
Stick to packages that are enabled

  1. … 1 more file in changeset.
Use the intended table to get packages that are known to the system

  1. … 1 more file in changeset.
Add comment

Make api to retrieve the dependencies of a package public, as we use it in a test in another package, swith to the api that will retrieve the cached value instead of re-computing the result

  1. … 1 more file in changeset.
New test to check that message keys are used consistently with package dependencies

this can only be enforced as a warning because it is possible to have constructs such as "if installed, then use message key" that would be tricky to detect

Reuse computation of lang::conn::locale when invoked again in the same request

This reduces stress on the util_memoize cache for those installation that invoke this api often.

Reduce divergency between oracle and postgres codebase

    • -18
    • +0
    ./tcl/lang-util-procs-postgresql.xql
    • -36
    • +0
    ./www/admin/batch-editor-oracle.xql
    • -29
    • +0
    ./www/admin/batch-editor-postgresql.xql
  1. … 3 more files in changeset.
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 overquoting resulting in batch message key editor

This was caused by the now stricter quoting applied to ad_form, which is used under the hood to produce this UI

make sure that the query variable "show" is only passed non-empty, otherwise the page-contract of admin/message-list.tcl will fail

    • -9
    • +9
    ./www/admin/edit-localized-message.tcl
list called api procs

Mark 'lang::message::cache' as public, as it is used in 'acs-admin'

Mark 'lang::catalog::package_catalog_dir' as public, as it is used in 'acs-admin'

Mark 'lang::util::get_hash_indices' as public, as it is used in 'acs-admin'

Remove ancient tests for 'acs-lang', which use obsolete API and don't work for the most part anymore

    • -26
    • +0
    ./www/admin/test/translator-mode.adp
    • -43
    • +0
    ./www/admin/test/translator-mode.tcl
complete listing of covered procs in test cases

  1. … 14 more files in changeset.
Make api public, complies with acs-api-browser.graph__bad_calls automated test

  1. … 4 more files in changeset.
remove protection "private", since function has to be called from other packages

  1. … 6 more files in changeset.
bring test coverage to >50% by adding test cases and marking only locally called functions as private

    • -0
    • +29
    ./tcl/test/acs-lang-localization-procs.tcl