October 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4423) UPDATE command with non-pushdown functions leads to TEIID30253 error

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4423?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4423: ---------------------------------- Fix Version/s: 9.1 Assigning to 9.1 to resolve the inconsistent handling for the final release. Since it allows more optimization and is consistent with postgresql/oracle, we'll treat uncorrelated subqueries as deterministic. Note that this behavior is inconsistent with h2/mysql (which can treat uncorrelated subqueries as deterministic) - but I don't think that warrants additional handling yet. > UPDATE command with non-pushdown functions leads to TEIID30253 error > -------------------------------------------------------------------- > > Key: TEIID-4423 > URL: https://issues.jboss.org/browse/TEIID-4423 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.12.x > Environment: teiid-8.12-Beta1 on Red Hat JBoss Enterprise Application Platform - Version 6.3.0.GA > teiid-9.0.3 on WildFly Full 9.0.2.Final > Reporter: dalex dalex > Assignee: Steven Hawkins > Fix For: 9.1 > > > Running the following queries: > {code:sql} > update test.textagg_test_2 set id =(select uuid());; > {code} > or > {code:sql} > update test.textagg_test_2 set id =(select rand());; > {code} > leads to the following errors: > {code} > TEIID30253 Source UPDATE or DELETE command "UPDATE test.textagg_test_2 SET id = (SELECT uuid() LIMIT 2)" contains non-pushdown constructs and no compensating action can be taken as the table lacks a unique key or the source does not support equality predicates. > {code} > and > {code} > TEIID30253 Source UPDATE or DELETE command "UPDATE test.textagg_test_2 SET id = convert((SELECT rand() LIMIT 2), string)" contains non-pushdown constructs and no compensating action can be taken as the table lacks a unique key or the source does not support equality predicates. > {code} > though the following query: > {code:sql} > update test.textagg_test_2 set id =(select now());; > {code} > works without errors. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4492) When using annotations, add option that specifies all child classes to register as part of the JDG schema

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4492?page=com.atlassian.jira.plugin... ] Van Halbert updated TEIID-4492: ------------------------------- Git Pull Request: https://github.com/teiid/teiid/pull/806, https://github.com/teiid/teiid-documents/pull/71 > When using annotations, add option that specifies all child classes to register as part of the JDG schema > --------------------------------------------------------------------------------------------------------- > > Key: TEIID-4492 > URL: https://issues.jboss.org/browse/TEIID-4492 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 9.2 > Reporter: Van Halbert > Assignee: Van Halbert > > When using protobuf annotations, need to specify all the child related (e.g, 1-to-1 relationship or 1-to-many relationship) pojo's that also need to be registered with the JDG schema. When these are registered, JDG will auto generate the .proto file and marshallers used by the schema. Which is the information used by the hot rod translator to create the source models. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4492) When using annotations, add option that specifies all child classes to register as part of the JDG schema

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-4492?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-4492: ------------------------------------ Adding property ChildClasses ChildClasses - className[,className,..] contains a comma separated list of class names that indicate the child classes to register in the JDG schema > When using annotations, add option that specifies all child classes to register as part of the JDG schema > --------------------------------------------------------------------------------------------------------- > > Key: TEIID-4492 > URL: https://issues.jboss.org/browse/TEIID-4492 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 9.2 > Reporter: Van Halbert > Assignee: Van Halbert > > When using protobuf annotations, need to specify all the child related (e.g, 1-to-1 relationship or 1-to-many relationship) pojo's that also need to be registered with the JDG schema. When these are registered, JDG will auto generate the .proto file and marshallers used by the schema. Which is the information used by the hot rod translator to create the source models. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4323) Add support for first/last/absolute/relative "FETCH " syntax

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4323?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4323: ------------------------------------------------ Jan Stastny <jstastny(a)redhat.com> changed the Status of [bug 1353933|https://bugzilla.redhat.com/show_bug.cgi?id=1353933] from ON_QA to VERIFIED > Add support for first/last/absolute/relative "FETCH " syntax > ------------------------------------------------------------ > > Key: TEIID-4323 > URL: https://issues.jboss.org/browse/TEIID-4323 > Project: Teiid > Issue Type: Feature Request > Components: ODBC > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 9.1, 8.7.8.6_2, 8.12.6.6_3 > > > Add Support for the below FETCH syntax: > FETCH LAST FROM cursor_name > FETCH ABSOLUTE fetch_when FROM cursor_name > FETCH RELATIVE fetch_when FROM cursor_name > FETCH FIRST FROM cursor_name -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4329) Using JDG annotations, unable to provide package name qualification for serialization

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4329?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4329. --------------------------------- > Using JDG annotations, unable to provide package name qualification for serialization > ------------------------------------------------------------------------------------- > > Key: TEIID-4329 > URL: https://issues.jboss.org/browse/TEIID-4329 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 9.x, 8.12.5 > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 9.1, 8.12.6.6_3 > > > When using the JDG annotations as the means of configuring the cache and serialization, its not specifying the package name qualifier. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4494) Differentiate requests pending close

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4494?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4494. ----------------------------------- Resolution: Done Allowed the requestClose method to transition directly to close, updated the reporting of the state, and corrected the synchronization around state. > Differentiate requests pending close > ------------------------------------ > > Key: TEIID-4494 > URL: https://issues.jboss.org/browse/TEIID-4494 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1, 9.0.5 > > > TestODBCSocketTransport.testImplicitPortalClosing will fail sometimes due to the asynch handling of close. But we should be able to differentiate requests that are pending close. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4396) Missing images in the Admin section of the documentation

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4396?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4396. ----------------------------------- Fix Version/s: 9.1 Resolution: Done Added missing images for the 9.1 release docs. > Missing images in the Admin section of the documentation > -------------------------------------------------------- > > Key: TEIID-4396 > URL: https://issues.jboss.org/browse/TEIID-4396 > Project: Teiid > Issue Type: Bug > Components: Documentation > Affects Versions: 9.0.2 > Reporter: Patrick McElreavy > Assignee: Steven Hawkins > Priority: Minor > Fix For: 9.1 > > > Section "Profile View" links to image "images/author/download/attachments/18646076/webconsole2.png" > Section "Runtime View" links to image "images/author/download/attachments/18646076/webconsole1.png" > Both these images are missing. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4494) Differentiate requests pending close

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4494: ------------------------------------- Summary: Differentiate requests pending close Key: TEIID-4494 URL: https://issues.jboss.org/browse/TEIID-4494 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.7 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 9.1, 9.0.5 TestODBCSocketTransport.testImplicitPortalClosing will fail sometimes due to the asynch handling of close. But we should be able to differentiate requests that are pending close. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4493) Add support for integration with qgis

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4493: ------------------------------------- Summary: Add support for integration with qgis Key: TEIID-4493 URL: https://issues.jboss.org/browse/TEIID-4493 Project: Teiid Issue Type: Enhancement Components: Documentation, Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 9.2 Similar to our support for GeoServer, we should support qgis integration if possible. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4491) Refine uniqueidentifier support for SQL Server

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4491?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4491: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1381566, https://bugzilla.redhat.com/show_bug.cgi?id=1381568 Bugzilla Update: Perform > Refine uniqueidentifier support for SQL Server > ---------------------------------------------- > > Key: TEIID-4491 > URL: https://issues.jboss.org/browse/TEIID-4491 > Project: Teiid > Issue Type: Quality Risk > Components: JDBC Connector > Affects Versions: 7.0 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1 > > > SQL Servers later than 2000 can treat uniqueidentifier as a comparable type - there is no need to always cast. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 6 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2016