Top Level :: Database
Package Information: MDB2_Driver_mssql
| » Version | » Information |
|---|---|
| 1.5.0b4 |
Easy InstallNot sure? Get more info. pear install MDB2_Driver_mssql-1.5.0b4 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB2_Driver_mssql-1.5.0b4 Release date: 2012-10-23 19:15 UTC Release state: beta Release uploaded by: danielc Changelog: - PEAR::isError() -> MDB2::isError(), Bug #19491. - PEAR::loadExtension() -> extension_loaded(), Bug #19583. - Fixed boolean type conversion for non-boolean types - Fix Bug #19262. Updates conditional stagements to use logical operators to include MDB2_FETCHMODE_OBJECT where appropriate. Was broken in r321197. - Have truncateTable() return MDB2_OK on success, as documented (bug 19201) - Have dropIndex() return MDB2_OK on success, as documented (bug 19198) - Have vacuum() return MDB2_OK on success, as documented (bug 19196) - Have dropSequence() return MDB2_OK on success, as documented (bug 19191). - FETCHMODE constants are NOT bitwise. - fixed bug #18203: Type introspection breaks with associative arrays if names are identical (patch by Peter Bex) open todo items: - explore fast limit/offset emulation (Request #4544) Dependencies:
|
| 1.5.0b3 |
Easy InstallNot sure? Get more info. pear install MDB2_Driver_mssql-1.5.0b3 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB2_Driver_mssql-1.5.0b3 Release date: 2010-08-29 12:29 UTC Release state: beta Release uploaded by: quipo Changelog: - Fixed bug #16612: Added the timestamp database attribute [genericbob] - fixed bug #16118: escape doesn't take into account trailing backslashes [urkle] - request #16903: Add ability to use ODBTP extension [hedroom] - fixed numRows() with setLimit() open todo items: - explore fast limit/offset emulation (Request #4544) Dependencies:
|
| 1.3.0b2 |
Easy InstallNot sure? Get more info. pear install MDB2_Driver_mssql-1.3.0b2 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB2_Driver_mssql-1.3.0b2 Release date: 2009-01-14 12:25 UTC Release state: beta Release uploaded by: quipo Changelog: - fixed bug #11571: when using setLimit(), numRows() returns wrong values - fixed bug #12117: disconnect() does not work as documented - fixed bug #14019: MDB2 is not aware of MS-SQL 'smalldatetime' type open todo items: - explore fast limit/offset emulation (Request #4544) Dependencies:
|
| 1.3.0b1 |
Easy InstallNot sure? Get more info. pear install MDB2_Driver_mssql-1.3.0b1 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB2_Driver_mssql-1.3.0b1 Release date: 2008-03-15 04:28 UTC Release state: beta Release uploaded by: quipo Changelog: - fixed bug #12391: fixed lastInsertID() (thanks to Marius Toma) - fixed bug #12599: BLOB quoting incorrect (thanks to Ferdy Hanssen) - fixed bug #12697: MDB2_Driver_mssql fails to load with the sybase_ct extension - request #12731: added truncateTable() in the Manager module - request #12732: added vacuum() in the Manager module for OPTIMIZE/VACUUM TABLE abstraction - request #12800: added alterDatabase() in the Manager module [afz] - fixed bug #12924: correctly handle internal expected errors even with custom error handling - extended alterTable() support in the Manager module [afz] - added standaloneQuery() and databaseExists() - request #13106: added unixtimestamp() in the Function module open todo items: - explore fast limit/offset emulation (Request #4544) Dependencies:
|
| 1.3.0a2 |
Easy InstallNot sure? Get more info. pear install MDB2_Driver_mssql-1.3.0a2 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB2_Driver_mssql-1.3.0a2 Release date: 2007-12-06 15:15 UTC Release state: alpha Release uploaded by: quipo Changelog: - fixed bug #11571: when using setLimit(), numRows() returns wrong values - request #12012: added collation support in createDatabase() and in createTable() for table fields open todo items: - explore fast limit/offset emulation (Request #4544) Dependencies:
|
| 1.3.0a1 |
Easy InstallNot sure? Get more info. pear install MDB2_Driver_mssql-1.3.0a1 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB2_Driver_mssql-1.3.0a1 Release date: 2007-10-28 15:26 UTC Release state: alpha Release uploaded by: quipo Changelog: - initial support for FOREIGN KEY and CHECK constraints in the Reverse and Manager modules - fixed bug #9735, #11175, #11228: two instances fail to keep different databases selected - request #11297: added support for "schema.table" notation in the Reverse module - request #11445: added support for unicode datatypes (nchar, nvarchar, ntext) - fixed bug #11479: wrong query in nextID() - fixed bug #11790: avoid array_diff() because it has a memory leak in PHP 5.1.x - request #11797: don't use mssql_field_name() in listTableFields() in the Manager module since it only returns the first 30 chars - fixed bug #12010: MDB2_PORTABILITY_RTRIM option was ignored - fixed bug #12083: createTable() in the Manager module now returns MDB2_OK on success, as documented - fixed bug #12269: tableInfo() in the Reverse module detect 'clob' data type as first option open todo items: - explore fast limit/offset emulation (Request #4544) Dependencies:
|
| 1.2.1 |
Easy InstallNot sure? Get more info. pear install MDB2_Driver_mssql-1.2.1 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB2_Driver_mssql-1.2.1 Release date: 2007-05-03 15:31 UTC Release state: stable Release uploaded by: quipo Changelog: - return length as "precision,scale" for NUMERIC and DECIMAL fields in mapNativeDatatype() - in getTableIndexDefinition() and getTableConstraintDefinition() in the Reverse module, also return the field position in the index/constraint open todo items: - explore fast limit/offset emulation (Request #4544) Dependencies:
|
| 1.2.0 |
Easy InstallNot sure? Get more info. pear install MDB2_Driver_mssql-1.2.0 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB2_Driver_mssql-1.2.0 Release date: 2007-03-14 08:19 UTC Release state: stable Release uploaded by: davidc Changelog: - added ability to escape wildcard characters in escape() and quote() - added setTransactionIsolation() - added savepoint support to beginTransaction(), commit() and rollback() - added debug() call at the end of a query/prepare/execute calling (Request #7933) - added context array parameter to debug() and make use of it whereever sensible - added optional method name parameter to raiseError() and use whereever possible - added ability to escape wildcard characters in escape() and quote() - added debug() call at the end of a query/prepare/execute calling (Request #7933) - added 'nativetype' output to tableInfo() and getTableFieldDefinition() - added 'mdb2type' output to getTableFieldDefinition() - reworked tableInfo() to use a common implementation based on getTableFieldDefinition() when a table name is passed (Bug #8124) - fixed incorrect regex in mapNativeDatatype() (Bug #8256) (thx ioz at ionosfera dot com) - use old DSN when rolling back open transactions in disconnect() - MSSQL requires making columns exlicitly NULLable (Bug #8359) - do not list empty contraints and indexes - added support for autoincrement via IDENTITY in getDeclaration() - ALTER TABLE bug when adding more than 1 column (Bug #8373) - fixed handling return values when disable_query is set in _doQuery() and _execute() - added dropIndex() to the manager module - increased MDB2 dependency to XXX - renamed valid_types property to valid_default_values in the Datatype module - increased PHP dependency due to bug #31195 - using 'ADD COLUMN' syntax instead of just 'ADD' in alterTable() - fixed bug #9024: typo in error checking - fixed inheritance structure of convertResult() - added support for new 'disable_iso_date' date DSN option (Request #8739) - fix typos in error handling in a few places (bug #9024) - do not skip id generation in nextId() when creating a sequence on demand because this prevents lastInsertID() from working - added support for more error codes (patch by Adam Harvey) - migrated to package.xml version 2 - implemented getTableFieldDefinition() in the Reverse module - implemented getTableIndexDefinition() in the Reverse module - implemented getTableConstraintDefinition() in the Reverse module - implemented getTriggerDefinition() in the Reverse module - implemented listTableConstraints() in the Manager module - implemented listFunctions() in the Manager module - implemented listDatabases() in the Manager module - implemented listUsers() in the Manager module - implemented guid() in the Function module [globally unique identifier] - implemented a fallback mechanism within getTableIndexDefinition() in the Reverse module to ignore the 'idxname_format' option and use the index name as provided in case of failure before returning an error - added a 'nativetype_map_callback' option to map native data declarations back to custom data types (thanks to Andrew Hill). - added missing integer data types and their length in _mapNativeDatatype() - phpdoc fixes open todo items: - explore fast limit/offset emulation (Request #4544) Dependencies:
|
| 1.1.2 |
Easy InstallNot sure? Get more info. pear install MDB2_Driver_mssql-1.1.2 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB2_Driver_mssql-1.1.2 Release date: 2007-01-10 14:22 UTC Release state: stable Release uploaded by: davidc Changelog: - removed mysql_select_db and used mssql_select_db open todo items: - explore fast limit/offset emulation (Request #4544) Dependencies:
|
| 1.1.1 |
Easy InstallNot sure? Get more info. pear install MDB2_Driver_mssql-1.1.1 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB2_Driver_mssql-1.1.1 Release date: 2007-01-09 11:12 UTC Release state: stable Release uploaded by: davidc Changelog: - Quotes being escaped when autoExecute (Bug #9442) - fread() truncates after execute() ? (Bug #9410) - LimitQuery now compatible with DISTINCT (Bug #8206) - Now using @@IDENTITY (Bug #7291) - Implementation of mapNativeDatatype() - Limit query now working - Execute syntax changed in sql server 2005 - Added more relevant sql server 2005 error codes open todo items: - fix sequence emulation soon - explore fast limit/offset emulation (Request #4544) Dependencies:
|
| 1.1.0 |
Easy InstallNot sure? Get more info. pear install MDB2_Driver_mssql-1.1.0 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB2_Driver_mssql-1.1.0 Release date: 2006-06-15 09:31 UTC Release state: stable Release uploaded by: nrf Changelog: - added the listTableTriggers() method to the Manager. - added the listViews() method to the Manager. - aligned _modifyQuery() signature and phpdoc - added the map datatype patch for (bug #6863) - added support for length in reverse engineering of integer fields - added 'result_introspection' supported metadata support - fixed alterTable() when adding/dropping multiple columns - properly quote table names in tableInfo() (related to bug #6573) - use connected_server_info in getServerVersion() as a cache cache - use parent::disconnect() in disconnect() - added support for length in integer reverse engineering - some fixes regarding boolean reverse engineering - protect against sql injection in the reverse and manager module - explicitly set is_manip parameter to false for transaction debug calls - various minor tweaks to error messages, phpdoc and adding stub methods to the common driver - typo fixes in phpdoc (thx Stoyan) - added support for fixed and variable types for 'text' in declarations, as well as in reverse engineering (Request #1523) - made _doQuery() return a reference - added userinfo's to all raiseError calls that previously had none - added 'prepared_statements' supported meta data setting - limit fetch to 1 row in listTableFields() - use setCharset() in connect()/_doConnect() - generalized quoteIdentifier() with a property - drop parentheses from executeStoredProc() syntax (bug #7855) - switched most array_key_exists() calls to !empty() to improve readability and performance - fixed a few edge cases and potential warnings - added ability to rewrite queries for query(), exec() and prepare() using a debug handler callback - added implementation for now() and substring() (Request #7774) - check if result/connection has not yet been freed/dicsonnected before attempting to free a result set(Bug #7790) - fix range offsets (bug #7448) - revert change that would prefer 'clob' over 'text' for TEXT fields (this was breaking runtime instrospection) - use SCOPE_IDENTITY() when version >= 8 (SQL Server 2000) otherwise fallback to @@IDENTITY to retrieve last inserted value (bug #7291) - implement getServerVersion() - removed bogus but unharmful code from mapNativeDatatype() Dependencies:
|
| 1.0.0 |
Easy InstallNot sure? Get more info. pear install MDB2_Driver_mssql-1.0.0 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB2_Driver_mssql-1.0.0 Release date: 2006-02-09 10:27 UTC Release state: stable Release uploaded by: davidc Changelog: - unified case fixing in the list*() methods - use getConnection() to access connection property - split index and constraint handling - quote identifiers where possible inside the manager methods depending on the new 'quote_identifier' option (defaults to off) - refactored get*Declaration() methods to use getTypeDeclaration() - setting in_transaction to false on disconnect - added new Function modules to handle difference in SQL functions - force rollback() with open transactions on disconnect - escape floats to make sure they do not contain evil characters (bug #5608) - split off manipulation queries into exec() method from the query() method *BC BREAK* - only if result_types is set to false in prepare() method the query will be handled as a DML statement *BC BREAK* - use lastInsertID() method in nextID() - cleanup _checkSequence() method to not raise errors when no table was found - added 'mdbtype' to tableInfo() output - changed 'len' to 'length' in tableInfo() output *BC BREAK* - explicitly pass if the module is phptype specific in all loadModule calls (bug #6226) - fixed signature of quoteIdentifier() to make second param optional - fixed signature of executeStoredProc() - typo fixes in error handling of nextResult() and numRows() calls - nextResult() returns false if there are no more result sets to read - _fixIndexName() now just attempts to remove possible formatting - renamed _isSequenceName() to _fixSequenceName() - _fixSequenceName() now just attempts to remove possible formatting, and only returns a boolean if no formatting was applied when the new "check" parameter is set to true - added support for length in decimal columns - removed ugly hack for quote parameter in quote() since it was insufficient (escaping also needs to be prevented) - handle null as resource when disable_query option is enabled in result object open todo items: - add missing index/contraint methods to the manager and reverse module methods - ensure that all primary/unique/foreign key handling is only in the contraint methods - fix alterTable() Dependencies:
|
| 0.1.2 |
Easy InstallNot sure? Get more info. pear install MDB2_Driver_mssql-0.1.2 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB2_Driver_mssql-0.1.2 Release date: 2005-10-11 09:49 UTC Release state: alpha Release uploaded by: davidc Changelog: * Bugfix 5507 * created method _checkSequence that checks if a sequence exists * moved all private fetch mode into _fixResultAraryValues * net portability with MDB2_PORTABILITY_FIX_ASSOC_FIELD (to remove database/table qualifiers from assoc indexes) * now using !empty instead of isset() to fetchRow * getAfterId is no lastInsertId * fixed some php4 breakage * Fixed many typos. * return 0 for manipulation queries when disable_query is enabled. * Cosmetic fixes * dropped_fields is handled by 'remove' * using array_key_exist instaed of isset() * structures of field add/remove/change in alterTable now match with MDB2_Schema * bug fixes 5507 * renamed MDB2_PORTABILITY_LOWERCASE to MDB2_PORTABILITY_FIX_CASE and use 'field_case' option to determine if to upper- or lowercase (CASE_LOWER/CASE_UPPER) * use getDBInstance() * query() -> queryCol() * native extends to MDB2_Module_Common * reverse now uses TOP instead of LIMIT * reverse fixed typos * reverse uses getDBInstance() * open todo items: - added missing createIndex() method Dependencies:
|
| 0.1.0 |
Easy InstallNot sure? Get more info. pear install MDB2_Driver_mssql-0.1.0 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB2_Driver_mssql-0.1.0 Release date: 2005-06-08 09:23 UTC Release state: alpha Release uploaded by: lsmith Changelog: first unbundled release from MDB2 core - dont just check for isset() for boolean values in order to support setting them false as well (bug #4373) - ensure SQL injection protection in all _quote() methods (was missing in some decimal, float, time, date and timestamp implementations) - typo fixes in constructor - Warning: this release is untested Dependencies:
|