[IGNITE-23347] Comparison of strings works wrong

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 3.0.0-beta1
• Fix Version/s: 3.0
• Component/s: sql
• Labels: ignite-3
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Konstantin Orlov
• Reporter: Igor
• Created: 03/Oct/24 07:32
• Updated: 21/Oct/24 10:58
• Resolved: 21/Oct/24 10:49

Description

Query: "select '12345 ' > '12345' as result;"
Expected:
(true)
Actual:
(false)

Query: "select 'a' < 'a ' as result;"
Expected:
(true)
Actual:
(false)

Query: "select 'a' >= 'a ' as result;"
Expected:
(false)
Actual:
(true)

Query: "select '12345 ' <= '12345' as result;"
Expected:
(false)
Actual:
(true) 

Issue Links

• fixes: IGNITE-22472 Sql. Char. Inconsistent handling of comparison operation
• is caused by: IGNITE-23042 Sql. Forbid implicit casts between different type families
• links to: GitHub Pull Request #4584