[
https://issues.apache.org/jira/browse/IGNITE-26090?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Andrey Mashenkov updated IGNITE-26090:
--------------------------------------
Description:
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.
was:
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.
> 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
>
> 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)
