| 1 |
lars |
1 |
STATUS OF THE PEAR DB PACKAGE
|
|
|
2 |
=============================
|
|
|
3 |
|
|
|
4 |
DB Driver Feature Matrix
|
|
|
5 |
------------------------
|
|
|
6 |
Symbols:
|
|
|
7 |
x = implemented, but without tests
|
|
|
8 |
t = implemented, but one or more tests fail
|
|
|
9 |
T = implemented, passing all tests
|
|
|
10 |
e = emulated, without tests
|
|
|
11 |
l = emulated, but one or more tests fail
|
|
|
12 |
E = emulated, passing all tests
|
|
|
13 |
n = returns "not capable"
|
|
|
14 |
- = no implementation of this feature or status unknown
|
|
|
15 |
|
|
|
16 |
fbsql ifx mssql mysqli odbc sqlite
|
|
|
17 |
FEATURE dbase | ibase | msql | mysql | oci8 | pgsql | sybase
|
|
|
18 |
simpleQuery - T T T T T T T T T T T T
|
|
|
19 |
numCols x T T T T T T T T T T T T
|
|
|
20 |
numRows x T E E T T T T E T T T T
|
|
|
21 |
errorNative n T T T T T T T T T T E T
|
|
|
22 |
prepare/execute e E T E E E E E T E E E E
|
|
|
23 |
sequences n T T n T T T T T E T E T
|
|
|
24 |
affectedRows n T E E T T T T T T E T T
|
|
|
25 |
fetch modes x T T T T T T T T T T T T
|
|
|
26 |
fetch row by no x x n n x x x x n x x x x
|
|
|
27 |
transactions - T T T n T T T T T T n T
|
|
|
28 |
auto-commit n T E E n E E E E T E n E
|
|
|
29 |
error mapping - T T T T T T T T T T T T
|
|
|
30 |
tableInfo x T T t T T T T T T T T T
|
|
|
31 |
|
|
|
32 |
getListOf() TYPES
|
|
|
33 |
tables - T T T T T T T T T T T T
|
|
|
34 |
views - T T - - T - - - T T - T
|
|
|
35 |
users - T T - - - T T - - T - -
|
|
|
36 |
databases - - - - T - T T - T T - -
|
|
|
37 |
functions - T - - - - - - - - T - -
|
|
|
38 |
synonyms - - - - - - - - T - - - -
|
|
|
39 |
|
|
|
40 |
|
|
|
41 |
Test Conformance
|
|
|
42 |
----------------
|
|
|
43 |
Symbols:
|
|
|
44 |
o = Test passed
|
|
|
45 |
X = Test failed
|
|
|
46 |
L = Some portions of the test failed due to limitations in PHP or DBMS
|
|
|
47 |
n = Test returns "not capable"
|
|
|
48 |
- = Not tested
|
|
|
49 |
|
|
|
50 |
fbsql ifx mssql mysqli odbc sqlite
|
|
|
51 |
dbase | ibase | msql | mysql | oci8 | pgsql | sybase
|
|
|
52 |
01connect o o o o o o o o o o o o o
|
|
|
53 |
02fetch - o o o o o o o o o o o o
|
|
|
54 |
03simplequery - o o o o o o o o o o o o
|
|
|
55 |
04numcols - o o o o o o o o o o o o
|
|
|
56 |
05sequences - o o o o o o o o o o o o
|
|
|
57 |
06prepexec - o o o L o o o o o o o o
|
|
|
58 |
08affectedrows - o o o o o o o o o o o o
|
|
|
59 |
09numrows - o o o o o o o o o o o o
|
|
|
60 |
10errormap - o o o o o o o o o o o o
|
|
|
61 |
11transactions - o o o n o o o o o o n o
|
|
|
62 |
13limit - o o o o o o o o o o o o
|
|
|
63 |
14fetchmode_obje - o o o o o o o o o o o o
|
|
|
64 |
15quote - o o o o o o o o o o o o
|
|
|
65 |
16tableinfo - o o L o o o o o o o o o
|
|
|
66 |
17query - o o o o o o o o o o o o
|
|
|
67 |
18get - o o o o o o o o o o o o
|
|
|
68 |
19getlistof - o o o o o o o o o o o o
|
|
|
69 |
|
|
|
70 |
|
|
|
71 |
DBMS Versions Tested
|
|
|
72 |
--------------------
|
|
|
73 |
dbase n/a
|
|
|
74 |
fbsql 4.1.6
|
|
|
75 |
ibase Firebird 1.5.1 (PHP 5 only)
|
|
|
76 |
ifx 7.2 Standard Edtition
|
|
|
77 |
msql 3.6 (PHP snapshots dated 2005-02-18)
|
|
|
78 |
mssql 8.0.760
|
|
|
79 |
mysql 4.0.21
|
|
|
80 |
mysqli 4.1.5 (PHP 5 only)
|
|
|
81 |
oci8 9.2
|
|
|
82 |
odbc DB2 ESE 8.1 and MS Access 2000
|
|
|
83 |
pgsql 7.4.1 and 8.0.1
|
|
|
84 |
sqlite PHP 5: extension. PHP 4: PECL snapshot.
|
|
|
85 |
sybase ASE 12.5.3
|
|
|
86 |
|
|
|
87 |
Tests were performed under both of the following PHP versions
|
|
|
88 |
unles otherwise noted:
|
|
|
89 |
4.3.11-dev dated 2005-02-22
|
|
|
90 |
5.1.0-dev dated 2005-02-22
|