liukun4515 commented on issue #3304:
URL: 
https://github.com/apache/arrow-datafusion/issues/3304#issuecomment-1233704074

   ```
   
   
   boolean IS TRUE → booleanTest whether boolean expression yields true.true IS 
TRUE → tNULL::boolean IS TRUE → f (rather than NULL)
   --
   boolean IS NOT TRUE → booleanTest whether boolean expression yields false or 
unknown.true IS NOT TRUE → fNULL::boolean IS NOT TRUE → t (rather than NULL)
   boolean IS FALSE → booleanTest whether boolean expression yields false.true 
IS FALSE → fNULL::boolean IS FALSE → f (rather than NULL)
   boolean IS NOT FALSE → booleanTest whether boolean expression yields true or 
unknown.true IS NOT FALSE → tNULL::boolean IS NOT FALSE → t (rather than NULL)
   boolean IS UNKNOWN → booleanTest whether boolean expression yields 
unknown.true IS UNKNOWN → fNULL::boolean IS UNKNOWN → t (rather than NULL)
   boolean IS NOT UNKNOWN → booleanTest whether boolean expression yields true 
or false.true IS NOT UNKNOWN → tNULL::boolean IS NOT UNKNOWN → f (rather than 
NULL)
   
   
   ```


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

Reply via email to