ACK RDS controller DBCluster reporting delta when only engineVersion major is supplied

[rmullinnix461332]

Describe the bug
rds controller DBCluster is setting condition for sync as false if only major engineVersion is supplied at DBCluster. There is a reconcile check in DBInstance to allow for major version only when autoMinorVersionUpgrade is set.

This prevents FieldExport resources that rely on the status section from being set.

Steps to reproduce
DBCluster Resource

• engine: aurora-mysql
• engineVersion: "8.0"

Expected outcome
The dbcluster manifest should have a condition

• lastTransitionTime: "2025-08-28T15:52:46Z"
  status: "True"
  type: ACK.ResourceSynced

However, the condition is reported as

• lastTransitionTime: "2025-08-28T15:52:46Z"
  status: "False"
  type: ACK.ResourceSynced

Environment

• Kubernetes version 1.33
• Using EKS (yes/no), if so version? yes - 1.33
• AWS service targeted (S3, RDS, etc.) RDS - controller version 1.6.0

[github-actions]

Hello @rmullinnix461332 👋 Thank you for opening an issue in ACK! A maintainer will triage this issue soon.

We encourage community contributions, so if you're interested in tackling this yourself or suggesting a solution, please check out our Contribution and Code of Conduct guidelines.

You can find more information about ACK on our website.

[knottnt]

@rmullinnix461332 Could you share a YAML manifest results in this behavior?

[rmullinnix461332]

@rmullinnix461332 Could you share a YAML manifest results in this behavior?

status:
  ackResourceMetadata:
    arn: arn:aws:rds:us-east-1:XXXXXXXXXX:cluster:aa-aaa-aaa
    ownerAccountID: "XXXXXXXXXX"
    region: us-east-1
  clusterCreateTime: "2024-03-08T15:55:09Z"
  conditions:
  - lastTransitionTime: "2025-08-28T19:29:46Z"
    status: "True"
    type: ACK.ReferencesResolved
  - lastTransitionTime: "2025-08-28T19:29:47Z"
    status: "False"
    type: ACK.ResourceSynced

and the info message from the controller
{"level":"info","ts":"2025-08-28T19:33:19.578Z","logger":"ackrt","msg":"desired resource state has changed","kind":"DBCluster","namespace":"xxx-xxxx-xxxxxxx","name":"aa-aaa-aaaa","account":"XXXXXXXXXX","role":"","region":"us-east-1","is_adopted":false,"generation":214,"diff":[{"Path":{"Parts":["Spec","EngineVersion"]},"A":"8.0","B":"8.0.mysql_aurora.3.08.2"}]}