You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@spark.apache.org by GitBox <gi...@apache.org> on 2020/02/04 03:31:54 UTC

[GitHub] [spark] turboFei commented on issue #27150: [SPARK-30471][SQL] Fix issue when comparing String and IntegerType

turboFei commented 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 string, 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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org