search

argasi / google-bigquery

Automatically exported from code.google.com/p/google-bigquery
0 stars 0 forks source link

ignore case conflicting with writing to table #211

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Write a query with "ignore case" at the end
2. Select a table or create a table for the results to be put into
3. Run query and look for error: "Error: unexpected LIMIT clause at: 31.13 - 
31.19"

What is the expected output? What do you see instead?
Expected to successfully create a table with the data from the Query

What version of the product are you using? On what operating system?
BigQuery. Chrome/Windows 7

Please provide any additional information below.
I know that there was an issue with ignore case conflicting with other things 
such as the group each by statement, but wasn't sure if the fix for that would 
fix this issue as well. (also not sure when that fix is going into production)

For reference: Job ID: ua-web-analytics:job_gX3dMUzoZCgwzUJKGB0W_RbZQ7g

Original issue reported on code.google.com by hog...@gmail.com on 23 Jan 2015 at 2:17

GoogleCodeExporter commented 9 years ago 
There is currently an issue where IGNORE CASE causes this error when used with 
the "Allow Large Results" query option.  It's due to some internal operations 
specific to the "Allow Large Results" codepath.

It's a separate issue from the GROUP EACH BY / IGNORE CASE issue.  I'll update 
the other issue report with details on that.

Thanks for continuing to help us flush out bugs related to IGNORE CASE. :)

Original comment by dk...@google.com on 23 Jan 2015 at 7:55