December 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4045) OData throws unknown error if $select is applied to expanded entity

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4045?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4045. --------------------------------- > OData throws unknown error if $select is applied to expanded entity > ------------------------------------------------------------------- > > Key: TEIID-4045 > URL: https://issues.jboss.org/browse/TEIID-4045 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Fix For: 9.0, 8.12.5 > > > *URL:* http://localhost:8080/odata4/olingo_basic/Source/Customers/?$expand=Order... > *Result:* OData Library: An exception without message text was thrown. > *Status code:* 500 -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3994) AliasSymbol wrapping AliasSymbol error

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3994?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3994. --------------------------------- > AliasSymbol wrapping AliasSymbol error > -------------------------------------- > > Key: TEIID-3994 > URL: https://issues.jboss.org/browse/TEIID-3994 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.1.6_2 > Environment: Red Hat JBoss Data Virtualization 6.2 on EAP6.4.0 patched to version 6.4.3, > JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157 > 64-bit Windows 7 environment > Reporter: Steve Tran > Assignee: Steven Hawkins > Fix For: 9.0, 8.12.5, 8.13.2 > > Attachments: Oracle.PNG, SQLServer.PNG > > > I've defined a view and overrode the default triggers for Select, Insert, Update, and Delete. I overrode the triggers because the select is returning "hardcoded" values for a few fields (calling them virtual columns). The Update and Insert triggers will ignore these hardcoded values just in case the caller tries to update a virtual column. > I'm trying to run a insert into <tableA> select * from <tableB> query. When I run this, I get an error org.teiid.jdbc.TeiidSQLException: Cannot create AliasSymbol wrapping AliasSymbol. > Facts: > -- I can insert a record if I only select one column from tableB. > -- If I select two or more columns, it throws the error every time. > -- If I remove the overridden triggers, the insert into <tableA> select * from <tableB> works fine. > -- I can insert one or more columns into <tableA> when *not* using a insert into <tableA> select * from <tableB> query > -- Table A is Oracle > -- Table B is SQL Server > My hunch is the generated query (hibernate, or whatever SQL generator) is choking with the overridden trigger. Perhaps this use-case slipped through testing, or even more probable, I made a mistake in the trigger creation. > Here's a snip of the insert trigger, with a lot of fields removed for simplicity. > {code} > FOR EACH ROW > BEGIN ATOMIC > INSERT INTO <schema>.<tableA> (SourceSystemID, RecordTypeID, BatchID ...) > VALUES ( > convert("NEW".SourceSystemID, short), > convert("NEW".RecordTypeID, short), > convert("NEW".BatchID, integer) > ... > ) > END > {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4405) delete using in statement does not remove records from temporary table

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4405?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4405. --------------------------------- > delete using in statement does not remove records from temporary table > ---------------------------------------------------------------------- > > Key: TEIID-4405 > URL: https://issues.jboss.org/browse/TEIID-4405 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 9.0.2 > Reporter: Bram Gadeyne > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 9.1, 8.13.7, 9.0.4, 8.12.7.6_3 > > > Hi, > I have a temporary table called #tmp_cohort that was constructed using this create statement. > create local temporary table #tmp_cohort( > patientid integer not null, > age float not null, > sex string not null, > patgroup string not null, > admtime timestamp not null, > distime timestamp not null, > los long not null, > icuoutcome string, > hospoutcome string, > PRIMARY KEY(patientid) > ); > After filling it up it contains 12230 records. I only want to keep 10 records and remove the rest. > When I do the following select it does indeed return the 10 records I want to keep. > select * > from #tmp_cohort c > where c.patientid in (24123,55785,16667,53701,30763,59762,22679,46328,46453,55956) > The delete command however returns "0 rows deleted": > delete from #tmp_cohort > where patientid not in (24123,55785,16667,53701,30763,59762,22679,46328,46453,55956); > This is the query plan: > ============================================================================ > USER COMMAND: > DELETE FROM #tmp_cohort WHERE #tmp_cohort.patientid NOT IN (24123, 55785, 16667, 53701, 30763, 59762, 22679, 46328, 46453, 55956) > ---------------------------------------------------------------------------- > OPTIMIZE: > DELETE FROM #tmp_cohort WHERE #tmp_cohort.patientid NOT IN (24123, 55785, 16667, 53701, 30763, 59762, 22679, 46328, 46453, 55956) > ---------------------------------------------------------------------------- > GENERATE CANONICAL: > DELETE FROM #tmp_cohort WHERE #tmp_cohort.patientid NOT IN (24123, 55785, 16667, 53701, 30763, 59762, 22679, 46328, 46453, 55956) > CANONICAL PLAN: > Project(groups=[], props={PROJECT_COLS=[Count]}) > Source(groups=[#tmp_cohort], props={ATOMIC_REQUEST=DELETE FROM #tmp_cohort WHERE #tmp_cohort.patientid NOT IN (24123, 55785, 16667, 53701, 30763, 59762, 22679, 46328, 46453, 55956), VIRTUAL_COMMAND=DELETE FROM #tmp_cohort WHERE #tmp_cohort.patientid NOT IN (24123, 55785, 16667, 53701, 30763, 59762, 22679, 46328, 46453, 55956)}) > ============================================================================ > EXECUTING PlaceAccess > AFTER: > Project(groups=[], props={PROJECT_COLS=[Count]}) > Access(groups=[#tmp_cohort], props={SOURCE_HINT=null, MODEL_ID=__TEMP__}) > Source(groups=[#tmp_cohort], props={ATOMIC_REQUEST=DELETE FROM #tmp_cohort WHERE #tmp_cohort.patientid NOT IN (24123, 55785, 16667, 53701, 30763, 59762, 22679, 46328, 46453, 55956), VIRTUAL_COMMAND=DELETE FROM #tmp_cohort WHERE #tmp_cohort.patientid NOT IN (24123, 55785, 16667, 53701, 30763, 59762, 22679, 46328, 46453, 55956)}) > ============================================================================ > EXECUTING RaiseAccess > AFTER: > Access(groups=[#tmp_cohort], props={SOURCE_HINT=null, MODEL_ID=__TEMP__}) > Project(groups=[], props={PROJECT_COLS=[Count]}) > Source(groups=[#tmp_cohort], props={ATOMIC_REQUEST=DELETE FROM #tmp_cohort WHERE #tmp_cohort.patientid NOT IN (24123, 55785, 16667, 53701, 30763, 59762, 22679, 46328, 46453, 55956), VIRTUAL_COMMAND=DELETE FROM #tmp_cohort WHERE #tmp_cohort.patientid NOT IN (24123, 55785, 16667, 53701, 30763, 59762, 22679, 46328, 46453, 55956)}) > ============================================================================ > EXECUTING AssignOutputElements > AFTER: > Access(groups=[#tmp_cohort], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[Count]}) > Project(groups=[], props={PROJECT_COLS=[Count], OUTPUT_COLS=[Count]}) > Source(groups=[#tmp_cohort], props={ATOMIC_REQUEST=DELETE FROM #tmp_cohort WHERE #tmp_cohort.patientid NOT IN (24123, 55785, 16667, 53701, 30763, 59762, 22679, 46328, 46453, 55956), VIRTUAL_COMMAND=DELETE FROM #tmp_cohort WHERE #tmp_cohort.patientid NOT IN (24123, 55785, 16667, 53701, 30763, 59762, 22679, 46328, 46453, 55956), OUTPUT_COLS=[Count]}) > ============================================================================ > EXECUTING CalculateCost > AFTER: > Access(groups=[#tmp_cohort], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[Count], EST_CARDINALITY=12230.0, EST_COL_STATS={Count=[-1.0, -1.0]}}) > Project(groups=[], props={PROJECT_COLS=[Count], OUTPUT_COLS=[Count], EST_CARDINALITY=12230.0, EST_COL_STATS={Count=[-1.0, -1.0]}}) > Source(groups=[#tmp_cohort], props={ATOMIC_REQUEST=DELETE FROM #tmp_cohort WHERE #tmp_cohort.patientid NOT IN (24123, 55785, 16667, 53701, 30763, 59762, 22679, 46328, 46453, 55956), VIRTUAL_COMMAND=DELETE FROM #tmp_cohort WHERE #tmp_cohort.patientid NOT IN (24123, 55785, 16667, 53701, 30763, 59762, 22679, 46328, 46453, 55956), OUTPUT_COLS=[Count], EST_CARDINALITY=12230.0}) > ============================================================================ > EXECUTING PlanSorts > AFTER: > Access(groups=[#tmp_cohort]) > Project(groups=[]) > Source(groups=[#tmp_cohort]) > ============================================================================ > EXECUTING CollapseSource > AFTER: > Access(groups=[#tmp_cohort], props={SOURCE_HINT=null, MODEL_ID=__TEMP__, OUTPUT_COLS=[Count], EST_CARDINALITY=12230.0, EST_COL_STATS={Count=[-1.0, -1.0]}, ATOMIC_REQUEST=DELETE FROM #tmp_cohort WHERE #tmp_cohort.patientid NOT IN (24123, 55785, 16667, 53701, 30763, 59762, 22679, 46328, 46453, 55956)}) > ============================================================================ > CONVERTING PLAN TREE TO PROCESS TREE > PROCESS PLAN = > AccessNode(0) output=[Count] DELETE FROM #tmp_cohort WHERE #tmp_cohort.patientid NOT IN (24123, 55785, 16667, 53701, 30763, 59762, 22679, 46328, 46453, 55956) > ============================================================================ > ---------------------------------------------------------------------------- > OPTIMIZATION COMPLETE: > PROCESSOR PLAN: > AccessNode(0) output=[Count] DELETE FROM #tmp_cohort WHERE #tmp_cohort.patientid NOT IN (24123, 55785, 16667, 53701, 30763, 59762, 22679, 46328, 46453, 55956) > ============================================================================ -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4615) Provide Swagger support for Odata

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4615?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4615. --------------------------------- > Provide Swagger support for Odata > ---------------------------------- > > Key: TEIID-4615 > URL: https://issues.jboss.org/browse/TEIID-4615 > Project: Teiid > Issue Type: Feature Request > Components: OData > Reporter: Debbie Steigner > Assignee: Ramesh Reddy > > Is there way to look at the OData service also in the Swagger UI to view and Test it ? I can manually enter the below URL in the browser address but it will be good to list these APIs also in the Swagger UI. > http://{hostname}:8080/odata/SwaggerDemo/$metadata > http://{hostname}:8080/odata/SwaggerDemo/DV_Cache.CUSTOMER > http://{hostname}:8080/odata/SwaggerDemo/DV_Cache.CUSTOMER?$filter=CUSTOMERID eq 'CST01005' > http://{hostname}:8080/odata/SwaggerDemo/DV_Cache.CUSTOMER?$filter=CUSTOMERID eq 'CST01005'&$format=JSON -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4590) Fix the Select ALL logic so that it works when different object types exists

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4590?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4590. --------------------------------- > Fix the Select ALL logic so that it works when different object types exists > ---------------------------------------------------------------------------- > > Key: TEIID-4590 > URL: https://issues.jboss.org/browse/TEIID-4590 > Project: Teiid > Issue Type: Bug > Components: JDG Connector > Affects Versions: 9.2 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Blocker > Fix For: 8.12.8.6_3, 9.2 > > > Fix the select * (ALL) logic so that it can work when there are multiple object types in the cache. The select ALL should only be selecting based on the object type associated with that table. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2293) Update Object-Translator to add support for JPA/Hibernate search annotations in the metadata processor

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2293?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2293. --------------------------------- > Update Object-Translator to add support for JPA/Hibernate search annotations in the metadata processor > ------------------------------------------------------------------------------------------------------ > > Key: TEIID-2293 > URL: https://issues.jboss.org/browse/TEIID-2293 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 8.2 > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 9.0, 8.12.5 > > > Update Object-Translator to add support for JPA/Hibernate search annotations in the metadata processor. Coordinate with the JPA/OGM work that is being done. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4086) OData - Math functions floor and ceiling doesn't accept number as parameter

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4086?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4086. --------------------------------- > OData - Math functions floor and ceiling doesn't accept number as parameter > --------------------------------------------------------------------------- > > Key: TEIID-4086 > URL: https://issues.jboss.org/browse/TEIID-4086 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Michal Sanitrak > Assignee: Ramesh Reddy > Labels: Alpha3 > Fix For: 9.0, 8.12.5 > > > Basic functionality of math functions floor and ceiling works properly as \[1\] describes, but these functions doesn't accept number as parameter. > Reference service which supports OData V4: > *ULR:* http://services.odata.org/V4/Northwind/Northwind.svc/Employees/?$filter=E... > *Result:* Employee with ID 4 > *ULR:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... > *Actual result:* {"error":{"code": null, "message": "TEIID30069 The function 'FLOOR(\?)' has more than one possible signature."}} > *Expected result:* Entity with intkey 4 > *ULR:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... > *Actual result:* {"error": {"code": null, "message": "TEIID30069 The function 'CEILING(\?)' has more than one possible signature."}} > *Expected result:* Entity with intkey 5 > See [\[OData-ABNF\]|http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/abnf/odata-abnf-construction-rules.txt] _Line:_ 539 - Math functions accepts _commonExpr_ > \[1\] http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part2-ur... -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

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

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4491?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4491. --------------------------------- > 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, 8.7.10.6_2, 8.12.8.6_3 > > > 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 (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3925) Rename infinispan translators / resources adapters to align with running library mode versus access remote cache

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3925?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3925. --------------------------------- > Rename infinispan translators / resources adapters to align with running library mode versus access remote cache > ---------------------------------------------------------------------------------------------------------------- > > Key: TEIID-3925 > URL: https://issues.jboss.org/browse/TEIID-3925 > Project: Teiid > Issue Type: Quality Risk > Components: JDG Connector > Affects Versions: 9.0 > Reporter: Van Halbert > Assignee: Steven Hawkins > > Currently, the infinispan translators and resource adapters are named: > - translator-infinispan-cache (infinispan-cache) / connector-infinispan.6 > - translator-infinispan-dsl (infinispan-cache-dsl) / connector-infinispan-dsl > Suggested rename to be done in version 9 to align with infinispan 7: > - translator-infinispan-library-mode (infinispan-library-mode) / connector-infinispan-library-mode.7 > - translator-infinispan-remote-cache (infinispan-remote-cache / connector-infinispan-remote-cache.7 -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3879) Error during state transfer prevents a node from loading later

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3879?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3879. --------------------------------- > Error during state transfer prevents a node from loading later > -------------------------------------------------------------- > > Key: TEIID-3879 > URL: https://issues.jboss.org/browse/TEIID-3879 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.13, 8.12.4 > > > During an initial transfer or a later transfer after invalidation an error will cause the receiving node to just wait for the next load (which could be indefinite) rather than initiating it's own load. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

8 years, 4 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 December 2017