[PHP-DEV] BAD Benchmark Results for PHP Master 2017-05-18

2017-05-19 Thread lp_benchmark_robot
Results for project PHP master, build date 2017-05-18 19:24:13-07:00 commit: 372397f previous commit:b627e33 revision date: 2017-05-18 19:24:30+03:00 environment:Haswell-EP cpu:Intel(R) Xeon(R) CPU E5-2699 v3 @ 2.30GHz 2x18 cores, stepping 2, LLC 45 MB

RE: [PHP-DEV] PDO Parameter types // PDO::PARAM_AUTO

2017-05-19 Thread Dorin Marcoci
> > It's not an empty string. > > My mistake, I ran the wrong example test script through the debugger. It is > an empty string, sorry. That's why I'm trying to preach this :) really annoying to guess/detect and put once again param type while driver know it! -- PHP Internals - PHP Runtime Dev

Re: [PHP-DEV] PDO Parameter types // PDO::PARAM_AUTO

2017-05-19 Thread Matteo Beccati
On 19/05/2017 14:35, Matteo Beccati wrote: > [0x716801e0] bool: false > > It's not an empty string. My mistake, I ran the wrong example test script through the debugger. It is an empty string, sorry. Cheers -- Matteo Beccati Development & Consulting - http://www.beccati.com/ -- PHP Inte

Re: [PHP-DEV] PDO Parameter types // PDO::PARAM_AUTO

2017-05-19 Thread Matteo Beccati
Hi Dorin, On 18/05/2017 12:17, Matteo Beccati wrote: > Hi Dorin, > > On 18/05/2017 11:41, Dorin Marcoci wrote: >> I meant the case when a bool is passed as string, like >> bindValue('boolparam', false); >> Here it comes as an empty string, not "0", while true comes as "1". > > Please have a loo

[PHP-DEV] RE: PDO Parameter types // PDO::PARAM_AUTO

2017-05-19 Thread Dorin Marcoci
Hello Adam, > From: Adam Baratz [mailto:adambar...@php.net] > Sent: Friday, May 19, 2017 1:26 PM >> Maybe even a better way is just to change default param type from PARAM_STR >> to PARAM_AUTO in bindValue family routines, without any driver options or >> configs. >> So if drivers supports ser

[PHP-DEV] RE: PDO Parameter types // PDO::PARAM_AUTO

2017-05-19 Thread Dorin Marcoci
Hi Adam, From: Adam Baratz [mailto:adambar...@php.net] Sent: Friday, May 19, 2017 1:26 PM Maybe even a better way is just to change default param type from PARAM_STR to PARAM_AUTO in bindValue family routines, without any driver options or configs. So if drivers supports server prepares wi

[PHP-DEV] Re: PDO Parameter types // PDO::PARAM_AUTO

2017-05-19 Thread Adam Baratz
> > > The risk with this is queries could lose portability between drivers. > There are differences in the level of information each one can get from the > DB server, and different costs associated with asking. > > I think the right model is to have PDO types map directly to SQL types. > That said,