google-code-export / google-bigquery

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

Simple query fails with constant column #61

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Run this query:

SELECT 1 AS Number_of_Records,
  [alt] AS alt,
  [col] AS col,
  [country] AS country,
  [day] AS day,
  [fog] AS fog,
  [hail] AS hail,
  [lat] AS lat,
  [long] AS long
FROM [bigquery-samples:weather_geo.gsod_update_fixed] gsod_update_fixed
LIMIT 7

What is the expected output? What do you see instead?
Expected: 7 rows.
Actual: "Unexpected" error.

What version of the product are you using? On what operating system?
Using bigquery.cloud.google.com.

Please provide any additional information below.
Tried this with a couple different sample data sets. Removing the constant 
column, or modifying it to be non-constant, causes the error to go away.

Original issue reported on code.google.com by entropy...@gmail.com on 20 Jan 2014 at 10:05

GoogleCodeExporter commented 9 years ago
Thanks for the report. This does look like an issue on our end; we'll try to 
get it fixed soon.

Original comment by jcon...@google.com on 20 Jan 2014 at 8:13

GoogleCodeExporter commented 9 years ago
This should now be fixed, please re-open if you still encounter issues.

Original comment by thomasp...@google.com on 6 Feb 2014 at 8:11