| Changelog for ibm_db2 |
| Release |
What has changed? |
| 2.3.1 |
- Try to use out_length for bound character columns when smaller than strlen.
This is to work around an issue on IBM i where SQL/CLI returns garbage after out_length.
Note that strlen is still used to keep existing behaviour with nulls in strings;
binary bound columns are also not affected. |
| 2.3.0 |
- Support for PHP 8.5
- Fix garbage in column names on IBM i
- Fix binding empty strings with WVARCHAR |
| 2.2.2 |
- Support for PHP 8.4
- Update header version |
| 2.2.0 |
- Support for PHP 8.3
- Support for boolean data type (IBM i 7.5, Db2/LUW 9.6)
- Passwords and connection strings are marked as sensitive parameters
- Build system improvements for finding driver library
- CI and test suite improvements |
| 2.1.7 |
Corrects a packaging mistake in 2.1.6. |
| 2.1.6 |
* 2022-08-24: 2.1.6
- Allows fetching the current naming mode with db2_get_option on IBM i.
- Uses the password (obfuscated in memory) as part of the persistent resource hash key. This means the password must be the same to reuse a persistent connection.
- Fixes build issues with 64-bit Windows.
- Fixes crashes with level 4 i5_check_pconnect.
- Cleans up CI for modern IBM i and PHP 8.1. |
| 2.1.5 |
* 2021-09-30: 2.1.5
- Use the new persistent resource API introduced in 7.3 (PHP 7.3 is new minreq)
- Fix truncation issues in db2_result
- Fix typo with character trim
- Fix issues with trim returning empty string if it should only return one char
- Fix leaks with various functions (result, get_option, escape_string, etc.)
- Fix build issue with ulong on some platforms |
| 2.1.3 |
* 2021-03-10: 2.1.3
- Report failures in SQLGetDiagRec. This should warn on many silent errors.
- Workaround issue with using SQLGetSubString with a large buffer on a DBCLOB
with locator by trimming from first instead of last null byte.
- Workaround bug in SQL/CLI caused by unknown PTF, which causes a buffer
overflow with SQLGetData on char-like values. The PTF causing the regression
is unidentified, but workaround PTFs seem to exist, including SI75759. The
workaround will likely be kept until most no longer have the defective PTF. |
| 2.1.2 |
* 2020-12-22: 2.1.2
- Fix memory leaks
- Remove PHP 5 compatibility stubs and ifdefs
- Fix compile warnings
- Use PHP 8 arginfo generator, with generated fallbacks for PHP 7 |
| 2.1.1 |
* 2020-12-02: 2.1.1
- Fix build regression on LUW with db2_execute_many |
| 2.1.0 |
* 2020-11-30: 2.1.0
- Compatibility with PHP 8
- Fix compatibility with 64-bit PASE/modern IBM i (sqlcli-dev package, pointer/integer width mismatch, XMLSERVICE location, etc)
- Backport character trim from Zend Server
- Major improvements to test suite (fix broken tests, less hardcoding)
- Handle CCSID 65535 on IBM i
- Fix warnings (returning void from non-void, etc) |
| 2.0.8 |
Fixed Crash in windows with PHP 7 |
| 2.0.7 |
Added PHP 7.3 Support. |
| 2.0.6 |
Fixed crash while in windows. |
| 2.0.5 |
Fixed config.m4 file which messed up in last release. |
| 2.0.4 |
Added support for PHP 7.2 |
| 2.0.3 |
Added support for PHP 7.2 |
| 2.0.2 |
Fixed memory leak stored procedure i/o param both IBM i and LUW.
Customer request abandon 'executing' persistent connection for IBM i |
| 2.0.1 |
Fixed : signal 11 in db2_pconnect
Fixed : Security flaw with using user and password for hashing in db2_pconnect.
Fxied : Local scope bound values in a class are not used
Fixed : Compilation issue of PHP-5.6 in windows. |
| 2.0.0 |
Fixed : signal 11 in db2_pconnect
Fixed : Security flaw with using user and password for hashing in db2_pconnect.
Fxied : Local scope bound values in a class are not used |
| 1.9.9 |
Enhanced: Added PHP 7 support and fixed linking error. |
| 1.9.8 |
Enhanced: Added PHP 7 support. |
| 1.9.7 |
Enhanced: Code refactoring to enhance maintainability of code
Removed: IBM i V5R4 is no longer supported
Removed: unsupported test cases of V5 removed |
| 1.9.6 |
Fixed: Fetching of mixed character data when the application code page different from database code page
Fixed: db2-bind-param with INOUT LOB parameters
Enhanced: Enable iSeries system naming mode from LUW to iSeries
Enhanced: Clear global error state at end of request |
| 1.9.5 |
Fixed: Segfault due to INTERNED strings in PHP-5.4.x
Enhanced: execute_many API to accept NULL mixed with other values. |
| 1.9.4 |
Fixed: DB2 PHP driver does not work as expected with values in BIGINT column
Added: test case test_bigint.phpt for BIGINT datatype
Fixed: Persistent connections takes up to 1 hour to reconnect on db2 TSA HA failover
FIxed: Fixed: Allow trial license to connect ZOS/i5
Added a environment variable IBM_DB_HOME to make the installation process easy and config script will automatically detect the architecure for which PHP is built and accordingly use the libraries under lib32/lib64. |
| 1.9.3 |
Fixed: Garbage value for VARCHAR type OUT variable of stored-procedure
Fixed: Compilation error with php-5.4.x
i5/OS: Remove compile errors during IBM i compiles due to chaining support
i5/OS: Allow use of V6+ (SQL_ATTR_INFO_ACCTSTR, SQL_ATTR_INFO_APPLNAME, SQL_ATTR_INFO_PROGRAMID, SQL_ATTR_INFO_USERID, SQL_ATTR_INFO_WRKSTNNAME connection attributes) |
| 1.9.2 |
Added execute_many() API to execute batch.
Fixed: Connection hanging issue.
Fixed: Defect #20281 (Improve error reporting) |
| 1.9.1 |
Fix for db2_statistics (Failing with pconnect). |
| 1.9.0 |
Fix for BIGINT fix for i5.
Fix for autocommit issue (CLI setting is now handled).
Fix for db2_pconnect connection reset issue.
Fix for connection rollback in db2_pconnect at the end of request. |
| 1.8.4 |
Adding support for query time out.
Fixing problem with DATE/TIME datatype.
i5/OS Add new attribute DB2_I5_JOB_SORT_ON/OFF (php.ini ibm_db2.i5_job_sort).
i5/OS Fix BIGINT string type to help with larger values.
i5/OS Fix "early" terminate fetch loops due to CLOB/BLOB zero length.
i5/OS Fix db2_pclose() to allow reset persistent connections. |
| 1.8.3 |
Fixed 14347: ibm_db2 1.6.6 fails to compile (still a problem w/ 1.8.2).
Fixed 16257: db2_execute() Segfault on an empty string as a bind parameter.
Fixed: GRAPHIC, VARGRAPHIC Data type error. |
| 1.8.2 |
Fixed 15601: Adding Real Datatype support.
|
| 1.8.1 |
Adding Mac OS support.
Adding DecFloat Datatype support.
Updating test case names.
|
| 1.8.0 |
Adding SQLRowCount feature.
|
| 1.7.1 |
Added last insert ID feature.
|
| 1.7.0 |
Add trusted context support.
Bug 13185 - Updating wrong row (fixed).
Bug related to special character fixed.
|
| 1.6.6 |
Fixing defects in test cases.
Bug in zero length string has been fixed.
|
| 1.6.5 |
Updating the module version.
|
| 1.6.4 |
Fixed db2_escape_string() to correct escaping characters.
Fixed segmentation fault caused by XML output parameters when calling stored procedures.
Facilitated a convenience override of db2_connect to invoke db2_pconnect for i5/OS, without needing to change PHP app code.
Added environment options so that the user can specify whether to use lib64 or lib32 directory.
|
| 1.6.3 |
Fixed bug -- db2_tables() was failing on i5/OS
|
| 1.6.2 |
Fixed bug -- db2_fetch_assoc() of BLOB columns
|
| 1.6.1 |
Several fixes for i5 support
Fixing db2_bind_param for a clean exit.
Fix for Pecl bug 10353 and adding deferred prepare statement option
|
| 1.6.0 |
Fixed bug #9217 (ability to stream LOB elements)
Fixed bug #7882 (escape string functionality added)
Fixed bug #9870 (fix for db2_result LOB defect)
Fix for LOB binding defects
|
| 1.5.1 |
Major peformance increase for iSeries
Bug fix for binding two parameters out of order
Options fix for setting cursor to scrollable
Fix for db2_free_result segfault
|
| 1.5.0 |
Greater iSeries support
Fix for setting AUTOCOMMIT in Linux/Windows
Stored procedure with INOUT/IN paramters segfault fix
Addition of more tests to the test suite
|
| 1.4.10 |
Fix for memory leak on failed connection attempt and failed statement execution
|
| 1.4.9 |
iSeries support added
LOB functionality modified to use LOB locaters
XML functionality for Viper modified
Multiple memory leak fixes
Fix for stored procedures
Modified db2_exec functionality to improve performance
|
| 1.2.3 |
XML functionality for Viper modified
Multiple memory leak fixes
Fix for stored procedures
Modified db2_exec functionality to improve performance
|
| 1.2.2 |
XML functionality for Viper modified
Multiple memory leak fixes
Fix for stored procedures
Modified db2_exec functionality to improve performance
|
| 1.2.1 |
Use strlcpy() rather than strncpy() to comply with PECL standards.
Stricter type-matching, initialize all allocated memory.
Improve unit test implementation.
Enable SUCCESS_WITH_INFO to return results successfully (bug 6561).
Handle null characters within SQL values (bug 6572).
Avoid appending a null character to CLOB values (bug 6755).
Enable default cursor type to be set as a connection attribute.
Provide initial support and testing for native XML data type.
Improve variable scope binding
|
| 1.2.0 |
Use strlcpy() rather than strncpy() to comply with PECL standards.
Stricter type-matching, initialize all allocated memory.
Improve unit test implementation.
Enable SUCCESS_WITH_INFO to return results successfully (bug 6561).
Handle null characters within SQL values (bug 6572).
Avoid appending a null character to CLOB values (bug 6755).
Enable default cursor type to be set as a connection attribute.
Provide initial support for native XML data type.
|
| 1.1.6 |
Better handling of persistent connection resources.
Better memory management for OUT and INOUT parameters.
More forgiving of NULL or 0 values for scrollable cursor positioning.
|
| 1.1.5 |
Fix condition where db2_connect() returns a bogus connection resource.
|
| 1.1.4 |
Add option to force column names to lower case or upper case:
* pass 'DB2_ATTR_CASE' => DB2_CASE_LOWER for lower case
* pass 'DB2_ATTR_CASE' => DB2_CASE_UPPER for upper case
* pass 'DB2_ATTR_CASE' => DB2_CASE_NATURAL for natural case (default)
|
| 1.1.3 |
Add option to force column names to lower case or upper case:
* pass 'DB2_ATTR_CASE' => DB2_CASE_LOWER for lower case
* pass 'DB2_ATTR_CASE' => DB2_CASE_UPPER for upper case
* pass 'DB2_ATTR_CASE' => DB2_CASE_NATURAL for natural case (default)
|
| 1.1.2 |
Fix win32 build problem. |
| 1.1.1 |
Adds db2_client_info() and db2_server_info() functions.
|
| 1.1.0 |
First stable release of the ibm_db2 extension for IBM DB2 Universal Database for Linux, UNIX, and Windows, IBM Cloudscape, and Apache Derby.
|
| 1.0.2 |
Enable LOB support in the driver.
Optimize db2_bind_param().
Disable connect options in pconnection.
Add in correct message buffer length.
|
| 1.0.1 |
Enable binary data types. Handle string truncation errors gracefully.
Enable verbose output in phpinfo().
|
| 1.0 |
This is the first release of this extension. Lookup TODO in docs for in-complete features.
|
