Omnidex 5.1 Patches

The following is a list of fixes and enhancements for the Omnidex 5.x series of releases.

For a list of fixes and enhancements for Omnidex 5.0 series, click here.

For a list of fixes and enhancements for Omnidex 4.x series, click here.

• Fixed problem in internal oaexecsql routine to allow the Oracle functions within an Export statement.
• Fixed Segmentation Fault error in the SQL optimizer.
• Fixed Licensing system to work on read-only file systems.

• Fixed an issue to allow spaces in the OMNDIEX_HOME directory.

• Internal licensing change for flat file licensing.
• Fixed an issue with the internal dbigetkeys optimizer and the indexing kernal.

• Fixed a problem when using EXISTS in an Omnidex Grid environment.
• Added a facility to create an odxnet.log in the $OMNIDEX_HOME/logs/ directory should OdxNet abort abnormally.
• OdxSQL no longer requires Windows file specifications to be escaped when using a connection string. Prior to 5.01.01G, the following syntax was required when using Windows filespecs and connection strings:

odxsql> connect [localhost:7555]c:\\dev\\odx\\myodx.xml;

Now the following syntax is allowed:

odxsql> connect [localhost:7555]c:\dev\odx\myodx.xml;

• Fixes to OdxNet to better handle network processing across a grid.
• As of the 5.01.01F release, the Index Directory option of the CREATE DATABASE no longer uses the index prefix option and will instead create the directory if they do not already exist in the OS. Existing DDL may have to be modified if they are using the Index_Directory/Index_Prefix option.

• Added several Oracle functions which can be used after a SET SQL_SYNTAX ORACLE statement is issued.
• Made improvements to OdxNet for Grid processing and the ODBC/JDBC interfaces.
• Enhanced Explain Plans to show Grid information.

• Added Machine (System and User) Data Source creation and editing to the Omnidex ODBC Driver under Windows. You create/modify/delete System/User/File DSN using the standard “ODBC Data Source Administrator” program. Access this interface from Control Panel/Administrative Tools/Data Sources (ODBC).

• Under Linux, you need to use odbcinst program if you use UnixODBC. Otherwise, you need to manually modify ODBC.INI file.

• Omnidex Data Definitiion (DDL) support
  • CREATE ENVIRONMENT
  • CREATE DATABASE
  • CREATE TABLE
  • CREATE INDEX
  • DROP ENVIRONMENT
  • DROP DATABASE
  • DROP TABLE
  • DROP INDEX

Omnidex Index is a MDK index with the No Parse and No Exclude options (dbinstal NP, NE).
QuickText Index is a MDK index with the keyword option (dbinstal KW).
FullText Index is a MDK index with the proximity option (dbinstal PX).

As of Omnidex 5.1 XML Environments are the preferred approach over the legacy Omnidex Environment Catalogs using the original OmniAccess Environment syntax and compiled with oacomp. With 5.1, XML Environments can be more easily maintained with the OdxSQL using the DDL CREATE statements. The new Omnidex Environment file is stored in the common XML format.

• NsAdmin does not work.
• odxnet -admin option is not currently active.
• odxnet -nodaemon option is disabled.

• OdxSQL now defaults to using a terminator, like Oracle or SQL Server. In 5.0 and earlier, you could do:

select * \
  from grs \
  where criteria

and not have to end with a terminator. Now you can do:

select * 
  from grs
  where criteria;

and not have to enter the continuation characters.

To get the previous behavior, use the following OdxSQL SET option.

set termination off

and it will use the 5.0-style behavior.