CHANGE HISTORY
==============

Since the 1.1.0.0 release we have changed the way changes are reported
and numbered. From 1.1.0.0, every fix/change gets a new build number.

Since 1.1.10 we have changed to using 3 part version numbers which are
major.minor.build.

1.3.16 (16-09-2021)

  Fix seg fault if index file is missing

1.3.11 (02-11-2007)

  Include newer version of SQL Engine with fix for NOT LIKE

1.3.8 (06-11-2006)

  Include newer version of SQL Engine for 64 bit support

1.3.7 (24-02-2005)

  Include newer version of SQL Engine in windows distribution

  Fix a problem with conversion from ODBC 3 to ODBC 2 types in the result
  set from a SQLColumns call. (BZ1501)

1.3.6 (06-6-2005)
=================

  Included Easysoft ODBC-SQI SQL Engine version 2.5.8. For a list of changes
  / fixes in this release see :-
  
  Non-Windows 
  ~~~~~~~~~~~
    /usr/local/easysoft/isam/doc/Engine_Changes.txt

  Windows
  ~~~~~~~
    Engine_Changes.txt in 
    Start->Programs->Easysoft->Easysoft Data Access for ISAM->Documentation.

1.3.5 (17-5-2005)
=================

  Included Easysoft ODBC-SQI SQL Engine version 2.5.7. For a list of changes
  / fixes in this release see :-
  
  Non-Windows 
  ~~~~~~~~~~~
    /usr/local/easysoft/isam/doc/Engine_Changes.txt

  Windows
  ~~~~~~~
    Engine_Changes.txt in 
    Start->Programs->Easysoft->Easysoft Data Access for ISAM->Documentation.

1.3.3 (05-5-2005)
=================

  Included Easysoft ODBC-SQI SQL Engine version 2.5.5. For a list of changes
  / fixes in this release see :-
  
  Non-Windows 
  ~~~~~~~~~~~
    /usr/local/easysoft/isam/doc/Engine_Changes.txt

  Windows
  ~~~~~~~
    Engine_Changes.txt in 
    Start->Programs->Easysoft->Easysoft Data Access for ISAM->Documentation.

1.3.1 (24-3-2005)
=================

  Bug 1736, calculation of precisions and scale for numeric operations sometimes
  returns a lower precision than is required.

1.3.1 (11-3-2005)
=================

  Bug 1711, problem with TRAILING-OVERPUNCHED-NUMERICS datatype not 
  correctly calculating the minimum value allowed in a field.

1.3.0 (1-2-2005)
================

  Add support for Solaris 10.

  Bug 1312. EDA-ISAM dependencies on ODBC-ODBC Bridge versions is not
  enforced properly. This means it is possible to install EDA-ISAM
  (or upgrade it) when you have an earlier ODBC-ODBC Bridge without the
  installer warning the ODBC-ODBC Bridge is too old.

  Bug 1649. Add a message to the startup banner of the sql (demosql)
  program warning that all SQL entered must be terminated with a ';'.

  Included Easysoft ODBC-SQI SQL Engine version 2.5.1. For a list of changes
  / fixes in this release see :-
  
  Non-Windows 
  ~~~~~~~~~~~
    /usr/local/easysoft/isam/doc/Engine_Changes.txt

  Windows
  ~~~~~~~
    Engine_Changes.txt in 
    Start->Programs->Easysoft->Easysoft Data Access for ISAM->Documentation.
 
1.2.14 (08-12-2004)
===================

  Bug 1279 a statement containing a aggregate function, that has no 
  matching rows, lost the single row output when a GROUPBY was employed.

  Bug 1489 with the large file builds, a missing return statement could 
  cause a error whilst sorting. "OSFile err 110".

1.2.13 (23-11-2004)
===================

  Bug 1417 problem with index selection routines when multiple fields
  are mapped over the same index segment (redefines).

1.2.12 (11-11-2004)
===================

  Changed the SQI layer to return null for cardinality and pages columns
  when using the SQLStatistics call.

1.2.11 (09-11-2004)
===================

  Added new setting statistics into datasource configuration, this element
  allows the behaviour of the SQLStatistics call to be altered. 

  See /usr/local/easysoft/isam/doc/INSTALL.txt for more details.

1.2.10 (08-11-2004)
===================

  Included Easysoft ODBC-SQI SQL Engine version 2.4.10. For a list of changes
  / fixes in this release see :-
  
  Non-Windows 
  ~~~~~~~~~~~
    /usr/local/easysoft/isam/doc/Engine_Changes.txt

  Windows
  ~~~~~~~
    Engine_Changes.txt in 
    Start->Programs->Easysoft->Easysoft Data Access for ISAM->Documentation.

1.2.9 (19-10-2004)
==================

  Bug introduced when HP-UX 11 PA-RISC 1 build was changed to use dlopen.
  This caused core dumps on unpatched early HP-UX 11 versions. Changed back
  to use shl_load.

1.2.8 (09-09-2004)
==================
  
  Bug ID (1246) HP-UX 11 PA-RISC 1 build only, when a server based process
  opened multiple odbc connections the disconnect of the first connection
  caused all other instances to be unloaded.

1.2.7 (07-09-2004)
==================

  Bug ID (1230) Maximum positive value check for SPACE-RIGHT-LN datatype
  was checking a value on digit less than the possible maximum length.

1.2.6 (27-08-2004)
==================

  Included Easysoft ODBC-SQI SQL Engine version 2.4.8. For a list of changes
  / fixes in this release see :-
  
  Non-Windows 
  ~~~~~~~~~~~
    /usr/local/easysoft/isam/doc/Engine_Changes.txt

  Windows
  ~~~~~~~
    Engine_Changes.txt in 
    Start->Programs->Easysoft->Easysoft Data Access for ISAM->Documentation.

1.2.5 (05-08-2004)
==================
  
  Bug ID (971) new datatype added V14.SIRSI-TIMESTAMP, big endian integer
  containing a count of seconds since the 1st January 1970. The resultant
  date is passed throught localtime to apply the servers timezone.

1.2.4 (05-08-2004)
==================

  Bug ID's (846, 1118) V14.SIRSI-MONEY datatype incorrectly returning
  digits after decimal place and also datatype changed to be big
  endian (instead of native endian).

1.2.3 (12-05-2004) (HP-UX Only)
===============================

  UnixODBC included within distribution needed to be recompiled due to
  missing --enable-stats=no argument this can cause applications to hang
  within UnixODBC due to running out of semundo structures.

1.2.2 (07-05-2004)
==================

  Included Easysoft ODBC-SQI SQL Engine version 2.4.7. For a list of changes
  / fixes in this release see :-
  
  Non-Windows 
  ~~~~~~~~~~~
    /usr/local/easysoft/isam/doc/Engine_Changes.txt

  Windows
  ~~~~~~~
    Engine_Changes.txt in 
    Start->Programs->Easysoft->Easysoft Data Access for ISAM->Documentation.

1.2.1 (28-04-2003)
==================

  BUG ID (769) problem with ascii dates incorrectly using pad character
  for individual format elements, for space padded date types this would
  cause leading zeros in days and months to be replaced with space.

1.2.0 (18-03-2004)
==================

  Upgraded to latest release of unixODBC (2.2.7) (non-windows only).

  Included Easysoft ODBC-SQI SQL Engine version 2.4.5. For a list of changes
  / fixes in this release see :-
  
  Non-Windows 
  ~~~~~~~~~~~
    /usr/local/easysoft/isam/doc/Engine_Changes.txt

  Windows
  ~~~~~~~
    Engine_Changes.txt in 
    Start->Programs->Easysoft->Easysoft Data Access for ISAM->Documentation.

  Included Easysoft ODBC-ODBC Bridge version 1.4. For a list of changes /
  fixes in this release see /usr/local/easysoft/oob/doc/Changes.txt.

  BUG ID (589) When Unixware distribution is untarred error message 
  tar : Cannot get passwd information for sources was displayed.

  BUG ID (586) warning message displayed regarding md5sum when installing
  on Unixware.

  BUG ID (94) during conversion descending unique keys were being marked
  as the primary key, in SQL terms primary keys cannot be descending.
  This has now been changed to not mark descending keys as primary.

  BUG ID (93) users.sh script can now be run from any location, previously
  this could only be run from /usr/local/easysoft/isam/bin.

  BUG ID (97) Web administration server compared datasources against the 
  driver name Easysoft Data Access for ISAM  for the latest version of
  unixODBC this needs to check against EASYSOFT_ISAM.

  BUG ID (98) Datasources created during installation were missing description
  field.

  BUG ID (194) Default values on decimal columns not being written to file.

1.1.24 (10-06-2003)
===================
  Included Easysoft ODBC-SQI SQL Engine version 2.3.17. For a list of changes
  / fixes in this release see :-
  
  Non-Windows 
  ~~~~~~~~~~~
    /usr/local/easysoft/isam/doc/Engine_Changes.txt

  Windows
  ~~~~~~~
    Engine_Changes.txt in 
    Start->Programs->Easysoft->Easysoft Data Access for ISAM->Documentation.

1.1.23 (20-05-2003)
===================
  Included Easysoft ODBC-SQI SQL Engine version 2.3.15. For a list of changes
  / fixes in this release see :-
  
  Non-Windows 
  ~~~~~~~~~~~
    /usr/local/easysoft/isam/doc/Engine_Changes.txt

  Windows
  ~~~~~~~
    Engine_Changes.txt in 
    Start->Programs->Easysoft->Easysoft Data Access for ISAM->Documentation.

1.1.22 - BUG ID : 2172 (12-05-2003)
===================================
  Various memory leaks cleared in SQI-ISAM Driver discovered internally during
  pre-release testing.

1.1.21 - BUG ID : 2194 (08-05-2003)
===================================
  Command line sql utility on windows now outputs arguments when no arguments
  are specified on the command line.

1.1.20 - BUG ID : 2192 (08-05-2003)
===================================
  Easysoft ODBC Version 1.4/1.5 catalog converter on windows gave incorrect
  example directory (displayed a unix example).

1.1.19 - BUG ID : 2170 (08-05-2003)
===================================
  Command line sql utility now outputs an additional blank line once an
  incoming file of sql statements has completed executing.

1.1.18 - BUG ID : 2169 (08-05-2003)
===================================
  Various minor changes to the UNIX install scripts for better handling of 
  errors.

1.1.17 - BUG ID : 2159 (07-05-2003) (non-windows only)
======================================================
  Additional text added to the end of the installation to notify users to 
  change the default administrative password for their catalog.

1.1.16 - BUG ID : 2158 (07-05-2003) (non-windows only)
======================================================
  If a non-privileged user attempted to stop the web administration server
  using the stop_http.sh script the routine would spin reporting the same
  error message until an interrupt was received, this behavour has been
  fixed.

1.1.15 - BUG ID : 2154 (07-05-2003)
===================================
  Web administration server would fail if an apostrophe was passed in the
  description field when adding or updating users.

1.1.14 - BUG ID : 2153 (07-05-2003) (Linux Distributions Only)
==============================================================
  On newer versions of linux distributions \c in scripts is not 
  interpreted unless echo is called with a -e option, this has been 
  changed for the administration web server start and stop scripts.

1.1.13 (07-05-2003) (non-windows only)
======================================
  Wording changes to datasource.txt file to generalise on where the
  ODBC Data Sources applet can be found within different versions of
  Windows.

1.1.12 (24-03-2003) (non-windows only)
======================================
  Introduced two new connection settings which may be set within the 
  data source (null_insert_check and null_update_check) see INSTALL.txt
  text file for an explanation of these options.

1.1.11 (17-03-2003) (non-windows only)
======================================
  Upgraded to latest release of unixODBC (2.2.5).

1.1.10 (14-03-2003)
===================
  Easysoft ODBC-SQI SQL Engine corrupting memory when using long varchar's 
  and long varbinaries.

1.1.0.9 (20-02-2003)
====================
  Easysoft ODBC-SQI SQL Engine was leaking memory on large sorts, eventually
  causing the process to core dump.

1.1.0.8 (18-02-2003) (windows only)
===================================
  Mutexes were not correctly being initialised on windows, this could cause
  thread safe issues with multithreaded windows applications.

1.1.0.7 - BUG ID : 1893 (18-02-2003) (non-windows only)
=======================================================
  UnixODBC header file sqlucode.h missing from non-windows distributions, this
  file is needed when trying to build perl dbd module on the top of Easysoft
  Data Access for ISAM.

1.1.0.6 - BUG ID : 1919 (18-02-2003)
====================================
  Spelling mistake corrected in error message reported when a length is
  specified which is greater than the datatypes maximum length.

1.1.0.5 - BUG ID : 1930 (18-02-2003)
====================================
  When inserting data columns which were not nullable or the underlying datatype
  was not nullable were allowed to proceed. 
  These inserts will now return error messages indicating that either the column 
  or datatype in question is not nullable.

1.1.0.4 (18-02-2003)
====================
  Easysoft ODBC-SQI SQL Engine was failing with memory corruption on the
  following sql types.

  LONG VARCHAR
  LONG VARBINARY

1.1.0.3 (05-02-2003) (non-windows only)
=======================================
  Included Easysoft ODBC-ODBC Bridge version 1.2. For a list of changes /
  fixes in this release see /usr/local/easysoft/oob/doc/Changes.txt.

1.1.0.2 (03-02-2003) (non-windows only)
=======================================
  INSTALL.txt file updated to describe various settings which may be set
  within the data source (/etc/odbc.ini).
  
1.1.0.1 - BUG ID : 1835 (23-01-2003)
====================================
  Problem with exporting tables (using Microsoft Access) to ISAM. If
  column type to be exported was a long varchar the Easysoft ODBC-SQI
  SQL Engine could crash.

1.1.0.0 (19-12-2002)
====================

 28-11-2002  Included Easysoft ODBC-ODBC Bridge 1.1.0.0 into package. 
             For a list of changes see the file Changes.txt in the 
             directory /usr/local/easysoft/oob/doc/ (non-windows only).

 25-11-2002  Added unixODBC cursor library into distribution. This would not
             cause any problems when accessing ISAM data but may effect other 
             easysoft products installed on the same server (non-windows only).
             Jitterbug number : 1737.

 21-11-2002  Problem with multiple table joins in sql statements causing SQL
             Engine to segmentation fault fixed.
             Jitterbug numbers : 1715, 1716.

 05-11-2002  Fixed problem with SQL92 NUMERIC datatype not correctly returning
             values after a null value had been returned.
             Jitterbug number : 1713.

 17-10-2002  Convert routine (converts Easysoft ODBC for ISAM catalogs
             into Easysoft Data Access for ISAM format), has been changed
             to allow datatype conversion details to be changed / overridden.

 11-10-2002  Upgraded to latest release of unixODBC (2.2.4) (non-windows only).

 10-10-2002  Updated to latest Disam96 source library, supplied by Byte
             Designs. This update fixed a problem whereby the disam source
             would crash upon inserting large numbers of records into a 
             file which contained compressed duplicate keys.
             Jitterbug number : 1559.

 04-10-2002  Included Easysoft ODBC-ODBC Bridge 1.0.0.42 into package. 
             For a list of changes see the file Changes.txt in the 
             directory /usr/local/easysoft/oob/doc/ (non-windows only).

 25-09-2002  Definition for datatype V14 ABC-STRING changed, this type
             should have encoded the maximum length (precision) for the field 
             rather than the actual length.
             Jitterbug Number : 1507.

 25-09-2002  If column is marked as not nullable in the table definition
             nulls will no longer be returned from the underlying datatype
             regardless of whether the datatype supports nulls or not.

 24-09-2002  When inserting values in some cases default values were simply
             initialising the buffer to 0x00. This behaviour has now changed
             so that if a column is nullable its default value will be null 
             as long as no default value has been set.

 27-08-2002  Upgraded to latest release of unixODBC (2.2.3) (non-windows only).

 21-08-2002  Problem with Packed decimal types not correctly writing / reading
             small values less than 1 (e.g. -0.008 or 0.007).
             Jitterbug Number : 1425.

 06-08-2002  Enabled large file (>2GB) support on aix 4.3 and above.

 05-08-2002  Changed demonstration data source to set umask = 0666. This will
             allow all users access to any files created within the sample_isam
             data source (non-windows only).

 01-08-2002  Added new disam library to support cisam 7.26 (non-windows only).
             
1.0.0.17 
~~~~~~~~

 24-05-2002  Easysoft Data Access for ISAM now allows files to be accessed
             which have no extension, previously a symbolic link was 
             required.

 03-05-2002  Included Easysoft ODBC-ODBC Bridge 1.0.0.40 into package. 
             For a list of changes see the file Changes.txt in the 
             directory /usr/local/easysoft/oob/doc/ (non-windows only).

 15-04-2002  Added powerhouse definition parser (pdlcnv). This binary
             takes the output from powerhouse qshow and generates
             definitions which can be imported into Easysoft Data Access
             for ISAM (non-windows only).

 11-04-2002  Easysoft ODBC version 1.4 converter changed to take into
             account changes made for sequential files and rowid's. Also
             any version 1.4 tables with criteria will now be converted
             into views.

 10-04-2002  Added ability for software to access fixed length sequential
             files. Only read and insert functions are supported on these
             file types (no delete, update, etc ..).

 09-04-2002  Five remaining datatypes from version 1.4 datatype list have 
             been added. 
             
             BDC-OVERPUNCHED-NUMERIC
             SOCIALE-DATE
             SOCIALE-DATE-REV
             SIRSI-MONEY
             SPECIAL-DATE-15

 08-04-2002  Isam rowid can now be defined within a table by using datatype
             group ISAM and datatype name ROWID. This value can also be 
             defined as a key field within the administrator.

1.0.0.16 
~~~~~~~~
 
 18-03-2002  Added catalog_null and schema_null arguments to data source.
             Setting these two values to 1 will allow sql server via
             linked servers to access Easysoft Data Access for ISAM tables
             which were defined without a catalog and schema.

 04-03-2002  Added case_insensitive setting in data source to allow metadata
             calls to become case insensitive.

 22-02-2002  Jitterbug number 1347. Incorrectly defined datatype, 
             TRAILING-NEGSIGN-DECIMAL should write a physical decimal point
             when decimal digits are included.

 22-02-2002  Added MAGIC-STRING-MEMO-4 datatype. Which is a string with
             a 4 byte native endian integer containing the length of the
             following string.

 21-02-2002  Included Easysoft ODBC-ODBC Bridge 1.0.0.38 into package. 
             For a list of changes see the file Changes.txt in the 
             directory /usr/local/easysoft/oob/doc/ (non-windows only).

 18-02-2002  Jitterbug number 1293. SQL Engine problem with un-initialized
             memory in views. A query joining two views would return different
             results on subsequent runs.

 18-02-2002  Jitterbug number 1297. SQL Engine drop view not working.

 17-02-2002  Jitterbug number 1310. SQL Engine returning invalid return code
             upon executing a query on a view.

 17-02-2002  Jitterbug number 1316. SQL Engine problem with left joins
             on views.

 14-02-2002  Jitterbug number 1267. SQL Engine joining two views returns 
             no rows.

 23-01-2002  Jitterbug number 1319. V14 STRING datatype index operators
             set to all to allow fastmode operation.
 
 21-01-2002  Jitterbug number 1315. Whereby web administrator required two
             connections on initial connect.

 03-01-2002  Jitterbug number 1256. SQL Engine problem with un-initialized
             fields in the Views. This caused views containing timestamps 
             to return errors.

1.0.0.15
~~~~~~~~

 12-12-2001  Fixed problems with loaded isam libraries calling disam
             functions included in engine (SCO, SIEMENS).

 23-11-2001  Fixed problems with ISAM INT and ISAM LONG datatypes not
             parsing correctly.

 10-11-2001  Installation stops any currently running httpisam servers
             before new distribution is extracted (non-windows only).

 08-11-2001  Included ability for D-ISAM transactions to be enabled. 
             Read transations.txt for an overview of how transactions are
             handled by D-ISAM.

 18-10-2001  Added a check in table create so that sql type specified
             must match sql type of local datatype.

 18-10-2001  Conversion from version 1.4 type BD-DEC was assigning a
             multiplier value if a scale existed, the scale for this
             type in version 1.4 doesn't have any effect. Changed
             version 1.4 convert to map any BD-DEC fields with a scale
             to SQL_NUMERIC (precision, scale).

 18-10-2001  Added isam INT and LONG types into fastmode index
             walking mechanism. Changed several datatype definitions
             to take advantage of this setting.

 17-10-2001  Added additional restrictions on fastmode selection to
             ensure that fastmode cannot cause looping.

 17-10-2001  Long varchars not being returned correctly if file scan
             was performed (long buffers not being reset).

 12-10-2001  Any string types with encoded lengths could cause access
             violations on insert/update. (dtsqlstring.c).

 29-09-2001  Catalog administrator did not export SQL_FLOAT types correctly.
  
 06-09-2001  SPACES-LEFT-D datatype incorrectly defined in catalog. 

1.0.0.14
~~~~~~~~
 08/08/2001   Added new datatypes to cater for unsigned ascii numerics.

 08/08/2001   Changed several incorrectly defined negative sign only
              numerics which were still writing back the positive
              sign.

1.0.0.13
~~~~~~~~
 01/08/2001   Added custom key types into disam libraries to improve
              compatibility with Easysoft ODBC for ISAM version 1.4.
 
 28/07/2001   Internally reported engine bug (jbug id 1159) which caused
              crash if multiple sqi's were present beneath the engine and 
              the connection to the first sqi failed.

 19/07/2001   Select * from table where field is not null could return
              the wrong rows if the field in question was indexed.

 19/07/2001   SQL engine fix for access violation when performing an
              inner join from table a back to table a.

1.0.0.12
~~~~~~~~
 25/06/2001   Added several new datatype groups to simplify task of 
              defining files.

1.0.0.11
~~~~~~~~
 13/06/2001   LONG VARCHAR datatypes in Microsoft Access 2000 causing access 
              violations.  

 13/06/2001   Added two new version 1.4 types BPDATE and BPDOUBLE.

1.0.0.10
~~~~~~~~
 21/05/2001   Key information on disam files with no primary key was looping 
              in the Administrator.

1.0.0.9
~~~~~~~
 18/05/2001   Loadable isam libraries needed rebuilding due to variable length 
              files (ISVARLEN and ISVARCMP) types being incorrectly reported 
              back to the sqi.

1.0.0.8
~~~~~~~
 16/05/2001   When creating new tables specifying additional easysoft specific 
              arguments to override column datatypes caused subsequent columns 
              to be left with incorrect datatype values.

1.0.0.7 (non-windows only)
~~~~~~~~~~~~~~~~~~~~~~~~~~
 08/05/2001   Added ability for isam install to check for existence of Easysoft 
              ODBC-ODBC Bridge and if not installed allow it to be installed.

1.0.0.6
~~~~~~~
 08/05/2001   Added MAGIC-DATE and MAGIC-TIME datatypes.

1.0.0.5
~~~~~~~
 08/05/2001   Create table statements with numeric type specifying no precision 
              and scale now defaults to precision 18 and scale 0.

1.0.0.4 (non-windows only)
~~~~~~~~~~~~~~~~~~~~~~~~~~
 04/05/2001   Installer now creates two data sources on installation and
              installs two scripts demosql and easysql to access them.

1.0.0.3
~~~~~~~
 03/05/2001   Added BD-DEC and MAGIC-NUMBER datatypes.

1.0.0.2
~~~~~~~
 26/04/2001   Changed sqi layer to dynamically load isam driver using 
              isamlibrary= setting in data source, this allows more
              flexibility and fixed a problem with duplicate symbols on HP-UX.
1.0.0.1
~~~~~~~
 25/04/2001   Remove datatype.dat and datatype.idx from sample data as this 
              was causing problems on big endian platforms.
 
