You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@inlong.apache.org by "Zkplo (via GitHub)" <gi...@apache.org> on 2024/09/15 02:43:41 UTC

[I] [Feature][SDK] Transform SQL supports parsing of IS [inlong]

Zkplo opened a new issue, #11109:
URL: https://github.com/apache/inlong/issues/11109

   ### Description
   
   - parent issue #10796 
   - MySql Official Description: https://dev.mysql.com/doc/refman/8.4/en/comparison-operators.html#operator_is
   
   ```
   is [not] boolean_value: Tests a value against a boolean value, where boolean_value can be TRUE, FALSE, or UNKNOWN.
   is [not] NULL : Tests whether a value is NULL.
   ```
   > **Note:** Due to the fact that jsqlparser does not support parsing of UNKOWN and UNKOWN is not commonly used, support for UNKOWN will not be implemented here.
   
   ### Use case
   
   ```sql
   SELECT 1 IS TRUE, 0 IS FALSE;   -> 1, 1
   SELECT 1 IS NOT TRUE, 0 IS NOT FALSE;   -> 0, 0
   
   SELECT 1 IS NULL, 0 IS NULL, NULL IS NULL;  -> 0, 0, 1
   SELECT 1 IS NOT NULL, 0 IS NOT NULL, NULL IS NOT NULL;    -> 1, 1, 0
   ```
   
   ### Are you willing to submit PR?
   
   - [X] Yes, I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
   


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

To unsubscribe, e-mail: dev-unsubscribe@inlong.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] [Feature][SDK] Transform SQL supports parsing of IS [inlong]

Posted by "dockerzhang (via GitHub)" <gi...@apache.org>.
dockerzhang closed issue #11109: [Feature][SDK] Transform SQL supports parsing of IS
URL: https://github.com/apache/inlong/issues/11109


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

To unsubscribe, e-mail: dev-unsubscribe@inlong.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org