• last updated 1 hour ago
Constraints: committers
Constraints: files
Constraints: dates
reduce usage of idiom "select 1 from dual where exists" when not necessary

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

    • -2
    • +4
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

Improve sql portability

Cleanup leftover query

Whitespace cleanup

Improve sql portability

Fix missing end

Im prove sql portability

Improve sql portability

Improve sql portability: oracle cannot select a boolean directly using exists

Whitespace cleanup

Make sql portable

Improve sql portability

Replace limit idiom with portable idiom

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

Replace limit with a portable idiom

Improve sql portability

Replace limit (pg only) with fetch idiom, which should be portable on "modern" Oracle

Reduce divergencies between oracle and postgres codebase

Reduce divergency between oracle and postgres codebase

Improve portability, fetch idiom should be supported by "modern Oracle"

Rewrite idiom to be portable (limit is psql only)