October 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2381) Expanded source hint support

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-2381?page=com.atlassian.jira.plugin... ] Johnathon Lee closed TEIID-2381. -------------------------------- Resolution: Done > Expanded source hint support > ---------------------------- > > Key: TEIID-2381 > URL: https://issues.jboss.org/browse/TEIID-2381 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.4.4, 8.5 > > Attachments: HintsExecutionFactory.java, RandomExecutionFactory.java, RandomNumberStoredProcedureExecution.java, SysviewHintsExecutionTest.java > > > We currently look at the source hint in only the root user query (not in subqueries nor the with clause) and only consider it in a very narrow set of circumstances when it's used in a view. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2381) Expanded source hint support

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-2381?page=com.atlassian.jira.plugin... ] Johnathon Lee updated TEIID-2381: --------------------------------- Fix Version/s: 8.4.4 > Expanded source hint support > ---------------------------- > > Key: TEIID-2381 > URL: https://issues.jboss.org/browse/TEIID-2381 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.5, 8.4.4 > > Attachments: HintsExecutionFactory.java, RandomExecutionFactory.java, RandomNumberStoredProcedureExecution.java, SysviewHintsExecutionTest.java > > > We currently look at the source hint in only the root user query (not in subqueries nor the with clause) and only consider it in a very narrow set of circumstances when it's used in a view. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2381) Expanded source hint support

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-2381?page=com.atlassian.jira.plugin... ] Johnathon Lee reopened TEIID-2381: ---------------------------------- > Expanded source hint support > ---------------------------- > > Key: TEIID-2381 > URL: https://issues.jboss.org/browse/TEIID-2381 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.5 > > Attachments: HintsExecutionFactory.java, RandomExecutionFactory.java, RandomNumberStoredProcedureExecution.java, SysviewHintsExecutionTest.java > > > We currently look at the source hint in only the root user query (not in subqueries nor the with clause) and only consider it in a very narrow set of circumstances when it's used in a view. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2903) Dynamic VDB with Google Spreadsheet source - no metadata

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-2903?page=com.atlassian.jira.plugin... ] Johnathon Lee closed TEIID-2903. -------------------------------- Resolution: Done > Dynamic VDB with Google Spreadsheet source - no metadata > --------------------------------------------------------- > > Key: TEIID-2903 > URL: https://issues.jboss.org/browse/TEIID-2903 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.4 > Reporter: Mark Drilling > Assignee: Steven Hawkins > Fix For: 8.4.4, 8.7 > > > Deployed Dynamic VDB with Google Spreadsheet source. This is in the server log: > 16:17:49,286 WARN [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31070 Empty model;There are no tables, procedures or functions defined in this model importVDBSrcModel > According to the translator docs https://docs.jboss.org/author/display/TEIID/Google+Spreadsheet+Translator "There are no google-spreadsheet importer settings, but it does provide metadata for dynamic VDBs." > No metadata is returned. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2903) Dynamic VDB with Google Spreadsheet source - no metadata

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-2903?page=com.atlassian.jira.plugin... ] Johnathon Lee reopened TEIID-2903: ---------------------------------- > Dynamic VDB with Google Spreadsheet source - no metadata > --------------------------------------------------------- > > Key: TEIID-2903 > URL: https://issues.jboss.org/browse/TEIID-2903 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.4 > Reporter: Mark Drilling > Assignee: Steven Hawkins > Fix For: 8.7 > > > Deployed Dynamic VDB with Google Spreadsheet source. This is in the server log: > 16:17:49,286 WARN [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31070 Empty model;There are no tables, procedures or functions defined in this model importVDBSrcModel > According to the translator docs https://docs.jboss.org/author/display/TEIID/Google+Spreadsheet+Translator "There are no google-spreadsheet importer settings, but it does provide metadata for dynamic VDBs." > No metadata is returned. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2903) Dynamic VDB with Google Spreadsheet source - no metadata

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-2903?page=com.atlassian.jira.plugin... ] Johnathon Lee updated TEIID-2903: --------------------------------- Fix Version/s: 8.4.4 > Dynamic VDB with Google Spreadsheet source - no metadata > --------------------------------------------------------- > > Key: TEIID-2903 > URL: https://issues.jboss.org/browse/TEIID-2903 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.4 > Reporter: Mark Drilling > Assignee: Steven Hawkins > Fix For: 8.7, 8.4.4 > > > Deployed Dynamic VDB with Google Spreadsheet source. This is in the server log: > 16:17:49,286 WARN [org.teiid.PLANNER.RESOLVER] (teiid-async-threads - 2) TEIID31070 Empty model;There are no tables, procedures or functions defined in this model importVDBSrcModel > According to the translator docs https://docs.jboss.org/author/display/TEIID/Google+Spreadsheet+Translator "There are no google-spreadsheet importer settings, but it does provide metadata for dynamic VDBs." > No metadata is returned. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3160) Teiid inappropriately narrowing

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3160?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3160. ----------------------------------- Resolution: Done Updated the resolver to always choose the non-narrowing form if possible. > Teiid inappropriately narrowing > ------------------------------- > > Key: TEIID-3160 > URL: https://issues.jboss.org/browse/TEIID-3160 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.9 > > > issuing a query such as "select 1.0/2" should be done with non-integral division (.5), but the resolver is choosing integer division and returning 0. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3160) Teiid inappropriately narrowing

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-3160: ------------------------------------- Summary: Teiid inappropriately narrowing Key: TEIID-3160 URL: https://issues.jboss.org/browse/TEIID-3160 Project: Teiid Issue Type: Bug Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.7.1, 8.9 issuing a query such as "select 1.0/2" should be done with non-integral division (.5), but the resolver is choosing integer division and returning 0. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3159) Rename sap-nw-gateway Translator

by Ted Jones (JIRA)

Ted Jones created TEIID-3159: -------------------------------- Summary: Rename sap-nw-gateway Translator Key: TEIID-3159 URL: https://issues.jboss.org/browse/TEIID-3159 Project: Teiid Issue Type: Quality Risk Components: Misc. Connectors Affects Versions: 8.8 Reporter: Ted Jones Assignee: Steven Hawkins SAP has dropped NetWeaver for the name of their OData server product. We should rename the translator to sap-gateway. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3141) Bad result of query with GROUB BY clause (underlying sybase15 datasource)

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3141?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3141: --------------------------------------- > Only rows with IntNum=1 and IntNum=-1 are correct. Same result for IntKey column. Actually for the types involved, what sybase/Teiid is returning is the correct answer. You are performing integer division which results in most values being acos(0). > I have tried oracle12 (VDB and original) and result has been OK More than likely the source is performing decimal division. That is the intnum type is likely not a true integral type. > Result is for every value in the table 1.5708 (same for ShortValue). In this case original sybase returns correct result. Same as above. It matters what the source type is. From the Teiid perspective with the query as written you are performing integer division and thus getting acos(0). An issue I do see is that if you issue 1.0/int Teiid should not evaluate using integer division, and should produce the wider decimal result. > Bad result of query with GROUB BY clause (underlying sybase15 datasource) > ------------------------------------------------------------------------- > > Key: TEIID-3141 > URL: https://issues.jboss.org/browse/TEIID-3141 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1 > Environment: OS: fedora20 > arch: x86_64 > java: sun 1.7 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > > Description: > There is sybase15 database with table named SmallA and table named SmallA in VDB which is mapped to sybase table (see tables definition below). > I am trying to run query against VDB: > SELECT > INTKEY, STRINGKEY, INTNUM, STRINGNUM, FLOATNUM, LONGNUM, DOUBLENUM, BYTENUM, DATEVALUE, TIMEVALUE, TIMESTAMPVALUE, BOOLEANVALUE, CHARVALUE, SHORTVALUE, BIGINTEGERVALUE, BIGDECIMALVALUE > FROM > BQT1.SMALLA > GROUP BY > INTKEY, STRINGKEY, INTNUM, STRINGNUM, FLOATNUM, LONGNUM, DOUBLENUM, BYTENUM, DATEVALUE, TIMEVALUE, TIMESTAMPVALUE, BOOLEANVALUE, CHARVALUE, SHORTVALUE, BIGINTEGERVALUE, BIGDECIMALVALUE > Result is table which misses some values (the other values are OK): > FloatNum: always 0 > ByteNum: always 0 > DateValue: always 1900-01-01 > TimeValue: always 00:00:00 > BooleanValue: always 'false' > CharValue: always empty character > ShortValue: always 0 > BigIntegerValue: always 0 > BigDecimalValue: always 0 > After removing 'INTKEY' and 'STRINGKEY' from the query is result OK (sybase15 has indices only for these two columns). > /////////////////// > Table definition > /////////////////// > SmallA (sybase) has these columns (name:type): > IntKey:int -> PRIMARY KEY, HAS INDEX > StringKey:varchar -> HAS INDEX > IntNum:int > StringNum:varchar > FloatNum:float > LongNum:numeric > DoubleNum:float > ByteNum:real > DateValue:datetime > TimeValue:datetime > TimestampValue:datetime > BooleanValue:tinyint > CharValue:char > ShortValue:numeric > BigIntegerValue:numeric > BigDecimalValue:numeric > ObjectValue:text > SmallA (VDB) has these columns (name:type): > IntKey:integer > StringKey:string > IntNum:integer > StringNum:string > FloatNum:float > LongNum:long > DoubleNum:double > ByteNum:byte > DateValue:date > TimeValue:time > TimestampValue:timestamp > BooleanValue:boolean > CharValue:char > ShortValue:short > BigIntegerValue:biginteger > BigDecimalValue:bigdecimal > ObjectValue:object -- This message was sent by Atlassian JIRA (v6.3.1#6329)

10 years, 3 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2014