ALTER APPLICATION PACKAGE command: Expanded validation¶

The ALTER APPLICATION PACKAGE … [ADD VERSION | ADD PATCH FOR VERSION] command command behaves as follows:

Before the change:

When altering an application package to either add a new version, or patch an existing version, the operation could succeed even though there were SQL syntax errors in the associated setup script.

Such syntax errors would cause errors later in the application lifecycle, such as when a user attempted to install the app.

After the change:

When altering an app to either add a new version, or patch an existing version, static validation is performed for setup script syntax errors.

When a error is detected the command fails with error:

Application package <pkg> failed validation during version creation: ....<details of error>

Ref: 1627