dosubot[bot] commented on issue #33206:
URL: https://github.com/apache/superset/issues/33206#issuecomment-2825976742
<!-- Answer -->
To reproduce the issue with numeric filtering in Superset, follow these
steps:
1. **Set Up a Filter:**
- Add a filter for a numeric field that contains both integer and decimal
values (e.g., 21, 21.8, 25.35).
2. **Select an Integer Value First:**
- In the filter, first select an integer value (e.g., 21).
- Observe that the query returns only the rows where the value is exactly
21, excluding decimal values like 21.8 and 25.35.
3. **Select a Decimal Value First:**
- Now, select a decimal value first (e.g., 21.8 or 25.35).
- Observe that the filtering works as expected, returning all matching
rows regardless of decimal precision.
This issue has been observed across multiple databases, including
ClickHouse, Impala, and PostgreSQL. The expected behavior is that filtering by
numeric value should match all equivalent numeric representations, regardless
of the number of decimal places.
<!-- Dosu Comment Footer -->
*To continue talking to [Dosu](https://dosu.dev), mention @dosu.*
---
<sup>Help Dosu learn! Give it feedback: [Great
Response](https://app.dosu.dev/response-feedback/37c4411f-7a0d-42aa-b536-366e8c98fcb4?feedback_type=great_response)
| [Irrelevant
Answer](https://app.dosu.dev/response-feedback/37c4411f-7a0d-42aa-b536-366e8c98fcb4?feedback_type=irrelevant_answer)
| [Incorrect
Sources](https://app.dosu.dev/response-feedback/37c4411f-7a0d-42aa-b536-366e8c98fcb4?feedback_type=incorrect_sources)
| [Too
Verbose](https://app.dosu.dev/response-feedback/37c4411f-7a0d-42aa-b536-366e8c98fcb4?feedback_type=too_verbose)
|
[Hallucination](https://app.dosu.dev/response-feedback/37c4411f-7a0d-42aa-b536-366e8c98fcb4?feedback_type=hallucination)
| [Bug
Report](https://app.dosu.dev/response-feedback/37c4411f-7a0d-42aa-b536-366e8c98fcb4?feedback_type=bug_report)
|
[Other](https://app.dosu.dev/response-feedback/37c4411f-7a0d-42aa-b536-366e8c98fcb4?feedback_type=other)</sup>
--
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]
