[
https://issues.apache.org/jira/browse/IGNITE-26090?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Andrey Mashenkov updated IGNITE-26090:
--------------------------------------
Fix Version/s: 3.1
> 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
> Assignee: Andrey Mashenkov
> Priority: Major
> Labels: ignite-3
> Fix For: 3.1
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> 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.
> See also, ItDataTypesTest.nonFiniteNumerics.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
