maropu commented on issue #25615: [SPARK-28495][SQL][FOLLOW-UP] Disallow 
conversions between timestamp and long in ASNI mode
URL: https://github.com/apache/spark/pull/25615#issuecomment-526045102
 
 
   The change looks reasonable to me. Just in case, I checked the pgSQL 
behaivour;
   ```
   postgres=# create table t (l bigint);
   postgres=# insert into t values ('20190829 00:00:00'::timestamp);
   2019-08-29 15:26:10.998 JST [4553] ERROR:  column "l" is of type bigint but 
expression is of type timestamp without time zone at character 23
   2019-08-29 15:26:10.998 JST [4553] HINT:  You will need to rewrite or cast 
the expression.
   2019-08-29 15:26:10.998 JST [4553] STATEMENT:  insert into t values 
('20190829 00:00:00'::timestamp);
   ERROR:  column "l" is of type bigint but expression is of type timestamp 
without time zone
   LINE 1: insert into t values ('20190829 00:00:00'::timestamp);
                              
   ```

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
[email protected]


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to