Calendar events created for policies with invalid SQL

[getvictor]

Fleet version: <!-- Copy this from the "My account" page in the Fleet UI, or run fleetctl --version --> 4.48.0 Web browser and operating system:

---

💥  Actual behavior

With calendar events enabled on a policy with invalid SQL, calendar event is created, and end user has no idea why.

🧑‍💻  Steps to reproduce

1. Using gitops (or fleetctl apply), create an invalid policy with calendar enabled for this policy only:

   - name: macOS - Check if latest version
   query: SELECT 1 WHERE 
   EXISTS ( 
     SELECT major, concat_ws(".", major, minor, patch) AS "macOS Version" FROM os_version --Sonoma WHERE 
       (major = "14" AND "macOS Version" < "14.4.1")
   );
   critical: false
   description: This policy check if macOS version is most recent version available.
   resolution: From the Apple menu, select System Settings. Navigate to General > Software Update.
   platform: darwin
   calendar_events_enabled: true

2. Calendar event gets created, even though this policy has no results.

🕯️ More info (optional)

N/A

[fleet-release]

SQL error in event, Fleet's fix brings clarity, Users breathe easy.