malwaregarry opened a new issue, #36351: URL: https://github.com/apache/doris/issues/36351
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version 2.1.4 ### What's Wrong? If we insert -1049190528 into a tinyint column, it will be returned in a IS NULL filter, even if it is not null this returns false: `SELECT ((t1.c0) IS NULL) from t1;` this returns -128: `SELECT t1.c0 FROM t1 WHERE ((t1.c0) IS NULL);` ### What You Expected? `SELECT t1.c0 FROM t1 WHERE ((t1.c0) IS NULL);` does not return non-null rows ### How to Reproduce? ``` DROP DATABASE IF EXISTS doris1; CREATE DATABASE doris1; USE doris1; CREATE TABLE t1(c0 TINYINT) DISTRIBUTED BY RANDOM PROPERTIES ("replication_num" = "1"); INSERT INTO t1 (c0) VALUES (-1049190528); SELECT ((t1.c0) IS NULL) FROM t1; SELECT t1.c0 FROM t1 WHERE ((t1.c0) IS NULL); ``` ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
