1.8 to 1.9 migration script can fail on Linux

Description

The migrate-1.8-to-1.9.sql script used to upgrade OpenVPMS from 1.8 to 1.9 can fail with the error message:

This is due to mixed-case being used in a statement that may cause the script to fail on platforms where MySQL table names are case-sensitive. This failure has been observed in one Linux installation. Other Linux installations have worked successfully.
Windows installations are unlikely to be affected, as MySQL on Windows treats table names as case-insensitive.

WARNING

If the script was run and failed with the above error, any subsequent migration must be done with a freshly restored database, or the migrated prices will be incorrect.

The incorrect statement is:

It should be:

Environment

None

Status

Assignee

Tim Anderson

Reporter

Tim Anderson

Labels

None

Components

Fix versions

Affects versions

Priority

Major
Configure