• last updated 1 hour ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Reduce divergence between oracle and postgres codebase

    • -31
    • +0
    ./acs-lang/tcl/lang-message-procs-oracle.xql
    • -29
    • +0
    ./acs-lang/tcl/lang-message-procs-postgresql.xql
    • -1
    • +20
    ./acs-lang/tcl/lang-message-procs.xql
Reduce divergency between postgres and oracle codebase

    • -20
    • +0
    ./acs-lang/www/admin/set-system-timezone-postgresql.xql
    • -0
    • +17
    ./acs-lang/www/admin/set-system-timezone.xql
Make forum::use_ReadingInfo_p more robust when UseReadingInfo parameter in forums is not set

    • -2
    • +2
    ./forums/lib/message/threads-chunk.tcl
make boolean test strict

    • -2
    • +2
    ./forums/lib/message/threads-chunk.tcl
Hot fix for latest changes concerning reading info

    • -2
    • +2
    ./forums/lib/message/threads-chunk.tcl
Reduce divergency between oracle and postgres codebase

    • -14
    • +0
    ./acs-lang/tcl/locale-procs-oracle.xql
    • -18
    • +0
    ./acs-lang/tcl/locale-procs-postgresql.xql
Reduce divergency between oracle and postgres codebase

    • -13
    • +0
    ./acs-content-repository/tcl/symlink-procs-oracle.xql
    • -13
    • +0
    ./acs-content-repository/tcl/symlink-procs-postgresql.xql
    • -0
    • +13
    ./acs-content-repository/tcl/symlink-procs.xql
    • -13
    • +0
    ./acs-content-repository/tcl/extlink-procs-oracle.xql
    • -13
    • +0
    ./acs-content-repository/tcl/extlink-procs-postgresql.xql
    • -0
    • +13
    ./acs-content-repository/tcl/extlink-procs.xql
Add missing new xql file

    • -0
    • +23
    ./acs-automated-testing/tcl/aa-test-procs.xql
Reduce divergence between postgres and oracle codebase

    • -23
    • +0
    ./acs-automated-testing/tcl/aa-test-procs-oracle.xql
    • -34
    • +0
    ./acs-automated-testing/tcl/aa-test-procs-postgresql.xql
    • -7
    • +8
    ./acs-automated-testing/tcl/aa-test-procs.tcl
Reduce divergence between oracle and postgres codebase

    • -28
    • +0
    ./acs-authentication/tcl/sync-procs-oracle.xql
    • -28
    • +0
    ./acs-authentication/tcl/sync-procs-postgresql.xql
    • -0
    • +26
    ./acs-authentication/tcl/sync-procs.xql
Reduce divergence between postgres and oracle codebase

    • -37
    • +0
    ./acs-admin/www/users/complex-search-oracle.xql
    • -9
    • +3
    ./acs-admin/www/users/complex-search.tcl
    • -5
    • +28
    ./acs-admin/www/users/complex-search.xql
Ehm... reintroduce dual for oracle compliance

Use dual for oracle compliance

Add dual for oracle compliance

Reduce divergency between oracle and postgres codebase

    • -27
    • +0
    ./news/www/admin/process-2-oracle.xql
    • -27
    • +0
    ./news/www/admin/process-2-postgresql.xql
    • -0
    • +17
    ./news/www/admin/process-2.xql
Reduce divergency between oracle and postgres codebase

    • -28
    • +0
    ./news/www/admin/revision-add-oracle.xql
    • -29
    • +0
    ./news/www/admin/revision-add-postgresql.xql
Use tcl to do date calculations instead of db, reduce postgres/oracle divergencies

    • -7
    • +0
    ./news/www/admin/approve-postgresql.xql
Reduce divergence between oracle and postgres codebase, optimize queries

Do date calculations in tcl rather than in db, reduce oracle and postgres divergency

    • -14
    • +0
    ./news/www/item-create-postgresql.xql
Reduce divergence between oracle and postgres code

    • -0
    • +10
    ./news/lib/latest-news.xql
Reduce oracle/postgres divergence

    • -22
    • +0
    ./rss-support/tcl/rss-generation-service-procs-oracle.xql
    • -23
    • +0
    ./rss-support/tcl/rss-generation-service-procs-postgresql.xql
    • -2
    • +21
    ./rss-support/tcl/rss-generation-service-procs.xql
Uniform sql codebase

    • -19
    • +0
    ./notifications/tcl/sweep-procs-oracle.xql
    • -13
    • +0
    ./notifications/tcl/sweep-procs-postgresql.xql
    • -0
    • +14
    ./notifications/tcl/sweep-procs.xql
Use cached api instead of query to retrieve node id from community and community_type

Remove unused query from xql (no usage was found upstream and on Learn@WU)

Get rid of dual idiom

Oracle doesn't support limit :-|

Streamline and optimize idiom

Declare explicitly the only column we need in a way that DBMS can create a better query plan

Tolerate the same request variable specified multiple times

We use export_vars as arbiter to decide how this will be treated.

Also remove some postgres/oracle divergence

    • -21
    • +16
    ./calendar/www/view-list-display.tcl
Replace db date conversion with tcl one, remove unneded statements (sort_by is already defined in page contract, ad_return_template is implicit)

    • -7
    • +3
    ./calendar-portlet/www/calendar-list-portlet.tcl