December 2013 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2695) Unable to use CASE statement in Select

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2695?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2695. --------------------------------- > Unable to use CASE statement in Select > -------------------------------------- > > Key: TEIID-2695 > URL: https://issues.jboss.org/browse/TEIID-2695 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.4.1 > Reporter: Van Halbert > Assignee: Steven Hawkins > Attachments: portfolio-vdb.xml > > > Trying to add a <mask> of: > <permission> > <resource-name>Stocks.StockPrices.Price</resource-name> > <mask>CASE WHEN hasRole('prices') THEN Price END</mask> > </permission> > even tried using "= true" just to see > but it it always returns null for Prices. > To test it, I logged in as 'user' using CommandLog vdb and issued: > Select VDB, CASE WHEN hasRole('prices') THEN 'Y' Else 'N' END as V from TEIID_COMMANDLOG > and 'N' was always returned for column V. > teiid roles file: > # A roles.properties file for use with the UsersRolesLoginModule > # username=role1,role2 > portfolio=superuser > viewonly=readonly > user=user,prices -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2189) Can the behaviour of the || operator to use concat2 to mirror the oracle functionality be made configurable

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2189?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2189. --------------------------------- > Can the behaviour of the || operator to use concat2 to mirror the oracle functionality be made configurable > ----------------------------------------------------------------------------------------------------------- > > Key: TEIID-2189 > URL: https://issues.jboss.org/browse/TEIID-2189 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Connector, Server > Affects Versions: 7.4.4 > Reporter: Van Halbert > Assignee: Steven Hawkins > Priority: Minor > > Is it possible to make configurable the ability to switch the behaviour of the || operator to use concat2 in order to mirror the oracle functionality. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2749) Dead links on About Teiid page

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2749?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2749. --------------------------------- > Dead links on About Teiid page > ------------------------------ > > Key: TEIID-2749 > URL: https://issues.jboss.org/browse/TEIID-2749 > Project: Teiid > Issue Type: Bug > Components: Documentation > Reporter: Radim Hopp > Assignee: Steven Hawkins > > Many links on About Teiid page (http://www.jboss.org/teiid/about.html) are dead. Mainly in Teiid Components section. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2605) Optimization substitutes wrong column in where clause

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2605?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2605. --------------------------------- > Optimization substitutes wrong column in where clause > ----------------------------------------------------- > > Key: TEIID-2605 > URL: https://issues.jboss.org/browse/TEIID-2605 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.1 > Environment: z/OS > Reporter: Jeff Hayes > Assignee: Steven Hawkins > Attachments: query_plan.txt, views.xml > > > Optimization results in a query with a different column in the WHERE clause producing an empty result set. > Full query plan is attached but the beginning and ending queries are shown below. Note that the subject column of the IN clause is SCOPEID but optimization changes it to AUTHID for some reason. > USER COMMAND: > SELECT * FROM SECURITY.SCPXREF AS CHORUS_B WHERE (CHORUS_B.SYSID = 'DE29') AND ((CHORUS_B.SCOPEID IN (SELECT SN5.SCOPEID FROM SECURI > TY.SCPNEXT AS SN5 WHERE (SYSID = 'DE29') AND (NEXTREC IN (SELECT SN4.SCOPEID FROM SECURITY.SCPNEXT AS SN4 WHERE (SYSID = 'DE29') AND > (NEXTREC IN (SELECT SN3.SCOPEID FROM SECURITY.SCPNEXT AS SN3 WHERE (SYSID = 'DE29') AND (NEXTREC IN (SELECT SN2.SCOPEID FROM SECURI > TY.SCPNEXT AS SN2 WHERE (SYSID = 'DE29') AND (NEXTREC = 'CHRDEPT1'))))))))) OR (CHORUS_B.SCOPEID IN (SELECT SN4.SCOPEID FROM SECURIT > Y.SCPNEXT AS SN4 WHERE (SYSID = 'DE29') AND (NEXTREC IN (SELECT SN3.SCOPEID FROM SECURITY.SCPNEXT AS SN3 WHERE (SYSID = 'DE29') AND > (NEXTREC IN (SELECT SN2.SCOPEID FROM SECURITY.SCPNEXT AS SN2 WHERE (SYSID = 'DE29') AND (NEXTREC = 'CHRDEPT1'))))))) OR (CHORUS_B.SC > OPEID IN (SELECT SN3.SCOPEID FROM SECURITY.SCPNEXT AS SN3 WHERE (SYSID = 'DE29') AND (NEXTREC IN (SELECT SN2.SCOPEID FROM SECURITY.S > CPNEXT AS SN2 WHERE (SYSID = 'DE29') AND (NEXTREC = 'CHRDEPT1'))))) OR (CHORUS_B.SCOPEID IN (SELECT SN2.SCOPEID FROM SECURITY.SCPNEX > T AS SN2 WHERE (SYSID = 'DE29') AND (NEXTREC = 'CHRDEPT1'))) OR (CHORUS_B.SCOPEID = 'CHRDEPT1')) > OPTIMIZATION COMPLETE: > PROCESSOR PLAN: > AccessNode(10) output=[x.sysid AS sysid, x.scopeid AS authid, x.authid AS scopeid, x.authtype AS authtype] SELECT g_0.SYSID, g_0.SCO > PEID, g_0.AUTHID, g_0.AUTHTYPE FROM SECURITY_CIA_DB2_D91BPTIB_CIADB01.SCPXREF AS g_0 WHERE (g_0.SYSID = 'DE29') AND ((g_0.AUTHID IN > (SELECT g_1.SCOPEID FROM SECURITY_CIA_DB2_D91BPTIB_CIADB01.SCPNEXT AS g_1 WHERE (g_1.SYSID = 'DE29') AND (g_1.NEXTREC IN (SELECT g_2 > .SCOPEID FROM SECURITY_CIA_DB2_D91BPTIB_CIADB01.SCPNEXT AS g_2 WHERE (g_2.SYSID = 'DE29') AND (g_2.NEXTREC IN (SELECT g_3.SCOPEID FR > OM SECURITY_CIA_DB2_D91BPTIB_CIADB01.SCPNEXT AS g_3 WHERE (g_3.SYSID = 'DE29') AND (g_3.NEXTREC IN (SELECT g_4.SCOPEID FROM SECURITY > _CIA_DB2_D91BPTIB_CIADB01.SCPNEXT AS g_4 WHERE (g_4.SYSID = 'DE29') AND (g_4.NEXTREC = 'CHRDEPT1'))))))))) OR (g_0.AUTHID IN (SELECT > g_5.SCOPEID FROM SECURITY_CIA_DB2_D91BPTIB_CIADB01.SCPNEXT AS g_5 WHERE (g_5.SYSID = 'DE29') AND (g_5.NEXTREC IN (SELECT g_6.SCOPEI > D FROM SECURITY_CIA_DB2_D91BPTIB_CIADB01.SCPNEXT AS g_6 WHERE (g_6.SYSID = 'DE29') AND (g_6.NEXTREC IN (SELECT g_7.SCOPEID FROM SECU > RITY_CIA_DB2_D91BPTIB_CIADB01.SCPNEXT AS g_7 WHERE (g_7.SYSID = 'DE29') AND (g_7.NEXTREC = 'CHRDEPT1'))))))) OR (g_0.AUTHID IN (SELE > CT g_8.SCOPEID FROM SECURITY_CIA_DB2_D91BPTIB_CIADB01.SCPNEXT AS g_8 WHERE (g_8.SYSID = 'DE29') AND (g_8.NEXTREC IN (SELECT g_9.SCOP > EID FROM SECURITY_CIA_DB2_D91BPTIB_CIADB01.SCPNEXT AS g_9 WHERE (g_9.SYSID = 'DE29') AND (g_9.NEXTREC = 'CHRDEPT1'))))) OR (g_0.AUTH > ID IN (SELECT g_10.SCOPEID FROM SECURITY_CIA_DB2_D91BPTIB_CIADB01.SCPNEXT AS g_10 WHERE (g_10.SYSID = 'DE29') AND (g_10.NEXTREC = 'C > HRDEPT1'))) OR (g_0.AUTHID = 'CHRDEPT1')) > The view definitions are shown below: > <view name="SCPNEXT"> > <columns> > <column name="sysid" type="varchar"/> > <column name="scopeid" type="varchar"/> > <column name="nextrec" type="varchar"/> > </columns> > <definition> > #if ($db.count("select count(*) from sys.tables where Name='config' and SchemaName = 'security_db'") > 0) > #set ($count = 0) > #foreach($t in $db.query("select DB_TYPE, DB_LOC, DB_QUAL from security_db.config WHERE TYPE = 'CIA'")) > #if ($db.count("select count(*) from sys.tables where SchemaName = 'SECURITY_CIA_${t.DB_TYPE}_${t.DB_LOC}_${t.DB_QUAL}'") == 0) > #set ($count = $count + 1) > #end > #end > #if ($count == 0) > SELECT t.sysid, t.scopeid, t.nextrec > FROM ( > #foreach($t in $db.query("select DB_TYPE, DB_LOC, DB_QUAL from security_db.config WHERE TYPE = 'CIA'")) > SELECT n.sysid, n.scopeid, n.nextrec > FROM SECURITY_CIA_${t.DB_TYPE}_${t.DB_LOC}_${t.DB_QUAL}.SCPNEXT n > #if( $velocityHasNext ) UNION #end > #end > ) AS t > #end > #end > </definition> > </view> > <view name="SCPXREF"> > <columns> > <column name="sysid" type="varchar"/> > <column name="authid" type="varchar"/> > <column name="scopeid" type="varchar"/> > <column name="authtype" type="varchar"/> > </columns> > <definition> > #if ($db.count("select count(*) from sys.tables where Name='config' and SchemaName = 'security_db'") > 0) > #set ($count = 0) > #foreach($t in $db.query("select DB_TYPE, DB_LOC, DB_QUAL from security_db.config WHERE TYPE = 'CIA'")) > #if ($db.count("select count(*) from sys.tables where SchemaName = 'SECURITY_CIA_${t.DB_TYPE}_${t.DB_LOC}_${t.DB_QUAL}'") == 0) > #set ($count = $count + 1) > #end > #end > #if ($count == 0) > SELECT sysid, scopeid, authid, authtype > FROM ( > #foreach($t in $db.query("select DB_TYPE, DB_LOC, DB_QUAL from security_db.config WHERE TYPE = 'CIA'")) > SELECT x.sysid, x.scopeid, x.authid, x.authtype > FROM SECURITY_CIA_${t.DB_TYPE}_${t.DB_LOC}_${t.DB_QUAL}.SCPXREF x > #if( $velocityHasNext ) UNION #end > #end > ) AS t > #end > #end > </definition> > </view> > I guess the best way to test this is to define these views and run the input query with SHOWPLAN=DEBUG and see if the AUTHID substitution is occurring. > Thanks! -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2649) NoClassDefFoundError when trying to run adminshell

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2649?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2649. --------------------------------- > NoClassDefFoundError when trying to run adminshell > -------------------------------------------------- > > Key: TEIID-2649 > URL: https://issues.jboss.org/browse/TEIID-2649 > Project: Teiid > Issue Type: Bug > Components: Tools > Affects Versions: 8.4.1 > Reporter: Van Halbert > Assignee: Steven Hawkins > Priority: Blocker > > adminshell is throwing the following exception when trying to be run: > Exception in thread "main" java.lang.NoClassDefFoundError: jline/History > at java.lang.Class.getDeclaredMethods0(Native Method) > at java.lang.Class.privateGetDeclaredMethods(Class.java:2521) > at java.lang.Class.getDeclaredMethods(Class.java:1845) > at org.codehaus.groovy.reflection.CachedClass$3$1.run(CachedClass.java:83) > at java.security.AccessController.doPrivileged(Native Method) > at org.codehaus.groovy.reflection.CachedClass$3.initValue(CachedClass.java:80) > at org.codehaus.groovy.reflection.CachedClass$3.initValue(CachedClass.java:78) > at org.codehaus.groovy.util.LazyReference.getLocked(LazyReference.java:46) > at org.codehaus.groovy.util.LazyReference.get(LazyReference.java:33) > at org.codehaus.groovy.reflection.CachedClass.getMethods(CachedClass.java:249) > at groovy.lang.MetaClassImpl.populateMethods(MetaClassImpl.java:341) > at groovy.lang.MetaClassImpl.fillMethodIndeMetaClassImpl.java:291) > at groovy.lang.MetaClassImpl.initialize(MetaClassImpl.java:2912) > at org.codehaus.groovy.reflection.ClassInfo.getMetaClassUnderLock(ClassInfo.java:166) > at org.codehaus.groovy.reflection.ClassInfo.getMetaClass(ClassInfo.java:182) > at org.codehaus.groovy.runtime.metaclass.MetaClassRegistryImpl.getMetaClass(MetaClassRegistryImpl.java:210) > at org.codehaus.groovy.runtime.InvokerHelper.getMetaClass(InvokerHelper.java:701) > at org.codehaus.groovy.runtime.callsite.CallSiteArray.createCallConstructorSite(CallSiteArray.java:69) > at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallConstructor(CallSiteArray.java:52) > at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor(AbstractCallSite.java:192) > at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor(AbstractCallSite.java:200) > at org.codehaus.groovy.tools.shell.Main.main(Main.groovy:124) > at org.teiid.adminshell.GroovyAdminShell.main(GroovyAdminShell.java:30) > Caused by: java.lang.ClassNotFoundException: jline.History > at java.net.URLClassLoader$1.run(URLClassLoader.java:366) > at java.net.URLClassLoader$1.run(URLClassLoader.java:355) > at java.security.AccessController.doPrivileged(Native Method) > at java.net.URLClassLoader.findClass(URLClassLoader.java:354) > at java.lang.ClassLoader.loadClass(ClassLoader.java:424) > at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) > at java.lang.ClassLoader.loadClass(ClassLoader.java:357) > ... 23 more -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2705) Remove from standalone.cli and domain.cli, the adding of the resource adapters

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2705?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2705. --------------------------------- > Remove from standalone.cli and domain.cli, the adding of the resource adapters > ------------------------------------------------------------------------------ > > Key: TEIID-2705 > URL: https://issues.jboss.org/browse/TEIID-2705 > Project: Teiid > Issue Type: Enhancement > Components: Build/Kits > Affects Versions: 8.4.1 > Reporter: Van Halbert > Assignee: Van Halbert > > Remove the adding of the resource adapters in the cli configuration scripts. This is because: > 1. They don't define a specific instance > 2. When multiple instances are added, they each should have a different name, so that one can be removed without removing the other. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2480) Unable to execute the domain cli script due bug in AS 7

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2480?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2480. --------------------------------- > Unable to execute the domain cli script due bug in AS 7 > ------------------------------------------------------- > > Key: TEIID-2480 > URL: https://issues.jboss.org/browse/TEIID-2480 > Project: Teiid > Issue Type: Bug > Components: Build/Kits > Affects Versions: 8.4 > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 8.4 > > > I'm using EAP 6.1 ER5, and trying to execute the following using CLI: > /profile=ha/subsystem=security/security-domain=teiid-security:add(cache-type=default) > /profile=ha/subsystem=security/security-domain=teiid-security/authentication=classic/:add(login-modules=[{"code"=>"org.jboss.security.auth.spi.UsersRolesLoginModule", "flag"=>"required", "module-options"=>[("usersProperties"=>"$ > {jboss.domain.config.dir}/teiid-security-users.properties"), ("rolesProperties"=>"${jboss.domain.config.dir} > /teiid-security-roles.properties")]}]) > but I get the message: > … > "failure-description" => "JBAS014884: No operation named 'composite' exists at address [ > … > The resolution is the workaround. However, this workaround needs to be applied to the script to make it work. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2207) RHQ Plugin gets NPE when getting requests for a VDB

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2207?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2207. --------------------------------- > RHQ Plugin gets NPE when getting requests for a VDB > --------------------------------------------------- > > Key: TEIID-2207 > URL: https://issues.jboss.org/browse/TEIID-2207 > Project: Teiid > Issue Type: Bug > Affects Versions: 7.7.1 > Environment: SOA-P 5.3 with BZ842760 (9/13) patch applied > Reporter: Paul Nittel > Assignee: Johnathon Lee > Fix For: 8.0 > > Attachments: server.log > > > Using RHQ while a long query was executing, I used the VDB's "View VDB Requests" and received no information in the UI. The server log contained the attached exception and stack trace. > java.lang.reflect.UndeclaredThrowableException: Failed to invoke method 'getRequestsUsingVDB' on component 'RuntimeEngineDeployer' with parameters [SimpleMetaType:java.lang.String:TpcrVdb, SimpleMetaType:int:1]. > at org.jboss.profileservice.management.KernelBusRuntimeComponentDispatcher.invoke(KernelBusRuntimeComponentDispatcher.java:201) > at org.jboss.profileservice.management.DelegatingComponentDispatcherImpl.invoke(DelegatingComponentDispatcherImpl.java:103) > at sun.reflect.GeneratedMethodAccessor661.invoke(Unknown Source) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:616) > at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:121) -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2538) Validate Apache Hive 0.11 version of Driver

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2538?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2538. --------------------------------- > Validate Apache Hive 0.11 version of Driver > ------------------------------------------- > > Key: TEIID-2538 > URL: https://issues.jboss.org/browse/TEIID-2538 > Project: Teiid > Issue Type: Task > Components: Misc. Connectors > Reporter: Ramesh Reddy > Assignee: Filip Nguyen > Fix For: 8.4.1 > > > There are report that the metadata does not load properly when used with Apache Hive 0.11 version of the JDBC driver. This needs to be validated and make any changes that are required. > Test with Hive driver that comes with the Hortonworks Sandbox distro -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-2541) Quick starts fail due to .rar deployments cause a server failure

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2541?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2541. --------------------------------- > Quick starts fail due to .rar deployments cause a server failure > ---------------------------------------------------------------- > > Key: TEIID-2541 > URL: https://issues.jboss.org/browse/TEIID-2541 > Project: Teiid > Issue Type: Bug > Components: Quick Starts > Affects Versions: 8.4 > Reporter: Van Halbert > Assignee: Van Halbert > > Teiid made adjustments to how EAP 6 wants .rar deployed and it also impacted how they were configured. Because of this, the quick starts fail because the configuration is applied incorrectly. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 1 month

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues December 2013