October 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3518) Add a print method for Virtual Procedures

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3518?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3518. --------------------------------- > Add a print method for Virtual Procedures > ----------------------------------------- > > Key: TEIID-3518 > URL: https://issues.jboss.org/browse/TEIID-3518 > Project: Teiid > Issue Type: Feature Request > Affects Versions: 8.11 > Reporter: Kylin Soong > Assignee: Steven Hawkins > > Add a function that Virtual Procedures can print line, like DBMS_OUTPUT.PUT_LINE in Oracle, this is useful for debug the Procedures. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3471) unable to consume odata service deployed in teiid

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3471?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3471. --------------------------------- > unable to consume odata service deployed in teiid > ------------------------------------------------- > > Key: TEIID-3471 > URL: https://issues.jboss.org/browse/TEIID-3471 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.7 > Reporter: Mark Drilling > Assignee: Ramesh Reddy > Labels: CR1 > Fix For: 8.7.1.6_2, 8.11 > > Attachments: deployment-exception.txt, MyVDB-vdb.xml, standalone-snippet.xml > > > I am unable to consume odata service created in teiid. > Steps to reproduce and files are attached. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3517) The oracle importer should offer an option to use integral types

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3517?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3517. --------------------------------- > The oracle importer should offer an option to use integral types > ---------------------------------------------------------------- > > Key: TEIID-3517 > URL: https://issues.jboss.org/browse/TEIID-3517 > Project: Teiid > Issue Type: Quality Risk > Components: JDBC Connector > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.11 > > > The oracle importer should have an option to map number fields with null or 0 decimal digits to an integral type wide enough to represent the precision. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3495) add ROUND() as supported function for DB2

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3495?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3495. --------------------------------- > add ROUND() as supported function for DB2 > ----------------------------------------- > > Key: TEIID-3495 > URL: https://issues.jboss.org/browse/TEIID-3495 > Project: Teiid > Issue Type: Feature Request > Components: JDBC Connector > Affects Versions: 8.7 > Reporter: Johnathon Lee > Assignee: Steven Hawkins > Fix For: 8.11 > > > DB2 translator can be updated to reflect the ROUND() function available on DB2 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3555) Like expression in select statement fails against Sybase

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3555?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3555. --------------------------------- > Like expression in select statement fails against Sybase > -------------------------------------------------------- > > Key: TEIID-3555 > URL: https://issues.jboss.org/browse/TEIID-3555 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 8.9.1 > Reporter: Bram Gadeyne > Assignee: Steven Hawkins > Fix For: 8.12 > > > Sometimes I use a like statement within the select statement to evaluate whether or not some text contains a certain sub-string. e.g: > > select outcome like '%died%' as died > from patients > > Some databases support this and return a boolean value but others (like sybase) don't. This results in an exception "Incorrect syntax near keyword 'like'" > > Would is be possible to rewrite this for Sybase (and maybe others) to something like: > select case when icuoutcomename like '%overleden%' then cast(1 as bit) else cast(0 as bit) end as mort > from patients > > I used cast(1 as bit) and cast(0 as bit) here because it seems like Sybase does not support true and false. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3368) The database-service.jar needs version version in its name

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3368?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3368. --------------------------------- > The database-service.jar needs version version in its name > ---------------------------------------------------------- > > Key: TEIID-3368 > URL: https://issues.jboss.org/browse/TEIID-3368 > Project: Teiid > Issue Type: Bug > Components: Tools > Affects Versions: 8.7.1, 8.11 > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 8.10 > > > The database-service.jar in the tepid-extensions needs to be built with a version in the name. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3300) Add SPATIAL_REF_SYS table

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3300?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3300. --------------------------------- > Add SPATIAL_REF_SYS table > ------------------------- > > Key: TEIID-3300 > URL: https://issues.jboss.org/browse/TEIID-3300 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Tom Arnold > Assignee: Steven Hawkins > Labels: spatial > Fix For: 8.11 > > > Implement SPATIAL_REF_SYS table (from the OGC Simple Features spec). This table stores metadata about different coordinate systems and how to tranform between them. See [here|http://en.wikipedia.org/wiki/SRID] and [here|http://www.carocoops.org/resources/doc/postgis/x321.html] for details. > {code} > CREATE TABLE SPATIAL_REF_SYS > ( > SRID INTEGER NOT NULL PRIMARY KEY, > AUTH_NAME CHARACTER VARYING(256), > AUTH_SRID INTEGER, > SRTEXT CHARACTER VARYING(2048) > ) > {code} > https://raw.githubusercontent.com/postgis/postgis/svn-trunk/spatial_ref_s... > This would be used in conjunction with the GeoTools referencing module or Proj4J to transform between coordinate systems in Teiid (ST_Transform function). -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3540) Salesforce translator returning duplicate records on querying with certain criteria

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3540?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3540. --------------------------------- > Salesforce translator returning duplicate records on querying with certain criteria > ----------------------------------------------------------------------------------- > > Key: TEIID-3540 > URL: https://issues.jboss.org/browse/TEIID-3540 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 8.10 > Reporter: Pranav K > Assignee: Steven Hawkins > Fix For: 8.11 > > > Salesforce translator is returning each record twice when I query over a view model which is made over a Salesforce source model. > Please find more details in the Steps to reproduce below. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3473) Selecting RAW(16) column via OData errors

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3473?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3473. --------------------------------- > Selecting RAW(16) column via OData errors > ----------------------------------------- > > Key: TEIID-3473 > URL: https://issues.jboss.org/browse/TEIID-3473 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.7 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 8.7.1.6_2, 8.11, 8.7.3 > > > When selecting a RAW(16) column via OData, a runtime error is thrown w/ the following message: > http://superdrake:8080/odata/Medbus/reqtracking.query?$format=json > { > "error": { > "code" : "ServerErrorException", > "message": { > "lang": "en-US", > "value": "[B cannot be cast to org.teiid.core.types.BinaryType" > } > } > } -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3543) Complex type values not resolved in translator execution

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3543?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3543. --------------------------------- > Complex type values not resolved in translator execution > -------------------------------------------------------- > > Key: TEIID-3543 > URL: https://issues.jboss.org/browse/TEIID-3543 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.11 > > > Embedded complex types do not have metadata associated and will fail to resolve resulting in an exception: > {code} > java.lang.RuntimeException: unknown property type: RMTSAMPLEFLIGHT.FlightDetails > at org.odata4j.format.xml.AtomFeedFormatParser.parseProperties(AtomFeedFormatParser.java:210) ~[odata4j-core-0.8.0-SNAPSHOT-redhat.jar:na] > {code} -- 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