Bug 855017 (TEIID-2189)

Summary: Can the behaviour of the || operator to use concat2 to mirror the oracle functionality be made configurable
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Van Halbert <vhalbert>
Component: TeiidAssignee: Van Halbert <vhalbert>
Status: CLOSED WONTFIX QA Contact:
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: unspecifiedCC: cmondesi, jolee, soa-p-jira, vhalbert
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
URL: https://c.na7.visual.force.com/apex/Case_View?id=500A000000AuG9mIAF&sfdc.override=1
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2013-03-07 18:57:31 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Comment 1 JBoss JIRA Server 2012-09-14 17:01:41 UTC 
Steven Hawkins <shawkins> made a comment on jira TEIID-2189

Our logic isn't really amenable to handling || differently than concat.  This would probably have to be implemented as having both || and concat map to concat2.  That by itself is not a large change especially if it's enabled via a system property and affects the system globally (user queries transformations etc.)  If that's not desirable then we need more information.
Comment 3 JBoss JIRA Server 2013-08-06 15:36:27 UTC 
Steven Hawkins <shawkins> updated the status of jira TEIID-2189 to Resolved
Comment 4 JBoss JIRA Server 2013-08-06 15:36:27 UTC 
Steven Hawkins <shawkins> made a comment on jira 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.
Comment 5 JBoss JIRA Server 2013-12-05 13:55:53 UTC 
Steven Hawkins <shawkins> updated the status of jira TEIID-2189 to Closed