Iurii Gerzhedovich created IGNITE-26090:
-------------------------------------------
Summary: Sql. Validate Special Values for Approximate Numeric
Types in SQL (NaN, ±Infinity, ±0)
Key: IGNITE-26090
URL: https://issues.apache.org/jira/browse/IGNITE-26090
Project: Ignite
Issue Type: Bug
Components: sql ai3
Reporter: Iurii Gerzhedovich
This task involves investigating and testing how SQL handles special values for
approximate numeric types (floating-point), including:
• +Infinity
• -Infinity
• NaN (Not a Number)
• +0
• -0
The goal is to ensure the database correctly handles these values in the
following contexts:
• Inserting into tables
• Comparisons (=, <, >, IS DISTINCT FROM, etc.)
• Aggregations (MIN, MAX, AVG)
• Sorting
• Use in WHERE, GROUP BY, ORDER BY clauses
• Indexes
• ......
The results will help clarify edge case behavior in business logic and improve
test coverage.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
