You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "yml-github (via GitHub)" <gi...@apache.org> on 2026/04/21 08:12:57 UTC
[I] [Bug] ipv4、ipv6字段类型查询时多个相同字段不等于或not查询仅第一个条件生效 [doris]
yml-github opened a new issue, #62672:
URL: https://github.com/apache/doris/issues/62672
### 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
doris-4.0.3-rc03-e9096296b8
### What's Wrong?
<img width="1151" height="493" alt="Image" src="https://github.com/user-attachments/assets/f690bdef-e2f3-430d-a6b0-10d247ec8434" />
第二个条件没生效，还是被查出来了
<img width="1061" height="673" alt="Image" src="https://github.com/user-attachments/assets/27beb815-20f7-4f27-b9f8-f8318f212de2" />
explain看也是只有第一个条件
<img width="1140" height="809" alt="Image" src="https://github.com/user-attachments/assets/8cbf0655-ea4f-4d2c-b6f5-7d23fd2faea5" />
### What You Expected?
ip类型字段多个not查询能够正常执行，比如以下2种示例
ipField != '1.1.1.1' and ipField != '1.1.1.2'
not (ipField between '1.1.1.1' and '1.1.1.10') and not (ipField between '10.1.1.1' and '10.1.1.10')
### How to Reproduce?
_No response_
### 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: commits-unsubscribe@doris.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [Bug] ipv4、ipv6字段类型查询时多个相同字段不等于或not查询仅第一个条件生效 [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on issue #62672:
URL: https://github.com/apache/doris/issues/62672#issuecomment-4591479665
https://github.com/apache/doris/pull/63481
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] [Bug] ipv4、ipv6字段类型查询时多个相同字段不等于或not查询仅第一个条件生效 [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow closed issue #62672: [Bug] ipv4、ipv6字段类型查询时多个相同字段不等于或not查询仅第一个条件生效
URL: https://github.com/apache/doris/issues/62672
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org