Not a bug. Best practice is NOT to use reserved words like "by" as column names. Until such names are got rid of, surround sql references to them with backticks, eg select `by`, ...
PB On Wednesday, November 17, 2021 at 5:14:48 AM UTC-6 [email protected] wrote: > There seem to be a bug in the parser (or docs or me hehe) but it says that > eg the following query is faulty: > QUERY(A:BZ, "SELECT BY, COUNT(BY) GROUP BY BY") > whereas eg the following works: > QUERY(A:BZ, "SELECT BZ, COUNT(BZ) GROUP BY BZ") > > According to me this is a parser bug. > > Do one need to go by ColXX or is there any way to specify column BY in > some other notation? I tried 'BY' and`BY`etc but to no avail. > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/67010074-4124-4642-be36-befcf9fc0a96n%40googlegroups.com.
