search

runt18 / google-bigquery

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

cryptic reporting of error during TABLE_DATE_RANGE's timestamp evaluation #455

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
http://stackoverflow.com/questions/35731841/timestamp-evaluation-connection-erro
r-in-date-add-in-table-date-range-in

Reproduction:
SELECT *
FROM
  TABLE_DATE_RANGE([ds.table_prefix_], DATE_ADD(CURRENT_TIMESTAMP(), -3, 'MONTHS'), DATE_ADD(CURRENT_TIMESTAMP(), -1, 'DAY'))

Expected: an error message that includes "Invalid interval unit in function 
DATE_ADD: MONTHS"

Actual: "Timestamp evaluation: connection error."

Original issue reported on code.google.com by e...@google.com on 1 Mar 2016 at 11:14

GoogleCodeExporter commented 8 years ago

Original comment by e...@google.com on 4 Mar 2016 at 5:40