[IGNITE-14960] Calcite engine. EXTRACT(DOW FROM d) returns invalid results

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: sql
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Aleksey Plekhanov
• Reporter: Taras Ledkov
• Created: 22/Jun/21 09:23
• Updated: 10/Nov/21 13:05
• Resolved: 22/Jul/21 08:03

Description

The query
SELECT EXTRACT(DOW FROM CAST('1993-08-14' AS DATE))
return 7.

According with documentation:
dow - The day of the week as Sunday(0) to Saturday(6)

Tests:
function/date/test_extract.test
function/date/test_extract_edge_cases.test
function/timestamp/test_extract.test

Issue Links

• is part of: IGNITE-14535 Caclite SQL engine capabilities
• links to: GitHub Pull Request #9265