Github user stanzhai commented on the issue:

    https://github.com/apache/spark/pull/18986
  
    @DonnyZone @gatorsmile @cloud-fan  PostgreSQL will throw an error when 
comparing a string to  a int.
    
    ```
    postgres=# select * from tb;
      a   | b
    ------+---
     0.1  | 1
     a    | 1
     true | 1
    (3 rows)
    
    postgres=# select * from tb where a>0;
    ERROR:  operator does not exist: character varying > integer
    LINE 1: select * from tb where a>0;
                                    ^
    HINT:  No operator matches the given name and argument type(s). You might 
need to add explicit type casts.
    ```


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---

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

Reply via email to