This is an old revision of the document!
Software Installation: Release Notes
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:
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.01A Beta
Version 5.3.02A Beta
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.03A Beta
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.03B Beta
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.03C Beta
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.04A Beta
Improve the stability of $segment functions
Add support for AUTOCOMPLETE option in SELECT
Enhance Omnidex Grids to avoid duplicate loading of OFX's on non-partitioned tables
Improve stability of TOP/SKIP paging
Improve stability of SELECT statements with multiple COUNT (DISTINCT …) clauses
Add support for multiple databases in Omnidex Grids
Version 5.3.05A Beta
Add support for MAX_THREADS option on SELECT statements
Add support for summing double datatypes with more than 256 distinct values with MIA
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
Version 5.3.07A
Use Omnidex Network Services by default, rather than OdxNet Network Services
Add support for POWERSEARCH option in QUALIFY statements
Version 5.3.07B
Version 5.3.07C
Version 5.3.07D
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
Version 5.3.07E
Version 5.3.07F
Version 5.3.07G
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.07H
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.07J
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.07K
Improve handling of file permissions on Linux
Resolve an issue with the idleTimeout setting in Omnidex network services configuration
Resolve an issue with double-nested query in the FROM clause
Version 5.3.08A
Add beta support for VX/RMS files
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.
Version 5.3.08B
Version 5.3.08C
Support for Oracle 12c
Support for REQUIRED_OPTIMIZATION settings of NO_EMBEDDED_WILDCARDS and NO_EXTENDED_WILDCARDS.
Support for SINGLE_OFX option to produce one OFX for multi-file delimited files.
Improve handling of error conditions from Windows WMI interface so that licensing is not disabled.
Improve how statements are logged to the Omnidex logs to handled escaped characters, quotes, and statement options.
Improve error handling of file permissions on index directories and files.
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.
Version 5.3.08D
Support for system logicals with VX/RMS
Support for declaring QUALIFY_MODE in the Omnidex environment file
Resolve issue with ODBC when using Oracle BI or Business Objects
Improve optimization of QUALIFY statements that have not A and not B …' syntax.
Version 5.3.08E
Improvements to Omnidex Network Services
Improvements to Omnidex Grid Pooling
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
Version 5.3.08F
Improvements to Omnidex Network Services
Improvements to license validation process
Support for logging of licensing activity
Improved output for 'omnidex -admin'
Improvements to ODBC driver to support compatability with Alpha Five software
Additional Resources