This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
install:releases:odx53:history [2014/03/01 00:13] doc |
install:releases:odx53:history [2016/06/28 22:38] (current) |
||
---|---|---|---|
Line 6: | Line 6: | ||
Each new version of Omnidex brings a collection of improvements, from new features to increased performance. Here are the primary features and enhancements in the major releases of Omnidex: | Each new version of Omnidex brings a collection of improvements, from new features to increased performance. Here are the primary features and enhancements in the major releases of Omnidex: | ||
- | {{page>install:releases:topnav&nofooter&noeditbtn}} | + | {{page>install:releases:topnav53&nofooter&noeditbtn}} |
===== Omnidex 5.3 Release History ===== | ===== Omnidex 5.3 Release History ===== | ||
- | The following table shows the individual releases of Omnidex 5.3, including their release dates and features. | + | === Version 5.3.09D (June 2015) === |
+ | * Fix odbcsql and jdbcsql to work without default port and with special characters. | ||
- | |< 60% 40% 60% >| | + | === Version 5.3.09C (June 2015) === |
- | ^ Release ^ Release Date ^ | + | |
- | | [[#5_3_01A|5.3.01A]] | September 2012 | | + | |
- | | [[#5_3_02A|5.3.02A]] | October 2012 | | + | |
- | | [[#5_3_03A|5.3.03A]] | January 2013 | | + | |
- | | [[#5_3_03B|5.3.03B]] | January 2013 | | + | |
- | | [[#5_3_03C|5.3.03C]] | February 2013 | | + | |
- | | [[#5_3_04A|5.3.04A]] | March 2013 | | + | |
- | | [[#5_3_05A|5.3.05A]] | April 2013 | | + | |
- | | [[#5_3_07A|5.3.07A]] | June 2013 | | + | |
- | | [[#5_3_07B|5.3.07B]] | June 2013 | | + | |
- | | [[#5_3_07C|5.3.07C]] | June 2013 | | + | |
- | | [[#5_3_07D|5.3.07D]] | July 2013 | | + | |
- | | [[#5_3_07E|5.3.07E]] | July 2013 | | + | |
- | | [[#5_3_07F|5.3.07F]] | July 2013 | | + | |
- | | [[#5_3_07G|5.3.07G]] | August 2013 | | + | |
- | | [[#5_3_07H|5.3.07H]] | October 2013 | | + | |
- | | [[#5_3_07J|5.3.07J]] | November 2013 | | + | |
- | | [[#5_3_07K|5.3.07K]] | December 2013 | | + | |
- | | [[#5_3_08A|5.3.08A]] | February 2014 | | + | |
- | \\ | + | * Addition of JdbcSQL and OdbcSQL utilities |
- | ---- | + | * Improve ODBC and JDBC performance |
+ | * Support for EXTRACT QUERIES command | ||
+ | * Fix issues with using Omnidex with client application connection pools | ||
+ | * Fix issue with logging statements on Grid Controller | ||
+ | * Fix issues with TOP, SKIP and EVERY with Omnidex Grids | ||
+ | * Fix issue with count distinct optimization in Star Schema optimization | ||
+ | * Fix issue in synonym lookups with apostrophes | ||
+ | * Fix memory leak with expression based columns using CASE function and IN or BETWEEN operators | ||
+ | * Support for Java 7 | ||
+ | * Support for DBCP 1.3 | ||
+ | * Support for Tomcat | ||
- | === 5.3.01A === | + | === Version 5.3.08G (March 2015) === |
- | * Initial release | + | * Support for optimization of descending sorts |
+ | * Improvements to explain plan for Omnidex Grids | ||
+ | * Support for VXRT 8.5.4 | ||
+ | * Support for new PREFETCH option for ODBC/JDBC driver | ||
+ | * Fix issue in Client JDBC Driver dealing with multithreaded processing of Java strings | ||
+ | * Fix issue with multiple count distincts in a star schema query | ||
+ | * Fix issue with signal handling when libraries are unloaded | ||
+ | * Fix memory leak in JDBC driver with especially large buffers | ||
+ | * Fix issue introduced in 5.3.08E with proximity queries | ||
- | === 5.3.02A === | + | === Version 5.3.08F (January 2015) === |
- | * Omnidex now supports, real-time connection and query monitoring. | + | * Improvements to Omnidex Network Services |
- | * Improvements were made to the InstallShield release process. | + | * Improvements to license validation process |
- | * Support for the DISC Licensing server was restored. | + | * Support for logging of licensing activity |
- | * Expansion of the methods available in the OmniSearch Java and .NET classes. | + | * Improved output for 'omnidex -admin' |
- | * Improvements to the multi-process and multi-thread communication approaches provided using the Boost libraries. | + | * Improvements to ODBC driver to support compatability with Alpha Five software |
- | * Improvements for multi-user access on Microsoft Windows. | + | |
- | === 5.3.03A === | + | === Version 5.3.08E (November 2014) === |
- | * Support for the REGISTER ODBC command to register the ODBC driver | + | |
- | * Rename the 'versions' program to 'odxversions' | + | |
- | * Improvements when running Omnidex as a Windows Service | + | |
- | * Improvements when running Omnidex as a daemon on Linux | + | |
- | * Resolve issue with HAVING clauses involving COUNT (DISTINCT ...) with Omnidex Grids | + | |
- | * Stability improvements with Multi-Index Aggregations | + | |
- | === 5.3.03B === | + | * Improvements to Omnidex Network Services |
- | * Stability improvements with Multi-Index Aggregations dealing with composite keys, SAMPLE functions, and parsed indexes | + | * Improvements to Omnidex Grid Pooling |
- | * Resolve issue with COUNT(column) construction with Union Views | + | * Improvements to query timeouts. |
+ | * Support for use of 'yum' on Linux software installations. | ||
+ | * Fix issue with access permissions in the config directory. | ||
+ | * Fix issue with Multi-Index Aggregations | ||
- | === 5.3.03C === | + | === Version 5.3.08D (October 2014) === |
- | * Fix aggregations that have PQ's that were repeating control breaks (HygenicsData) | + | * Support for system logicals with VX/RMS |
- | * Fix DROP SEGMENT for Grid processing | + | * Support for declaring QUALIFY_MODE in the Omnidex environment file |
- | * Fix HAVING clause problem with Grid processing | + | * Resolve issue with ODBC when using Oracle BI or Business Objects |
- | * Continue processing nodes on error condition in Grid UPDATE FOR commands. | + | * Improve optimization of QUALIFY statements that have not A and not B ...' syntax. |
- | * Support for $uniquekey in $segment() | + | |
- | * Support for applying Omnidex criteria before building HDC tables. | + | |
- | === 5.3.04A === | + | === Version 5.3.08C (September 2014) === |
- | * Further fixes for $segment functions | + | * Support for Oracle 12c |
- | * Support for AUTOCOMPLETE option in SELECT | + | * Support for REQUIRED_OPTIMIZATION settings of NO_EMBEDDED_WILDCARDS and NO_EXTENDED_WILDCARDS. |
- | * Avoid duplicate loading of OFX's on non-partitioned tables in grids | + | * Support for SINGLE_OFX option to produce one OFX for multi-file delimited files. |
- | * Fix problems with TOP/SKIP paging | + | * Improve handling of error conditions from Windows WMI interface so that licensing is not disabled. |
- | * Fix problems with empty segments | + | * Improve how statements are logged to the Omnidex logs to handled escaped characters, quotes, and statement options. |
- | * Fix problems with multiple count(distinct)'s | + | * Improve error handling of file permissions on index directories and files. |
- | * Support multiple databases in Omnidex grids | + | * Improve handling of VMS-style filenames and directory names for VX/RMS files. |
+ | * Improve error message for memory allocation failures to include source location. | ||
+ | * Fix issue in UPDATE INDEXES command due to reading index tree in boundary condition. | ||
+ | * Fix issue with Idle Timeout and hanging of threads, appearing then as orphan processes. | ||
+ | * Fix issue with indexing of especially long string fields | ||
+ | * Fix issue with qualifications on composite indexes with especially wide columns | ||
+ | * Fix issue with table PHYSICAL clauses containing multiple wildcard sets, some of which are empty. | ||
+ | * Fix parsing of date fields with negative time zones, found with Omnidex log files | ||
+ | * Fix issue with qualifications on bitmap indexes where values become localized at beginning of bitmap | ||
+ | * Fix issue with ODBC/JDBC clients receiving a connection error indicating no driver was available. | ||
- | === 5.3.05A === | + | === Version 5.3.08B (March 2014) === |
- | * Support for MAX_THREADS option on SELECT statements | + | * Production release of support for VX/RMS files |
- | * Support for summing double datatypes with more than 256 distinct values with MIA (Glaxo) | + | * Install service files for Omnidex on Linux installations |
- | * Support unlimited SQL statement lengths | + | |
- | * Further fixes for MIA and sums, and count(distinct) mixed with other aggregations | + | |
- | * Support for licensing through proxy servers | + | |
- | === 5.3.07A === | + | === Version 5.3.08A (February 2014) === |
- | * Remove Beta designation for 5.3 | + | |
- | * Use Omnidex by default | + | |
- | * Support POWERSEARCH option in QUALIFY | + | |
- | === 5.3.07B === | + | * Add beta support for VX/RMS files |
- | * Minor changes for licensing server | + | * Add support for multiplexing one socket connection rather than using dual sockets |
+ | * Resolve an issue with locking OFX files, seen in high concurrency situations | ||
+ | * Resolve an issue with aggregations on bitmap indexes returning an error if the partition qualifiers exceed the highest value in the bitmap index | ||
+ | * Remove Omnidex Administrator from Start menu until development completes | ||
+ | * Change the default translation table to not alter the upper 128 characters. | ||
- | === 5.3.07C === | + | === Version 5.3.07K (December 2013) === |
- | * Minor changes for licensing server | + | |
- | === 5.3.07D === | + | * Improve handling of file permissions on Linux |
- | * Support for SET QUALIFY_COUNTS PREINTERSECT | + | * Resolve an issue with the idleTimeout setting in Omnidex network services configuration |
- | * Improvements to QUALIFY explain plans | + | * Resolve an issue with double-nested query in the FROM clause |
- | * Fix problem with samelist qualifications followed by empty criteria | + | |
+ | === Version 5.3.07J (November 2013) === | ||
+ | |||
+ | * Add support for the POWERSEARCH option on criteria using LIKE contruct | ||
+ | * Resolve an issue with nested subqueries in the FROM clause that use DISTINCT operations | ||
+ | * Resolve an issue with aliases for nested subqueries in the FROM clause | ||
+ | * Resolve an issue with HAVING clauses that contain invalid partition qualifiers | ||
+ | * Resolve an issue with NOT (a and b) with POWERSEARCH | ||
+ | * Resolve an issue with exit handlers on non-pooled network processes, calling fork/exec instead of just fork. | ||
+ | |||
+ | === Version 5.3.07H (October 2013) === | ||
+ | |||
+ | * Disallow CASE_INSENSITIVE option on OMNIDEX indexes; require CUSTOM index instead | ||
+ | * Improve connection/disconnection performance | ||
+ | * Resolve an issue with comparing index segment creation timestamps against index timestamps | ||
+ | * Add support for POWERSEARCH option in the CREATE ENVIRONMENT statement | ||
+ | * Enhance optimizer to prefer QUICKTEXT indexes over OMNIDEX indexes in criteria unless criteria is double-quoted | ||
+ | * Enhance UPDATE INDEXES command to automatically generate log files | ||
+ | * Enhance delimited files to not require OFX due to the HEADER_ROW option | ||
+ | * Improve error handling of ODXSQL connecting using the -odbc or -jdbc option | ||
+ | * Prohibit connection options in the ODXSQL command line | ||
+ | * Add support for $SAMPLE function in Omnidex Grid environments | ||
+ | * Add support for unlimited SQL statement lengths | ||
+ | * Avoid using PRIKEY optimization when using the $SAMPLE function | ||
+ | * Avoid using index partition qualifiers when criteria contains wildcards | ||
+ | * Add support for ODXSQL SET QUALIFY_COUNTS PREINTERSECT | ||
+ | * Enhance delimited files so that an OFX is created for each delimited file within a table PHYSICAL clause, allowing delimited files to be shared | ||
+ | * Resolve an issue with DETACH of an OST with the DELETE option | ||
+ | * Resolve an issue with error occurring on LEFT OUTER JOIN's to a nested subquery | ||
+ | |||
+ | === Version 5.3.07G (August 2013) === | ||
+ | |||
+ | * Further improvements to InstallShield, including issues with 32-bit Microsoft Windows installations | ||
+ | * Resolve an issue with references to numeric literals in Omnidex Grid processing | ||
+ | * Resolve an issue with with cached sysinfo writing incorrect machine information | ||
+ | |||
+ | |||
+ | === Version 5.3.07F (July 2013) === | ||
+ | |||
+ | * Resolve an issue with the NOAUTORESET option in QUALIFY statement using ODBC | ||
+ | * Expand InstallShield's ability to remove older versions of Omnidex | ||
+ | |||
+ | === Version 5.3.07E (July 2013) === | ||
- | === 5.3.07E === | ||
* Enhance InstallShield to clean up the registry from earlier versions of Omnidex. | * Enhance InstallShield to clean up the registry from earlier versions of Omnidex. | ||
- | * InstallShield fixes to improve starting Omnidex as a Windows Service | + | * Resolve issues in InstallShield with starting Omnidex as a Windows Service |
- | === 5.3.07F === | + | === Version 5.3.07D (July 2013) === |
- | * Fix problem with NOAUTORESET option in QUALIFY statement using ODBC | + | |
- | * Further InstallShield fixes to remove old versions of Omnidex | + | |
- | === 5.3.07G === | + | * Add support for the SET QUALIFY_COUNTS PREINTERSECT statement |
+ | * Improve the query plans for QUALIFY statements | ||
+ | * Resolve an issue with samelist qualifications followed by empty criteria | ||
- | * Changes to InstallShield: | + | === Version 5.3.07C (June 2013) === |
- | * Remove multiuser prompts | + | |
- | * Removing the cached version of sysinfo | + | |
- | * Fixing creation of omnidex.cfg file (32-bit Windows only) | + | |
- | * Fix missing odxodbc.dll on (32-bit Windows only) | + | |
- | * Fix for references to numeric literals in grid processing | + | |
- | * Fix problem with cached sysinfo writing incorrect machine information | + | |
+ | * Resolve minor issue with the licensing server | ||
- | === 5.3.07H === | + | === Version 5.3.07B (June 2013) === |
- | * Disallow CASE_INSENSITIVE option on OMNIDEX indexes; require CUSTOM index instead | + | * Resolve minor issue with the licensing server |
- | * Further improvements to connection/disconnection performance | + | |
- | * Fix issue with comparing index segment creation timestamps against index timestamps | + | |
- | * Support POWERSEARCH option in the CREATE ENVIRONMENT statement | + | |
- | * Prefer QUICKTEXT indexes over OMNIDEX indexes in criteria unless criteria is double-quoted (DNB, DS) | + | |
- | * Automatically generate log files on UPDATE INDEXES command, located in a log subdirectory of the index directory by default. | + | |
- | * Do not require OFX due to the HEADER_ROW option for a delimited file. (HD) | + | |
- | * Improve error handling of ODXSQL connecting using the -odbc or -jdbc option. | + | |
- | * Disallow connection options in ODXSQL command line. | + | |
- | * Fix build_config.bat to bypass internal licensing step. | + | |
- | * Support $SAMPLE function in Grid environments (HD) | + | |
- | * Don't use PRIKEY optimization when using the $SAMPLE function. (HD) | + | |
- | * Support for unlimited SQL statement lengths (HD) | + | |
- | * Avoid using index partition qualifiers when criteria contains wildcards. | + | |
- | * Support for ODXSQL SET QUALIFY_COUNTS PREINTERSECT (DNB) | + | |
- | * Create an OFX for each delimited file within a table PHYSICAL clause, allowing delimited files to be shared | + | |
- | * Fix issue with DETACH of an OST with the DELETE option (HD) | + | |
- | * Fix issue with error occurring on left outer joins to a nested subquery (DS) | + | |
- | === 5.3.07J === | + | === Version 5.3.07A (June 2013) === |
- | * Support POWERSEARCH option on criteria using LIKE contruct | + | * Use Omnidex Network Services by default, rather than OdxNet Network Services |
- | * Rename 'versions' program to 'odxversions' | + | * Add support for POWERSEARCH option in QUALIFY statements |
- | * Fix issue with LEFT OUTER JOIN's to nested subqueries | + | |
- | * Fix issue with nested subqueries in the FROM clause that use DISTINCT operations | + | |
- | * Fix issue with aliases for nested subqueries in the FROM clause | + | |
- | * Fix issue with HAVING clauses that contain invalid partition qualifiers | + | |
- | * Fix issue with NOT (a and b) with POWERSEARCH | + | |
- | * Fix issue with exit handlers on non-pooled network processes, called fork/exec instead of just fork. | + | |
- | === 5.3.07K === | + | === Version 5.3.05A Beta (April 2013) === |
- | * Better handling of file permissions on Linux | + | * Add support for MAX_THREADS option on SELECT statements |
- | * Fix issue with idleTimeout setting in Omnidex network services configuration | + | * Add support for summing double datatypes with more than 256 distinct values with MIA |
- | * Fix issue dealing with double-nested query in the SELECT … FROM clause | + | * Add support for unlimited SQL statement lengths |
+ | * Improve the stability of Multi-Index Aggregations dealing with sums, and count(distinct) mixed with other aggregations | ||
+ | * Add support for licensing through proxy servers | ||
- | === 5.3.08A === | + | === Version 5.3.04A Beta (March 2013) === |
- | * Initial beta release for VX/RMS Driver | + | * Improve the stability of $segment functions |
- | * Support for multiplexing one socket connection rather than using dual sockets | + | * Add support for AUTOCOMPLETE option in SELECT |
- | * Fix to locking of OFX files, seen in high concurrency situations | + | * Enhance Omnidex Grids to avoid duplicate loading of OFX's on non-partitioned tables |
- | * Fix issue where aggregations on bitmap indexes returned a 999/314 if the partition qualifiers passed to dbigetkeys exceeded the highest value in the bitmap index. (HygenicsData) | + | * Improve stability of TOP/SKIP paging |
- | * Remove Omnidex Administrator from Start menu until development completes | + | * Improve stability of SELECT statements with multiple COUNT (DISTINCT ...) clauses |
- | * Change default translation table to not alter the upper 128 characters. | + | * Add support for multiple databases in Omnidex Grids |
+ | |||
+ | === Version 5.3.03C Beta (February 2013) === | ||
+ | |||
+ | * Resolve an issue with aggregations that have partition qualifiers containing repeating control breaks | ||
+ | * Resolve issues with DROP SEGMENT for Omnidex Grids | ||
+ | * Resolve an issue with HAVING clause processins for Omnidex Grids | ||
+ | * Enhance Omnidex Grid processing to continue processing nodes on error conditions | ||
+ | * Add support for $uniquekey in $segment() | ||
+ | * Add support for applying Omnidex criteria before building HDC tables | ||
+ | |||
+ | === Version 5.3.03B Beta (January 2013) === | ||
+ | |||
+ | * Improve the stability of Multi-Index Aggregations dealing with composite keys, SAMPLE functions, and parsed indexes | ||
+ | * Resolve an issue with COUNT(column) constructs with Union Views | ||
+ | |||
+ | === Version 5.3.03A Beta (January 2013) === | ||
+ | |||
+ | * Support the REGISTER ODBC command | ||
+ | * Rename the 'versions' program to 'odxversions' | ||
+ | * Improvement Omnidex running as a Windows Service and a Linux daemon | ||
+ | * Resolve an issue with HAVING clauses involving COUNT (DISTINCT ...) with Omnidex Grids | ||
+ | * Improve the stability of Multi-Index Aggregations | ||
+ | |||
+ | === Version 5.3.02A Beta (October 2012) === | ||
+ | |||
+ | * Add support for real-time connection and query monitoring | ||
+ | * Improve the InstallShield release process | ||
+ | * Restore support for the DISC Licensing server | ||
+ | * Expand the methods available in the OmniSearch Java and .NET classes | ||
+ | * Improve the multi-process and multi-thread communication approaches provided using the Boost libraries | ||
+ | * Improve multi-user access on Microsoft Windows | ||
+ | |||
+ | === Version 5.3.01A Beta (September 2012) === | ||
+ | |||
+ | * Initial release | ||
Line 180: | Line 230: | ||
{{page>:bottom_add&nofooter&noeditbtn}} | {{page>:bottom_add&nofooter&noeditbtn}} | ||
+ |