Using LIMIT without ORDER BY in a query for customer_client results in server error

[Dorian Kind]

Hi there,

just an observation I made, if you send a query like the following to the GoogleAdsService, the result is reproducibly "Internal error encountered.":

SELECT

  customer_client.client_customer

FROM customer_client

LIMIT 1000

The actual limit value doesn't matter, only either adding an ORDER BY or removing the LIMIT clause makes the error go away. Other resources don't seem to be affected by this and as far as I understand the Google Ads Query Language grammar it should be a valid query.

[googleadsapi...@google.com]

Hi Dorian, 

Thank you for sharing the details. I was able to replicate the issue and we are currently looking into it. I will keep you posted on the updates.

Regards,

Bharani, Google Ads API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    https://ads-developers.googleblog.com/search/label/google_ads_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

[cv]

Hello Bharani,

It is not working with any where clause as well.

I created issue here which might be same as this.

https://groups.google.com/d/msg/adwords-api/LAW0JsNwpP0/504PF5cuBQAJ

Thanks,

[Google Ads API Forum Advisor Prod]

Hi Chirag, 

I see that my team is already assisting you on that thread. Please continue the discussion on that thread to maintain continuity. 

Thanks,
Bharani, Google Ads API Team

ref:_00D1U1174p._5001UAqVnT:ref