March 2016 - teiid-issues - Jboss List Archives

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

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4022?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-4022: ------------------------------------ Also, to note, the above exception: org.teiid.api.exception.query.QueryProcessingException was not being seen in the server log, only thru debug did I see the issue found in the ProcedurePlan code (line 394). > 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 > > 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)

8 years, 10 months

1
0
0 / 0

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

by Van Halbert (JIRA)

Van Halbert created TEIID-4022: ---------------------------------- Summary: 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 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)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4017) EXECUTE IMMEDIATE in anonymous procedure ignores permissions

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4017?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4017: ------------------------------------------------ jolee(a)redhat.com changed the Status of [bug 1314864|https://bugzilla.redhat.com/show_bug.cgi?id=1314864] from NEW to ASSIGNED > EXECUTE IMMEDIATE in anonymous procedure ignores permissions > ------------------------------------------------------------ > > Key: TEIID-4017 > URL: https://issues.jboss.org/browse/TEIID-4017 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.12 > Environment: teiid-8.12-Beta1 on Red Hat JBoss Enterprise Application Platform - Version 6.3.0.GA > Reporter: dalex dalex > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 9.0, 8.12.5, 8.13.2 > > > I've found a bug when executing a query in the EXECUTE IMMEDIATE clause. It ignores permissions. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4017) EXECUTE IMMEDIATE in anonymous procedure ignores permissions

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4017?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4017: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1314863, https://bugzilla.redhat.com/show_bug.cgi?id=1314864 (was: https://bugzilla.redhat.com/show_bug.cgi?id=1314863) > EXECUTE IMMEDIATE in anonymous procedure ignores permissions > ------------------------------------------------------------ > > Key: TEIID-4017 > URL: https://issues.jboss.org/browse/TEIID-4017 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.12 > Environment: teiid-8.12-Beta1 on Red Hat JBoss Enterprise Application Platform - Version 6.3.0.GA > Reporter: dalex dalex > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 9.0, 8.12.5, 8.13.2 > > > I've found a bug when executing a query in the EXECUTE IMMEDIATE clause. It ignores permissions. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4017) EXECUTE IMMEDIATE in anonymous procedure ignores permissions

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4017?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4017: ------------------------------------------------ jolee(a)redhat.com changed the Status of [bug 1314863|https://bugzilla.redhat.com/show_bug.cgi?id=1314863] from NEW to ASSIGNED > EXECUTE IMMEDIATE in anonymous procedure ignores permissions > ------------------------------------------------------------ > > Key: TEIID-4017 > URL: https://issues.jboss.org/browse/TEIID-4017 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.12 > Environment: teiid-8.12-Beta1 on Red Hat JBoss Enterprise Application Platform - Version 6.3.0.GA > Reporter: dalex dalex > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 9.0, 8.12.5, 8.13.2 > > > I've found a bug when executing a query in the EXECUTE IMMEDIATE clause. It ignores permissions. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4017) EXECUTE IMMEDIATE in anonymous procedure ignores permissions

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4017?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4017: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1314863 Bugzilla Update: Perform > EXECUTE IMMEDIATE in anonymous procedure ignores permissions > ------------------------------------------------------------ > > Key: TEIID-4017 > URL: https://issues.jboss.org/browse/TEIID-4017 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.12 > Environment: teiid-8.12-Beta1 on Red Hat JBoss Enterprise Application Platform - Version 6.3.0.GA > Reporter: dalex dalex > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 9.0, 8.12.5, 8.13.2 > > > I've found a bug when executing a query in the EXECUTE IMMEDIATE clause. It ignores permissions. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4020) Add xquery to message when it is invalid

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4020?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4020. ----------------------------------- Resolution: Done Added the xquery to the message. > Add xquery to message when it is invalid > ---------------------------------------- > > Key: TEIID-4020 > URL: https://issues.jboss.org/browse/TEIID-4020 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.0 > > > Teiid TEIID30154 conveys the saxon exception, but not the xquery value that causes the issue. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4017) EXECUTE IMMEDIATE in anonymous procedure ignores permissions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4017?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4017. ----------------------------------- Fix Version/s: 9.0 8.12.5 8.13.2 Resolution: Done Updated the validation logic to also be run when dynamic sql is used from a user submitted anonymous procedure block. > EXECUTE IMMEDIATE in anonymous procedure ignores permissions > ------------------------------------------------------------ > > Key: TEIID-4017 > URL: https://issues.jboss.org/browse/TEIID-4017 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.12 > Environment: teiid-8.12-Beta1 on Red Hat JBoss Enterprise Application Platform - Version 6.3.0.GA > Reporter: dalex dalex > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 9.0, 8.12.5, 8.13.2 > > > I've found a bug when executing a query in the EXECUTE IMMEDIATE clause. It ignores permissions. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4021) MSSQL Pagination

by Mark Tawk (JIRA)

Mark Tawk created TEIID-4021: -------------------------------- Summary: MSSQL Pagination Key: TEIID-4021 URL: https://issues.jboss.org/browse/TEIID-4021 Project: Teiid Issue Type: Enhancement Reporter: Mark Tawk Assignee: Steven Hawkins I'm using Teiid 8.11.3 with mssql translator. I have a huge table over sql server 2008 on which i'm applying pagination. I noticed slowliness in the query execution over this table at each time I increase the pagination. I monitored the JDBC queries execute by teiid and found out that it is using top n according to the limit used into the query. For example: in teiid : Select * from mytable LIMIT 90 , 10 is translated in JDBC: select top 100 from mytable Since my table contains millions of records, when fetching the last page, the executed jdbc query is retrieving the whole table top n, to return in result the last 10 records. And the execution is taking too much time. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4020) Add xquery to message when it is invalid

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4020: ------------------------------------- Summary: Add xquery to message when it is invalid Key: TEIID-4020 URL: https://issues.jboss.org/browse/TEIID-4020 Project: Teiid Issue Type: Quality Risk Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 9.0 Teiid TEIID30154 conveys the saxon exception, but not the xquery value that causes the issue. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 10 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues March 2016