Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:55349
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: error (pb1.pair.com: domain lsces.co.uk from 213.123.20.131 cause and error)
Message-ID: <4E6B1CB3.7080802@lsces.co.uk>
Date: Sat, 10 Sep 2011 09:15:47 +0100
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:6.0) Gecko/20110815 Firefox/6.0 SeaMonkey/2.3
MIME-Version: 1.0
To: PHP internals <internals@lists.php.net>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Subject: PDO_firebird testing
From: lester@lsces.co.uk (Lester Caine)

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