[jira] [Created] (IGNITE-25339) Sql. Cast FORMAT. Incorrect parsing for RR/RRRR

[Maksim Zhuravkov (Jira)]

Maksim Zhuravkov created IGNITE-25339:
-----------------------------------------

             Summary: Sql. Cast FORMAT. Incorrect parsing for RR/RRRR 
                 Key: IGNITE-25339
                 URL: https://issues.apache.org/jira/browse/IGNITE-25339
             Project: Ignite
          Issue Type: Improvement
          Components: sql
            Reporter: Maksim Zhuravkov


Parsing of RR/RRRR works incorrect.
{noformat}
sql-cli> SELECT CAST ('49-01-01' AS DATE FORMAT 'RRRR-MM-dd' )
╔══════════════════════════════════════════════╗
║ CAST('49-01-01' AS DATE FORMAT 'RRRR-MM-dd') ║
╠══════════════════════════════════════════════╣
║ 0049-01-01                                   ║
╚══════════════════════════════════════════════╝
Should be 2049-01-01

sql-cli> SELECT CAST ('51-01-01' AS DATE FORMAT 'RRRR-MM-dd' )
╔══════════════════════════════════════════════╗
║ CAST('51-01-01' AS DATE FORMAT 'RRRR-MM-dd') ║
╠══════════════════════════════════════════════╣
║ 0051-01-01                                   ║
╚══════════════════════════════════════════════╝
Should be 1951-01-01

sql-cli> SELECT CAST ('51-01-01' AS DATE FORMAT 'RR-MM-dd' )
╔════════════════════════════════════════════╗
║ CAST('51-01-01' AS DATE FORMAT 'RR-MM-dd') ║
╠════════════════════════════════════════════╣
║ 1951-01-01                                 ║
╚════════════════════════════════════════════╝
Correct

sql-cli> SELECT CAST ('49-01-01' AS DATE FORMAT 'RR-MM-dd' )
╔════════════════════════════════════════════╗
║ CAST('49-01-01' AS DATE FORMAT 'RR-MM-dd') ║
╠════════════════════════════════════════════╣
║ 1949-01-01                                 ║
╚════════════════════════════════════════════╝
Should be 2049-01-01

sql-cli> 
{noformat}




--
This message was sent by Atlassian Jira
(v8.20.10#820010)