CREATE <object> commands: Changes to error messages when creating an object in a share (Pending)


This behavior change is in the 2024_05 bundle.

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

When you execute a CREATE <object> command to create an object in a share, if an error occurs during the type-checking phase of the command, the command prints an error message.

This error message is changing in the following way:

Before the change:

The command fails with the following error message, regardless of the cause of the error:

003540 (42501): SQL execution error:
  Creating table on shared database '<database_name>'
  is not allowed.
After the change:

The command fails with an error message that describes the specific problem that occurred.

For example, if you do not have the privilege to operate on the schema, the command fails with the following error message:

003001 (42501): SQL access control error:
  Insufficient privileges to operate on schema '<schema_name>'

Ref: 1623