STATUS OF THE PEAR DB PACKAGE
=============================

$Id: STATUS 602 2007-07-18 16:18:38Z stephanet $
------------------------------------------------------------------------

DB Driver Feature Matrix
------------------------
Symbols:
  x  =  implemented, but without tests
  t  =  implemented, but one or more tests fail
  T  =  implemented, passing all tests
  e  =  emulated, without tests
  l  =  emulated, but one or more tests fail
  E  =  emulated, passing all tests
  n  =  returns "not capable"
  -  =  no implementation of this feature or status unknown

                    fbsql      ifx      mssql     mysqli     odbc     sqlite
FEATURE        dbase  |  ibase  |  msql   |  mysql  |   oci8  |  pgsql  |  sybase
simpleQuery      -    T    T    T    T    T    T    T    T    T    T    T    T
numCols          x    T    T    T    T    T    T    T    T    T    T    T    T
numRows          x    T    E    E    T    T    T    T    E    T    T    T    T
errorNative      n    T    T    T    T    T    T    T    T    T    T    E    T
prepare/execute  e    E    T    E    E    E    E    E    T    E    E    E    E
sequences        n    T    T    n    T    T    T    T    T    E    T    E    T
affectedRows     n    T    E    E    T    T    T    T    T    T    E    T    T
fetch modes      x    T    T    T    T    T    T    T    T    T    T    T    T
fetch row by no  x    x    n    n    x    x    x    x    n    x    x    x    x
transactions     -    T    T    T    n    T    T    T    T    T    T    n    T
auto-commit      n    T    E    E    n    E    E    E    E    T    E    n    E
error mapping    -    T    T    T    T    T    T    T    T    T    T    T    T
tableInfo        x    T    T    t    T    T    T    T    T    T    T    T    T

getListOf() TYPES
tables           -    T    T    T    T    T    T    T    T    T    T    T    T
views            -    T    T    -    -    T    -    -    -    T    T    -    T
users            -    T    T    -    -    -    T    T    -    -    T    -    -
databases        -    -    -    -    T    -    T    T    -    T    T    -    -
functions        -    T    -    -    -    -    -    -    -    -    T    -    -
synonyms         -    -    -    -    -    -    -    -    T    -    -    -    -


Test Conformance
----------------
Symbols:
    o  =  Test passed
    X  =  Test failed
    L  =  Some portions of the test failed due to limitations in PHP or DBMS
    n  =  Test returns "not capable"
    -  =  Not tested

                    fbsql      ifx      mssql     mysqli     odbc     sqlite
               dbase  |  ibase  |  msql   |  mysql  |   oci8  |  pgsql  |  sybase
01connect        o    o    o    o    o    o    o    o    o    o    o    o    o
02fetch          -    o    o    o    o    o    o    o    o    o    o    o    o
03simplequery    -    o    o    o    o    o    o    o    o    o    o    o    o
04numcols        -    o    o    o    o    o    o    o    o    o    o    o    o
05sequences      -    o    o    o    o    o    o    o    o    o    o    o    o
06prepexec       -    o    o    o    L    o    o    o    o    o    o    o    o
08affectedrows   -    o    o    o    o    o    o    o    o    o    o    o    o
09numrows        -    o    o    o    o    o    o    o    o    o    o    o    o
10errormap       -    o    o    o    o    o    o    o    o    o    o    o    o
11transactions   -    o    o    o    n    o    o    o    o    o    o    n    o
13limit          -    o    o    o    o    o    o    o    o    o    o    o    o
14fetchmode_obje -    o    o    o    o    o    o    o    o    o    o    o    o
15quote          -    o    o    o    o    o    o    o    o    o    o    o    o
16tableinfo      -    o    o    L    o    o    o    o    o    o    o    o    o
17query          -    o    o    o    o    o    o    o    o    o    o    o    o
18get            -    o    o    o    o    o    o    o    o    o    o    o    o
19getlistof      -    o    o    o    o    o    o    o    o    o    o    o    o


DBMS Versions Tested
--------------------
dbase   n/a
fbsql   4.1.6
ibase   Firebird 1.5.1  (PHP 5 only)
ifx     7.2 Standard Edtition
msql    3.6  (PHP snapshots dated 2005-02-18)
mssql   8.0.760
mysql   4.0.21
mysqli  4.1.5  (PHP 5 only)
oci8    9.2
odbc    DB2 ESE 8.1 and MS Access 2000
pgsql   7.4.1 and 8.0.1
sqlite  PHP 5: extension.  PHP 4: PECL snapshot.
sybase  ASE 12.5.3

Tests were performed under both of the following PHP versions
unles otherwise noted:
    4.3.11-dev dated 2005-02-22
    5.1.0-dev dated 2005-02-22
