Bug 1322935 (TEIID-4112-DV6.2.5)

Summary:	ORA-32039: recursive WITH clause must have column alias list
Product:	[JBoss] JBoss Data Virtualization 6	Reporter:	dsteigne
Component:	Teiid	Assignee:	jolee
Status:	CLOSED CURRENTRELEASE	QA Contact:	Filip Elias <felias>
Severity:	high	Docs Contact:
Priority:	high
Version:	6.2.0	CC:	asmigala, aszczucz, blafond, jolee, mbaluch, thauser
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2016-08-24 11:37:36 UTC	Type:	Support Patch
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:
Bug Blocks:	1316260

Description dsteigne 2016-03-31 17:26:09 UTC

Description of problem:
See https://issues.jboss.org/browse/TEIID-4112

Version-Release number of selected component (if applicable):


How reproducible:


Steps to Reproduce:
1.
2.
3.

Actual results:


Expected results:


Additional info:

Comment 1 JBoss JIRA Server 2016-04-22 16:54:38 UTC

Steven Hawkins <shawkins> updated the status of jira TEIID-4112 to Resolved

Comment 2 jolee 2016-04-26 14:51:19 UTC

git:jboss-integration/teiid.git : 8.7.x-prod-ipv6.2 : 82d2322

git:teiid/teiid.git : 62-8.7.x : 82d2322

Comment 3 Andrej Smigala 2016-05-16 10:31:35 UTC

The property ExcludedCommonTableExpressionName cannot be set as described, because the setter method name has a typo in it [1]. The getter method has the correct name.



https://github.com/teiid/teiid/blob/62-8.7.x/api/src/main/java/org/teiid/translator/ExecutionFactory.java#L1240

Comment 4 Andrej Smigala 2016-05-16 10:39:39 UTC

Actually, even if I use the "correct" property name, the common table expression name is still not changed in the query. I am unsure whether this is caused by the mismatch in the property name, or by something else.

Comment 5 Andrej Smigala 2016-05-16 11:12:23 UTC

Turns out the property is not not being used even when I specify it in the translator override with the typo, the following is logged in console instead:


TEIID40001 The provided translator property values [ExcluedCommonTableExpressionName] were not used.  Please check the properties that are expected by translator oracle-override.

Comment 6 JBoss JIRA Server 2016-05-16 11:15:08 UTC

Andrej Šmigala <asmigala> updated the status of jira TEIID-4112 to Reopened

Comment 7 JBoss JIRA Server 2016-05-16 14:04:19 UTC

Steven Hawkins <shawkins> updated the status of jira TEIID-4112 to Resolved

Comment 8 jolee 2016-05-16 15:37:13 UTC

@Angrej,
  re: comment #5,  "ExcluedCommonTableExpressionName" was only mangled in one class,  so when trying to test w/the "wrong" spelling TEIID40001 is to be expected.

git:jboss-integration/teiid.git : 8.7.x-prod-ipv6.2 : c2126b1

git:teiid/teiid.git : 62-8.7.x : c2126b1