Home » Database » MDB2_Driver_ibase

ibase MDB2 driver

This package is unmaintained.

Download latest release 1.5.0b5 (archived versions might be outdated)

License: BSD License

Description

This is the Interbase/Firebird MDB2 driver.

Maintainers

• Lorenzo Alberton (quipo) — lead, active
• Lukas Kahwe Smith (lsmith) — lead, inactive
• Daniel Convissor (danielc) — helper, active

Dependencies

Required

• PHP (>= 5.2.0)
• PEAR Installer (>= 1.9.1)
• MDB2 (>= 2.5.0b4)
• interbase (extension)

Releases

• 1.5.0b5 (beta, 2012-10-29)
  Release notes

  License: BSD License

  * Implement Feature #18396: Interbase file extensions are .IB now

• 1.5.0b4 (beta, 2012-10-23)
  Release notes

  License: BSD License

  - PEAR::isError() -> MDB2::isError(), Bug #19491.
  - PEAR::loadExtension() -> extension_loaded(), Bug #19583.
  - Added supporting quite identifier(backward compatible)
  - Fix Bug #19262. Updates conditional stagements to use logical operators to include MDB2_FETCHMODE_OBJECT where appropriate. Was broken in r321197.
  - Bug #17094 NULL character is not escaped
  - Have alterTable() return MDB2_OK on success, as documented (bug 19200)
  - Have dropTable() return MDB2_OK on success, as documented (bug 19199)
  - Have createIndex() return MDB2_OK on success, as documented (bug 19195)
  - Have createConstraint() return MDB2_OK on success, as documented (bug 19193)
  - Have createSequence() return MDB2_OK on success, as documented (bug 19192)
  - Have dropSequence() return MDB2_OK on success, as documented (bug 19191).
  - Make setOption('result_wrap_class') actually useful by changing the default value of $result_wrap_class parameters from false to true.
  - FETCHMODE constants are NOT bitwise.
  - fixed bug #18203: Type introspection breaks with associative arrays if names are identical (patch by Peter Bex)

• 1.5.0b3 (beta, 2010-08-29)
  Release notes

  License: BSD License

  - fixed regression in lastInserID()
  - fixed bug #15971: typo in standaloneQuery() [elpaso]
  - fixed bug #16350: typo in setTransactionIsolation() [nilya]
  - fixed bug #16741: Manager::listTableIndexes and listTableContraints should check NULL or 0 [nilya]
  - fixed bug #17676: use connection resource when fetching LOBs [renskiy]

• 1.5.0b2 (beta, 2009-01-14)
  Release notes

  License: BSD License

  - fixed bug #12117: disconnect() does not work as documented
  - request #14639: automatically fetch CLOBs when retrieved with 'text' data type
  - getTableFieldDefinition() now returns the charset and collation of the field, if defined

• 1.5.0b1 (beta, 2008-03-15)
  Release notes

  License: BSD License

  - request #12731: added truncateTable() in the Manager module
  - request #12732: added vacuum() in the Manager module for OPTIMIZE/VACUUM TABLE abstraction
  - fixed bug #12924: correctly handle internal expected errors even with custom error handling
  - fixed bug #12948: removed setCharset(), since "SET NAMES" is only supported in ISQL
  - fixed bug #12958: support multi autoincrement fields in _makeAutoincrement() [patch by Ali Fazelzadeh]
  - fixed listSequences() and listFunctions() in the Manager module with Firebird 2.x
  - fixed getServerVersion() with Firebird 2.x
  - feature #12962: in getServerVersion(), fallback to the username/password of the
  connected user if DBA_username/DBA_password options are not provided [thanks to Ali Fazelzadeh]
  - added standaloneQuery() and databaseExists()
  - added length() function in the Function module (use STRLEN in the std UDF functions)

• 1.5.0a2 (alpha, 2007-12-06)
  Release notes

  License: BSD License

  - added missing parentheses in query in listTableTriggers() in the Manager module

• 1.5.0a1 (alpha, 2007-10-28)
  Release notes

  License: BSD License

  - initial support for FOREIGN KEY and CHECK constraints in the Reverse and Manager modules
  - fixed bug #11428: propagate quote() errors with invalid data types
  - fixed bug #11790: avoid array_diff() because it has a memory leak in PHP 5.1.x
  - fixed some E_STRICT errors with PHP5
  - fixed bug #12083: createTable() in the Manager module now returns MDB2_OK on success,
  as documented

• 1.4.1 (stable, 2007-05-03)
  Release notes

  License: BSD License

  - 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
  - fixed failed connection when DSN is passed as an uppercase string (db file
  extension appended twice)
  - fixed array key case issue with resultset in getTableIndexDefinition() in the
  Reverse module

• 1.4.0 (stable, 2007-03-13)
  Release notes

  License: BSD License

  - propagate errors in getTableFieldDefinition() in the Reverse module
  - fixed getTriggerDefinition() in the Reverse module [experimental]
  - fixed listTableTriggers() in the Manager module
  - added support for the -902 (feature is not supported) error code
  (thanks to Adam Harvey)
  - fixed bug #9943: MDB2_Driver_ibase install failing because wrong
  extension name (ibase instead of interbase)
  - implemented a fallback mechanism within getTableIndexDefinition() and
  getTableConstraintDefinition() 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).
  - listFunctions() in the Manager module now lists UDFs and stored procedures
  - phpdoc fixes

• 1.3.0 (stable, 2006-11-03)
  Release notes

  License: BSD License

  - added charset and collation support to field declaration
  - fixed bug #9024: typo in currID() error checking
  - added lastInsertID() method (reads global current value instead of connection level)
  - fixed inheritance structure of convertResult()
  - added support for new 'disable_iso_date' date DSN option (Request #8739)
  - removed spurious 4th parameter of getDeclaration()
  - fix typos in error handling in a few places (bug #9024)
  - added support for getting the table name in tableInfo()
  - migrated to package.xml version 2

• 1.2.1 (stable, 2006-08-29)
  Release notes

  License: BSD

  - flip positions property array in prepared statement objects to make it
  possible to optionally use the same named placeholder in multiple places
  inside a single prepared statement
  - do not list empty contraints and indexes
  - added support for 'primary' option in createTable()
  - added missing 'mdb2type' to getTableFieldDefinition()
  - do not set a default if type is a LOB (Request #8074)
  - fixed handling return values when disable_query is set in _doQuery() and _execute()
  - increased MDB2 dependency too 2.2.1

• 1.2.0 (stable, 2006-07-25)
  Release notes

  License: BSD

  - 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()

• 1.1.0 (stable, 2006-06-15)
  Release notes

  License: BSD

  - added "emulate_prepared" option to force prepared statement emulation
  - tweaked handling of free() for prepared statements
  - return error if a prepared statement is attempted to be freed twice
  - added setCharset()
  - use setCharset() in connect()/_doConnect()
  - generalized quoteIdentifier() with a property
  - cosmetic performance tweak in getTableFieldDefinition()
  - 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
  - check if result/connection has not yet been freed/dicsonnected before
  attempting to free a result set(Bug #7790)
  - fixed control flow in MDB2_Driver_Datatype_ibase::mapNativeDatatype()
  for 'numeric' or 'decimal' types

• 1.0.2 (stable, 2006-05-14)
  Release notes

  License: BSD

  - implemented listTableTriggers(), listTableViews() and listFunctions()
  in the Manager module
  - implemented getTriggerDefinition() in the Reverse module
  - explicitly set is_manip parameter to false for transaction debug calls
  - pass parameter array as debug() all with scope "parameters" in every execute()
  call (bug #4119)
  - 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
  - typo fix ressource/resource in LOB array
  - added missing unset() to _destroyLOB()
  - fixed _destroyLOB() API to match other private LOB methods
  - fixed phpdoc comments of all private LOB methods
  - added missing supported parameter to prepare() signature
  - fix default field value in getTableFieldDefinition() [Reverse module]

• 1.0.1 (stable, 2006-04-16)
  Release notes

  License: BSD

  - discard all constraints in MDB2_Driver_Reverse::getTableIndexDefinition(),
  leave them to MDB2_Driver_Reverse::getTableConstraintDefinition().
  - return the constraint type in MDB2_Driver_Reverse::getTableConstraintDefinition().
  - aligned _modifyQuery() signature and phpdoc
  - added 'result_introspection' supported metadata support
  - added server_version option
  - some clean ups with determining if limit_queries needs to be emulated or not
  - honor check_option parameter in quoteIdentifier()
  - 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()
  - set error code in all raiseError() calls
  - don't return views in listTables()
  - fixed query in listViews()
  - protect against sql injection in the reverse and manager module

• 1.0.0 (stable, 2006-02-09)
  Release notes

  License: BSD

  - handle null as resource when disable_query option is enabled in result object

  open todo items:
  - handle autoincremement fields in alterTable()

• 0.2.2 (beta, 2006-02-05)
  Release notes

  License: BSD

  - native DECIMAL datatype is now used instead of converting it to a string
  - 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)
  - added support for out of order parameter binding in prepared queries
  - reset row_limit and row_offset after calling prepare() just like we do for query() and exec()
  - cosmetic fix (removed "row_" prefix from "row_limit" and "row_offset")
  - now using SMALLINT by default instead of CHAR(1) for the boolean datatype (BC BREAK!)
  - check if a constraint name is given in createConstraint()
  - added private _silentCommit() method to avoid uncommitted queries preventing
  further queries to succeed (@see bug #6494)
  - improved parsing in getServerInfo() (bug #6550)

  open todo items:
  - handle autoincremement fields in alterTable()

• 0.2.1 (beta, 2006-01-14)
  Release notes

  License: BSD

  - removed unnecessary if statement in getTableFieldDefinition()
  - no need to register a shutdown function since te ibase driver is php5 only
  and therefore always uses the destructor
  - fixed typo in _execute() that would lead to using the wrong types inside the result object
  - use proper error code in alterTable()
  - explicitly pass if the module is phptype specific in all loadModule calls (bug #6226)
  - added error handling in prepare()
  - fixed signature of quoteIdentifier() to make second param optional
  - req #6464: add the extension only if neither '.gdb' nor '.fdb' is given in the
  database name, for compatibility with PEAR::DB DNS (Mark Wiesemann)
  - fixed bug #6465: possible mismatch in MDB2_Reverse_ibase due to parentheses
  in the returned datatype (Mark Wiesemann)
  - fixed bug #6468: possible NOTICE in Driver/Datatype/ibase.php (Mark Wiesemann)
  - fixed bug #6475: listTableIndexes() should only list indices, not constraints,
  and listTableConstraints() should return the user-defined names when available
  - _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

  open todo items:
  - handle autoincremement fields in alterTable()

• 0.2.0 (beta, 2005-12-22)
  Release notes

  License: BSD

  - fixed _dropAutoincrement()
  - use _dropAutoincrement() in dropTable()
  - fixed mapNativeDatatype()
  - implemented getTableFieldDefinition() and getTableIndexDefinition() in the Reverse module
  - implemented listUsers() in the Manager module
  - unified case fixing in the list*() methods
  - use custom implementation of getConnection() to access connection property
  - split index and constraint handling
  - return "0" as default value for integer NOT NULL fields with no default value
  - quoteIdentifier() is just returning an uppercase string, since quoted
  identifiers in ibase do more harm than good
  - refactored get*Declaration() methods to use getTypeDeclaration()
  - set in_transaction to false on disconnect
  - fixed type changing in alterTable()
  - added new Function modules to handle difference in SQL functions
  - autoincrement emulation works correctly
  - pass the correct connection resource to ibase_blob_import()
  - force rollback() with open transactions on disconnect
  - escape floats to make sure they do not contain evil characters (bug #5608)
  - in listSequences(), skip system generators
  - 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*
  - added ability to determine unsigned in mapNativeDatatype()
  (only really implemented in the mysql(i) drivers) (bug #6054)
  - use MDB2_ERROR_NOT_FOUND in getTableConstraintDefinition() and getTableIndexDefinition() (bug #6055)
  - added getServerVersion()
  - unified array structure in mapNativeDatatype() *BC BREAK*
  - added 'mdbtype' to tableInfo() output that is generated from mapNativeDatatype()
  - changed 'len' to 'length' in tableInfo() output *BC BREAK*

  open todo items:
  - handle autoincremement fields in alterTable()

• 0.1.2 (beta, 2005-10-10)
  Release notes

  License: BSD

  Warning: this release features numerous BC breaks!

  There have been considerable improvements to the datatype, manager and reverse
  modules. Furthermore preliminary support for auto increment and primary keys
  has been added. Please note that making a field auto increment implies a single
  column primary key on this field.

  - added support for auto increment and primary key in schema.
  - alterTable now needs the full definition to work (use getTableFieldDefinition
  from Reverse module if you do not have a definition at hand) this eliminates the need
  of the declaration part in the alterTable array.
  - fix PHP4.4 breakage
  - fixed several incorrect raiseError() calls in manager module
  - use !empty() instead of isset() in fetchRow to determine if result cols were bound or result types were set
  - expect keys in type arrays the same way as they are passed for the values in execute() and bindParamArray()
  - add s pattern modifier to preg_replace() call for parameter searches in prepare() (bug #5362)
  - moved all private fetch mode fix methods into _fixResultArrayValues() for performance reasons
  - 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 array_key_exists() instead of isset() where possible
  - changed structure of field add/remove/change in alterTable() to match MDB2_Schema
  - createIndex(): index_sorting is not a feature in the supported array, but is supported by interbase
  - return 0 for manipulation queries when disable_query is enabled
  - tweaked field changing in alterTable()
  - getTypeDeclaration() in the datatype module is now a public method
  - fixed alterTable() signature
  - fixed listTableFields()
  - added listTableIndexes()
  - added listTables()

  open todo items:
  - code to be able to list primary contraints inside listTableIndexes()/dropIndex()
  - handle autoincremement fields in alterTable() and dropTable()

• 0.1.1 (beta, 2005-06-08)
  Release notes

  License: BSD

  - fixed LOB management and package dependencies
  - fully tested

• 0.1.0 (alpha, 2005-06-08)
  Release notes

  License: BSD

  first unbundled release from MDB2 core

  - cosmetic fixes to _getDatabaseFile()
  - removed redundant code from datatype module
  - 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)
  - use new quote() parameter
  - renamed execute() to _execute() since common provides some common
  functionality via execute()
  - fixed decimal result conversion in datatype module
  - typo fixes in result class
  - support numeric and string keys in types array for prepared queries
  - Warning: this release is untested

Bugs