[
https://issues.apache.org/jira/browse/IGNITE-25339?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Maksim Zhuravkov resolved IGNITE-25339.
---------------------------------------
Resolution: Fixed
Fixed in https://issues.apache.org/jira/browse/IGNITE-25317
> Sql. Cast FORMAT. Incorrect parsing for RR/RRRR
> ------------------------------------------------
>
> Key: IGNITE-25339
> URL: https://issues.apache.org/jira/browse/IGNITE-25339
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Reporter: Maksim Zhuravkov
> Priority: Major
> Labels: ignite-3
>
> Parsing of RR/RRRR works incorrectly:
> {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)
