Does anyone else frequently get “Unsupported Search” errors when joining to a subquery that has a group by clause? Sometimes it works and other times it doesn’t.

i’ve had issues with group by when there is a trailing comma in the group by clause

@Matt Bernstein are you wrapping it to get more than 5000 results.

Yeah that is another thing that is odd — using a WITH clause fixes it. Putting the subquery inline doesn’t work

Yeah I am. do you think that’s what could be causing the issue?

Depending on how your wrapping it. I think that a comma before a right parentheses should fail.

Select * from (${query},)

will fail.

I had one very odd case where I joined to a subquery, which worked fine. However I counldn’t reference any of the columns in the SELECT clause — Except when using the * selector. So: alias.customer_name wouldn’t work, but alias.* WOULD work (and oddly included the customer_name column from the subquery!)

That's odd. CTEs work the opposite way. You can't use

temporarytable.*

you have to name the columns. Get super annoying.