Version 5
Created by rareddy on Sep 22, 2009 5:31 PM. Last modified by rareddy on Jan 20, 2011 11:23 AM.

    Release Notes for Teiid 6.2

     

    Teiid 6.2 introduces the standalone-server mode with features and APIs similar to the MetaMatrix Enterprise Server.

     

    New Features/Enhancements

     

    • The JDBC Connector can obtain connections through JNDI.
    • Added support for parsing the UNKOWN keyword.
    • JDBC 4 support was added DatabaseMetadata queries – except for getFunctions.
    • The dynamic VDB feature was added that allows users to create a ConfigurationInfo.def file – defining models and connector information – that will automatically import metadata and create a queryable VDB from the sources.
    • Order by clauses may now specify unrelated (not in the select clause) columns.
    • The Salesforce connector can accept some join queries.
    • JDBC sources supporting the NULLS FIRST/LAST specification will add the appropriate clause to match Teiid's default null low behavior.
    • The release also adds AdminShell for scripted/interative use of Teiid.  The AdminShell scriptable/interactive environment for testing and administering a Teiid runtime.
    • Insert into with a query expression can specify a view as a target.

     

    Deprecations

     

    Removals

     

    Breaking Changes

     

    • The Teiid char type is treated the same as the database char(1) type.  Previously the cast of an empty string to char resulted in an exception, it now returns a space character.
    • The conversion of string to boolean no longer throws an exception, rather 'false' or '0' returns false and any other non-null value return true.
    • The conversion of a numeric type to boolean no longer throws an exception, rather 0 returns false and any other non-null value return true.
    • The connector API FunctionModifier class was simplified to a single modification method.

     

    Release Notes for Teiid 6.1

    Release Notes for Teiid 6.0


    Changelog for Teiid 6.2

    Sub-task

    • [ TEIID-104 ] Connector development documentation out-of-date
    • [ TEIID-664 ] Add "membership" service
    • [ TEIID-665 ] Add "authorization" service, and add support for entitlements in "embedded"
    • [ TEIID-666 ] Add "Session" service
    • [ TEIID-677 ] Document/test a Means of Exposing a Teiid Source as a REST Service
    • [ TEIID-679 ] Make all scripts use TEIID_HOME
    • [ TEIID-680 ] Add "socket" transport as service
    • [ TEIID-681 ] Fix logger for JBoss cache, JBossTM integration to use the same log file as the rest of the system
    • [ TEIID-685 ] Define Metadata aware Connector API
    • [ TEIID-686 ] Query engine should be able to plan and execute user queries based upon metadata from connectors
    • [ TEIID-687 ] JDBC Connector should be Metadata Aware Connector
    • [ TEIID-688 ] Text Connector should be Medata Aware Connector
    • [ TEIID-697 ] Make Admin API changes to support newly added services to runtime engine
    • [ TEIID-706 ] Deployed vdbs should have a consistent unzipped location.
    • [ TEIID-708 ] Connector metadata should be availble to the metadata connector
    • [ TEIID-779 ] Move the tests from the jbedsp-test-embedded project to the teiid communitiy

    Feature Request

    • [ TEIID-514 ] ORDER BY should have ability to include columns not specified in the SELECT clause
    • [ TEIID-408 ] logging controls/maintenance capabilities for transaction logging
    • [ TEIID-596 ] Support for partial results mode and warnings in web services
    • [ TEIID-210 ] mmadmin should format XML documents
    • [ TEIID-202 ] Salesforce connector should support SOQL Relationship Queries
    • [ TEIID-595 ] Add VDB version as attribute to definitions tag of MM WSDL
    • [ TEIID-378 ] Only synchronize referenced connector bindings when importing a new VDB
    • [ TEIID-209 ] SalesForce Connector should support semi-join and anti-join pushdown upon release of 14.0 API
    • [ TEIID-405 ] Allow importing a VDB file from a URL (not just the local file system)
    • [ TEIID-193 ] MembershipService does not show failure in Console when unable to connect to LDAP database
    • [ TEIID-241 ] Entitlements | Authorizations: add a "select all" option
    • [ TEIID-228 ] Need to verify keystore/password when changing SSL resource props
    • [ TEIID-221 ] WS-RM Support in Enterprise Web Services
    • [ TEIID-232 ] SortUtility merge phase enhancement
    • [ TEIID-163 ] Add classloader cache to embedded
    • [ TEIID-156 ] Console should allow for setting arbitrary propeties
    • [ TEIID-393 ] The Salesforce connector must be able to query about deleted SF objects.
    • [ TEIID-417 ] Add REST Support to Data Services
    • [ TEIID-486 ] MOD() scalar function should be supported by DB2 Connector
    • [ TEIID-490 ] Change the meaning of essential services / essential service restart
    • [ TEIID-497 ] Modify SOAP War to Allow for Multiple Connection Type Support
    • [ TEIID-500 ] Request for INSERT INTO...SELECT..FROM capability for virtual tables
    • [ TEIID-509 ] Add new logging level so that server startup information can be logged and be differentiated from critical/warning level entries
    • [ TEIID-540 ] Embed Servlet Container in Teiid
    • [ TEIID-580 ] Add ability to monitor Connector Connection Pool
    • [ TEIID-630 ] Add Support for UDDI V3 in WSDL Publishing Feature of Console
    • [ TEIID-660 ] Move sort removal to the rewriter
    • [ TEIID-684 ] Dynamic data integration feature (Integrate data with out a VDB)
    • [ TEIID-724 ] Support JDBC 4 style DatabaseMetaData getColumns
    • [ TEIID-725 ] Provide a mechanism to shutdown teiid embedded
    • [ TEIID-738 ] Connector binding properties should resolve nested properties
    • [ TEIID-739 ] JDBC Connector updates
    • [ TEIID-746 ] Composite keys should be detected by costing
    • [ TEIID-758 ] Add locate function support to postgres
    • [ TEIID-783 ] Fetch enhancements
    • [ TEIID-798 ] Add support for unknown keyword parsing
    • [ TEIID-805 ] Enable JDBC Connector to provide a way to obtain connection through JNDI

    Bug

    • [ TEIID-365 ] Console Error Message when logging into MM Server is confusing
    • [ TEIID-363 ] Console - Admin Roles screen misleading if user with System Admin privileges deletes their own role and tries to delete other roles
    • [ TEIID-626 ] Eclipse Datatools view cannot see tables in a VDB
    • [ TEIID-362 ] Console - Create New Data Roles panel step 2 & 3 displays wrong VDB version #
    • [ TEIID-377 ] Model visibility changes during VDB deployment wizards are not retained when moving forward and backward through wizard
    • [ TEIID-364 ] Is Immutable should be an expert property
    • [ TEIID-607 ] Connectors with invalid connection properties should show Source Unavailable at startup
    • [ TEIID-75 ] SqlQueryWebService WSDL updates
    • [ TEIID-20 ] Audit logs should roll-over (not just grow)
    • [ TEIID-70 ] Bouncing server, then synchronize (during bounce) should be prohibited.
    • [ TEIID-78 ] Need to support SOAP 1.2 in next release across all web service implementations
    • [ TEIID-113 ] Connector Bindings Window requires refresh to see newly imported Connectors
    • [ TEIID-30 ] Wrong file in the file descriptor field causes weird error
    • [ TEIID-72 ] show authorization properties on the security summary
    • [ TEIID-28 ] VDB Wizard Layout Issues When Resizing
    • [ TEIID-27 ] Replace Extension Module Wizard's Confirmation Step Does Not Provide Enough Information
    • [ TEIID-360 ] SQLServer SQLTranslator issues
    • [ TEIID-474 ] Need to Hard-code serialVersionUID in LogonResult
    • [ TEIID-496 ] ValueValidationVisitor needs the variable context
    • [ TEIID-542 ] Temp folders not being cleaned up in MetaMatrixTxnStore folder
    • [ TEIID-597 ] AdminAPI method: UpdateProperties() needs to support updating the Service properties
    • [ TEIID-601 ] Check for duplicate process at the statup and avoid it
    • [ TEIID-605 ] Push down query results different than MetaMatrix query results without push down - Oracle 11
    • [ TEIID-614 ] Log XML Request/Response Doc binding property = TRUE is not causing documents to be logged.
    • [ TEIID-616 ] Start time of the system could be incorrect in rare cases where processes are brought down and back up
    • [ TEIID-625 ] ConvertPassword utility doesn't work
    • [ TEIID-628 ] Resource property editing is error prone
    • [ TEIID-633 ] Error in Teiid Designer TestServerRuntimeMetadata unit test
    • [ TEIID-652 ] Custom Connectors: Teiid looks in configuration.xml--not ConfigurationInfo.def--for connector information
    • [ TEIID-655 ] Console dialog sizing issue during VDB deployment
    • [ TEIID-656 ] URLHelper does not handle absolute windows file paths for the mmrofile protocol
    • [ TEIID-661 ] Internal doc version numbers still indicate 6.0.0
    • [ TEIID-670 ] Query Testing returned 0 rows on 16 queries when results were expected - Involves FoatNum, LongNum, DoubleNum, BigDecimalValue, and BigIntegerValue
    • [ TEIID-671 ] Teiid should accept LongNum, DoubleNum, and BigDecimalValue in numeric function
    • [ TEIID-695 ] Equality comparison of JoinPredicate returns true even when JoinPredicate criteria is different
    • [ TEIID-700 ] Adding ORDER BY to a specific query (see details) gets ORA-00904: "C_0": invalid identifier
    • [ TEIID-705 ] Index connector post processing of case insensitive matching is incorrect.
    • [ TEIID-709 ] Non-blocking dup removal may loose partial batches
    • [ TEIID-710 ] DB2 does not support pushdown of null keyword as a select expression
    • [ TEIID-712 ] JDBC Metadata SQLXML type is wrong
    • [ TEIID-713 ] JDBC Connector deregistration logic is incorrect.
    • [ TEIID-714 ] getProcedures procedureName pattern logic correct
    • [ TEIID-716 ] Connector Status can reported wrong or possibility of NPE
    • [ TEIID-717 ] Virtual access pattern validation issue.
    • [ TEIID-718 ] Translate criteria fails on prepared statement update/delete criteria
    • [ TEIID-719 ] Authorization Realms are being checked in case dependent way
    • [ TEIID-720 ] Translate criteria validation issues
    • [ TEIID-721 ] JDBC Connection thru SQuirreL to Teiid Server instance not working
    • [ TEIID-722 ] Determining the Teiid runtime instace identity could be error prone
    • [ TEIID-726 ] Distinct aggregate type mismatch bug
    • [ TEIID-727 ] Lookup function does not implicitly convert search argument
    • [ TEIID-729 ] Default keystore may lead to confusion or provide false sense of security in encrypting passwords
    • [ TEIID-731 ] NPE when trying to execute a query through the LDAP connector
    • [ TEIID-733 ] ConcurrentModificationException in SessionMonitor
    • [ TEIID-734 ] Exception while closing the JDBC Connection to the Teiid Runtime
    • [ TEIID-735 ] Equals method for subqueryfromclause is incorrect
    • [ TEIID-736 ] MMJDBCSQLTypeInfo incorrectly maps char sql type
    • [ TEIID-740 ] PropertiesUtils should be tolerant of trailing spaces on all numeric conversions
    • [ TEIID-741 ] SQL Server type hadling issues
    • [ TEIID-742 ] Nested properties are not correctly being resolved
    • [ TEIID-743 ] Excessive cloning of connector binding properties
    • [ TEIID-744 ] Inversion of convert(string, ...) and parseXXX(string, ...) is not always possible.
    • [ TEIID-748 ] QueryRewriter null handling
    • [ TEIID-751 ] SDO_WITHIN_DISTANCE function of Oracle Spatial Connector is pushing string literal to data source
    • [ TEIID-752 ] Errors with bulk updates
    • [ TEIID-753 ] MySQL translator issues
    • [ TEIID-754 ] LOCATE() function isn't being translated correctly by Oracle Connector
    • [ TEIID-755 ] Oracle Connector is not honouring metadata when rewriting ORDER BY clause
    • [ TEIID-757 ] Oracle Spatial Connector is not properly adding ORDERED hint to SDO_RELATE function
    • [ TEIID-759 ] XQuery parameter evaluation fails
    • [ TEIID-762 ] tuplesource leak in update procedures
    • [ TEIID-763 ] Exceptions from cache under load
    • [ TEIID-764 ] Error message not found for missing lob tuplesource
    • [ TEIID-765 ] Procedures without a return parameter and with output parameters indexing issue
    • [ TEIID-766 ] Oracle Spatial Connector is not utilizing function modifiers from Oracle Connector
    • [ TEIID-768 ] The utility to check whether a SQL string is update returns wrong result in certain cases
    • [ TEIID-770 ] Log Manager is not checking if the context is enabled before it logs message
    • [ TEIID-771 ] Simplify lob handling in the buffermanager
    • [ TEIID-772 ] Fix TestEmbeddedVDBService test in the runtime project
    • [ TEIID-774 ] Invalid session terminination after 30 minutes
    • [ TEIID-775 ] Backwards scrolling defect
    • [ TEIID-791 ] M2 build getting NPE when connecting to VDB
    • [ TEIID-793 ] Admin connection is not being authorized correctly
    • [ TEIID-795 ] Embedded connection issues after restart
    • [ TEIID-797 ] The parser should use common conversion routines
    • [ TEIID-801 ] PropertyUtils.resolveNestedProperties has side effect of adding all "default" properties to the list while resolving
    • [ TEIID-804 ] Source download is currently not in form which is readily consumable by the developers
    • [ TEIID-809 ] Path to config file has been remove from deploy.properties and Teiid is looking in the wrong location.
    • [ TEIID-810 ] Error executing "limit ?" against Teiid via Hibernate
    • [ TEIID-811 ] Float/Double to BigInteger conversion bug
    • [ TEIID-812 ] Embedded deployment is creating "log" directory in wrong location
    • [ TEIID-815 ] java.lang.NoClassDefFoundError: org/teiid/adminapi/SystemObject when connecting to Teiid embeded
    • [ TEIID-816 ] XML-Relational File connector throws NPE.
    • [ TEIID-817 ] XML-Relational connector is not handling = criteria.
    • [ TEIID-818 ] Error returned from SQL Server: Incorrect syntax near: NULLS
    • [ TEIID-824 ] Encountered error message:
    • [ TEIID-825 ] DEBUG level loggging Issues
    • [ TEIID-826 ] Lob steram is being closed after the result set close
    • [ TEIID-831 ] Stored procedure execution fails with with out parameters after in
    • [ TEIID-834 ] CTC Testing -Queries should not depend on a Stored Procedure result set if the stored procedures is not designed to return a result set.
    • [ TEIID-835 ] AdminApi (thru AdminShell) allows deletion of an active VDB from under a connected user
    • [ TEIID-836 ] adminAPI returns VDB status as an integer -- it should be a String
    • [ TEIID-837 ] deleteVDBAndConnectorBindings gets NPE
    • [ TEIID-839 ] adminAPI shutdown method gets NPE and does not shut down the server
    • [ TEIID-840 ] admin-roles appears to be ignored and allegedly privileged users cannot execute methods appropriately
    • [ TEIID-841 ] Failed to export extension module from admin shell
    • [ TEIID-842 ] Failed to add Connector Bindings and Types using Admin API
    • [ TEIID-843 ] IndexOutOfBoundsException occurs when a running query is cancelled.
    • [ TEIID-847 ] Constant conversion issue

    Task

    • [ TEIID-308 ] Merge the query rewriter and expression evaluator visitor
    • [ TEIID-339 ] Push down aggragate and distinct through union
    • [ TEIID-593 ] Remove WSDL User Setup Verbiage from MM Documentation
    • [ TEIID-277 ] Create Automated Test for Data Services Over JMS
    • [ TEIID-594 ] Update Web Services Security Documentation for Security Setup in setupmm
    • [ TEIID-259 ] Create Teiid Server Kit
    • [ TEIID-381 ] Migrate Teiid JOPR Plugin from Product to Project
    • [ TEIID-423 ] Audit logging should be extension of logging
    • [ TEIID-484 ] Upgrade JGroups to 2.6.10
    • [ TEIID-485 ] Upgrade JBoss Cache to 3.1.0
    • [ TEIID-498 ] Use current instead of next startup to refer to the configuration
    • [ TEIID-598 ] Remove context parameters from web.xml in SOAP War and Move to a Properties File in WEB-INF
    • [ TEIID-649 ] Replace BlobImpl and ClobImpl with SerialBlob and SerialClob
    • [ TEIID-658 ] Use client java logging instead of DriverManager.println
    • [ TEIID-659 ] Embedded cleanups
    • [ TEIID-663 ] Enrich "embedded" service offerings
    • [ TEIID-667 ] Simplify "Command Logging"
    • [ TEIID-668 ] Simplify "Audit Logging"
    • [ TEIID-672 ] Replace homegrown Logging with Log4J
    • [ TEIID-682 ] Remove old transactionmanager framework
    • [ TEIID-689 ] Improve numeric transforms
    • [ TEIID-696 ] Add unit test coverage for use of a procedure variable as non join criteria
    • [ TEIID-698 ] Create AdminShell Kit
    • [ TEIID-701 ] Provide a single JDBC driver for "embedded" and "server" configurations
    • [ TEIID-702 ] Define/Provide ways to create and use encrypted passwords in Teiid
    • [ TEIID-707 ] Remove metadata connector handling of in and is null criteria
    • [ TEIID-711 ] Add Google Analytics support to the Teiid.org site.
    • [ TEIID-732 ] Rename the teiid-embedded project to teiid-runtime
    • [ TEIID-737 ] Upgrade Log4J to 1.2.15 version
    • [ TEIID-769 ] Configure Log4j to use the ASYNC appender
    • [ TEIID-787 ] Merge Oracle Spatial Connector functionality into Oracle Connector
    • [ TEIID-814 ] Make a notion of "standard" connector type in the configuration

    Quality Risk

    • [ TEIID-350 ] Add documentation about function determinism
    • [ TEIID-703 ] Configuration service is assuming the Session Service roles in some instances
    • [ TEIID-745 ] Ensure string parsing routines are consistent
    • [ TEIID-747 ] Minor costing updates
    • [ TEIID-761 ] Correct inefficient buffermanager tuplesource and managedbatch scans
    • [ TEIID-767 ] Combine the memorystoragemanager and the buffermanager
    • [ TEIID-785 ] Embedded usage issues
    • [ TEIID-786 ] Minor performance enhancements
    • [ TEIID-794 ] Simplify functionmodifier
    • [ TEIID-799 ] String to boolean conversion should not throw an exception
    • [ TEIID-800 ] Teiid char type should be consistently treated as char(1)
    • [ TEIID-802 ] Move the properties defined in DQPConfigSource into DQpEmbeddedProperties
    • [ TEIID-806 ] JDBC connector handling of convert is inconsistent
    • [ TEIID-813 ] Perform bound checking on narrowing numeric conversions
    • [ TEIID-828 ] Default of 20 code tables is too small