• last updated 17 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
some packages have high number of instances: no need to aggregate over these

Pass missing object_id flag

Do not insert object_ids that do not exist in acs_object (leftover group message keys)

Replace limit with portable idiom

prefer ad_try, since it is silent, when action is ended by a script_abort

Fix oracle query as for most recent version limit is not supported

Go straight to the database with a portable query

Improve sql portability, reduce number of statements

    • -16
    • +12
    ./news-aggregator/tcl/subscription-procs.tcl
Improve sql portability

    • -9
    • +11
    ./acs-service-contract/tcl/acs-service-contract-procs.tcl
    • -6
    • +10
    ./acs-subsite/tcl/group-type-procs.tcl
    • -12
    • +15
    ./acs-subsite/tcl/test/acs-subsite-procs.tcl
Cleanup leftover query

    • -6
    • +1
    ./acs-content-repository/tcl/content-revision-procs.xql
Whitespace cleanup

Improve sql portability

    • -22
    • +22
    ./acs-lang/tcl/test/acs-lang-localization-procs.tcl
    • -2
    • +4
    ./forums/www/admin/subscribe-others-2.tcl
Fix missing end

    • -2
    • +2
    ./acs-content-repository/tcl/test/content-extlink-procs.tcl
    • -2
    • +2
    ./dotlrn/tcl/dotlrn-security-procs.tcl
Im prove sql portability

Improve sql portability

    • -11
    • +11
    ./acs-content-repository/tcl/test/content-extlink-procs.tcl
    • -4
    • +4
    ./dotlrn/tcl/dotlrn-security-procs.tcl
Improve sql portability: oracle cannot select a boolean directly using exists

    • -3
    • +4
    ./acs-authentication/tcl/authentication-procs.tcl
Whitespace cleanup

    • -2
    • +2
    ./news-aggregator-portlet/www/news-aggregator-portlet.tcl
Make sql portable

    • -1
    • +5
    ./news-aggregator-portlet/www/news-aggregator-portlet.tcl
Improve sql portability

    • -4
    • +7
    ./forums/www/admin/subscribe-others-2.tcl
Replace limit idiom with portable idiom

    • -8
    • +0
    ./assessment/tcl/as-apm-action-procs-oracle.xql
    • -10
    • +0
    ./assessment/tcl/as-apm-action-procs-postgresql.xql
    • -1
    • +5
    ./assessment/tcl/as-apm-action-procs.tcl
Avoid the not portable limit idiom, just kill the recursive part using the flag instead

...although one should point out that Oracle does not support the boolean type...

Improve portability of test code

    • -3
    • +3
    ./acs-tcl/tcl/test/db-proc-test-procs.tcl
Replace limit with a portable idiom

Improve sql portability

    • -2
    • +3
    ./acs-mail-lite/tcl/email-inbound-procs.tcl
    • -2
    • +3
    ./acs-mail-lite/tcl/imap-inbound-procs.tcl
Replace limit (pg only) with fetch idiom, which should be portable on "modern" Oracle

    • -2
    • +9
    ./acs-mail-lite/tcl/acs-mail-lite-procs.tcl
    • -13
    • +0
    ./acs-mail-lite/tcl/acs-mail-lite-procs.xql
Reduce divergencies between oracle and postgres codebase

    • -9
    • +0
    ./acs-authentication/tcl/test/acs-authentication-procs-oracle.xql
    • -10
    • +0
    ./acs-authentication/tcl/test/acs-authentication-procs-postgresql.xql
    • -2
    • +6
    ./acs-authentication/tcl/test/acs-authentication-procs.tcl
Reduce divergency between oracle and postgres codebase

    • -20
    • +0
    ./acs-api-browser/www/index-oracle.xql
    • -20
    • +0
    ./acs-api-browser/www/index-postgresql.xql
Improve portability, fetch idiom should be supported by "modern Oracle"

Rewrite idiom to be portable (limit is psql only)

    • -2
    • +8
    ./notifications/tcl/notification-callback-procs.tcl
    • -10
    • +0
    ./notifications/tcl/notification-callback-procs.xql
Pass check_active_p from the including page