Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:45718
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: pass (pb1.pair.com: domain gmail.com designates 209.85.219.227 as permitted sender)
DomainKey-Status: bad
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=subject:from:to:cc:in-reply-to:references:content-type:date
         :message-id:mime-version:x-mailer:content-transfer-encoding;
        b=XvL3bj0LFmqsROhq5r317bypGZFOnmbSH4ogg5I/JL0SoA0CFLvj2vlQgis1in1z8n
         opuR81ObgN+Nuynadk8tLCWnikvOwOaQPkEmum6TCiYRuk8ykf+qiOjKm2gHzPZVqU2m
         vULbsVg4VLUVZBp88T5e84nPyEhPeVfn9+f6M=
To: Lester Caine <lester@lsces.co.uk>
Cc: PHP internals <internals@lists.php.net>
In-Reply-To: <4AD09F8B.1010205@lsces.co.uk>
References: <1255038690.10759.9.camel@samuel-laptop>
	 <1255120269.3605.14.camel@samuel-laptop>
	 <fe05d1540910091405ld0cc7c9r4355723c5b039a76@mail.gmail.com>
	 <1255122734.3605.21.camel@samuel-laptop>
	 <b54d0abe0910100344w7c87aa70m8fdff1d1030155d6@mail.gmail.com>
	 <4AD09F8B.1010205@lsces.co.uk>
Content-Type: text/plain; charset="UTF-8"
Date: Sat, 10 Oct 2009 19:32:25 +0200
Message-ID: <1255195945.3605.49.camel@samuel-laptop>
Mime-Version: 1.0
Content-Transfer-Encoding: 8bit
Subject: Re: [PHP-DEV] Re: Patch: Use notices in PDO
From: samuel.roze@gmail.com (Samuel ROZE)

Le samedi 10 octobre 2009 à 15:51 +0100, Lester Caine a écrit :
> Ferenc Kovacs wrote:
> >>> Then see how we can do it for the other drivers at the same time.
> >> I'm looking for Oracle.
> >> Is somebody know how we can do for MySQL (and how raise notices with
> >> it) ?
> >>
> > http://dev.mysql.com/doc/refman/5.1/en/show-warnings.html
> 
> Something to consider here is that, like MySQL in this case, many of 
> these types of activity ARE now available as SQL queries and so do not 
> have to be handled specially by the driver. It is only those areas where 
> the results are only available by non-SQL calls that should be added as 
> special cases. PDO has no interest in mapping SQL between different 
> engines! Carrying out additional SQL calls in the background to emulate 
> functions required by other drivers just seems wrong? The Firebird 
> engine has been working to move all of the 'service' facilities which 
> would normally be handled directly by the driver into simple SQL queries 
> to get around this problem from the other end.

It is the case for MySQL and Oracle...so for your mind, we don't have to
make this option available ? I disagree because PDO want make that PHP
codes support many Databases and if I want to get this notices on MySQL,
I can use "SHOW WARNING" but, if my apps is used on PostgreSQL, my query
will fail ! If I can use PDO::noticeInfo in MySQL and in PostgreSQL, it
will be great. :-)

And we have to know that these additional requests will be executed only
if PDO::ATTR_LOG_NOTICES is turned to 1 ! So user want 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
>