Various Oracle conversion script fixes

Description

When Western upgraded from Sakai 11.3 to Sakai 20.2, we compiled all the intermediate conversion scripts together and ran them line by line against our DEV / QA databases, and corrected any errors we encountered before going to production. In doing so, we detected a handful of errors (both syntactic and semantic), for example:

  • number columns that default to 0 on MySQL, but default to null on Oracle opening the door to NPEs

  • BEGIN... END compound statements that execute in MySQL, but act only as a declaration in PL/SQL, and require a following "/" to actually execute.

I will review the differences between the finished script we used to update our Oracle database in production vs the oracle scripts in sakai-reference/documentation/conversions and submit a PR.

Activity

Show:

Automation for Jira January 28, 2022 at 11:02 PM

A pull request has been created, "SAK-46848 - Various Oracle conversion script fixes", you can see it at https://github.com/sakaiproject/sakai-reference/pull/148

Fixed

Details

Priority

Affects versions

Fix versions

Components

Assignee

Reporter

Created January 27, 2022 at 9:05 PM
Updated January 26, 2023 at 5:04 PM
Resolved May 4, 2022 at 2:40 PM