[teiid-commits] teiid SVN: r3174 - trunk/build/kits/jboss-container.

Author: shawkins Date: 2011-05-13 15:17:14 -0400 (Fri, 13 May 2011) New Revision: 3174 Modified: trunk/build/kits/jboss-container/teiid-releasenotes.html Log: scrubbing release notes for 7.5 Modified: trunk/build/kits/jboss-container/teiid-releasenotes.html =================================================================== --- trunk/build/kits/jboss-container/teiid-releasenotes.html 2011-05-13 19:14:08 UTC (rev 3173) +++ trunk/build/kits/jboss-container/teiid-releasenotes.html 2011-05-13 19:17:14 UTC (rev 3174) @@ -25,38 +25,6 @@ <LI><A HREF="#About">About JBoss</A> </UL> <H2><A NAME="Highlights"></A>Highlights</H2> -<UL> - <LI><B>Virtual procedure out params</B> - virtual procedures can now have RETURN/OUT/INOUT parameters to return values. - <LI><B>OLAP</B> - OLAP translator is now part of Teiid kit using OLAP4J - <LI><B>Multi-source procedures</B> - multi-source handling was expanded to cover stored procedure execution. See the Reference for more. - <LI><B>Function Support</B> - additional system functions were made available. - <UL> - <LI><B>uuid</B> was added to generate type 4 UUIDs and the Hibernate dialect was updated to support the GUIDGenerator. - <LI><B>array_get</B> was added to extract values from java.sql.Array or java array values. - <LI><B>array_length</B> was added to get the length of java.sql.Array or java array values. - </UL> - <LI><B>ARRAYTABLE</B> - the ARRAYTABLE table function was added to simplify array value extraction into a tabular format. - <LI><B>Ingres</B> - Ingres database translator is now available to use as supported source under Teiid. - <LI><B>Optional Join Enhancements</B> - the optional join hint no longer requires the use of ANSI joins and can will not remove optional bridging tables that are used by two other tables that are required. - <LI><B>InterSystems Cache</B> - InterSystems Cache database translator is now available to use as supported source under Teiid. - <LI><B>userRequestSourceConcurrency</B> - was added to control the number of concurrent source queries allowed for each user request. - <LI><B>Memory Management Improvements</B> - maxReserveBatchColumns and maxProcessingBatchesColumns will be default be determined automatically and will more reliably prevent memory issues. See the admin guide for more. - <LI><B>Subquery optimization control</B> - added the MJ and NO_UNNEST hints and the org.teiid.subqueryUnnestDefault system property to control the optimization of subqueries to traditional joins or to a merge join implementation of a semijoin or antijoin. - <LI><B>Local connection threads</B> - local connection calling threads will be used to process work rather than using an engine thread. This helps decouple the configuration of maxThreads. - <LI><B>Dependent Join Improvements</B> - several major improvements were made to increase performance and develop better plans. - <UL> - <LI><B>Improved Planning</B> - the decision to create a dependent join is now considered earlier in planning and is much more effective for dependent joins involving multiple unrelated independent tables. - <LI><B>IN predicate splitting</B> - the planner can now split large dependent IN predicates into multiple IN predicates, which is controlled by the translator property MaxDepdendentInPredicates. This allows for much larger dependent joins to be performed as a single query. - <LI><B>Dependent query parallelization</B> - when multiple dependent queries are still required, then they will be run in parallel (up to MaxUserSourceRequestConcurrency), rather than sequentially. - <LI><B>Cost based back-off</B> - for cost based dependent joins if the number of independent values is too large, then the join will be performed as normal. - </UL> - <LI><B>Enhanced Sort Join</B> - the partitioned merge join was replaced with an enhanced sort join. The enhanced sort join will use the actual row counts from each side of the relation to perform a index based join if one side is small enough, a partial sort of the larger side and a repeated merge join if the tuples are unbalanced but one side is not small enough to form an index, or a standard sort merge join if the tuples are balanced. - <LI><B>JDK1.5 JDBC Client JAR</B> - A retro-translated Teiid client JDBC jar now available to use with JDK 1.5 VM. Note only the JDBC API is supported, not the Admin API, or retrieving query plans as XML. - <LI><B>Security Improvements</B> - UDF and pushdown functions can now be protected with data roles. Also the CommandContext can provide the Subject for custom security checks in UDFs. - <LI><B>Cache Invalidation</B> - Prepared plan and result set caches have will invalidate entries based upon metadata and data changes respectively. See the cache configuration maxStaleness setting and the Admin and Developer Guides for more. - <LI><B>Runtime Updates of Metadata</B> - ALTER statements have been added to change view/procedure/INSTEAD OF trigger (update procedure) definitions. A CREATE TRIGGER statement is also available to add an INSTEAD OF trigger (update procedures) to views. - System procedures were added to set extension metadata and stat values. By default all effects of metadata updates happen only on running vdbs across the cluster. To make the changes persistent see the Developers Guide Runtime Updates section. -</UL> <h2><a name="Compatibility">Compatibility Issues</a></h2> <ul> @@ -216,267 +184,7 @@ <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-99'>TEIID-99</a>] - Stored procedures should work in multisource connector binding scenarios -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1163'>TEIID-1163&l...>] - Provide LOB support in ODBC -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1164'>TEIID-1164&l...>] - Getting the Procedure Parameter metadata is not supported in ODBC -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1432'>TEIID-1432&l...>] - Getting SocketTimeout Exceptions on long running queries with CXF -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1458'>TEIID-1458&l...>] - Wrong count(*) result when joining data from two models -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1466'>TEIID-1466&l...>] - MySQL syntax error in cast from date to timestamp -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1467'>TEIID-1467&l...>] - Procedures in Teiid are not Resolvable if Their Models are Marked as Not Visible -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1469'>TEIID-1469&l...>] - EDS Teiid Plugin uses Invalid Datatype Mask for SessionID Parameter to Terminate Session Operation -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1470'>TEIID-1470&l...>] - Deploying VDB XML file before data sources leads to failed deployment -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1476'>TEIID-1476&l...>] - correct preventable exceptions -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1478'>TEIID-1478&l...>] - various jdbc import issues -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1479'>TEIID-1479&l...>] - Teiid Documentation does not include MS SQL Server as an available translator in section 10.2.2. JDBC Translator of the Reference Guide -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1480'>TEIID-1480&l...>] - Teiid&#39;s ODBC interaction with PostgreSQL-ODBC fails when column lengths exceed 64K as PostgreSQL stores these values as a short -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1488'>TEIID-1488&l...>] - EDS adminshell fails to connect to server with IBM JDK -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1489'>TEIID-1489&l...>] - Teiid assumes fqns in transformations, but they are no longer required to be there -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1492'>TEIID-1492&l...>] - StackOverflowError in DefaultCache -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1498'>TEIID-1498&l...>] - Incorrect rewrite of not disjunctive criteria -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1502'>TEIID-1502&l...>] - ODBC (and admin) scalability limited by maxWorker cap -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1503'>TEIID-1503&l...>] - Exception during Optimization -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1504'>TEIID-1504&l...>] - Internal Materialization does not honor the cache hint -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1505'>TEIID-1505&l...>] - MaxActivePlans is not being read from the configuration -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1506'>TEIID-1506&l...>] - ODBC Driver reporting BigInteger, BigDecimal columns as Strings -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1511'>TEIID-1511&l...>] - VDB deployment leaves with too many open files -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1512'>TEIID-1512&l...>] - show plan statement clob isn&#39;t readable -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1515'>TEIID-1515&l...>] - ODBC does not report primarykeys on the tables -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1516'>TEIID-1516&l...>] - IS_NULLABLE is reported incorrectly for columns -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1521'>TEIID-1521&l...>] - Dynamic vdb import logic error with procedures -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1523'>TEIID-1523&l...>] - Dynamic sql failure with null procedure parameters -</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-1529'>TEIID-1529&l...>] - LIMIT not pushed down for queries with subselects and ORDER BY -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1530'>TEIID-1530&l...>] - ODBC identifer matching issues -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1531'>TEIID-1531&l...>] - ODBC charset issues -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1532'>TEIID-1532&l...>] - ODBC prepared statement handling can hang -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1534'>TEIID-1534&l...>] - The driver incorrectly reports column labels as column names -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1537'>TEIID-1537&l...>] - Error loading older cached metadata -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1538'>TEIID-1538&l...>] - Invalid conversion from type class java.lang.Object with value &#39;oracle.sql.ROWID@1379cbd&#39; to type class java.lang.String -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1545'>TEIID-1545&l...>] - Order By not pushed down -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1548'>TEIID-1548&l...>] - Creating XA data sources from AdminShell: prop name &quot;addtional-ds-properties&quot; has misspelling - could cause confusion -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1549'>TEIID-1549&l...>] - aggregate unrelated order by error -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1553'>TEIID-1553&l...>] - UDF Function model fails to load when it located inside a folder in the VDB -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1554'>TEIID-1554&l...>] - NullPointerException in NodeEditor -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1555'>TEIID-1555&l...>] - NPE on server when admin-console requests for the &quot;vdb requests&quot; -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1558'>TEIID-1558&l...>] - Salesforce Connector gives NPE when the resultset is empty -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1561'>TEIID-1561&l...>] - Database Calender is not correctly being set in JDBC Translator -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1562'>TEIID-1562&l...>] - ArrayIndexOutOfBounds and ASSERTION FAILED in models with UNION -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1564'>TEIID-1564&l...>] - Clustered Caching Not Working -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1566'>TEIID-1566&l...>] - More complex join: ORDER BY and LIMIT not pushed down -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1567'>TEIID-1567&l...>] - Sybase translator needs to handle CROSS JOIN syntax. -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1570'>TEIID-1570&l...>] - pg catalog transformation issues -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1571'>TEIID-1571&l...>] - Error due to merge virtual with join and group by -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1572'>TEIID-1572&l...>] - Teiid ODBC does not handle SET and Show operations correctly -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1576'>TEIID-1576&l...>] - unexpected query result when joining with a virtual procedure -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1577'>TEIID-1577&l...>] - ArrayIndexOutOfBoundsException in queries with ORDER BY -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1578'>TEIID-1578&l...>] - Set query to string should account for branch limits/order bys -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1579'>TEIID-1579&l...>] - LocalServer Connection is not working -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1580'>TEIID-1580&l...>] - CME on VDB deploy -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1583'>TEIID-1583&l...>] - importer.useFullSchemaName property default value is incorrectly documented -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1584'>TEIID-1584&l...>] - Querying a virtual table backed by a SELECT x,y,z FROM EXECT ... TEXTTABLE() call fails to return data -</li> -</ul> - -<h2> Enhancement -</h2> -<ul> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1473'>TEIID-1473&l...>] - Don&#39;t batch more rows than is needed when query contains limit but translator does not support limit -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1482'>TEIID-1482&l...>] - Prevent unnecessary rebuffering of sorted results -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1490'>TEIID-1490&l...>] - In the process of loading the schema metadata and duplicate table is found, add a suggestion to the error message to use FQN option -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1519'>TEIID-1519&l...>] - Changing dynamicportfolio example in the JBoss as kit to use HSQL instead of Derby -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1539'>TEIID-1539&l...>] - Improve warning message when maximum thread count is encountered -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1556'>TEIID-1556&l...>] - Improve xmlagg performance -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1569'>TEIID-1569&l...>] - Documentation on creating UDF, extending ExecutionFactory and defining @Translator name should indicate what to do with the translator name -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1581'>TEIID-1581&l...>] - Adding a JCA example for creating a Teiid Data Source to the kits -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1582'>TEIID-1582&l...>] - Avoid buffering in enhanced sort merge join -</li> -</ul> - -<h2> Feature Request -</h2> -<ul> -<li>[<a href='https://issues.jboss.org/browse/TEIID-217'>TEIID-217</a>] - LDAP Connector should provide a way to retrieve all values of an attribute that appears multiple times within a search result -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-231'>TEIID-231</a>] - Ability to support Connector Level UDF functions in the System -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-239'>TEIID-239</a>] - ENHANCEMENT: Costing beyond cardinality sould be propogated -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-796'>TEIID-796</a>] - Allow for the import of overloaded procedures -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-946'>TEIID-946</a>] - add support for in/out out return params -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1011'>TEIID-1011&l...>] - Add support for connecting to Mondrian -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1059'>TEIID-1059&l...>] - Add a specific translator for Ingres -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1060'>TEIID-1060&l...>] - Add a specific translator for Intersystems Cache -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1061'>TEIID-1061&l...>] - Add a specific translator for SAP Business Warehouse -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1176'>TEIID-1176&l...>] - Provide a non-blocking JDBC api for ODBC support -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1217'>TEIID-1217&l...>] - Derive VDB Name Using Version During Deployment in Jopr -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1326'>TEIID-1326&l...>] - API request: rewrite query/command before it reaches the teiid planner -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1327'>TEIID-1327&l...>] - API request: Fine grained security -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1329'>TEIID-1329&l...>] - API to force metadata read -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1437'>TEIID-1437&l...>] - It&#39;s not possible to deploy single file (*.xml) virtual database through web admin console -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1463'>TEIID-1463&l...>] - limit buffering for large results -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1464'>TEIID-1464&l...>] - Add uuid function -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1471'>TEIID-1471&l...>] - Projection should be minimized prior to view removal -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1474'>TEIID-1474&l...>] - Add a limit to the number of concurrent source queries issued. -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1487'>TEIID-1487&l...>] - CLONE - Add implicit conversion of NULL to correct datatype in transformation validator -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1491'>TEIID-1491&l...>] - Provide JDBC 3.0 JRE 1.5 backwards compatibility -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1494'>TEIID-1494&l...>] - Allow the optional join hint to work with non-ansi joins -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1496'>TEIID-1496&l...>] - disjunctive rewrite -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1497'>TEIID-1497&l...>] - misc subquery enhancements -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1507'>TEIID-1507&l...>] - Cache invalidation -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1510'>TEIID-1510&l...>] - RulePushAggregates should consider cost in addition to key information -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1533'>TEIID-1533&l...>] - additional controls for dependent joins -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1536'>TEIID-1536&l...>] - Local connections should use calling thread -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1546'>TEIID-1546&l...>] - Be more selective as to what are created as bind variables -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1550'>TEIID-1550&l...>] - Row level security enhancements -</li> -</ul> -<h2> Quality Risk -</h2> -<ul> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1008'>TEIID-1008&l...>] - Correlated subquery handling for Oracle/MySQL -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1281'>TEIID-1281&l...>] - DB2 substring index bounds are different than teiid -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1493'>TEIID-1493&l...>] - In a cluster the distributed cache is cleared by a node rejoining -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1508'>TEIID-1508&l...>] - Dependent join planning problem -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1509'>TEIID-1509&l...>] - Change the default for value caching -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1513'>TEIID-1513&l...>] - Setting of translator properties should not be case sensitive -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1520'>TEIID-1520&l...>] - Reduce the memory footprint of metadata -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1525'>TEIID-1525&l...>] - update the hibernate usage with a note about id generation -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1527'>TEIID-1527&l...>] - local connection doc provides an invalid example -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1535'>TEIID-1535&l...>] - pg/odbc support should report rel oid with column metadata -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1574'>TEIID-1574&l...>] - Add new permission types for alter/execute -</li> -</ul> - -<h2> Task -</h2> -<ul> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1431'>TEIID-1431&l...>] - provide a working example of data roles -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1481'>TEIID-1481&l...>] - client url cleanups -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1483'>TEIID-1483&l...>] - Resolving changes to consolidate teiid/teiid designer handling -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1495'>TEIID-1495&l...>] - Validate the TeraData Translator -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1514'>TEIID-1514&l...>] - testZipFile.zip contains absolute path which impacted the MEAD sign -</li> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1551'>TEIID-1551&l...>] - ODBC logging context is not documented -</li> -</ul> - -<h2> Sub-task -</h2> -<ul> -<li>[<a href='https://issues.jboss.org/browse/TEIID-1524'>TEIID-1524&l...>] - Index metadata strings container their entire record line. -</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.