turboFei edited a comment on issue #27150: [SPARK-30471][SQL] Fix issue when 
comparing String and IntegerType
URL: https://github.com/apache/spark/pull/27150#issuecomment-581727090
 
 
   Sorry for late reply. I am blocked by other things recently. 
   
   For this pr, I tried to keep consistent with pgsql for ansi mode, but failed.
   For example:
   
   
![image](https://user-images.githubusercontent.com/6757692/73711329-75061280-4741-11ea-970e-5513633918fa.png)
   
   Pgsql does not treat '1' as a text, but spark will treat '1' as string at 
first.
   
   So, It is easy to cast string to double when comparing with Integer type, 
but it is difficult to keep consistent with pgsql.
   

----------------------------------------------------------------
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