[teiid-issues] [JBoss JIRA] (TEIID-4022) Materialization issue dynamic SQL command can't be executed due ambiguous group name

[RH Bugzilla Integration (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4022?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13172444#comment-13172444 ] 

RH Bugzilla Integration commented on TEIID-4022:
------------------------------------------------

Van Halbert <vhalbert at redhat.com> changed the Status of [bug 1314890|https://bugzilla.redhat.com/show_bug.cgi?id=1314890] from NEW to MODIFIED

> Materialization issue dynamic SQL command can't be executed due ambiguous group name  
> --------------------------------------------------------------------------------------
>
>                 Key: TEIID-4022
>                 URL: https://issues.jboss.org/browse/TEIID-4022
>             Project: Teiid
>          Issue Type: Bug
>          Components: Server
>    Affects Versions: 8.12.x
>            Reporter: Van Halbert
>            Assignee: Steven Hawkins
>            Priority: Blocker
>             Fix For: 9.0, 8.12.5, 8.13.2
>
>
> The defined model for materialization:
> {code}
> 	<model name="PersonMatModel" type="VIRTUAL">
> 		<metadata type="DDL"><![CDATA[
> 	CREATE view PersonMatView
> 		(
>             name string,
>             id integer,
>             email string
>  		) OPTIONS (MATERIALIZED 'TRUE', UPDATABLE 'TRUE',         
>                MATERIALIZED_TABLE 'PersonMatCache.Person', 
>                "teiid_rel:MATVIEW_TTL" 60000,
>                "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute PersonMatCache.native(''truncate cache'');',
>                "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT"  'execute PersonMatCache.native(''swap cache names'');', 
>                 "teiid_rel:MATERIALIZED_STAGE_TABLE" 'PersonMatCache.Person',
>               "teiid_rel:MATVIEW_SHARE_SCOPE" 'NONE',
>                "teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'true', 
>                "teiid_rel:MATVIEW_STATUS_TABLE" 'Accounts.status',                
>                "teiid_rel:MATVIEW_ONERROR_ACTION" 'THROW_EXCEPTION')
>  		AS SELECT  name, id, email from PersonInfoModel.Person;
>     	]]>
>    		</metadata>
> 	</model>   
> {code}
> causes the following exception:
> {code}
> org.teiid.api.exception.query.QueryProcessingException: TEIID30168 Couldn't 
> execute the dynamic SQL command "EXECUTE IMMEDIATE ('SELECT count(*) as 
> rowCount FROM ' || matViewTable) AS rowCount integer INTO #load_count" with 
> the SQL statement "('SELECT count(*) as rowCount FROM ' || matViewTable)" due 
> to: Group specified is ambiguous, resubmit the query by fully qualifying the group 
> name: Person
> {code}
> And executing the following internal call that Teiid uses does produce the non-qualifed name
> {ccode}
> SELECT TargetName from SYSADMIN.MatViews WHERE VDBName = 'PeopleMat' AND SchemaName = 'PersonMatModel' AND Name = 'PersonMatView'
> {code}
> returns:  Person



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)