Bug 1322935 (TEIID-4112-DV6.2.5) - ORA-32039: recursive WITH clause must have column alias list
Summary: ORA-32039: recursive WITH clause must have column alias list
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: TEIID-4112-DV6.2.5
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Teiid
Version: 6.2.0
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: ---
Assignee: jolee
QA Contact: Filip Elias
URL:
Whiteboard:
Depends On:
Blocks: 1316260
TreeView+ depends on / blocked
 
Reported: 2016-03-31 17:26 UTC by dsteigne
Modified: 2019-12-16 05:35 UTC (History)
6 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2016-08-24 11:37:36 UTC
Type: Support Patch
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker TEIID-4112 0 Major Resolved ORA-32039: recursive WITH clause must have column alias list 2017-04-18 07:58:25 UTC

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


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