June 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3998) EDS 5.3 jdbc driver virtual procedure call against JDV 6.2.3

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3998?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3998. --------------------------------- > EDS 5.3 jdbc driver virtual procedure call against JDV 6.2.3 > ------------------------------------------------------------ > > Key: TEIID-3998 > URL: https://issues.jboss.org/browse/TEIID-3998 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.12 > Environment: eds-5.3.1_1_2015-jdbc > Reporter: Filip Elias > Assignee: Steven Hawkins > Attachments: server1.log > > > We identified an issue when trying to connect with EDS 5.3 jdbc driver to JDV 6.2.3 instance. > The problem is caused by virtual procedure execution. > Query performed: > EXEC View.hiddenUpdate(456,'changed') > View definition: > {code} > <model name="View" type="VIRTUAL"> > <metadata type="DDL"><![CDATA[ > CREATE VIRTUAL PROCEDURE hiddenUpdate(ID integer,CUSTOMERNAME string) AS BEGIN > MERGE INTO Customers(id,customername) VALUES(ID,CUSTOMERNAME); > END > ]]> </metadata> > </model> > {code} > NPE excepton: > {code} > Exception in thread "main" java.lang.NullPointerException > at org.teiid.jdbc.StatementImpl.executeUpdate(StatementImpl.java:342) > at jdbcdriver.JDBCClient.executeUpdate(JDBCClient.java:59) > at jdbcdriver.JDBCClient.main(JDBCClient.java:52) > {code} > Client code: > {code} > @Test > public void procedureInvalidateCacheTest(){ > String sqlSelectAll = "/*+ cache */SELECT * FROM Customers;"; > try{ > > Utils.executeUpdate(con,"INSERT INTO Customers(id,customername) VALUES (456, 'Testing 1');"); > > ResultSet empty = Utils.executeQuery(con, sqlSelectAll); > Assert.assertTrue(empty.next(), "ResultSet should be empty"); > > try{ > Thread.sleep(3000); > }catch(InterruptedException ie){ > > } > > Utils.executeUpdate(con,"EXEC View.hiddenUpdate(456,'changed')"); > > ResultSet full = Utils.executeQuery(con, sqlSelectAll); > Assert.assertTrue(full.next(), "ResultSet shouldn't be empty"); > > int custId = full.getInt(1); > String custName = full.getString(2); > Assert.assertEquals(custId, 456,"Returned row with wrong customer id"); > Assert.assertEquals(custName,"changed","PROCEDURE with UPDATE query didn't invalidate the cache:returned row with wrong customer name"); > > > }catch(SQLException se){ > LOG.error("Error during performing sql query on teiid",se); > Assert.fail("Error during performing sql query on teiid", se); > } > } > static Connection getTeiidConnectionUser1() throws SQLException { > LOG.info("Getting Teiid connection for user1."); > return TeiidDriver.getInstance().connect(TEIID_URL_USER1, null); > } > static int executeUpdate(Connection con, String sql) throws SQLException{ > LOG.info("Executing update [connection: " + con + "]: " + sql + "."); > Statement s = con.createStatement(); > return s.executeUpdate(sql); > } > {code} > Server log is in the attachment. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3884) Queries with NextToken failing with NPE

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3884?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3884. --------------------------------- > Queries with NextToken failing with NPE > --------------------------------------- > > Key: TEIID-3884 > URL: https://issues.jboss.org/browse/TEIID-3884 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.12 > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Priority: Critical > Fix For: 8.13, 8.12.4 > > > Issuing the queries that return more than single page with out any system parameters are failing with NPE. Example: > {code} > http://localhost:8080/odata4/vdb.1/schema/view > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2808) Oversights in parser test unit tests

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2808?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2808. --------------------------------- > Oversights in parser test unit tests > ------------------------------------ > > Key: TEIID-2808 > URL: https://issues.jboss.org/browse/TEIID-2808 > Project: Teiid > Issue Type: Bug > Components: Integration Tests > Affects Versions: 8.4, 8.6 > Reporter: Paul Richardson > Assignee: Steven Hawkins > Priority: Minor > Attachments: 0001-TEIID-2808-Small-fixes-to-unit-tests-and-accompanyin.patch > > > While integrating the unit tests from TestParser into Designer's teiid runtime client codebase, I found several small issues with the tests. All the tests pass in TestParser under Teiid hence these items have not necessarily been noticed and its a question of whether they should be. > * testArrayTable > ** The Constant node class' equals method does not test the 'type' field if the 'value' field is null. This allows the test to pass when the constants in the expected and actual Commands trees have different types. Discussion with [~rareddy] concluded the equals method does this by design. > ** Suggestion is change the expected Constant to have NullType as its 'type' rather than Object. > * testBlockExceptionHandling > ** The Block node class has no equals method hence this test passes even though the 'groupExpression' field is different between expected and actual. > * testDynamicCommand1 > ** The ElementSymbol node class never considers its 'type' field in its equals method hence the test passes despite an expected type of Integer against an actual type of null. > ** test has a typo when the expected var 'a1' has its type set twice to String then Integer. > * testStoredQuery2SanityCheck > ** Has an extraneous query created and never used > * testStoredQuerySubqueryMultipleParens > ** Never executes due to a lack of @Test annotation. Judging by the comment it might be an experiment that has been commented out by removing the annotation. Reinforced by test failing with parsing exception. > * testStoredQueryWithNoParameter2 > ** The test passes but has different expected and actual GroupSymbols in the From clause since the 'shortname' field is actually "x" rather than the expected "X". The reason is that GroupSymbol equals method does not test the 'shortname' field if the schema is null. This maybe by design? > ** Suggestion is to at least change the expected value to "X". -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3957) Impala translator - Add pushdown of offset in LIMIT clause to overcome difference in LIMIT clause

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3957?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3957. --------------------------------- > Impala translator - Add pushdown of offset in LIMIT clause to overcome difference in LIMIT clause > ------------------------------------------------------------------------------------------------- > > Key: TEIID-3957 > URL: https://issues.jboss.org/browse/TEIID-3957 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Connector > Affects Versions: 8.12.4 > Environment: Ubuntu Trusty > Reporter: Don Krapohl > Assignee: Steven Hawkins > Priority: Minor > Fix For: 9.0 > > > With the impala translator we issue this LIMIT to Teiid: > ORDER BY somecolumn DESC LIMIT 75, 25 > this means give me 25 rows starting from *ROW* 76. > In Impala's SQL this should be translated to: > ORDER BY somecolumn DESC LIMIT 25 OFFSET 75 > BUT this means give me 25 rows starting from *PAGE * 76 (with page size of 25 rows) > ref: http://www.cloudera.com/documentation/archive/impala/2-x/2-1-x/topics/imp... > The Teiid Impala translator doesn't push the offset but sums the limit and offset: > ORDER BY somecolumn DESC LIMIT 100 > Request we add pushdown, which will be more efficient and overcome the difference in how offsets are handled between Impala and Teiid. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3876) Add an option to import RowId as binary

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3876?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3876. --------------------------------- > Add an option to import RowId as binary > --------------------------------------- > > Key: TEIID-3876 > URL: https://issues.jboss.org/browse/TEIID-3876 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Connector, Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.13, 8.12.4 > > > RowId values will be seen as object type, which may not be useful for consumers. We should offer a mapping to varbinary to pull the raw byte value, which can be properly typed. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3599) Excel translator and dynamic filenames

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3599?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3599. --------------------------------- > Excel translator and dynamic filenames > -------------------------------------- > > Key: TEIID-3599 > URL: https://issues.jboss.org/browse/TEIID-3599 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Reporter: Ralph Martin Black > Assignee: Ramesh Reddy > Priority: Minor > Labels: Alpha2 > Fix For: 9.0, 8.13.2 > > > Hi all, > All samples I've reached on how to setup a connection to xls files, set up file names as properties in the source model: > ... > <property name="importer.ExcelFileName" value="names.xls"/> > ... > Is there any way to specify filenames dynamically at run-time? > Best regards > MB! -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4020) Add xquery to message when it is invalid

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4020?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4020. --------------------------------- > Add xquery to message when it is invalid > ---------------------------------------- > > Key: TEIID-4020 > URL: https://issues.jboss.org/browse/TEIID-4020 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.0 > > > Teiid TEIID30154 conveys the saxon exception, but not the xquery value that causes the issue. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2742) transaction rollback in EDS with SQLServer

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2742?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2742. --------------------------------- > transaction rollback in EDS with SQLServer > ------------------------------------------ > > Key: TEIID-2742 > URL: https://issues.jboss.org/browse/TEIID-2742 > Project: Teiid > Issue Type: Quality Risk > Components: JDBC Connector > Affects Versions: 7.7.8 > Environment: EDS 5.3.1 > Reporter: Hisanobu Okuda > Assignee: Steven Hawkins > Priority: Minor > > When using LoadTest within SoapUI, upon increase the number of threads to greater than 1, we encounter the ATOMIC transaction encountering roll back and the following error is found. However, when the threads only set to 1, everything works fine. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3260) Create custom metadata repository that uses Modeshape

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3260?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3260. --------------------------------- > Create custom metadata repository that uses Modeshape > ----------------------------------------------------- > > Key: TEIID-3260 > URL: https://issues.jboss.org/browse/TEIID-3260 > Project: Teiid > Issue Type: Feature Request > Components: Grammar, Server, Tooling, VDB > Affects Versions: 8.10 > Reporter: Van Halbert > > Create a custom metadata repository implementation that uses ModeShape as the repository for obtaining the VDB metadata for deployment. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3909) Add support for odata translator geospatial handling

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3909?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3909. --------------------------------- > Add support for odata translator geospatial handling > ---------------------------------------------------- > > Key: TEIID-3909 > URL: https://issues.jboss.org/browse/TEIID-3909 > Project: Teiid > Issue Type: Enhancement > Components: OData > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.0 > > > We should use the Edm.Geometry type for the Teiid geometry type (we can also use system metadata to see if it's appropriate to use a geometry subtype) along with any geospatial operations that odata and Teiid support. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 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 June 2016