March 2013 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2308) Enhance reusable execution semantics to support throwing DataNotAvailable from reset method

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2308?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2308. --------------------------------- > Enhance reusable execution semantics to support throwing DataNotAvailable from reset method > ------------------------------------------------------------------------------------------- > > Key: TEIID-2308 > URL: https://issues.jboss.org/browse/TEIID-2308 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 8.2 > Reporter: Mark Addleman > Assignee: Steven Hawkins > Labels: 8.2.0.Final > Fix For: 8.2 > > > reset() can throw DataNotAvailable. Execution will resume at reset() method > reset() should only be called once. > Details, see https://community.jboss.org/message/773483#773483 -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years

1
0
0 / 0

[JBoss JIRA] (TEIID-2178) aggregate functions fails with subquery argument

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2178?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2178. --------------------------------- > aggregate functions fails with subquery argument > ------------------------------------------------ > > Key: TEIID-2178 > URL: https://issues.jboss.org/browse/TEIID-2178 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.2 > > > If a subquery is used as an argument to a aggregate function - max((select...)) - the subquery is not planned and will fail to execute. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years

1
0
0 / 0

[JBoss JIRA] (TEIID-2237) jdbc native query issues

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2237?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2237. --------------------------------- > jdbc native query issues > ------------------------ > > Key: TEIID-2237 > URL: https://issues.jboss.org/browse/TEIID-2237 > Project: Teiid > Issue Type: Bug > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.2 > > > A non-prepared procedure only works if the procedure has no parameters. It should be allowed to work even with parameters through literal substitution. > Also the parsing loop incorrectly increments the parsing position after a match. This means that the character after a positional reference is lost. The workaround for typical scenarios would be to use extra whitespace. i.e. > instead of {code}select * from tbl where x = $1 and y = $2{code} > use {code}select * from tbl where x = $1 and y = $2{code} > Note the extra space after $1. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years

1
0
0 / 0

[JBoss JIRA] (TEIID-2184) Locale issues

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2184?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2184. --------------------------------- > Locale issues > ------------- > > Key: TEIID-2184 > URL: https://issues.jboss.org/browse/TEIID-2184 > Project: Teiid > Issue Type: Quality Risk > Components: Common > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.2 > > > Some tests are specific to the en us locale. Also the monthname and dayname functions are hard coded to en, which is not consistent with our default logic of relying on the system locale for parse/format handling. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years

1
0
0 / 0

[JBoss JIRA] (TEIID-2004) Support 1.7 JDBC methods

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2004?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2004. --------------------------------- > Support 1.7 JDBC methods > ------------------------ > > Key: TEIID-2004 > URL: https://issues.jboss.org/browse/TEIID-2004 > Project: Teiid > Issue Type: Task > Components: JDBC Driver > Affects Versions: 8.0 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.0 > > > To build against a 1.7 VM without retarging to a 1.6 runtime for the Java libraries requires that we update our JDBC logic to add missing methods. Most will likely still not be supported and will throw a SQLFeatureUnsupported exception where appropriate. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years

1
0
0 / 0

[JBoss JIRA] (TEIID-2259) Error executing CASE WHEN THEN ELSE END statement

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2259?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2259. --------------------------------- > Error executing CASE WHEN THEN ELSE END statement > ------------------------------------------------- > > Key: TEIID-2259 > URL: https://issues.jboss.org/browse/TEIID-2259 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 7.7 > Environment: Running Teiid 8.1 embedded version on Windows > Reporter: Ivan Chan > Assignee: Steven Hawkins > Fix For: 8.2 > > Attachments: stacktrace.txt, vds.txt > > > Error executing CASE WHEN THEN ELSE END statement with boolean expression in the WHEN clause -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years

1
0
0 / 0

[JBoss JIRA] (TEIID-2176) Expose invoke procedures for querable sources

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2176?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2176. --------------------------------- > Expose invoke procedures for querable sources > --------------------------------------------- > > Key: TEIID-2176 > URL: https://issues.jboss.org/browse/TEIID-2176 > Project: Teiid > Issue Type: Sub-task > Components: Misc. Connectors > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Fix For: 8.2 > > > We should add procedures similar to invokeMDX that allow native query execution. This would compliment the canned native-query feature to allow fully dynamic query execution. > TEIID-2111 will also provide vararg capabilities should we need it. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years

1
0
0 / 0

[JBoss JIRA] (TEIID-2202) Incorrect aggregate rewriting on DB2/AS400 using UDF

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2202?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2202. --------------------------------- > Incorrect aggregate rewriting on DB2/AS400 using UDF > ---------------------------------------------------- > > Key: TEIID-2202 > URL: https://issues.jboss.org/browse/TEIID-2202 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector, Query Engine > Affects Versions: 7.7.1 > Reporter: Hisanobu Okuda > Assignee: Steven Hawkins > Fix For: 8.2 > > > When I run the following query, the count(*) in the middle inline view, gets rewritten as a sum and a count in the most inner inline view. This has something to do with my the parseDate_ UDF. This is a change from EDS 5.2 where it worked correctly. I've included logs from both for contrast. > Query: > {code} > SELECT > examiner, > exam_date, > exam_date_code, > num_claims, > company_id, > 1 AS enterprise_id > FROM > ( > SELECT > examiner, > parseDate_(exam_date_code) AS exam_date, > exam_date_code, > company_id, > COUNT(*) AS num_claims > FROM > ( > SELECT > CASE > WHEN (ME4.ADJUSR <> ' ') > AND (ME4.APRUSR <> ' ') > THEN > CASE > WHEN ME4.APRDAT >= ME4.ADJDAT > THEN ME4.APRUSR > ELSE ME4.ADJUSR > END > WHEN (ME4.APRUSR <> ' ') > AND (ME4.ADJUSR = ' ') > THEN ME4.APRUSR > WHEN (ME4.APRUSR = ' ') > AND (ME4.ADJUSR <> ' ') > THEN ME4.ADJUSR > ELSE MED.ADJUSR > END AS examiner, > CASE > WHEN (ME4.ADJUSR <> ' ') > AND (ME4.APRUSR <> ' ') > THEN > CASE > WHEN ME4.APRDAT >= ME4.ADJDAT > THEN ME4.APRDAT > ELSE ME4.ADJDAT > END > WHEN (ME4.APRUSR <> ' ') > AND (ME4.ADJUSR = ' ') > THEN ME4.APRDAT > WHEN (ME4.APRUSR = ' ') > AND (ME4.ADJUSR <> ' ') > THEN ME4.ADJDAT > ELSE MED.LSTCHG > END AS exam_date_code, > CONVERT(MED.COMPNO, INTEGER) AS company_id > FROM > FCC.MEDMAS AS MED > INNER JOIN > FCC.ME4MAS AS ME4 > ON > MED.BRANCD = ME4.BRANCD > AND MED.BATDAT = ME4.BATDAT > AND MED.BATSEQ = ME4.BATSEQ > AND MED.SEQNUM = ME4.SEQNUM > WHERE > (MED.SYSDAT >= curdate_('-11 months 1st day')) > AND (MED.LINENO = 1) > AND (MED.STATCD <> 'O') > AND ((ME4.ADJUSR <> ' ') > OR (ME4.APRUSR <> ' ') > OR (MED.ADJUSR <> ' '))) AS Event > GROUP BY > Event.examiner, > Event.exam_date_code, > Event.company_id) AS Count_By_Examiner_ID > {code} -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years

1
0
0 / 0

[JBoss JIRA] (TEIID-2302) Issues setting up Teiid as an XA datasource in AS 7

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2302?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2302. --------------------------------- > Issues setting up Teiid as an XA datasource in AS 7 > --------------------------------------------------- > > Key: TEIID-2302 > URL: https://issues.jboss.org/browse/TEIID-2302 > Project: Teiid > Issue Type: Bug > Components: Build/Kits > Affects Versions: 8.2 > Reporter: Van Halbert > Assignee: Steven Hawkins > Fix For: 8.3 > > > Ran across 2 issues when trying to setup Teiid as a XA data source based on the teiid-xa-ds.zml in the jboss kit: docs/teiid/datasources/teiid/teiid-xa-ds.xml > 1 - ClassNotFound for the org.hibernate.dialect.Dialect, so added: > <module name="org.hibernate"/> > to the teiid/client/main/module.xml > 2 - seeing this error: TEIID10006 Decryption failed: java.lang.ClassNotFoundException org.teiid.client.util.ExceptionHolder from [Module "org.jboss.jts:main" but that was resolved after I changed security from: > <security> > <user-name>user</user-name> > <password>user</password> > </security> > to: > <xa-datasource-property name="User"> > user > </xa-datasource-property> > <xa-datasource-property name="Password"> > user > </xa-datasource-property> -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years

1
0
0 / 0

[JBoss JIRA] (TEIID-2164) PermissionMap does not aggregate all permission types

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2164?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2164. --------------------------------- > PermissionMap does not aggregate all permission types > ----------------------------------------------------- > > Key: TEIID-2164 > URL: https://issues.jboss.org/browse/TEIID-2164 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.4 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.2 > > > If multiple permission entries are used per resource path and the prior entries have alter or execute set, then those permissions will be lost. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues March 2013