Top Level :: Database

Package Information: MDB2_Driver_mssql

Show All Changelogs

» Version » Information
1.5.0b4

Easy Install

Not sure? Get more info.

pear install MDB2_Driver_mssql-1.5.0b4

Pyrus Install

Try PEAR2's installer, Pyrus.

php pyrus.phar install pear/MDB2_Driver_mssql-1.5.0b4

Download

For manual installation only

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:
  • PHP Version: PHP 5.2.0 or newer
  • PEAR Package: PEAR Installer 1.9.1 or newer
  • PEAR Package: MDB2 2.5.0b4 or newer
  • PHP Extension: mssql
1.5.0b3

Easy Install

Not sure? Get more info.

pear install MDB2_Driver_mssql-1.5.0b3

Pyrus Install

Try PEAR2's installer, Pyrus.

php pyrus.phar install pear/MDB2_Driver_mssql-1.5.0b3

Download

For manual installation only

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:
  • PHP Version: PHP 5.3.0 or newer
  • PEAR Package: PEAR Installer 1.9.1 or newer
  • PEAR Package: MDB2 2.5.0b3 or newer
  • PHP Extension: mssql
1.3.0b2

Easy Install

Not sure? Get more info.

pear install MDB2_Driver_mssql-1.3.0b2

Pyrus Install

Try PEAR2's installer, Pyrus.

php pyrus.phar install pear/MDB2_Driver_mssql-1.3.0b2

Download

For manual installation only

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:
  • PHP Version: PHP 4.3.0 or newer
  • PEAR Package: PEAR Installer 1.4.0b1 or newer
  • PEAR Package: MDB2 2.5.0b2 or newer
  • PHP Extension: mssql
1.3.0b1

Easy Install

Not sure? Get more info.

pear install MDB2_Driver_mssql-1.3.0b1

Pyrus Install

Try PEAR2's installer, Pyrus.

php pyrus.phar install pear/MDB2_Driver_mssql-1.3.0b1

Download

For manual installation only

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:
  • PHP Version: PHP 4.3.0 or newer
  • PEAR Package: PEAR Installer 1.4.0b1 or newer
  • PEAR Package: MDB2 2.5.0b1 or newer
  • PHP Extension: mssql
1.3.0a2

Easy Install

Not sure? Get more info.

pear install MDB2_Driver_mssql-1.3.0a2

Pyrus Install

Try PEAR2's installer, Pyrus.

php pyrus.phar install pear/MDB2_Driver_mssql-1.3.0a2

Download

For manual installation only

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:
  • PHP Version: PHP 4.3.0 or newer
  • PEAR Package: PEAR Installer 1.4.0b1 or newer
  • PEAR Package: MDB2 2.5.0a2 or newer
  • PHP Extension: mssql
1.3.0a1

Easy Install

Not sure? Get more info.

pear install MDB2_Driver_mssql-1.3.0a1

Pyrus Install

Try PEAR2's installer, Pyrus.

php pyrus.phar install pear/MDB2_Driver_mssql-1.3.0a1

Download

For manual installation only

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:
  • PHP Version: PHP 4.3.0 or newer
  • PEAR Package: PEAR Installer 1.4.0b1 or newer
  • PEAR Package: MDB2 2.5.0a1 or newer
  • PHP Extension: mssql
1.2.1

Easy Install

Not sure? Get more info.

pear install MDB2_Driver_mssql-1.2.1

Pyrus Install

Try PEAR2's installer, Pyrus.

php pyrus.phar install pear/MDB2_Driver_mssql-1.2.1

Download

For manual installation only

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:
  • PHP Version: PHP 4.3.0 or newer
  • PEAR Package: PEAR Installer 1.4.0b1 or newer
  • PEAR Package: MDB2 2.4.1 or newer
  • PHP Extension: mssql
1.2.0

Easy Install

Not sure? Get more info.

pear install MDB2_Driver_mssql-1.2.0

Pyrus Install

Try PEAR2's installer, Pyrus.

php pyrus.phar install pear/MDB2_Driver_mssql-1.2.0

Download

For manual installation only

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:
  • PHP Version: PHP 4.3.0 or newer
  • PEAR Package: PEAR Installer 1.4.0b1 or newer
  • PEAR Package: MDB2 2.4.0 or newer
  • PHP Extension: mssql
1.1.2

Easy Install

Not sure? Get more info.

pear install MDB2_Driver_mssql-1.1.2

Pyrus Install

Try PEAR2's installer, Pyrus.

php pyrus.phar install pear/MDB2_Driver_mssql-1.1.2

Download

For manual installation only

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:
  • PHP Version: PHP 4.3.0 or newer
  • PEAR Package: PEAR Installer 1.4.0b1 or newer
  • PEAR Package: MDB2 2.3.0 or newer
  • PHP Extension: mssql
1.1.1

Easy Install

Not sure? Get more info.

pear install MDB2_Driver_mssql-1.1.1

Pyrus Install

Try PEAR2's installer, Pyrus.

php pyrus.phar install pear/MDB2_Driver_mssql-1.1.1

Download

For manual installation only

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:
  • PHP Version: PHP 4.3.0 or newer
  • PEAR Package: PEAR Installer 1.4.0b1 or newer
  • PEAR Package: MDB2 2.3.0 or newer
  • PHP Extension: mssql
1.1.0

Easy Install

Not sure? Get more info.

pear install MDB2_Driver_mssql-1.1.0

Pyrus Install

Try PEAR2's installer, Pyrus.

php pyrus.phar install pear/MDB2_Driver_mssql-1.1.0

Download

For manual installation only

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:
  • PHP Version: PHP 4.3.0 or newer
  • PEAR Package: PEAR Installer 1.0b1 or newer
  • PEAR Package: MDB2 2.1.0 or newer
  • PHP Extension: mssql
1.0.0

Easy Install

Not sure? Get more info.

pear install MDB2_Driver_mssql-1.0.0

Pyrus Install

Try PEAR2's installer, Pyrus.

php pyrus.phar install pear/MDB2_Driver_mssql-1.0.0

Download

For manual installation only

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:
  • PHP Version: PHP 4.3.0 or newer
  • PEAR Package: PEAR Installer 1.0b1 or newer
  • PEAR Package: MDB2 2.0.0 or newer
  • PHP Extension: mssql
0.1.2

Easy Install

Not sure? Get more info.

pear install MDB2_Driver_mssql-0.1.2

Pyrus Install

Try PEAR2's installer, Pyrus.

php pyrus.phar install pear/MDB2_Driver_mssql-0.1.2

Download

For manual installation only

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:
  • PHP Version: PHP 4.3.0 or newer
  • PEAR Package: PEAR Installer 1.0b1 or newer
  • PEAR Package: MDB2 2.0.0beta6 or newer
  • PHP Extension: mssql
0.1.0

Easy Install

Not sure? Get more info.

pear install MDB2_Driver_mssql-0.1.0

Pyrus Install

Try PEAR2's installer, Pyrus.

php pyrus.phar install pear/MDB2_Driver_mssql-0.1.0

Download

For manual installation only

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:
  • PHP Version: PHP 4.2.0 or newer
  • PEAR Package: PEAR Installer 1.0b1 or newer
  • PEAR Package: MDB2 2.0.0beta5 or newer
  • PHP Extension: mssql

AltStyle によって変換されたページ (->オリジナル) /