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

[Jan Stastny (JIRA)]

Jan Stastny created TEIID-4224:
----------------------------------

             Summary: 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


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)