July 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3008) limit being pushed even when already in the source query

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3008?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3008. --------------------------------- > limit being pushed even when already in the source query > -------------------------------------------------------- > > Key: TEIID-3008 > URL: https://issues.jboss.org/browse/TEIID-3008 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Query Engine > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.8 > > > Limits are being pushed even when already pushed down - this is a regression from TEIID-2878 -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3011) rewrite skipped

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3011?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3011. --------------------------------- > rewrite skipped > --------------- > > Key: TEIID-3011 > URL: https://issues.jboss.org/browse/TEIID-3011 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Query Engine > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.7, 8.7.1 > > > The rewrite of a set predicate is being bypassed when all of the in values are constants, but when pushed through a view with a convert on the left expression there is still optimizations that can be performed. > For example: > select * from (select e1, e2 from pm1.g1 union all select convert(e2, string), e2 from pm1.g2) x where e1 in ('1', '2') > such that e1 is string and e2 is integer, we expect that the second branch will have criteria of the form "e2 in (1, 2)" - with no conversion. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3000) Add Common Options when constraints are written

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3000?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3000. --------------------------------- > Add Common Options when constraints are written > ----------------------------------------------- > > Key: TEIID-3000 > URL: https://issues.jboss.org/browse/TEIID-3000 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Query Engine > Affects Versions: 8.0 > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 8.7.1, 8.8 > > > Changed to add Common Options when constraints are written -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2989) Support odata batching

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2989?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2989. --------------------------------- > Support odata batching > ---------------------- > > Key: TEIID-2989 > URL: https://issues.jboss.org/browse/TEIID-2989 > Project: Teiid > Issue Type: Enhancement > Security Level: Public(Everyone can see) > Components: OData > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.8 > > > We nearly have support for OData batching, but the ODataBatchingProvider is registered as a class and not as an instance. Otherwise it appears that a multipart/mixed post to an entity/$batch will allow for batching in OData4j. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2996) Ability to disable keepAlive

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2996?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2996. --------------------------------- > Ability to disable keepAlive > ---------------------------- > > Key: TEIID-2996 > URL: https://issues.jboss.org/browse/TEIID-2996 > Project: Teiid > Issue Type: Enhancement > Security Level: Public(Everyone can see) > Components: Server > Affects Versions: 7.7.10 > Reporter: Johnathon Lee > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.8 > > > offer an option to disable the ping/keep alive as the connections will always be associated with a given socket. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2998) problems with DDL returned for dynamic vdb with google spreadsheet source

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2998?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2998. --------------------------------- > problems with DDL returned for dynamic vdb with google spreadsheet source > ------------------------------------------------------------------------- > > Key: TEIID-2998 > URL: https://issues.jboss.org/browse/TEIID-2998 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Misc. Connectors > Affects Versions: 8.4 > Reporter: Mark Drilling > Attachments: ChromeSheet.png, FirefoxSheet.png, GoogleSpreadsheetJIRA.txt > > > I am seeing inconsistent DDL returned for dynamic VDB with a google spreadsheet source. In the same google account, I created two spreadsheets. One was created in firefox browser, one was created in chrome browser (don't know why that matters) > See the attached document showing a comparison of the dynamic VDBs and the DDL that I got back. The only difference is that the source was pointing to a different spreadsheet. > Notice that the DDL for the "ChromeSheet" returns the concatenated datavalues for the column name. But it includes a NIS OPTION for the column name. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3001) Custom translator cannot control its own namespace prefix

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3001?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3001. --------------------------------- > Custom translator cannot control its own namespace prefix > --------------------------------------------------------- > > Key: TEIID-3001 > URL: https://issues.jboss.org/browse/TEIID-3001 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Misc. Connectors > Affects Versions: 8.7.1, 8.8 > Reporter: Van Halbert > Assignee: Steven Hawkins > > When creating a custom translator, unable to control the namespace prefix: > SET NAMESPACE 'http://www.teiid.org/translator/infinispan/2014' AS n0 > it uses 'n0'. > I think the reason is the DDLStringVisitor only references BUILTIN_PREFIXES, for which is loaded from MetadataFactory. So if your namespace isn't a built in, it ends up with 'n0'. And the DDLStringVisitor doesn't have a way to get the MetadataFactory.namespaces that are added by calling: > metadataFactory.addNamespace(PREFIX, URI.substring(1, URI.length()-1)); -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3012) ModeShape requires to use 'JOIN' instead of ', ' when joining 2 tables

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3012?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3012. --------------------------------- > ModeShape requires to use 'JOIN' instead of ',' when joining 2 tables > --------------------------------------------------------------------- > > Key: TEIID-3012 > URL: https://issues.jboss.org/browse/TEIID-3012 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Misc. Connectors > Affects Versions: 8.4.2 > Reporter: Van Halbert > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.8 > > > Issuing either query: > SELECT c.jcr_name FROM relational_table AS t, relational_column AS c WHERE JCR.JCR_ISCHILDNODE(c.jcr_path, t.jcr_path) > SELECT c.jcr_name FROM relational_table AS t JOIN relational_column AS c ON JCR.JCR_ISCHILDNODE(c.jcr_path,t.jcr_path) > produces the following exception: > Caused by: javax.jcr.query.InvalidQueryException: The JCR-SQL2 query "SELECT g_1."jcr:name", g_1."jcr:path" FROM "relational:table" AS g_0, "relational:column" AS g_1 WHERE ISCHILDNODE(g_1, g_0)" is not well-formed: Unexpected token ',' at line 1, column 66 > at org.modeshape.jcr.JcrQueryManager.createQuery(JcrQueryManager.java:146) > at org.modeshape.jcr.JcrQueryManager.createQuery(JcrQueryManager.java:101) > at org.modeshape.jdbc.delegate.LocalRepositoryDelegate.execute(LocalRepositoryDelegate.java:139) > at org.modeshape.jdbc.JcrStatement.execute(JcrStatement.java:429) > ... 15 more > And after a discussion with Randall, it seems ModeShape needs JOIN in the syntax, and not ',' to join the tables. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3010) odata webapp missing joda time dependency

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3010?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3010. --------------------------------- > odata webapp missing joda time dependency > ----------------------------------------- > > Key: TEIID-3010 > URL: https://issues.jboss.org/browse/TEIID-3010 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: OData > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.8 > > > Usage of a datetime literal (datetime'2000-01-01T00:00:00) in a query, results in a no class def error: > Caused by: java.lang.NoClassDefFoundError: org/joda/time/LocalDateTime > at org.teiid.odata.ODataSQLBuilder.visit(ODataSQLBuilder.java:454) [classes:] -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2933) OData skipToken not properly honored

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2933?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2933. --------------------------------- > OData skipToken not properly honored > ------------------------------------ > > Key: TEIID-2933 > URL: https://issues.jboss.org/browse/TEIID-2933 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: OData > Affects Versions: 8.3 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.8 > > > If a skip token is provided, we still start providing results from the start of the result set. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 9 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 July 2014