September 2012 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2187) Constraint parsing is incorrect

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2187: ------------------------------------- Summary: Constraint parsing is incorrect Key: TEIID-2187 URL: https://issues.jboss.org/browse/TEIID-2187 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.0 Environment: Constraint parsing should follow the pattern: ([CONSTRAINT name] ... | PRIMARY KEY ...)* rather than: CONSTRAINT <constraint list> Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.2 -- 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

11 years, 6 months

1
3
0 / 0

[JBoss JIRA] (TEIID-2220) Invalid aggregate pushing

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2220: ------------------------------------- Summary: Invalid aggregate pushing Key: TEIID-2220 URL: https://issues.jboss.org/browse/TEIID-2220 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.7 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.2 When a grouping is performed over a 3 way or higher join and aggregation appears to be eligible to be pushed to a leaf join, but a higher level join contains equi-join criteria where the side in the path of push aggregate target uses a join expression that spans a table not in the aggregate target, then an exception will be thrown during processing that the outside expression value cannot be found. For example: TEIID30328 Unable to evaluate t2.e3: No value was available at org.teiid.query.util.CommandContext.getFromContext(CommandContext.java:430) at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:617) at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:1021) at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:622) at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:1021) at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:622) at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:592) at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:270) at org.teiid.query.eval.Evaluator.evaluateTVL(Evaluator.java:210) at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:199) at org.teiid.query.processor.relational.JoinNode.matchesCriteria(JoinNode.java:312) -- 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

11 years, 6 months

2
6
0 / 0

[JBoss JIRA] (TEIID-2147) FileInputStreamFactory lobs may be inappropriately inlined

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2147: ------------------------------------- Summary: FileInputStreamFactory lobs may be inappropriately inlined Key: TEIID-2147 URL: https://issues.jboss.org/browse/TEIID-2147 Project: Teiid Issue Type: Feature Request Components: Query Engine Affects Versions: 7.6 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.1 The check for storage mode does not take into account if the outputstream is backed by the filestore, which means that it will report memory storage even for large lobs. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 6 months

2
6
0 / 0

[JBoss JIRA] (TEIID-2107) Key usage can convert an outer join into an inner join

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2107: ------------------------------------- Summary: Key usage can convert an outer join into an inner join Key: TEIID-2107 URL: https://issues.jboss.org/browse/TEIID-2107 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Critical Fix For: 8.1 If a left outer join is against a table/view with a index and the join is using all equi-join predicates and there is an additional predicate beyond what is in the index, then the join will be erroneously converted to an inner join. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 6 months

2
12
0 / 0

[JBoss JIRA] (TEIID-2086) Local result set cache is not transactionally consistent

by Steven Hawkins (JIRA)

11 years, 6 months

2
11
0 / 0

[JBoss JIRA] (TEIID-2087) Order by clause causes org.teiid.core.TeiidException

by Johnathon Lee (JIRA)

11 years, 6 months

3
26
0 / 0

[JBoss JIRA] (TEIID-2111) Teiid Stored Procedure should support variable length arguments

by Rajasekhar Kota (JIRA)

Rajasekhar Kota created TEIID-2111: -------------------------------------- Summary: Teiid Stored Procedure should support variable length arguments Key: TEIID-2111 URL: https://issues.jboss.org/browse/TEIID-2111 Project: Teiid Issue Type: Enhancement Components: Query Engine Affects Versions: 8.0, 7.7 Environment: Windows 7, Jboss 5.x + Teiid7.x Reporter: Rajasekhar Kota Assignee: Steven Hawkins We need extended support of Stored procedures with providing support of variable length arguments(vararg). It saves our efforts a lot in our current product. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 6 months

2
7
0 / 0

[JBoss JIRA] (TEIID-2197) Temp table ordering not honored with index

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2197: ------------------------------------- Summary: Temp table ordering not honored with index Key: TEIID-2197 URL: https://issues.jboss.org/browse/TEIID-2197 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Critical Fix For: 8.2 If an IN predicate against an index is not entered in ascending order and an order by is specified against the same index, then the result will not be ordered properly. For example: create local temporary table x (e1 string, e2 integer, primary key (e2)) ... select * from x as y where e2 in (3, 2) order by e2 -- 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

11 years, 6 months

1
3
0 / 0

[JBoss JIRA] (TEIID-2096) Colons need to be escaped

by Simon Green (JIRA)

Simon Green created TEIID-2096: ---------------------------------- Summary: Colons need to be escaped Key: TEIID-2096 URL: https://issues.jboss.org/browse/TEIID-2096 Project: Teiid Issue Type: Bug Environment: Fedora 17, bash, psql from Fedora repo Reporter: Simon Green Assignee: Steven Hawkins $ psql -h vdb.engineering.redhat.com -p 35432 -U sgreen -d EngVDBR Password for user sgreen: psql (9.1.4, server 8.1.4) WARNING: psql version 9.1, server version 8.1. Some psql features might not work. SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256) Type "help" for help. EngVDBR=> SELECT class, COUNT(*) FROM Bugzilla.audit_log GROUP BY class; class | count ---------------------------------------------------+------- Bugzilla::Component | 3686 Bugzilla::Extension::ExternalBugs::Bug | 3110 Bugzilla::Extension::ExternalBugs::Type | 4 Bugzilla::Extension::ExternalBugs::Type::Bugzilla | 1 Bugzilla::Extension::Releases::Release | 5 Bugzilla::Field | 27 Bugzilla::Field::Choice::cf_extra_component | 421 Bugzilla::Field::Choice::cf_extra_version | 20 Bugzilla::Field::Choice::cf_verified | 1 Bugzilla::FlagType | 89 Bugzilla::Group | 34 Bugzilla::Milestone | 81 Bugzilla::Product | 30 Bugzilla::Release | 66 Bugzilla::User | 3316 Bugzilla::Version | 79 (16 rows) EngVDBR=> SELECT * FROM Bugzilla.audit_log WHERE class = 'Bugzilla::Component' LIMIT 1; user_id | class | object_id | field | removed | added | at_time ---------+-------+-----------+-------+---------+-------+--------- (0 rows) EngVDBR=> SELECT * FROM Bugzilla.audit_log WHERE class = 'Bugzilla\:\:Component' LIMIT 1; user_id | class | object_id | field | removed | added | at_time ---------+---------------------+-----------+--------------+---------+--------+-- --------------------- 271726 | Bugzilla::Component | 91289 | initialowner | 173606 | 295575 | 2 012-05-19 19:33:15.0 (1 row) Question is. Why do the colons need to be backspaced to get a result? -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 6 months

4
9
0 / 0

[JBoss JIRA] (TEIID-2162) VDB attachements may get lost when using vdb imports

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2162: ------------------------------------- Summary: VDB attachements may get lost when using vdb imports Key: TEIID-2162 URL: https://issues.jboss.org/browse/TEIID-2162 Project: Teiid Issue Type: Bug Components: Server Affects Versions: 8.1 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.2 The CompositeVDB logic does not copy all attachments. It looks like the only affect now is that the classloader is not propagated, which may only be an issue for the JPA translator. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 6 months

2
3
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues September 2012