July 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4245) Add support for fetch syntax "FETCH cursorname"

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4245?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4245: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1347841, https://bugzilla.redhat.com/show_bug.cgi?id=1353739 (was: https://bugzilla.redhat.com/show_bug.cgi?id=1347841) > Add support for fetch syntax "FETCH cursorname" > ----------------------------------------------- > > Key: TEIID-4245 > URL: https://issues.jboss.org/browse/TEIID-4245 > Project: Teiid > Issue Type: Feature Request > Components: ODBC > Reporter: Marc Shirley > Assignee: Steven Hawkins > Fix For: 9.1, 8.7.8.6_2 > > > Executing syntax "FETCH cursorname" results in parsing error like [1]. Instead, syntax like "FETCH 1 IN cursorname" has been used as a workaround. > [1] > org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "[*]FETCH[*] mycursor" at line 1, column 1. > Was expecting: "alter" | "begin" | "call" | "create" | "delete" | "drop" | "exec" | "execute" | "insert" | "merge" ... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4238) Remove need for quotes around cursor name declarations/fetches

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4238?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4238: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1347847, https://bugzilla.redhat.com/show_bug.cgi?id=1353737 (was: https://bugzilla.redhat.com/show_bug.cgi?id=1347847) > Remove need for quotes around cursor name declarations/fetches > -------------------------------------------------------------- > > Key: TEIID-4238 > URL: https://issues.jboss.org/browse/TEIID-4238 > Project: Teiid > Issue Type: Enhancement > Components: ODBC > Reporter: Marc Shirley > Assignee: Steven Hawkins > Fix For: 9.1, 8.7.8.6_2 > > > Attempting to declare a cursor without quotes results in an error similar to[1]. The quotes should be optional except in special cases, as this seems to match later standards (SQL2003). Performing fetch operations against the cursor have the same issue, where if the cursorname is not quoted, parsing errors occur. > [1] Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "[*]DECLARE[*] cursorname CURSOR" at line 1, column 1. > Was expecting: "alter" | "begin" | "call" | "create" | "delete" | "drop" | "exec" | "execute" | "insert" | "merge" ... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3834) Error during (re) adding connection factory using CLI

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3834?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3834: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1309067|https://bugzilla.redhat.com/show_bug.cgi?id=1309067] from CLOSED to ASSIGNED > Error during (re) adding connection factory using CLI > ----------------------------------------------------- > > Key: TEIID-3834 > URL: https://issues.jboss.org/browse/TEIID-3834 > Project: Teiid > Issue Type: Sub-task > Components: Server > Affects Versions: 8.13 > Reporter: Kylin Soong > Assignee: Ramesh Reddy > > enable datasource command > {code} > /subsystem=datasources/data-source=h2:enable > {code} > seems redundant, cause datasource add already enable it, so if execute setup.cli > {code} > ./bin/jboss-cli.sh --connect --file=setup.cli > {code} > will cause a eror > {code} > { > "outcome" => "failed", > "failure-description" => "WFLYCTL0158: Operation handler failed: org.jboss.msc.service.DuplicateServiceException: Service jboss.data-source-config.h2 is already registered", > "rolled-back" => true > } > 14:35:55,436 ERROR [org.jboss.as.controller.management-operation] (management-handler-thread - 9) WFLYCTL0013: Operation ("enable") failed - address: ([ > ("subsystem" => "datasources"), > ("data-source" => "h2") > ]): org.jboss.msc.service.DuplicateServiceException: Service jboss.data-source-config.h2 is already registered > at org.jboss.msc.service.ServiceRegistrationImpl.setInstance(ServiceRegistrationImpl.java:158) > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4304) Correct handling with subquery in on clause

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4304?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4304. ----------------------------------- Fix Version/s: 9.0.2 Resolution: Done Was partially resolved in 9.0.1 (for oracle if the pushdown query contained a with clause and a subquery in the on clause, there was an exception) but fully addressed in 9.0.2. > Correct handling with subquery in on clause > ------------------------------------------- > > Key: TEIID-4304 > URL: https://issues.jboss.org/browse/TEIID-4304 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1, 8.7.8.6_2, 9.0.2, 9.0.1 > > > With the translator capability supportsSubqueryInOn false, we can still plan a query with a subquery in the on clause if non-join criteria on the inner side of a left outer join is used in the user query on clause (it is temporarily pushed out of the join and then added back in rule collapse source). > Additionally the oracle translator should not support subquery in on for oracle 11 and earlier. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4322) Add embedded quickstart using sockets

by Van Halbert (JIRA)

Van Halbert created TEIID-4322: ---------------------------------- Summary: Add embedded quickstart using sockets Key: TEIID-4322 URL: https://issues.jboss.org/browse/TEIID-4322 Project: Teiid Issue Type: Task Components: Embedded, Quick Starts Affects Versions: 9.x Reporter: Van Halbert Assignee: Van Halbert Priority: Optional Add an embedded quick start that is using the socket feature. Have the following parameter options: - set the host and port - which protocol to use I would suggest duplicating the embedded-portfolio example. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4291) Object translator does not take into account folders where determining table name

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4291?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4291: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1349159|https://bugzilla.redhat.com/show_bug.cgi?id=1349159] from NEW to ASSIGNED > Object translator does not take into account folders where determining table name > --------------------------------------------------------------------------------- > > Key: TEIID-4291 > URL: https://issues.jboss.org/browse/TEIID-4291 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.x, 9.2 > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 9.1 > > > When obtaining the table name and using it to match the registered class (configured in RA), the logic doesn't take into account when folders are used. The name is returned like: folder[.folder].tableName > Nee to change logic to strip folder(s) to get the tableName. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4299) Object translator null values correctly

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4299?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4299: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1349159|https://bugzilla.redhat.com/show_bug.cgi?id=1349159] from NEW to ASSIGNED > Object translator null values correctly > --------------------------------------- > > Key: TEIID-4299 > URL: https://issues.jboss.org/browse/TEIID-4299 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 9.x, 8.12.5 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Critical > Fix For: 9.1 > > > The object translator wasn't handling the setting of null values when its tried to be set on a native attribute (i.e., long, int, boolean). -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4277) Infinispan Cache DSL translator: materialization incomplete results during view's loading

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4277?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4277: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1347582|https://bugzilla.redhat.com/show_bug.cgi?id=1347582] from NEW to ASSIGNED > Infinispan Cache DSL translator: materialization incomplete results during view's loading > ----------------------------------------------------------------------------------------- > > Key: TEIID-4277 > URL: https://issues.jboss.org/browse/TEIID-4277 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.5 > Reporter: Jan Stastny > Assignee: Van Halbert > Priority: Blocker > Attachments: test.log > > > When user tries to query materialized view in a moment when its loading is in progress, incomplete results are returned. The status of the view in corresponding status table is LOADING. > Vdb used: > {code:xml} > <?xml version="1.0" encoding="UTF-8"?> > <vdb name="jdg-remote" version="1"> > <description>For testing of materialized views</description> > <property name ="lib" value ="org.jboss.qe.jdg.pojos"></property> > <model name="jdgSource"> > <source name="jdgSource" translator-name="jdg-override" > connection-jndi-name="java:/jdg-mat-ds" /> > <metadata type="DDL"><![CDATA[ > CREATE FOREIGN TABLE CustomerReport( > customerId integer not null OPTIONS (SEARCHABLE 'Searchable', NATIVE_TYPE 'int'), > totalAmount integer, > CONSTRAINT PK_ID PRIMARY KEY(customerId) > ) OPTIONS (NAMEINSOURCE '${db.table.prefix}jdg-mat', UPDATABLE TRUE);]]> > </metadata> > </model> > <model name="h2Source"> > <source name="h2Source" translator-name="h2" connection-jndi-name="java:/h2-ds" /> > </model> > <model name="View" type="VIRTUAL"> > <metadata type="DDL"><![CDATA[ > CREATE VIEW external_long_ttl ( > customerId integer NOT NULL, > totalAmount integer > ) OPTIONS (MATERIALIZED 'TRUE', > MATERIALIZED_TABLE 'jdgSource.CustomerReport', > "teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'true', > "teiid_rel:MATVIEW_LOAD_SCRIPT" 'INSERT INTO jdgSource.CustomerReport(customerId,totalAmount) SELECT c.id AS customerId, CONVERT(SUM(o.amount),integer) AS totalAmount FROM DV_MATVIEWS_CUSTOMERS c INNER JOIN DV_MATVIEWS_ORDERS o ON c.id = o.customer_id GROUP BY c.id;', > "teiid_rel:MATVIEW_STATUS_TABLE" 'h2Source.DB.PUBLIC.DV_MATVIEWS_STATUSTABLE', > "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute jdgSource.native(''truncate cache'');', > "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute jdgSource.native(''swap cache names'');', > "teiid_rel:MATVIEW_ONERROR_ACTION" 'WAIT', > "teiid_rel:MATVIEW_TTL" 10000 > ) > AS SELECT c.id AS customerId, CONVERT(SUM(o.amount),integer) AS totalAmount FROM DV_MATVIEWS_CUSTOMERS c INNER JOIN DV_MATVIEWS_ORDERS o ON c.id = o.customer_id GROUP BY c.id; > ]]> > </metadata> > </model> > <translator name="jdg-override" type="infinispan-cache-dsl"> > <property name="SupportsDirectQueryProcedure" value="true" /> > </translator> > </vdb> > {code} > Resource-adapter used: > {code:xml} > <resource-adapter id="jdg-mat"> > <module slot="main" id="org.jboss.teiid.resource-adapter.infinispan.dsl"/> > <connection-definitions> > <connection-definition class-name="org.teiid.resource.adapter.infinispan.dsl.InfinispanManagedConnectionFactory" jndi-name="java:/jdg-mat-ds" enabled="true" pool-name="jdg-mat"> > <config-property name="ProtobufDefinitionFile"> > /org/jboss/qe/jdg/remote/protobuf/CustomerReport.proto > </config-property> > <config-property name="AliasCacheName"> > ${db.table.prefix}jdg-alias > </config-property> > <config-property name="MessageMarshallers"> > org.jboss.qe.jdg.pojo.CustomerReport:org.jboss.qe.jdg.remote.marshaller.CustomerReportMarshaller > </config-property> > <config-property name="RemoteServerList"> > [remote-server-address]:11322 > </config-property> > <config-property name="StagingCacheName"> > ${db.table.prefix}jdg-mat-stage > </config-property> > <config-property name="CacheTypeMap"> > ${db.table.prefix}jdg-mat:org.jboss.qe.jdg.pojo.CustomerReport;customerId > </config-property> > <config-property name="MessageDescriptor"> > org.jboss.qe.jdg.remote.protobuf.CustomerReport > </config-property> > <config-property name="Module"> > org.jboss.qe.jdg.pojos > </config-property> > </connection-definition> > </connection-definitions> > </resource-adapter> > {code} > Datasource used (tables that the view queries): > {code:xml} > <xa-datasource jndi-name="java:/h2-ds" pool-name="h2-xa-ds" enabled="true"> > <xa-datasource-property name="URL"> > jdbc:h2:tcp://localhost:9292/db;TRACE_LEVEL_FILE=4 > </xa-datasource-property> > <driver>h2</driver> > <security> > <user-name>sa</user-name> > </security> > </xa-datasource> > {code} > Query invoked to check current contents of materialized view: > {code:sql} > SELECT COUNT(*) FROM external_long_ttl; > {code} > And expected result is the same as count of DV_MATVIEWS_CUSTOMERS table from source h2Source. In my case 10. > But when I print out the result I get all numbers from 0 to 10 . See attached log output (search for 'check-count:') -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4090) Issue with entitysets/properties ending in auth or token

by Juraj Duráni (JIRA)

[ https://issues.jboss.org/browse/TEIID-4090?page=com.atlassian.jira.plugin... ] Juraj Duráni commented on TEIID-4090: ------------------------------------- [~rareddy] Just little comment to your comment \[1\]: > OData layer will not accept "static" named VDB It will accept VDB named "static". All you need is to add version of the VDB: http://localhost:8080/odata4/static.1/Model/tablea \[1\] https://issues.jboss.org/browse/TEIID-4090?focusedCommentId=13249942&page... > Issue with entitysets/properties ending in auth or token > -------------------------------------------------------- > > Key: TEIID-4090 > URL: https://issues.jboss.org/browse/TEIID-4090 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.12 > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Priority: Blocker > Labels: Final > Fix For: 9.0, 8.12.5 > > > To handle oauth, we are check for uri.endsWith("auth") || uri.endsWith("token") - however valid uris can end with those characters as well. An ioexception will be thrown instead of seeing the expected results - we also need to not simply throw an ioexception in ODataServlet as there is no server log of the exception and the client sees a 500 error. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2982) Allow to change visibility to a model from imported vdb

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2982?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-2982: ------------------------------------------------ Lucie Fabrikova <lfabriko(a)redhat.com> changed the Status of [bug 1098405|https://bugzilla.redhat.com/show_bug.cgi?id=1098405] from ON_QA to ASSIGNED > Allow to change visibility to a model from imported vdb > ------------------------------------------------------- > > Key: TEIID-2982 > URL: https://issues.jboss.org/browse/TEIID-2982 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 8.7 > Reporter: Kenichi Takemura > Assignee: Steven Hawkins > Fix For: 8.9 > > > When a new vdb uses import-vdb, changing(override) visibility to a model from imported vdb would need to hide non-related model to the new vdb. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues July 2016