January 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2133) Handle enterprise/UD types in metadata

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2133?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2133: --------------------------------------- This is now represented by TEIID-3624 > Handle enterprise/UD types in metadata > -------------------------------------- > > Key: TEIID-2133 > URL: https://issues.jboss.org/browse/TEIID-2133 > Project: Teiid > Issue Type: Sub-task > Components: Query Engine > Affects Versions: 8.1 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.1 > > > The ddl parsing/export logic handles runtime and built-in types, but enterprise types (from designer vdbs, typically used with xml document models) are not supported. > We may have to wait on implementing this until we make the type system more extensible in general. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4673) Translator import of google spreadsheet not updatable

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4673?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4673. ----------------------------------- Resolution: Done Updated the import to mark the columns updatable as well. > Translator import of google spreadsheet not updatable > ----------------------------------------------------- > > Key: TEIID-4673 > URL: https://issues.jboss.org/browse/TEIID-4673 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1.2, 9.2 > > > Only the table and not the columns of the spreadsheet were marked as updatable. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4673) Translator import of google spreadsheet not updatable

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4673?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4673: ---------------------------------- Summary: Translator import of google spreadsheet not updatable (was: Embedded import of google spreadsheet not updatable) > Translator import of google spreadsheet not updatable > ----------------------------------------------------- > > Key: TEIID-4673 > URL: https://issues.jboss.org/browse/TEIID-4673 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1.2, 9.2 > > > Only the table and not the columns of the spreadsheet were marked as updatable. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4673) Embedded import of spreadsheet not updatable

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4673: ------------------------------------- Summary: Embedded import of spreadsheet not updatable Key: TEIID-4673 URL: https://issues.jboss.org/browse/TEIID-4673 Project: Teiid Issue Type: Bug Components: Misc. Connectors Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 9.1.2, 9.2 Only the table and not the columns of the spreadsheet were marked as updatable. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4673) Embedded import of google spreadsheet not updatable

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4673?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4673: ---------------------------------- Summary: Embedded import of google spreadsheet not updatable (was: Embedded import of spreadsheet not updatable) > Embedded import of google spreadsheet not updatable > --------------------------------------------------- > > Key: TEIID-4673 > URL: https://issues.jboss.org/browse/TEIID-4673 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1.2, 9.2 > > > Only the table and not the columns of the spreadsheet were marked as updatable. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4666) Google translator throws SpreadsheetOperationException for query DELETE FROM table

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4666?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4666. ----------------------------------- Resolution: Done Updated the logic to recognize a null predicate for update/delete. > Google translator throws SpreadsheetOperationException for query DELETE FROM table > ---------------------------------------------------------------------------------- > > Key: TEIID-4666 > URL: https://issues.jboss.org/browse/TEIID-4666 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.8.6_3 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > Fix For: 9.2 > > Attachments: googlespreadsheetcrud-vdb.xml, server.log, standalone.xml, teiid-4666.png > > > Query "DELETE FROM smalla" where smalla is table throws exception: > 07:06:52,219 ERROR [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue20) Connector worker process failed for atomic-request=IlMZP21M8Gwr.8.0.2: org.teiid.resource.adapter.google.common.SpreadsheetOperationException: Error getting spreadsheet feed. Possibly bad authentication or connection problems. com.google.gdata.util.InvalidEntryException: Bad Request > Invalid query parameter value for sq. > Please see server.log, standalone.xml and vdb for other information. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4672) Sheet with header becomes invalid

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4672: ------------------------------------- Summary: Sheet with header becomes invalid Key: TEIID-4672 URL: https://issues.jboss.org/browse/TEIID-4672 Project: Teiid Issue Type: Quality Risk Components: Misc. Connectors Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 9.3 With a delete, such as a delete all from TEIID-4666, that removes all data rows subsequent select/delete/update queries do not function correctly because google will now treat the header as a data row. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4666) Google translator throws SpreadsheetOperationException for query DELETE FROM table

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4666?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4666: ---------------------------------- Issue Type: Bug (was: Feature Request) Component/s: Misc. Connectors Fix Version/s: 9.2 > Google translator throws SpreadsheetOperationException for query DELETE FROM table > ---------------------------------------------------------------------------------- > > Key: TEIID-4666 > URL: https://issues.jboss.org/browse/TEIID-4666 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.8.6_3 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > Fix For: 9.2 > > Attachments: googlespreadsheetcrud-vdb.xml, server.log, standalone.xml, teiid-4666.png > > > Query "DELETE FROM smalla" where smalla is table throws exception: > 07:06:52,219 ERROR [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue20) Connector worker process failed for atomic-request=IlMZP21M8Gwr.8.0.2: org.teiid.resource.adapter.google.common.SpreadsheetOperationException: Error getting spreadsheet feed. Possibly bad authentication or connection problems. com.google.gdata.util.InvalidEntryException: Bad Request > Invalid query parameter value for sq. > Please see server.log, standalone.xml and vdb for other information. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4668) Google translator skips NULL value in INSERT

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4668?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4668. ----------------------------------- Resolution: Done Updated the logic to better handle nulls for update and insert. In the update case we can allow nulls except for string values as there seems to be no way to differentiate between an empty string - but there is a difference between null and empty when reading from a sheet so we'll produce an exception for now. > Google translator skips NULL value in INSERT > -------------------------------------------- > > Key: TEIID-4668 > URL: https://issues.jboss.org/browse/TEIID-4668 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.8.6_3 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 9.0.6, 9.1.2, 9.2 > > Attachments: google-crud.png, googlespreadsheetcrud-vdb.xml > > > I have google spreadsheet table smalla with defined header columns intkey, intnum and other (see attached screenshot). > Following query doesn't insert NULL value to column intnum: > INSERT INTO smalla(intnum, intkey) values (null, 562) > Instead, it inserts 562 to intnum and NULL to intkey. > (Server log shows no exception) > INSERT works correctly if none of the inserted values is NULL. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4668) Google translator skips NULL value in INSERT

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4668?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4668: ---------------------------------- Component/s: Misc. Connectors > Google translator skips NULL value in INSERT > -------------------------------------------- > > Key: TEIID-4668 > URL: https://issues.jboss.org/browse/TEIID-4668 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.8.6_3 > Reporter: Lucie Fabrikova > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 9.0.6, 9.1.2, 9.2 > > Attachments: google-crud.png, googlespreadsheetcrud-vdb.xml > > > I have google spreadsheet table smalla with defined header columns intkey, intnum and other (see attached screenshot). > Following query doesn't insert NULL value to column intnum: > INSERT INTO smalla(intnum, intkey) values (null, 562) > Instead, it inserts 562 to intnum and NULL to intkey. > (Server log shows no exception) > INSERT works correctly if none of the inserted values is NULL. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

8 years, 8 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues January 2017