Bug 855017 (TEIID-2189) - Can the behaviour of the || operator to use concat2 to mirror the oracle functionality be made configurable
Summary: Can the behaviour of the || operator to use concat2 to mirror the oracle func...
Keywords:
Status: CLOSED WONTFIX
Alias: TEIID-2189
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Teiid
Version: unspecified
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
: ---
Assignee: Van Halbert
QA Contact:
URL: https://c.na7.visual.force.com/apex/C...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2012-09-06 14:12 UTC by Van Halbert
Modified: 2018-11-29 20:16 UTC (History)
4 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2013-03-07 18:57:31 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker TEIID-2189 0 Minor Closed Can the behaviour of the || operator to use concat2 to mirror the oracle functionality be made configurable 2013-12-10 02:53:55 UTC

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


Note You need to log in before you can comment on or make changes to this bug.