October 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-1680) issues with correlation and aggregation

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-1680?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-1680. --------------------------------- > issues with correlation and aggregation > --------------------------------------- > > Key: TEIID-1680 > URL: https://issues.jboss.org/browse/TEIID-1680 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.0 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.10 > > > subqueries used in the having/select clause of a query with grouping only understand correlated element symbols - not correlated grouping expressions or correlated aggregate values. > If a nested aggregate contains only outer references, then it should be treated as a correlated value. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2740) Support Direct Query Execution with MongoDB

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2740?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2740. --------------------------------- > Support Direct Query Execution with MongoDB > ------------------------------------------- > > Key: TEIID-2740 > URL: https://issues.jboss.org/browse/TEIID-2740 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 8.4 > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 8.4.1, 8.6 > > > Direct query execution in the MongoDB was not implemented completely. This needs to be fixed as this would be a very helpful enhancement. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2384) Managing Spatial Data Types

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2384?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2384. --------------------------------- > Managing Spatial Data Types > --------------------------- > > Key: TEIID-2384 > URL: https://issues.jboss.org/browse/TEIID-2384 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 8.2 > Reporter: luca gioppo > Assignee: Steven Hawkins > Labels: spatial, types > Fix For: 8.10 > > > It would be useful to be able to consume data from spatial database exposing the VDB as a spatial database to other application (imagine geoserver). > TEIID could be strategic for merging georeferenced data and make it available to those systems. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3336) Change logging to be disabled by default

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3336?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3336. --------------------------------- > Change logging to be disabled by default > ---------------------------------------- > > Key: TEIID-3336 > URL: https://issues.jboss.org/browse/TEIID-3336 > Project: Teiid > Issue Type: Enhancement > Components: Build/Kits > Affects Versions: 8.10 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Minor > > Change the teiid-extension to install logging, which is to change to be disabled by default. This will be done by splitting the current script into to scripts. One to configure the handlers (teiid-add-database-logger.cli). And the second script (teiid-enble-database-logger.cli) can be used to enable. So if someone wants to automate the enabling, the script will be available. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3379) Import error reporting duplicate constraints

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3379?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3379. --------------------------------- > Import error reporting duplicate constraints > -------------------------------------------- > > Key: TEIID-3379 > URL: https://issues.jboss.org/browse/TEIID-3379 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 8.8 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.11 > > > With TEIID-2922 it is now possible for metadata import to throw an exception when multiple constraints are found with the same name even erroneously - see comments on TEIID-2875. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3384) SQLServerException: Each GROUP BY expression must contain at least one column that is not an outer reference

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3384?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3384. --------------------------------- > SQLServerException: Each GROUP BY expression must contain at least one column that is not an outer reference > ------------------------------------------------------------------------------------------------------------ > > Key: TEIID-3384 > URL: https://issues.jboss.org/browse/TEIID-3384 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7 > Reporter: Salvatore R > Assignee: Steven Hawkins > Fix For: 8.11 > > > Running this query (where "test_a" is a table in MS SQL Server): > {code:sql} > select test2 > from > (select 'aaa' as test2 from ms.test_a) b > group by test2 > {code} > the following exception is thrown: > {code:sql} > 01:36:55,198 WARN [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue4) ks49tw3LLVqR Connector worker process failed for atomic-request=ks49tw3LLVqR.1.1.1: org.teiid.translator.jdbc.JDBCExecutionException: 164 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT 'aaa' FROM "test_tables"."dbo"."test_a" g_0 GROUP BY 'aaa'] > at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131) [translator-jdbc-8.10.0.Beta2.jar:8.10.0.Beta2] > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:335) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_51] > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_51] > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_51] > at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_51] > at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:209) > at com.sun.proxy.$Proxy47.execute(Unknown Source) > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298) > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) > at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_51] > at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_51] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_51] > at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51] > Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Each GROUP BY expression must contain at least one column that is not an outer reference. > at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) > at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515) > at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404) > at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350) > at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) > at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) > at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) > at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) > at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285) > at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462) > at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:123) [translator-jdbc-8.10.0.Beta2.jar:8.10.0.Beta2] > ... 18 more > {code} > The connection to the datasource is defined in standalone-teiid.xml as: > {code:sql} > <datasource jndi-name="java:/mssql-test-tables" pool-name="sqlserverDS1" enabled="true"> > <connection-url>jdbc:sqlserver://localhost:1433;databaseName=test_tables</connection-url> > <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class> > <driver>com.microsoft.sqlserver</driver> > <pool> > <prefill>false</prefill> > <use-strict-min>false</use-strict-min> > <flush-strategy>FailingConnectionOnly</flush-strategy> > </pool> > <security> > <user-name>test</user-name> > <password>test</password> > </security> > <validation> > <check-valid-connection-sql>select 1</check-valid-connection-sql> > </validation> > </datasource> > {code} > Driver and translator definitions are respectively: > {code:sql} > ... > <driver name="com.microsoft.sqlserver" module="com.microsoft.sqlserver"/> > ... > <translator name="sqlserver" module="org.jboss.teiid.translator.jdbc"/> > ... > {code} > and the "ms" model is defined in a dynamic vdb as: > {code:sql} > <model name="ms"> > <property name="importer.useFullSchemaName" value="false"/> > <property name="importer.tableTypes" value="TABLE,VIEW"/> > <property name="importer.importKeys" value="false"/> > <property name="importer.schemaPattern" value="dbo"/> > <source name="test_tables_ms" translator-name="sqlserver" connection-jndi-name="java:/mssql-test-tables"/> > </model> > {code} > I could reproduce this error in Teiid-8.10.0.Beta2 running SQL Server Express 2012 - 64bit (11.0.3128.0). -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3381) PSQLException: ERROR: failed to find conversion function from unknown to text

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3381?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3381. --------------------------------- > PSQLException: ERROR: failed to find conversion function from unknown to text > ----------------------------------------------------------------------------- > > Key: TEIID-3381 > URL: https://issues.jboss.org/browse/TEIID-3381 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 7.7 > Reporter: Salvatore R > Assignee: Steven Hawkins > Fix For: 8.11 > > > Running this query (where "test_a" is a table in PostgreSQL): > {code:sql} > select test2 > from > (select 'aaa' as test2 from pg.test_a) b > group by test2 > {code} > the following exception is thrown: > {code:sql} > 19:01:01,172 WARN [org.teiid.CONNECTOR] (Worker5_QueryProcessorQueue26) +AyVUdbE4D5l Connector worker process failed for atomic-request=+AyVUdbE4D5l.12.1.3: org.teiid.translator.jdbc.JDBCExecutionException: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT v_0.c_0 FROM (SELECT 'aaa' AS c_0 FROM "public"."test_a" AS g_0) AS v_0 GROUP BY v_0.c_0] > at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131) [translator-jdbc-8.10.0.Beta2.jar:8.10.0.Beta2] > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:335) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_51] > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_51] > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_51] > at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_51] > at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:209) > at com.sun.proxy.$Proxy47.execute(Unknown Source) > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298) > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) > at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_51] > at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_51] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_51] > at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51] > Caused by: org.postgresql.util.PSQLException: ERROR: failed to find conversion function from unknown to text > at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157) > at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) > at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255) > at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555) > at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417) > at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302) > at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462) > at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:123) [translator-jdbc-8.10.0.Beta2.jar:8.10.0.Beta2] > ... 18 more > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3373) Add an org.teiid logging context in the config

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3373?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3373. --------------------------------- > Add an org.teiid logging context in the config > ---------------------------------------------- > > Key: TEIID-3373 > URL: https://issues.jboss.org/browse/TEIID-3373 > Project: Teiid > Issue Type: Enhancement > Components: Server > Reporter: Steven Hawkins > Assignee: Van Halbert > Fix For: 8.11 > > > It would be convenient to have an existing org.teiid entry in the logging config to allow admins to quickly enabled debug/trace logging. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3223) An issue with time in WHERE clause - SQLServer

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3223?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3223. --------------------------------- > An issue with time in WHERE clause - SQLServer > ---------------------------------------------- > > Key: TEIID-3223 > URL: https://issues.jboss.org/browse/TEIID-3223 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1 > Environment: OS: fedora20 > arch: x86_64 > java: oracle 1.7 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.10 > > > Teiid is not able to manage WHERE clause with time value. > translator: sqlserver > base DB: SQL Server 2012/2008/2005 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3240) Tranlator archetype creation: -Dversion option sets the version of parent

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3240?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3240. --------------------------------- > Tranlator archetype creation: -Dversion option sets the version of parent > ------------------------------------------------------------------------- > > Key: TEIID-3240 > URL: https://issues.jboss.org/browse/TEIID-3240 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1 > Reporter: Juraj Duráni > Assignee: Van Halbert > > If new translator is created using command line, -Dversion option is set as version of parent project instead of version of actual translator. > pom file: > <parent> > <groupId>org.jboss.teiid</groupId> > <artifactId>connectors</artifactId> > <version>0.0.1</version> > </parent> > ... > <groupId>org.jboss.teiid.test.translator</groupId> > <artifactId>test-translator</artifactId> >  > <packaging>jar</packaging> > ... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 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 October 2015