Subject | Re: [firebird-php] php test failures |
---|---|
Author | Lester Caine |
Post date | 2011-09-09T20:18:33Z |
Lester Caine wrote:
Many of the tests can only fail since they are testing particular facets of a
database rather than the common functions that PDO is supposed to provide.
The starting point seems to be these 'named' parameters. i.e. putting ':id' in
the SQL and then feeding the prepared query with an array including (":id" => 1)
... while I can imagine that it is possible to rewrite the SQL to use '?'s and
reorder the supplied array to provide one suitable to feed to firebird, this is
not how one would want to work in an ideal world?
SQL such as
"SELECT 'Ã' as test FROM test WHERE id = :id" does not even follow the SQL standard?
marius - I'm going to suggest that pdo_firebird is just ignored for tests that
fail. It's simply not sensible to waste time making them work when it means that
the resulting queries can't be used in other databases anyway!
--
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
> PDO is another area ... many of the tests are simply not configured to run withAnybody actually USING pdo :)
> firebird ... about to work through them now.
Many of the tests can only fail since they are testing particular facets of a
database rather than the common functions that PDO is supposed to provide.
The starting point seems to be these 'named' parameters. i.e. putting ':id' in
the SQL and then feeding the prepared query with an array including (":id" => 1)
... while I can imagine that it is possible to rewrite the SQL to use '?'s and
reorder the supplied array to provide one suitable to feed to firebird, this is
not how one would want to work in an ideal world?
SQL such as
"SELECT 'Ã' as test FROM test WHERE id = :id" does not even follow the SQL standard?
marius - I'm going to suggest that pdo_firebird is just ignored for tests that
fail. It's simply not sensible to waste time making them work when it means that
the resulting queries can't be used in other databases anyway!
--
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