PDO_firebird testing View as Markdown

This by way of a crib sheet as I'm checking each test ...
I've posted a patch which should updated the 5.3 branch, and I can't see why it
should not work with 5.4 and trunk as nothing here should have changed between
branches?

https://bugs.php.net/bug.php?id=55663 has the patch ... why the f**k does the
patch never get saved when I create the bug report? Just added it back in again.

Still have rowCount.phpt to finish off, but I think that is just killing the
connection with an open transaction.

TEST 2597/6878 [ext/pdo/tests/pdo_016.phpt]
SKIP FIREBIRD PDO Common: PDO::FETCH_BOUND [ext/pdo_firebird/tests/pdo_016.phpt]
reason: not relevant for pdo_firebird driver - does not support named parameters
in this context
TEST 2598/6878 [ext/pdo/tests/pdo_016a.phpt]
SKIP FIREBIRD PDO Common: PDO::FETCH_BOUND w/o :
[ext/pdo_firebird/tests/pdo_016a.phpt] reason: not relevant for pdo_firebird
driver - does not support named parameters in this context
TEST 2600/6878 [ext/pdo/tests/pdo_018.phpt]
SKIP FIREBIRD PDO Common: serializing [ext/pdo_firebird/tests/pdo_018.phpt]
TEST 2603/6878 [ext/pdo/tests/pdo_021.phpt] reason: not relevant for
pdo_firebird driver - does not support named parameters in this context
SKIP FIREBIRD PDO Common: PDOStatement::execute with parameters
[ext/pdo_firebird/tests/pdo_021.phpt] reason: not relevant for pdo_firebird
driver - does not support named parameters in this context
TEST 2606/6878 [ext/pdo/tests/pdo_024.phpt]
SKIP FIREBIRD PDO Common: assert that bindParam does not modify parameter
[ext/pdo_firebird/tests/pdo_024.phpt] reason: not relevant for pdo_firebird
driver - does not support named parameters in this context
TEST 2541/6856 [ext/pdo/tests/bug_34630.phpt]
SKIP FIREBIRD PDO Common: Bug #34630 (inserting streams as LOBs)
[ext/pdo_firebird/tests/bug_34630.phpt] reason: not relevant for pdo_firebird
driver - does not support named parameters in this context
TEST 2543/6856 [ext/pdo/tests/bug_35671.phpt]
SKIP FIREBIRD PDO Common: Bug #35671 (binding by name breakage)
[ext/pdo_firebird/tests/bug_35671.phpt] reason: not relevant for pdo_firebird
driver - does not support named parameters in this context
TEST 2548/6856 [ext/pdo/tests/bug_39398.phpt]
SKIP FIREBIRD PDO Common: Bug #39398 (Booleans are not automatically translated
to integers) [ext/pdo_firebird/tests/bug_39398.phpt] reason: not relevant for
pdo_firebird driver - does not support named parameters in this context
TEST 2552/6856 [ext/pdo/tests/bug_43130.phpt]
SKIP FIREBIRD PDO Common: Bug #43130 (Bound parameters cannot have - in their
name) [ext/pdo_firebird/tests/bug_43130.phpt] reason: not relevant for
pdo_firebird driver - does not support named parameters in this context

In these cases, firebird does not manage named parameters over the wire. This is
normally handled by the client end software, so to emulate the PDO requirement
would also require modifying the SQL from that supplied, which is not catered
for in PDO currently.

TEST 2599/6878 [ext/pdo/tests/pdo_017.phpt]
SKIP FIREBIRD PDO Common: transactions [ext/pdo_firebird/tests/pdo_017.phpt]
reason: no working transactions: There is already an active transaction

Test to check if transactions are available leaves the open transaction ...
rollback() added to close, but can't see where the skip message is created.

TEST 2604/6878 [ext/pdo/tests/pdo_022.phpt]
SKIP FIREBIRD PDO Common: PDOStatement::getColumnMeta
[ext/pdo_firebird/tests/pdo_022.phpt] reason: this feature is not yet finalized,
no test makes sense

Agree with that one ...

TEST 2544/6856 [ext/pdo/tests/bug_36428.phpt]
SKIP FIREBIRD PDO Common: Bug #36428 (Incorrect error message for
PDO::fetchAll()) [ext/pdo_firebird/tests/bug_36428.phpt] reason: SimpleXML not
loaded

This is not listed anyway so should pass

TEST 2545/6856 [ext/pdo/tests/bug_36798.phpt]
SKIP FIREBIRD PDO Common: Bug #36798 (Error parsing named parameters with
queries containing high-ascii chars) [ext/pdo_firebird/tests/bug_36798.phpt]
reason: not relevant for pdo_firebird driver - SQL is not valid against SQL standard

Original bug report identified error, but was ignored. SQL standard only accepts
non assci characters within double quotes ...

TEST 2546/6856 [ext/pdo/tests/bug_38253.phpt]
SKIP FIREBIRD PDO Common: Bug #38253 (PDO produces segfault with default fetch
mode) [ext/pdo_firebird/tests/bug_38253.phpt] reason: pdo_firebird driver
failure to be identified in PDO::ATTR_DEFAULT_FETCH_MODE

Test does not seem to be setting up the right environment as manually running
the php gives reported errors. No time to dig into deeply so flag and skip

TEST 2558/6856 [ext/pdo/tests/bug_44861.phpt]
SKIP FIREBIRD PDO Common: Bug #44861 (scrollable cursor don't work with pgsql)
[ext/pdo_firebird/tests/bug_44861.phpt] reason: Scrollable cursors not supported

Skip report is wrong ... firebird supports cursors, but need to check if they
work in the same way as this test exercises them.

--
Lester Caine - G8HFL

Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php