ALTER APPLICATION PACKAGE command: Expanded validation (Pending)

Attention

This behavior change is in the 2024_05 bundle.

For the current status of the bundle, refer to Bundle History.

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