[teiid-issues] [JBoss JIRA] (TEIID-2497) Add support for DECODE(column, column_value, column_to_replace_with)

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-2497.
-----------------------------------

    Resolution: Rejected


DECODE is just a short cut for a case expression 

DECODE(product, 'CarB', amount)

can be expressed as:

CASE product WHEN 'CarB' THEN amount END
                
> Add support for DECODE(column, column_value, column_to_replace_with)
> --------------------------------------------------------------------
>
>                 Key: TEIID-2497
>                 URL: https://issues.jboss.org/browse/TEIID-2497
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>    Affects Versions: 7.7.6
>            Reporter: Van Halbert
>            Assignee: Steven Hawkins
>
> Looking at pivot and trying to use it like:
> Select salesperson, SUM(DECODE(product, 'CarA', amount)) as ProductCarA,
> SUM(DECODE(product, 'CarB', amount)) as ProductCarB,
> SUM(DECODE(product, 'CarC', amount)) as ProductCarC
> From SALES
> Group By salesperson
> Teiid's Decode requires you to know the value to substitute, with this option, it can be dynamically substituted at run time. 
>         
> See:  http://www.clearpeaks.com/blog/data-warehousing/pivot-data-in-sql

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira