MySQL dialect incompatible with BigQuery with LIMIT since #189

[vitaminmoo]

#189 moved LIMIT and OFFSET to use positional arguments. Unfortunately as per the bigquery documentation:

Note that a query can use positional or named parameters but not both.

This results in queries with named parameters and LIMIT/OFFSET resulting in googleapi: Error 400: named parameter and positional parameter cannot be used together, jobInternalError from the server where on v1.33.0 they succeeded.

#170 specifies that GoogleSQL is expected to be an alias of MySQL, but this appears to be a difference.

[huandu]

There is a new flavor Doris in the latest version. It's basically an alias of MySQL except that it doesn't use parameters in LIMIT/OFFSET. You can try this flavor and let me know whether it works for you. If so, I can add another flavor BigQuery with the same settings like Doris for your case.

[vitaminmoo]

Will try and let you know.

[vitaminmoo]

This appears to work