Forum OpenACS Development: Recent changes in Oracle xql codebase

Request notifications

Collapse
Posted by Antonio Pisano on
Hello everyone,

some of you might have noticed quite some commits regarding "reducing divergencies beween Oracle and Postgres codebase". In these files it was still the case we were maintaining some Oracle 8.* idioms, where modern, standard-compliant alternatives existed, allowing to have the same query for both DBMSs.

It is my opinion that having portable (and working) SQL code is something we want, while maintaining outdated Oracle-only stuff when it'is not really necessary is a burden we don't need to carry. If one looks at this [1], version 11.2 is oldest Oracle with some kind of official support at current date.

Changes involved xql files only, so data model scripts and stored procedures remained untouched. Please feel free to report any regression that might be found.

All the best

Antonio

[1] http://www.oracle.com/us/support/library/lifetime-support-technology-069183.pdf