[Bug]: Cannot deploy mssqldatabase to elastic pool with default enclave

[hobbesuk]

Is there an existing issue for this?

• I have searched the existing issues

Affected Resource(s)

sql.azure.upbound.io/v1beta1 - MSSQLDatabase

Resource MRs required to reproduce the bug

apiVersion: sql.azure.upbound.io/v1beta1
kind: MSSQLDatabase
metadata:
  name: {{ $name }}
  annotations:
    gotemplating.fn.crossplane.io/composition-resource-name: {{ $name }}-db
spec:
  forProvider:
    elasticPoolId:
      /subscriptions/xxx
    serverId:
      /subscriptions/xxx
    createMode: Default
    longTermRetentionPolicy:
      - weeklyRetention: P12W
      - immutableBackupsEnabled: true
    threatDetectionPolicy:
      - state: Enabled
      - emailAddresses:
        - [email protected]

Steps to Reproduce

Using azure elastic sql pool with secure enclaves off (or default) but when I use crossplane to create a database to put in this pool

What happened?

I get this error

async create failed: failed to create the resource: [{0 adding the Database (Subscription: "xxx"
Resource Group Name: "xxx"
Server Name: "xxx"
Database Name: "testtenantdb") with enclave type "VBS" to the Elastic Pool (Subscription: "xxx"
Resource Group Name: "xxx"
Server Name: "xxx"
Elastic Pool Name: "xxx") with enclave type "Default" is not supported. Before adding a database to an elastic pool please ensure that the 'enclave_type' is the same for both the database and the elastic pool  []}]

Relevant Error Output Snippet

Crossplane Version

1.16.0

Provider Version

1.11.0

Kubernetes Version

No response

Kubernetes Distribution

No response

Additional Info

No response