[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 resolved TEIID-4224.
-----------------------------------
    Fix Version/s: 9.0
                   8.12.5
                   8.13.5
       Resolution: Done


Added the translation from above.

> 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
(v6.4.11#64026)