customer_client causes Internal error if query contains LIMIT

[Alexander]

If a query contains a limit clause then customer_client always throws an Internal Error

 

SELECT  customer_client.hidden, customer_client.client_customer, customer_client.level, customer_client.resource_name  FROM customer_client  LIMIT 100

Without LIMIT the query works as expected.

I tested it on a non-MCC accounts. Maybe this is the problem.

[googleadsapi...@google.com]

Hello,

Thanks for the report. I can also consistently reproduce the same behavior on my own account. Even if this is an invalid query for some reason (which I don't think it is; it looks like it should work), you should be getting back a more useful error message.

I've passed this information along to our engineering team and I'll let you know when I have any more information to share.

Regards,

Mike, 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/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
 
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscribe@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/97673e86-34ef-4165-9c92-fb73b2bcfcd7%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[googleadsapi...@google.com]

Hello,

It looks like you can add an ORDER BY to your query to get around this error for now. We're going to work on making this case easier to debug for end users if they run into it in the future.

Regards,

Mike, 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/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~