"Internal error encountered" when querying "change_event" (on a specific date)

[Börje Sieling]

Hi, I am getting an internal error / 500 when trying to query the change_event
on a specific date in the google ads api:

change_event.change_date_time >= '2023-09-20' AND
change_event.change_date_time <= '2023-09-21'

The error does not happen when the date range is e.g. 2023-09-21 until 2023-09-22
This is the debug log with request and response data generated by the python code:

[2023-09-25 12:37:08,150 - INFO] Request
-------
Method: /google.ads.googleads.v14.services.GoogleAdsService/SearchStream
Host: googleads.googleapis.com
Headers: {
  "developer-token": "REDACTED",
  "login-customer-id": "2267532088",
  "x-goog-api-client": "gl-python/3.9.16 grpc/1.58.0 gax/2.11.1 gccl/22.0.0 pb/4.24.3",
  "x-goog-request-params": "customer_id=4294392384"
}
Request: customer_id: "4294392384"
query: "\n    SELECT\n        change_event.resource_name,\n        change_event.change_date_time,\n        change_event.change_resource_name,\n        change_event.user_email,\n        change_event.client_type,\n        change_event.change_resource_type,\n        change_event.old_resource,\n        change_event.new_resource,\n        change_event.resource_change_operation,\n        change_event.changed_fields\n    FROM change_event\n    WHERE \n        change_event.change_date_time >= \'2023-09-20\' AND\n        change_event.change_date_time <= \'2023-09-21\'\n    LIMIT 100\n    "


Response
-------
Headers: {
  "google.ads.googleads.v14.errors.googleadsfailure-bin": "\n%\n\u0002P\u0002\u0012\u001fAn internal error has occurred.\u0012\u0016TIlzXV4_d-Ebhjd43Drmtg",
  "grpc-status-details-bin": "\b\r\u0012\u001bInternal error encountered.\u001a\u0001\nDtype.googleapis.com/google.ads.googleads.v14.errors.GoogleAdsFailure\u0012?\n%\n\u0002P\u0002\u0012\u001fAn internal error has occurred.\u0012\u0016TIlzXV4_d-Ebhjd43Drmtg",
  "request-id": "TIlzXV4_d-Ebhjd43Drmtg"
}
Fault: {}