• last updated 11 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Reduce divergency between postgres and oracle codebase

    • -0
    • +17
    ./packages/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
    ./packages/forums/lib/forums/forums-chunk.tcl
    • -2
    • +2
    ./packages/forums/tcl/forums-procs.tcl
    • -2
    • +2
    ./packages/forums/www/message-view.tcl
make boolean test strict

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

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

    • -0
    • +11
    ./packages/acs-lang/tcl/locale-procs.xql
Reduce divergency between oracle and postgres codebase

Add missing new xql file

Reduce divergence between postgres and oracle codebase

Reduce divergence between oracle and postgres codebase

Reduce divergence between postgres and oracle codebase

Ehm... reintroduce dual for oracle compliance

    • -4
    • +4
    ./packages/dotlrn/tcl/community-procs.xql
Use dual for oracle compliance

Add dual for oracle compliance

    • -2
    • +2
    ./packages/news/www/admin/process-2.xql
Reduce divergency between oracle and postgres codebase

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

    • -1
    • +6
    ./packages/news/www/admin/revision-add.tcl
    • -0
    • +21
    ./packages/news/www/admin/revision-add.xql
Use tcl to do date calculations instead of db, reduce postgres/oracle divergencies

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

    • -48
    • +0
    ./packages/news/www/index-oracle.xql
    • -48
    • +0
    ./packages/news/www/index-postgresql.xql
Do date calculations in tcl rather than in db, reduce oracle and postgres divergency

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

    • -7
    • +2
    ./packages/news/lib/latest-news-oracle.xql
    • -4
    • +1
    ./packages/news/lib/latest-news-postgresql.xql
    • -0
    • +10
    ./packages/news/lib/latest-news.xql
Reduce oracle/postgres divergence

Uniform sql codebase

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

    • -3
    • +7
    ./packages/dotlrn/tcl/community-procs.tcl
    • -20
    • +0
    ./packages/dotlrn/tcl/community-procs.xql
Remove unused query from xql (no usage was found upstream and on Learn@WU)

    • -8
    • +0
    ./packages/dotlrn/tcl/community-procs.xql
Get rid of dual idiom

    • -9
    • +3
    ./packages/dotlrn/tcl/community-procs.xql
Oracle doesn't support limit :-|

    • -4
    • +4
    ./packages/dotlrn/tcl/community-procs.xql
Streamline and optimize idiom

    • -7
    • +2
    ./packages/dotlrn/tcl/community-procs.tcl
    • -13
    • +5
    ./packages/dotlrn/tcl/community-procs.xql
Declare explicitly the only column we need in a way that DBMS can create a better query plan

    • -2
    • +2
    ./packages/dotlrn/tcl/community-procs.tcl
    • -4
    • +3
    ./packages/dotlrn/tcl/community-procs.xql
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

    • -0
    • +1
    ./packages/calendar/www/view-list-display.adp
    • -21
    • +16
    ./packages/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)

Fix typo

    • -3
    • +3
    ./packages/forums/www/moderate/move.tcl
    • -1
    • +1
    ./packages/forums/www/moderate/move.xql