From teiid-commits at lists.jboss.org Thu Aug 18 21:18:38 2011
Content-Type: multipart/mixed; boundary="===============7163305948968747603=="
MIME-Version: 1.0
From: teiid-commits at lists.jboss.org
To: teiid-commits at lists.jboss.org
Subject: [teiid-commits] teiid SVN: r3399 - in branches/7.5.x:
engine/src/main/java/org/teiid/dqp/internal/process and 1 other directories.
Date: Thu, 18 Aug 2011 21:18:38 -0400
Message-ID: <201108190118.p7J1IcUS024075@svn01.web.mwc.hst.phx2.redhat.com>
--===============7163305948968747603==
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Author: shawkins
Date: 2011-08-18 21:18:37 -0400 (Thu, 18 Aug 2011)
New Revision: 3399
Modified:
branches/7.5.x/build/kits/jboss-container/teiid-releasenotes.html
branches/7.5.x/engine/src/main/java/org/teiid/dqp/internal/process/DQPCo=
re.java
branches/7.5.x/engine/src/main/java/org/teiid/dqp/internal/process/Sessi=
onAwareCache.java
branches/7.5.x/engine/src/main/java/org/teiid/query/tempdata/TempTableDa=
taManager.java
Log:
forward merge and update of the release notes
Modified: branches/7.5.x/build/kits/jboss-container/teiid-releasenotes.html
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- branches/7.5.x/build/kits/jboss-container/teiid-releasenotes.html 2011-=
08-19 01:07:56 UTC (rev 3398)
+++ branches/7.5.x/build/kits/jboss-container/teiid-releasenotes.html 2011-=
08-19 01:18:37 UTC (rev 3399)
@@ -10,7 +10,7 @@
![3D"Teiid"](3D"https://www.jboss.org/dms=)
=
Teiid ${project.version} Release Notes
-Teiid ${project.version} adds performance, integration, and runtime met=
adata update features. =
+
Teiid ${project.version} adds XML streaming, additional ANSI SQL, and i=
ntegration features. =
=
Overview
@@ -224,7 +224,221 @@
=
Detailed Release Notes - Teiid - Version ${project.version}
+ Bug
+
+
+- [TEIID-97] - =
add proper SQLState for timeout/cancel
+
+- [TEIID-1443=
] - SalesForce connector execution of procedure fails with NPE
+
+- [TEIID-1528=
] - ruleimplementjoin strategy may generate an order by that does n=
ot use a relevant index
+
+- [TEIID-1591=
] - Error thrown when attempting to use clustered cache in teiid 7.4
+
+- [TEIID-1592=
] - EventDistributor is not initialized correctly
+
+- [TEIID-1593=
] - Creating a temp table gets error that Cannot create temporary t=
able "dddd". A table with the same name already exists.
+
+- [TEIID-1595=
] - User without required role is able to explicitly create a tempo=
rary table
+
+- [TEIID-1597=
] - Index metadata issues
+
+- [TEIID-1603=
] - BQT Query not returning expected row count
+
+- [TEIID-1605=
] - Unable to call a function that is defined within a package in o=
racle
+
+- [TEIID-1612=
] - Tried a custom log appended, but the LoggingEvent.getMessage() =
returns org.teiid.logging.LogMessage and not org.teiid.logging.CommandLogMe=
ssage
+
+- [TEIID-1613=
] - Cannot define an implicit temp table with columns and a query v=
alue expression
+
+- [TEIID-1614=
] - Embedded connections using the calling thread can hang
+
+- [TEIID-1616=
] - ORDER BY not ordering query results on Teradata query: SELECT=
DoubleNum AS E FROM VQT.U5 ORDER BY E =
+
+- [TEIID-1617=
] - Incorrect rewrite of subquery
+
+- [TEIID-1618=
] - Designer (JBDS 4.1 CR1) not able to preview: NPE
+
+- [TEIID-1621=
] - Unexpected grouping for SELECT queries on views that include a =
GROUP BY
+
+- [TEIID-1623=
] - ODBC numeric and string precision issues
+
+- [TEIID-1625=
] - SalesForce INCLUDE function not being pushed to source
+
+- [TEIID-1626=
] - Subsequent usage of a statement cannot be timed out
+
+- [TEIID-1628=
] - Mondrian not returning the correct row values for the "ROW=
" dimention
+
+- [TEIID-1630=
] - XQT queries failing with: [TeiidProcessingException] 1054: Err=
or Code:1054 Message:Source: Error Code:1054 Message:'Unknown column &#=
39;c_2' in 'order clause'
+
+- [TEIID-1631=
] - ODBC SQLDescribeCol does not work, When used with the Prepare S=
tatement
+
+- [TEIID-1634=
] - For file connector-based queries, please provide a DEBUG warnin=
g if no files are found
+
+- [TEIID-1635=
] - Error resolving a procedure invocation w/o a resultset in a pro=
cedure
+
+- [TEIID-1639=
] - Unable to build on a file system that isn't formatted to su=
pport case-sensitivity
+
+- [TEIID-1640=
] - QueryTimeout connection parameter does not cancel long-running =
queries
+
+- [TEIID-1641=
] - In org.teiid.jdbc.StatementImpl, as there have been no batched =
updates the batchedUpdates member hasn't been instantiated so clearBatc=
h() throws a NPE. =
+
+- [TEIID-1642=
] - ModeShape translator needs to be changed to move the supported =
functions to the pushdown functions so that the function def. file isn'=
t needed to be updated
+
+- [TEIID-1645=
] - SELECT COUNT(*) FROM VQT.Agg3 is expecting a result of 1 but 50=
is being returned
+
+- [TEIID-1647=
] - TeiidComponentException from generated web service
+
+- [TEIID-1650=
] - hsql does not generally support catalog identifier parts
+
+- [TEIID-1651=
] - Due to a change in the JDBC spec on how the use of "AS&quo=
t; in the select statement will now be returned in the getColumnLabel of th=
e ResultSetMetadata, Teiid must provide backwards support =
+
+- [TEIID-1654=
] - CLONE - EDS - Node returns 0 rows for cached view when other no=
de had it loaded and leaves cluster
+
+- [TEIID-1657=
] - CLONE - EDS - refreshMatView does not work correctly for an int=
ernal materialized view when clustering is enabled
+
+- [TEIID-1658=
] - teiid-jdbc-template-ds.xml jca example is in trunk, but also ne=
eds to be on 7.4.x branch
+
+- [TEIID-1660=
] - EDS BQT Queries failing on SqlServer 2005 with SQLServerExcepti=
on "Type DATE is not a defined system type"
+
+- [TEIID-1661=
] - Not all expression types are validated for grouping columns
+
+- [TEIID-1662=
] - Teiid fails when calling databasemetadata.getTables and passing=
in a empty array for table types
+
+- [TEIID-1663=
] - Local Transactions not working
+
+- [TEIID-1664=
] - Teiid - Teradata queries containing LTRIM and RTRIM on the BQT =
booleanvalue column are returning unexpected BQT results
+
+- [TEIID-1676=
] - Decomposed aggregates results can be wrong
+
+- [TEIID-1677=
] - Exists subqueries will unnest by default
+
+- [TEIID-1678=
] - Order by may be applied incorrectly with pushed aggregate
+
+- [TEIID-1681=
] - Limit not working as expected
+
+- [TEIID-1682=
] - Sort optimization with grouping does not preserve descending/nu=
ll ordering
+
+- [TEIID-1683=
] - Error Code:0 Message: Remote org.teiid.core.TeiidException:Erro=
r Code: 0 Message:Symbol EMAIL.EMAILDOCUMENT.MAPPINGCLASSES.EMAIL_1.id is s=
pecified with an unknown group context
+
+- [TEIID-1686=
] - Assertion failure when using a plan result buffer
+
+- [TEIID-1688=
] - Derby is inappropriately picking up capabilities
+
+- [TEIID-1690=
] - NPE with xmltable in view
+
+- [TEIID-1695=
] - CLONE - java.lang.ClassNotFoundException: nu.xom.ParsingExcepti=
on via Import > Teiid Designer > WSDL into Relational Source Model
+
+- [TEIID-1696=
] - Issues with function schema qualification
+
+- [TEIID-1697=
] - CLONE - java.io.NotSerializableException: java.io.PrintWriter w=
hen SHOWPLAN is DEBUG in a clustered configuration
+
+- [TEIID-1698=
] - + is not properly handled in like patterns
+
+- [TEIID-1704=
] - if where clause contains more than one equal condition on the s=
ame column, no rows are returned for the count query
+
+- [TEIID-1706=
] - JOIN between two text file data sources extremely slow
+
+- [TEIID-1708=
] - Teiid Designer Preview Feature does not refresh if a transforma=
tion is changed on a procedure
+
+- [TEIID-1713=
] - default xmlnamespace fails to match root element when streaming =
+
+- [TEIID-1717=
] - NPE with texttable join
+
+- [TEIID-1718=
] - Object type is not handled well in ODBC
+
+- [TEIID-1719=
] - Executing an SQL statement over ODBC interface does not respond
+
+- [TEIID-1721=
] - ODBC metadata handling does not account for update statements
+
+- [TEIID-1722=
] - NPE with lookup function
+
+
+ =
+ Enhancement
+
+
+- [TEIID-1586=
] - Increase audit information
+
+- [TEIID-1587=
] - Minimize final project columns
+
+- [TEIID-1601=
] - When the webservice translator cannot reach the endpoint url, t=
he exception message should include the endpoint =
+
+- [TEIID-1602=
] - Add support for like_regex and other regex functions
+
+- [TEIID-1611=
] - Add reauthentication support for ODBC
+
+- [TEIID-1637=
] - In the Reference guide - Query Timeouts section - add a referen=
ce to the Client Developers guide
+
+- [TEIID-1652=
] - ODBC Data Row results should be batched
+
+- [TEIID-1656=
] - Add pushdown support for grouping expression over a UNION
+
+- [TEIID-1671=
] - Add Translator for Netzza
+
+- [TEIID-1691=
] - Improve xml staging table planning
+
+- [TEIID-1694=
] - Add additional ansi sql function support
+
+- [TEIID-1712=
] - Support different length records in files for modeling =
+
+
+ =
+ Feature Request
+
+
+- [TEIID-993] =
- Enhance XML processing to execute relational queries in parallel =
when possible
+
+- [TEIID-1448=
] - XMLTABLE processing should support streaming when possible
+
+- [TEIID-1460=
] - Have teiid emulate a native postgresql database connection
+
+- [TEIID-1585=
] - Make payload available in ExecutionFactory.getConnection
+
+- [TEIID-1607=
] - Provide a data role injection point where a different implement=
ation could be used for role validation
+
+- [TEIID-1615=
] - Add features to support relate planning
+
+- [TEIID-1620=
] - Fetch keyword not handled
+
+- [TEIID-1632=
] - Provide something like an ECHO statement in the procedure langu=
age that can assist a user in debugging their procedure logic =
+
+- [TEIID-1653=
] - Support Cursoring over ODBC protocol ( support UseDeclareFetch =
=3D 1)
+
+- [TEIID-1659=
] - Support pagination of LDAP results when retrieving from Active =
Directory
+
+- [TEIID-1665=
] - Optimize SELECT of all constants
+
+- [TEIID-1667=
] - Add support for sql olap functionality
+
+- [TEIID-1689=
] - Load internal mateirlized view cached contents when node joins =
the cluster
+
+- [TEIID-1692=
] - Include an example of the LOOKUP function in the Ref Guide
+
+
=
+ Quality Risk
+
+
+- [TEIID-1619=
] - Deprecate MAKEDEP/MAKENOTDEP keyword hints
+
+- [TEIID-1624=
] - Remove the buffer space configuration settings that deal with b=
atch columns
+
+- [TEIID-1715=
] - Simplify ODBC buffers
+
+
+ =
+ Task
+
+
+- [TEIID-1594=
] - Add to the sandox the example Coherence translator and connector
+
+- [TEIID-1655=
] - CLONE - Error messages displayed in the transformation editor a=
re often too generic or too long to be useful
+
+- [TEIID-1693=
] - Update Teiid Admin Console Documentation
+
+
+ =
=
The Teiid community project is=
hosted on jboss.org.
Modified: branches/7.5.x/engine/src/main/java/org/teiid/dqp/internal/proces=
s/DQPCore.java
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- branches/7.5.x/engine/src/main/java/org/teiid/dqp/internal/process/DQPC=
ore.java 2011-08-19 01:07:56 UTC (rev 3398)
+++ branches/7.5.x/engine/src/main/java/org/teiid/dqp/internal/process/DQPC=
ore.java 2011-08-19 01:18:37 UTC (rev 3399)
@@ -750,7 +750,9 @@
}
Set keys =3D this.matTables.replicatableKeys();
for (final CacheID key:keys) {
- refreshMatView(contextProvider, key.getVDBKey().getName(), key.ge=
tVDBKey().getVersion(), key.getSql());
+ if (key.getSql().startsWith(RelationalPlanner.MAT_PREFIX)) {
+ refreshMatView(contextProvider, key.getVDBKey().getName(), key.g=
etVDBKey().getVersion(), key.getSql().substring(RelationalPlanner.MAT_PREFI=
X.length()));
+ }
}
}
=
Modified: branches/7.5.x/engine/src/main/java/org/teiid/dqp/internal/proces=
s/SessionAwareCache.java
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- branches/7.5.x/engine/src/main/java/org/teiid/dqp/internal/process/Sess=
ionAwareCache.java 2011-08-19 01:07:56 UTC (rev 3398)
+++ branches/7.5.x/engine/src/main/java/org/teiid/dqp/internal/process/Sess=
ionAwareCache.java 2011-08-19 01:18:37 UTC (rev 3399)
@@ -38,6 +38,7 @@
import org.teiid.cache.CacheConfiguration.Policy;
import org.teiid.common.buffer.BufferManager;
import org.teiid.core.types.DataTypeManager;
+import org.teiid.core.util.Assertion;
import org.teiid.core.util.EquivalenceUtil;
import org.teiid.core.util.HashCodeUtil;
import org.teiid.logging.LogConstants;
@@ -238,6 +239,7 @@
}
=
public CacheID(ParseInfo pi, String sql, String vdbName, int vdbVersion,=
String sessionId, String userName){
+ Assertion.isNotNull(sql);
this.sql =3D sql;
this.vdbInfo =3D new VDBKey(vdbName, vdbVersion);
this.pi =3D pi;
Modified: branches/7.5.x/engine/src/main/java/org/teiid/query/tempdata/Temp=
TableDataManager.java
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
--- branches/7.5.x/engine/src/main/java/org/teiid/query/tempdata/TempTableD=
ataManager.java 2011-08-19 01:07:56 UTC (rev 3398)
+++ branches/7.5.x/engine/src/main/java/org/teiid/query/tempdata/TempTableD=
ataManager.java 2011-08-19 01:18:37 UTC (rev 3399)
@@ -559,7 +559,7 @@
TupleSource ts =3D null;
CacheID cid =3D null;
if (distributedCache !=3D null) {
- cid =3D new CacheID(new ParseInfo(), viewName, context.getVdbName(), =
+ cid =3D new CacheID(new ParseInfo(), fullName, context.getVdbName(), =
context.getVdbVersion(), context.getConnectionID(), context.getUserN=
ame());
if (useCache) {
CachedResults cr =3D this.distributedCache.get(cid);
--===============7163305948968747603==--