Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:45569
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.132 cause and error)
Message-ID: <4AACCACB.8070407@lsces.co.uk>
Date: Sun, 13 Sep 2009 11:34:51 +0100
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.8.1.22) Gecko/20090710 Fedora/1.1.17-1.fc11 pango-text SeaMonkey/1.1.17
MIME-Version: 1.0
To: internals@lists.php.net
References: <4AAB8580.9080607@lsces.co.uk>
In-Reply-To: <4AAB8580.9080607@lsces.co.uk>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Subject: Re: [PHP-DEV] pdp:firebird driver
From: lester@lsces.co.uk (Lester Caine)

Lester Caine wrote:
> I'm being dragged screaming into using PDO but I'm having major problems 
> since a number of fixes that have been applied to the firebird driver 
> have only been done to PHP5.3 branch ( back in 2007! )
> 
> Fedora does not have 5.3 deployed yet, and it will cause a lot more 
> problems anyway, since we will be forced to address the 5.3 changes when 
> the original 5.2 based code is already broken. So is there ANY way of 
> getting the fixes back ported to the 5.2 branch?
> 
> The first hurdle is http://bugs.php.net/bug.php?id=35386 which stops 
> many of the core SQL working in phpgedview - which has had all of the 
> older PEAR/ADOdb code stripped and so now will only work with PDO :(

OK - it IS a little more complex ....

That bug is not the only one, and so there are a number of SQL 
combinations that crash PDO:firebird. Next problem is to start testing a 
whole raft of SQL just in case it causes a crash.
What is a little confusing is why the CONTENT of an SQl statement should 
cause a problem when calling 'fetch'. The SQl prepares AND executes 
without a problem, it is only when trying to retrieve the results that 
the problem arises.

-- 
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