[teiid-issues] [JBoss JIRA] (TEIID-2189) Can the behaviour of the || operator to use concat2 to mirror the oracle functionality be made configurable

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-2189.
-----------------------------------



Reasons against this:
- it's non-ansi behavior
- Oracle doesn't even guarantee this behavior in later version
- addressing isn't straight-forward.  We can just change the behavior of the function method.  It would require us to internally differentiate between the || and the concat function and to ensure that all of the internal views (mostly in pg) use the concat function.

So marking as won't fix unless there is an additional driver to add this behavior.
                
> Can the behaviour of the || operator to use concat2 to mirror the oracle functionality be made configurable
> -----------------------------------------------------------------------------------------------------------
>
>                 Key: TEIID-2189
>                 URL: https://issues.jboss.org/browse/TEIID-2189
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: JDBC Connector, Server
>    Affects Versions: 7.4.4
>            Reporter: Van Halbert
>            Assignee: Steven Hawkins
>            Priority: Minor
>
> Is it possible to make configurable the ability to switch the behaviour of the || operator to use concat2 in order to mirror the oracle functionality.

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