search

runt18 / google-bigquery

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

COALESCE converts TIMESTAMP to INTEGER #479

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
1. Execute query SELECT CURRENT_TIMESTAMP() as ts1, 
COALESCE(CURRENT_TIMESTAMP(), NULL) as ts2
2. Observe that ts1 has type TIMESTAMP while ts2 has type INTEGER 

What is the expected output? What do you see instead?
I expect both ts1 and ts2 to be TIMESTAMPs

What version of the product are you using? On what operating system?
Though it's not important in this case: Java library 
google-api-services-bigquery[v2-rev136-1.17.0-rc]

Please provide any additional information below.
-

Original issue reported on code.google.com by ale...@gromov.ws on 25 Mar 2016 at 6:30

GoogleCodeExporter commented 8 years ago

Original comment by mos...@google.com on 25 Mar 2016 at 3:30

GoogleCodeExporter commented 8 years ago 
It will take couple of weeks for the fix to reach production.

Original comment by mos...@google.com on 25 Mar 2016 at 8:47

GoogleCodeExporter commented 8 years ago 
Nice, thank you :)

Original comment by ale...@gromov.ws on 27 Mar 2016 at 6:16