Incorrect column type in Oracle DB migration script
Closed this issue · 0 comments
stuartpullinger commented
The column type for the new Study.endDate column was incorrectly set to 'DATETIME' in the Oracle migration script for 4.10.0-snapshot. 'DATETIME' is not a valid column type in Oracle so the script fails.
Other similar columns (eg. Investigation.startDate and Investigation.endDate) show as 'TIMESTAMP(6)' in the ISIS Oracle database so this is probably what the column type should be.
Reported by @gc-code.