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