June 2010 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-605) Push down query results different than MetaMatrix query results without push down - Oracle 11

by Warren Gibson (JIRA)

Push down query results different than MetaMatrix query results without push down - Oracle 11 ---------------------------------------------------------------------------------------------- Key: TEIID-605 URL: https://jira.jboss.org/jira/browse/TEIID-605 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 6.0.0 Environment: Running Teiid Server on Windows CTC Query testing client on Windows Reporter: Warren Gibson Assignee: Steven Hawkins This may not be a bug but may just be a decision point to determine if MetaMatrix should guarantee the same query results as if the query was pushed down to the source. In some cases different results can be expected from different DBMS sources. 1. Running Teiid Server with Console Extension Capability Class set to default (blank). 2. Run queries against Oracle 11 source. 3. Results show many examples where "nulls" are being handled differently in a push down ORDER BY situation than what our expected results reflect. 4. Basically in the Oracle 11 situation the "nulls" are showing up in the results just opposite from what MetaMatrix does. In other words in the following query "Select BQT1.SmallA.IntNum From BQT1.SmallA ORDER BY BQT1.SmallA.IntNum DESC" push down results shows "nulls" at the beginning of results whereas without push down MetaMatrix will show the "nulls" at the end of the results. 5. See attached results from this query. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 7 months

3
4
0 / 0

[JBoss JIRA] Created: (TEIID-816) XML-Relational File connector throws NPE.

by John Doyle (JIRA)

XML-Relational File connector throws NPE. ----------------------------------------- Key: TEIID-816 URL: https://jira.jboss.org/jira/browse/TEIID-816 Project: Teiid Issue Type: Bug Components: XML Connector Affects Versions: 6.2.0 Reporter: John Doyle Assignee: John Doyle Fix For: 6.2.0 The XML-Relational File connector is throwing an NPE on start up because the caching Boolean is null. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 7 months

2
3
0 / 0

[JBoss JIRA] Created: (TEIID-748) QueryRewriter null handling

by Steven Hawkins (JIRA)

QueryRewriter null handling --------------------------- Key: TEIID-748 URL: https://jira.jboss.org/jira/browse/TEIID-748 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 6.2.0 The rewriter changes several criteria fragments into true/false criteria ignoring the affect of nulls. i.e. pm1.g1.e1 like '%' is not same as 1 = 1 since null e1 values should not be allowed to pass. This is not a regression, but has been a problem since the switch to three valued logic. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 7 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-848) Insert with out of order variables and query expression is incorrect

by Steven Hawkins (JIRA)

Insert with out of order variables and query expression is incorrect -------------------------------------------------------------------- Key: TEIID-848 URL: https://jira.jboss.org/jira/browse/TEIID-848 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 6.3.0 For example: create local temporary table x (e1 string, e2 integer); insert into x (e2, e1) select e2, e1 from pm1.g1; would fail because we are simply rewriting to select e2, e1 into x from pm1.g1. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 7 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-799) String to boolean conversion should throw an exception

by Steven Hawkins (JIRA)

String to boolean conversion should throw an exception ------------------------------------------------------ Key: TEIID-799 URL: https://jira.jboss.org/jira/browse/TEIID-799 Project: Teiid Issue Type: Quality Risk Components: Query Engine Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 6.2.0 To be more inline with the sql spec. The string to boolean conversion should throw an exception rather than using the default Boolean.valueOf method when the input string is not one of 0,1,TRUE,FALSE,UNKNOWN. As it stands the method is inappropriately marked as non-narrowing and maps any non-true value to false. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 7 months

2
5
0 / 0

[JBoss JIRA] Created: (TEIID-811) Float/Double to BigInteger conversion bug

by Steven Hawkins (JIRA)

Float/Double to BigInteger conversion bug ----------------------------------------- Key: TEIID-811 URL: https://jira.jboss.org/jira/browse/TEIID-811 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 6.2.0 Float/Double values with toString forms in engineering notation will fail to convert correctly because of the truncation logic. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 7 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-828) Default of 20 code tables is too small

by Steven Hawkins (JIRA)

Default of 20 code tables is too small -------------------------------------- Key: TEIID-828 URL: https://jira.jboss.org/jira/browse/TEIID-828 Project: Teiid Issue Type: Quality Risk Components: Query Engine Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 6.2.0 The default of 20 code tables of 10000 rows each is easily exhausted. It would be better to have max code tables, max records, and max records per table setting, which would allow for more tables, while still being conservative in the overall number of tables allowed. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 7 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-797) The parser should use common conversion routines

by Steven Hawkins (JIRA)

The parser should use common conversion routines ------------------------------------------------ Key: TEIID-797 URL: https://jira.jboss.org/jira/browse/TEIID-797 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 6.2.0 The parser is using it's own logic for parsing escaped literals, it should instead use the common logic through DataTypeManager. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 7 months

2
2
0 / 0

[JBoss JIRA] Created: (TEIID-745) Ensure string parsing routines are consistent

by Steven Hawkins (JIRA)

Ensure string parsing routines are consistent --------------------------------------------- Key: TEIID-745 URL: https://jira.jboss.org/jira/browse/TEIID-745 Project: Teiid Issue Type: Quality Risk Components: Common, Query Engine Affects Versions: 6.0.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Minor Fix For: 6.2.0 String parsing strictness varies depending upon whether a convert or a parse function is used. In short we should: 1. Perform a trim prior to parsing (double and float converts already do this implicitly) 2. Use all non-whitespace characters in the parse string - the DateFormat, NumberFormat, and most of the convert methods allow for junk to appear after a successful parsing. 3. Time/Date/Timestamps should use non lenient parsing to disallow dates that are out of range, i.e. 2007-13-35 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 7 months

2
4
0 / 0

[JBoss JIRA] Closed: (TEIID-162) Delete and update support in temp table

by Steve Hawkins (JIRA)

[ https://jira.jboss.org/browse/TEIID-162?page=com.atlassian.jira.plugin.sy... ] Steve Hawkins closed TEIID-162. ------------------------------- > Delete and update support in temp table > --------------------------------------- > > Key: TEIID-162 > URL: https://jira.jboss.org/browse/TEIID-162 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 8.x > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 7.0 > > > Defect Tracker #23925: Delete and update are currently not supported in temp table. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 7 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues June 2010