[teiid-commits] teiid SVN: r3399 - in branches/7.5.x: engine/src/main/java/org/teiid/dqp/internal/process and 1 other directories.

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