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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
