[teiid-issues] [JBoss JIRA] (TEIID-4224) HANA translator : incorrect pushdown of DAYOFWEEK function

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4224?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins closed TEIID-4224.
---------------------------------


> HANA translator : incorrect pushdown of DAYOFWEEK function
> ----------------------------------------------------------
>
>                 Key: TEIID-4224
>                 URL: https://issues.jboss.org/browse/TEIID-4224
>             Project: Teiid
>          Issue Type: Bug
>          Components: Misc. Connectors
>    Affects Versions: 8.12.5
>            Reporter: Jan Stastny
>            Assignee: Steven Hawkins
>             Fix For: 9.0, 8.12.5, 8.13.5
>
>
> Teiid's DAYOFWEEK function:
> {code:plain}
> DAYOFWEEK(x) 	Return day of week (Sunday=1, Saturday=7) 
> {code}
> is pushed down as:
> {code:plain}
> dayname(g_0."DATEVALUE")
> {code}
> but this function returns string representation of the day.
> More appropriate would be to push DAYOFWEEK as WEEKDAY function, but the returned value has to be adapted to Teiid's representation (Sunday=1 and Saturday=7, vs. HANA's Monday=0,Sunday=6). So the solution would be to push:
> {code:sql}
> MOD((WEEKDAY(datevalue)+1),7)+1
> {code}



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)