search

icatproject / icat.server

The ICAT server offering both SOAP and "RESTlike" interfaces to a metadata catalog.
Other
1 stars 5 forks source link

Incorrect column type in Oracle DB migration script #224

Closed stuartpullinger closed 5 years ago

stuartpullinger commented 5 years ago

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.