October 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3420) Support insert/update with ldap multi-value concat

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3420?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3420. --------------------------------- > Support insert/update with ldap multi-value concat > --------------------------------------------------- > > Key: TEIID-3420 > URL: https://issues.jboss.org/browse/TEIID-3420 > Project: Teiid > Issue Type: Feature Request > Components: LDAP Connector > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.11 > > > The translator currently only supports multi-value concat in the context of reads. Insert/update should be supported as well. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3372) Support multiple metadata tags

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3372?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3372. --------------------------------- > Support multiple metadata tags > ------------------------------ > > Key: TEIID-3372 > URL: https://issues.jboss.org/browse/TEIID-3372 > Project: Teiid > Issue Type: Feature Request > Components: Server > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.11 > > > To allow for a more flexible configuration, we should support multiple metadata tags under a model, rather than relying on comma separated values. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3354) AdminConsole fails getting mat view info with data roles

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3354?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3354. --------------------------------- > AdminConsole fails getting mat view info with data roles > -------------------------------------------------------- > > Key: TEIID-3354 > URL: https://issues.jboss.org/browse/TEIID-3354 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.11 > > > Once data roles are enable the web console fails to get the mat view info - unless the user allows access to systemadmin for the admin user. > I'm logging this initially against the Teiid side as depending on the resolution we may want to change the admin code (for example using a SYS.table). -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3376) SQL Server 2008/2012 - incompatible data types in comparison after cast/convert

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3376?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3376. --------------------------------- > SQL Server 2008/2012 - incompatible data types in comparison after cast/convert > ------------------------------------------------------------------------------- > > Key: TEIID-3376 > URL: https://issues.jboss.org/browse/TEIID-3376 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1 > Environment: OS: fedora 20 > java: oracle 1.7 > arch: x86_64 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.11 > > > If user want to cast/convert timestamp-value to time and then use it in comparison, Teiid throws an Exception: > "SQLServerException: The data types datetime and time are incompatible in the greater than operator." > Expected behavior: > The query should return correct result as the SQL Server is able to handle similar queries (teiid does not have any problem with same query with oracle, postgres, mysql,...) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3441) XMLParse should allow varbinary as well

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3441?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3441. --------------------------------- > XMLParse should allow varbinary as well > --------------------------------------- > > Key: TEIID-3441 > URL: https://issues.jboss.org/browse/TEIID-3441 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Minor > Fix For: 8.11 > > > XMLParse accepts blob and character types. It should also accept varbinary. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3058) Cassandra: cannot compare timestamp field in where clause

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3058?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3058. --------------------------------- > Cassandra: cannot compare timestamp field in where clause > ---------------------------------------------------------- > > Key: TEIID-3058 > URL: https://issues.jboss.org/browse/TEIID-3058 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7 > Environment: Cassandra with Teiid 8.7 > Reporter: Ivan Chan > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.9, 8.11 > > > It seems like Teiid is having problem to compare translate CQL if there is timestamp comparison in where clause: > ORIGINAL SQL: > select "cassandrads_sales"."product_family" as "cassandrads_sales_product_family", > "cassandrads_sales"."product_family" as "cassandrads_sales_product_family1" > from "cassandrads"."sales" "cassandrads_sales" > where "cassandrads_sales"."the_date" <= '2013-05-01 00:00:00' > limit 1000 > TRANSLATED CQL: > SELECT cassandrads.sales.product_family FROM cassandrads.sales WHERE cassandrads.sales.the_date <= {ts'2013-05-01 00:00:00.0'} LIMIT 1000 > And I got this error: > Caused by: org.teiid.translator.TranslatorException: line 1:55 no viable alternative at input '2013-05-01 00:00:0 > at org.teiid.translator.cassandra.CassandraQueryExecution.execute(CassandraQueryExecution.java:80) > at org.teiid.translator.cassandra.CassandraQueryExecution.execute(CassandraQueryExecution.java:72) > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:325) > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298) > at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:135) > If it is not possible to do time/ data comparison for CQL, maybe you guys should consider to do it in memory instead. Thanks. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2696) Update Teiid datasource examples to be fully parameterized

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2696?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2696. --------------------------------- > Update Teiid datasource examples to be fully parameterized > ---------------------------------------------------------- > > Key: TEIID-2696 > URL: https://issues.jboss.org/browse/TEIID-2696 > Project: Teiid > Issue Type: Enhancement > Components: Build/Kits > Affects Versions: 8.4.1 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Minor > Fix For: 8.4.1, 8.6 > > > Change the example datasources to be parameterized, and add an associated properties file so that to install, run: > jboss-cli.sh -c --file={datasource}-ds.cli --properties=/{datasource}-ds.properties -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3399) Greenplum is not in the translator list

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3399?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3399. --------------------------------- > Greenplum is not in the translator list > --------------------------------------- > > Key: TEIID-3399 > URL: https://issues.jboss.org/browse/TEIID-3399 > Project: Teiid > Issue Type: Quality Risk > Components: Server > Affects Versions: 8.4 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.7.1.6_2, 8.11 > > > Greenplum is not in the standalone xml. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3400) Oracle connection not consistently usable after cancel

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3400?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3400. --------------------------------- > Oracle connection not consistently usable after cancel > ------------------------------------------------------ > > Key: TEIID-3400 > URL: https://issues.jboss.org/browse/TEIID-3400 > Project: Teiid > Issue Type: Quality Risk > Components: Misc. Connectors > Affects Versions: 8.10 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.10.1, 8.11 > > > With TEIID-3275 we made use of cancel calls more to ensure that cleanup was happening as quickly as possible. However Oracle JDBC has a bug (independently reproducible outside Teiid) where if the cancelled statement does not reach the point of thrown an exception related to the cancel, then the next statement from that connection will throw the exception. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3302) Implement ST_Transform

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3302?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3302. --------------------------------- > Implement ST_Transform > ---------------------- > > Key: TEIID-3302 > URL: https://issues.jboss.org/browse/TEIID-3302 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Tom Arnold > Assignee: Steven Hawkins > Labels: spatial > Fix For: 8.11 > > > Implement [ST_Transform|http://postgis.org/docs/ST_Transform.html] system function. This would be used to transform geometry between different coordinate systems. This needs SPATIAL_REF_SYS table and a supporting library. > There are a couple of options for implementing this: > * http://trac.osgeo.org/proj4j/ - Port of the C library used by PostGIS. Fewest dependencies and should keep us close to PostGIS in capabilities. There will be a little boilerplate to interface with JTS. > * http://docs.geotools.org/latest/userguide/library/referencing/index.html - GeoTools referencing module. I think we would need to develop a simple plugin to interface with our SPATIAL_REF_SYS table. GeoTools is active and has good docs, but brings in a lot of dependencies. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2015