Changes in DBD::SQLAnywhere 2.04 19th October 2010 Used refcounting for SACAPI context since DBI can free driver handles before all database handles have been destroyed. Changes in DBD::SQLAnywhere 2.03 4th December 2009 Fixed fetching of double/floating point values Updated sacapi files. Changes in DBD::SQLAnywhere 2.02 1st October 2009 Previous driver (version 2.01) broke support to SQLAnywhere external through Perl. This has been fixed. Changes in DBD::SQLAnywhere 2.01 2nd June 2009 Improved threading support with SACAPI v1 and added SACAPI v2 support. Removed primary_key func (to rely on the one in DBI.PM) Added statistics_info (returns NULL) and last_insert_rowid Changes in DBD::SQLAnywhere 2.00 9th May 2008 Changed to use simplified SQLAnywhere C API (SACAPI). The driver can now be built without having SQLAnywhere installed but SQLAnywhere is required to use the driver. Added support for the the get_info method. Changes in DBD::SQLAnywhere 1.16 2nd Nov 2007, 28th Feb 2008, 17th March 17 2008 (version 1.15 was not released) Fixed installation location & increased version number so that we can detect it Support new bin32/bin64 directories for SQLAnywhere 11.0 on Windows Automated CPAN testing requires a successful exit from Makefile.PL if the module cannot be built (due to libs not found). Go figure. Changes in DBD::SQLAnywhere 1.15 17th July 2007 (version 1.14 was not released) Improved table_info routine Added column_info, primary_key, primary_key_info routines Changes in DBD::SQLAnywhere 1.14 18th Jan 2007 (previous changes to 1.14 were not released) Fixed UNIX builds. With the SQLAnywhere 10.0 release the bin and lib directories in the UNIX install have been renamed to bin32/bin64 and lib32/lib64. Fixed Makefile.PL to search for libraries in the correct path. Changes in DBD::ASAny 1.14 21th Nov 2006 (previous changes to 1.14 were not released) Fixed Windows x64 builds. Changes in DBD::ASAny 1.14 7th Sept 2006 (previous changes to 1.14 were not released) Added a manifest to the DLL for VS2005 builds. Changes in DBD::SQLAnywhere 1.14 9th Dec 2005 (previous changes to 1.14 were not released) Renamed from DBD::ASAny to DBD::SQLAnywhere for Jasper release which includes changes to use demo.db instead of asatest.db. Added -D_CRT_SECURE_NO_DEPRECATE to avoid VS2005 warnings. Cleaned up the README & the examples a bit. Added README.NT with CRLF line endings. Changes in DBD::ASAny 1.14 29th Jan 2004, 5th Apr 2005 Parsing for placeholders assumed that only single-quotes could be used to delimit a string. Now, either single or double quotes can be used. If fetch was called when there were no more rows, the driver set the err value to (integer) zero but DBI could interpret that as a warning because it converted it to a string and saw that it was non-empty. We now set err to the empty string. Changes in DBD::ASAny 1.13 7th Mar 2002, 3rd Sept 2003, 29th Oct 2003 Support 64bit UNIX platforms Avoid compile-time warning about assign_blob() Added /opt/sybase/SYBS* as default installation directories to search for ASA An error was reported if execute() was called twice on the same statement handle. Changed execute() to close a previously opened cursor using that statement. Also, the prepared statement was being dropped during finish() rather during destroy & that prevented the prepare_cache from working. Updated README to warn about resource governor errors now that statement handles are not dropped until destroy time. Set the "state" value on the handle when an error occurs. Fetching 64-bit integers failed when they contained more than 8 digits because we fetch them as strings but left the length as the size of the bigint datatype (8 bytes). Fixed additional compiler warnings from VC7. Added CLONE method. Added better handling for detecting new ASA versions -- should handle up to version 15 now (version 9 is the highest shipping version). Implemented the blob_read function which is an undocumented DBI API. Changed the long string/binary fetching code so that long character strings are fetched as varchar rather than binary so that character set translation will be applied to the string. Added a commit operation after a cursor is closed if AutoCommit is enabled. Previously, a commit was only performed if a non-cursor statement was executed. DML executed in procedures returning result sets were not committed. Added "-r" switch to sqlpp to generate thread-safe code. Added dbtasks library to UNIX link lines. Link against "_r" reentrant versions of ASA libraries when using ithreads on UNIX platforms. Avoid warning when building with VS.NET 2003 which has deprecated the /Gf switch (automatically added by MakeMaker). Changed it to /GF. Allow ASANY installation directory to be specified by the "ASANY{ver}" environment variable (ASANY9, ASANY8, etc). Changes in DBD::ASAny 1.12 11th May 2001 Fixed a problem with inout parameters where binding other parameters can cause us to find the incorrect location of the output parameter in the output SQLDA. Correctly handle NULL output parameters from procedures. Removed some debug printfs that snuck into v1.10. Corrected README to show that bind_param_inout is a supported function. Do not treat warnings as errors (err/errstr are still set but the calls to execute/fetch will not report a failure). Changes in DBD::ASAny 1.11 27th March 2001 Calling a procedure or batch that returned a result set for which the engine could not infer the data types, errors were reported. Fixed by describing the cursor after it was opened. Changes in DBD::ASAny 1.10 13th November 2000 Added support for AutoCommit. Changes in DBD::ASAny 1.09 21st September 2000 Added support for type_info_all and (indirectly) quote() Added support for the following statement attributes: TYPE, ASATYPE, SCALE, PRECISION, NULLABLE, CursorName, Statement, and RowsInCache. RowsInCache always returns undef. ASATYPE returns an array of native ASA type codes which is more detailed than the ODBC-types returned by the TYPE attribute. ASA type codes correspond to integer values defined in sqldef.h or you can use ASA type codes directly by doing 'use DBD::ASAny qw(:asa_types);' Changed handling of parameters to the connect() method to be more consistent with other drivers. Fixed a memory leak: space allocated for non-string, non-binary fields of an output SQLDA were not freed. Changes in DBD::ASAny 1.08 15th August 2000 When executing a statement that affected zero rows, an error was reported rather than success. Fixed driver to build with ActivePerl build 616 and DBI 1.14. Makefile now searches for SQLAnywhere in /opt/SYBSsa[6-9] as well as /opt/SYBSasa[6-9]. Changes in DBD::ASAny 1.07 17th May 2000 Fixed bug introduced in 1.06 - a statement that is prepared then dropped before being used could cause a GPF. Minor revision to license text. Changes in DBD::ASAny 1.06 10th March 2000 Added support for blobs and long strings. Values transferred to or from the engine can be up to 2GB in size. Default LongReadLen value for DBD::ASAny is 1MB. There is no default limit to the length of string that can be written (there appears to be no 'LongWriteLen' attribute in DBI). Added support for treating strings as binary data. When sending data to the engine (for an insert or update), the user must provide the DBI::SQL_BINARY or similar type attribute in a bind_param call. For fetching data, DBD::ASAny automatically detects that a column is binary. If binary data is treated as text it may be subjected to character set translation. Removed reference to GNU public license/Artistic license. Changes in DBD::ASAny 1.05 25th January 2000 Added Sybase license agreement Adding a call to db_fini when a connection attempt failed. Not calling db_fini in this situation caused a memory leak. Added better handling for detecting new ASA versions -- should handle up to version 9 now (which doesn't exist yet...) Changes in DBD::ASAny 1.04 19th November 1999 Fixed inout parameter support. Moved changes info from Makefile.PL to this file. Changes in DBD::ASAny 1.03 9th November 1999 Driver now builds on HPUX, AIX, Linux with native and GNU compilers. Dynamically resize SQLDA for bind variables or output values if the default size is not large enough. Avoid "memory leak" caused by dblib holding onto cursor information so that the cursor can be reopend without being redeclared. Changes in DBD::ASAny 1.02 21st October 1999 Driver should now be thread safe & it builds with the threaded version of perl; however, perl threads and/or DBI in a threaded environment is very unstable. Simple multithreaded tests easily crash perl. Changes in DBD::ASAny 1.01 5th August 1999 Initial Win32 support by Matthew C. Keranen (mck@iag.net). Win32 version requires ActivePerl (www.activestate.com). Changes in DBD::ASAny 1.00 8th December 1998 Changed SQL Anywhere driver (DBD::SQLAny) into Adaptive Server Anywhere driver(DBD::ASAny)