March 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4010) Differentiate between tables and views in the metadata

by Debbie Steigner (JIRA)

Debbie Steigner created TEIID-4010: -------------------------------------- Summary: Differentiate between tables and views in the metadata Key: TEIID-4010 URL: https://issues.jboss.org/browse/TEIID-4010 Project: Teiid Issue Type: Feature Request Affects Versions: 8.13.1, 8.7.2.6_2 Reporter: Debbie Steigner Assignee: Steven Hawkins Currently from the metamodel perspective both view and table share the same type, can they be separated? -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4007) Unparseable model name if user changes odata4 context root

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4007?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4007. ----------------------------------- Fix Version/s: 9.0 8.12.5 8.13.2 Resolution: Done Merged the pull request and made additional changes to consolidate the logic. > Unparseable model name if user changes odata4 context root > ---------------------------------------------------------- > > Key: TEIID-4007 > URL: https://issues.jboss.org/browse/TEIID-4007 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.12.x > Reporter: Juraj Duráni > Assignee: Juraj Duráni > Fix For: 9.0, 8.12.5, 8.13.2 > > > If user changes root context of odata4 service, Teiid does not parse model name from the URI and throws TEIID16022 instead. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4007) Unparseable model name if user changes odata4 context root

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4007?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4007: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1313626 Bugzilla Update: Perform > Unparseable model name if user changes odata4 context root > ---------------------------------------------------------- > > Key: TEIID-4007 > URL: https://issues.jboss.org/browse/TEIID-4007 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.12.x > Reporter: Juraj Duráni > Assignee: Juraj Duráni > > If user changes root context of odata4 service, Teiid does not parse model name from the URI and throws TEIID16022 instead. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 10 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 updated TEIID-3994: ---------------------------------- Component/s: Query Engine > 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 (v6.4.11#64026)

8 years, 10 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 resolved TEIID-3994. ----------------------------------- Fix Version/s: 9.0 8.12.5 8.13.2 Resolution: Done I had to modify your example to explicitly include an alias in the insert: insert into ... select col as foo ... You will need to open a support ticket to have this back ported beyond 8.12.x. > AliasSymbol wrapping AliasSymbol error > -------------------------------------- > > Key: TEIID-3994 > URL: https://issues.jboss.org/browse/TEIID-3994 > Project: Teiid > Issue Type: Bug > 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 (v6.4.11#64026)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4009) teiid shows wrong version on web console near to AS/EAP header logo

by Marco Ardito (JIRA)

Marco Ardito created TEIID-4009: ----------------------------------- Summary: teiid shows wrong version on web console near to AS/EAP header logo Key: TEIID-4009 URL: https://issues.jboss.org/browse/TEIID-4009 Project: Teiid Issue Type: Bug Affects Versions: 8.12.3 Reporter: Marco Ardito Assignee: Steven Hawkins Priority: Minor using the "teiid + EAP server" (at least on version 8.12.3) the Teiid Web Console includes a manifest file that includes "JBoss-Product-Release-Version: + Teiid 8.11" - which obviously needs to not hardcode the Teiid version (or should show the console version). -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4008) Sending teiid varbinary value (x'') to Microsoft SQL Server errors

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4008?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4008. ----------------------------------- Resolution: Done Corrected the source syntax for postgresql/derivatives, sql server and sybase. > Sending teiid varbinary value (x'') to Microsoft SQL Server errors > ------------------------------------------------------------------ > > Key: TEIID-4008 > URL: https://issues.jboss.org/browse/TEIID-4008 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 8.7.2.6_2 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 9.0, 8.12.5, 8.13.2 > > > When sending a query to Microsoft SQL Server with a varbinary in criteria: > select * from debBinary where ipv6= x'FFFF6BBE85D8' > It pushes the criteria to Microsoft SQL Server, but as X'FFFF6BBE85D8'[1] so Microsoft gives the syntax error[2] and needs to just be select * from debBinary where ipv6= 'FFFF6BBE85D8': > [1]14:26:08,951 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue8) Source-specific command: SELECT g_0."id", g_0."ipv6" FROM "bqt2"."dbo"."debbinary" g_0 WHERE g_0."ipv6" = X'FFFF6BBE85D8' > [2] com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'FFFF6BBE85D8'. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4008) Sending teiid varbinary value (x'') to Microsoft SQL Server errors

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4008?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-4008: ---------------------------------- Component/s: JDBC Connector Fix Version/s: 9.0 8.12.5 8.13.2 > Sending teiid varbinary value (x'') to Microsoft SQL Server errors > ------------------------------------------------------------------ > > Key: TEIID-4008 > URL: https://issues.jboss.org/browse/TEIID-4008 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 8.7.2.6_2 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 9.0, 8.12.5, 8.13.2 > > > When sending a query to Microsoft SQL Server with a varbinary in criteria: > select * from debBinary where ipv6= x'FFFF6BBE85D8' > It pushes the criteria to Microsoft SQL Server, but as X'FFFF6BBE85D8'[1] so Microsoft gives the syntax error[2] and needs to just be select * from debBinary where ipv6= 'FFFF6BBE85D8': > [1]14:26:08,951 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue8) Source-specific command: SELECT g_0."id", g_0."ipv6" FROM "bqt2"."dbo"."debbinary" g_0 WHERE g_0."ipv6" = X'FFFF6BBE85D8' > [2] com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'FFFF6BBE85D8'. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4008) Sending teiid varbinary value (x'') to Microsoft SQL Server errors

by Debbie Steigner (JIRA)

[ https://issues.jboss.org/browse/TEIID-4008?page=com.atlassian.jira.plugin... ] Debbie Steigner updated TEIID-4008: ----------------------------------- Description: When sending a query to Microsoft SQL Server with a varbinary in criteria: select * from debBinary where ipv6= x'FFFF6BBE85D8' It pushes the criteria to Microsoft SQL Server, but as X'FFFF6BBE85D8'[1] so Microsoft gives the syntax error[2] and needs to just be select * from debBinary where ipv6= 'FFFF6BBE85D8': [1]14:26:08,951 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue8) Source-specific command: SELECT g_0."id", g_0."ipv6" FROM "bqt2"."dbo"."debbinary" g_0 WHERE g_0."ipv6" = X'FFFF6BBE85D8' [2] com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'FFFF6BBE85D8'. was: When sending a query to Microsoft SQL Server with a varbinary in criteria: select * from debBinary where ipv6= x'FFFF6BBE85D8' It pushes the criteria to Microsoft SQL Server, but as X'FFFF6BBE85D8'[1] so Microsoft gives the syntax error[2] and needs to just be select * from debBinary where ipv6= 'FFFF6BBE85D8': [1]14:26:08,951 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue8) Source-specific command: SELECT g_0."id", g_0."ipv6" FROM "bqt2"."dbo"."debbinary" g_0 WHERE g_0."ipv6" = X'FFFF6BBE85D8' > Sending teiid varbinary value (x'') to Microsoft SQL Server errors > ------------------------------------------------------------------ > > Key: TEIID-4008 > URL: https://issues.jboss.org/browse/TEIID-4008 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.2.6_2 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > > When sending a query to Microsoft SQL Server with a varbinary in criteria: > select * from debBinary where ipv6= x'FFFF6BBE85D8' > It pushes the criteria to Microsoft SQL Server, but as X'FFFF6BBE85D8'[1] so Microsoft gives the syntax error[2] and needs to just be select * from debBinary where ipv6= 'FFFF6BBE85D8': > [1]14:26:08,951 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue8) Source-specific command: SELECT g_0."id", g_0."ipv6" FROM "bqt2"."dbo"."debbinary" g_0 WHERE g_0."ipv6" = X'FFFF6BBE85D8' > [2] com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'FFFF6BBE85D8'. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4008) Sending teiid varbinary value (x'') to Microsoft SQL Server errors

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4008?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-4008: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1313407 Bugzilla Update: Perform > Sending teiid varbinary value (x'') to Microsoft SQL Server errors > ------------------------------------------------------------------ > > Key: TEIID-4008 > URL: https://issues.jboss.org/browse/TEIID-4008 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.2.6_2 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > > When sending a query to Microsoft SQL Server with a varbinary in criteria: > select * from debBinary where ipv6= x'FFFF6BBE85D8' > It pushes the criteria to Microsoft SQL Server, but as X'FFFF6BBE85D8'[1] so Microsoft gives the syntax error[2] and needs to just be select * from debBinary where ipv6= 'FFFF6BBE85D8': > [1]14:26:08,951 DEBUG [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue8) Source-specific command: SELECT g_0."id", g_0."ipv6" FROM "bqt2"."dbo"."debbinary" g_0 WHERE g_0."ipv6" = X'FFFF6BBE85D8' -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 10 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues March 2016