# PDO_firebird testing - Thread: https://externals.io/message/55349 - Original archive: https://news-web.php.net/php.internals/55349 - Started by Lester Caine on 2011-09-10T08:15:47+00:00 - Messages: 2 - Reply by email to internals@lists.php.net - More for agents: search with https://externals.io/search.md?q={query} · JSON API at https://externals.io/api · documentation at https://externals.io/llms.txt --- ## #55349 — Lester Caine — 2011-09-10T08:15:47+00:00 URL: https://externals.io/message/55349#55349 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 --- ## #55350 — Lester Caine — 2011-09-10T08:41:53+00:00 URL: https://externals.io/message/55349#55350 · In reply to: #55349 Lester Caine wrote: > Still have rowCount.phpt to finish off, but I think that is just killing the > connection with an open transaction. https://bugs.php.net/bug.php?id=55664 That covers it ... The basic problem that needs to be resolved is what the pdo driver tests should be using to test the pdo driver? The test failure is not with rowCount, but with the interaction between pdo and generic interbase driver, so that needs investigating in isolation to rowCount. I am suspicious that this may be a difference between interbase and firebird default actions, as well, so fxing may well require an 'fbird' generic driver. -- 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