Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!newsreader4.netcologne.de!news.netcologne.de!newsfeed.arcor.de!newsspool4.arcor-online.net!news.arcor.de.POSTED!not-for-mail
Content-Type: text/plain; charset="UTF-8"
Message-ID: <12356089.gSGYd4PIy3@PointedEars.de>
From: Thomas 'PointedEars' Lahn <PointedEars@web.de>
Reply-To: Thomas 'PointedEars' Lahn <php@PointedEars.de>
Organization: PointedEars Software (PES)
Date: Tue, 29 Oct 2013 13:10:36 +0100
User-Agent: KNode/4.10.5
Content-Transfer-Encoding: 8Bit
X-Face: %i>XG-yXR'\"2P/C_aO%~;2o~?g0pPKmbOw^=NT`tprDEf++D.m7"}HW6.#=U:?2GGctkL,f89@H46O$ASoW&?s}.k+&.<b';Md8`dH6iqhT)6C^.Px|[=M@7=Ik[_w<%n1Up"LPQNu2m8|L!/3iby{-]A+#YE}Kl{Cw$\U!kD%K}\2jz"QQP6Uqr],./"?;=4v
Face: iVBORw0KGgoAAAANSUhEUgAAADAAAAAwBAMAAAClLOS0AAAAGFBMVEXTxa4RFk5dUWANED8PFEfy7+MGBiW+n3ZNF/QuAAACaElEQVQ4jVXUwVOcMBQG8Dc7Rc4PUntdWV2uxjDpGaGeozOp1woar4jd5t/v9wLstMwsA/ntlxdCAgUc1hjTc9/JCZfGoo3wG3HdmdAWrIJRHe7GM/TmpY5VFefuVcAkkPbLIaN8rmPmjloyZxgyR3GuJ4K0AGtJ2htz8o7yqikm759fldQXaMpbDzjKAG+8v+AugVTOPO5DOjLvGtUYQwh0CPjnVMyGd+8/GfUB5nLKJDD2aLDh5HYyMDJGDwQIo2ZmZcKbowNmAdB/AzyFhrmF2MHRb0QJJfaAnwGB6orZhoykLzJtGwF/xpYxI1dswomiUj3gTuAIqCn/4C7cULwGNBtwMTk3Y4LfKB5YUaOKBKYtpplm7u0vip8tU1NWWyI/7XdcSuIDoMt6rVHMWT0DbjHPGqDqZVSa6zleLcUTcIKLoMv3ueJluALtAo9B302zPPlrtiVScRdCjXvVh3e3JpYa/jjkuC9N+LrBMlz/eAN4eQijX2EdLo6c5tGGHwLyHFtXk89dDGHwCVhG9T0S/j55AhRZgkMCmUQXJ49TnS1wnQDvw0eAh9ICeMmEFbCnPMFzjAvsWoEWEFdYEx+S0MoUZ1gT1wId8+AF3Bl2OoEu906AUHx5VLw/gXYg/x84loOah/2UYNrgiwSwGO7RfUzVBbx/kgpckumGOi6QirtD6gkLTitbnxNol47S2jVc2vsN5kPqaAHT8uUdAJM4v/DanjYOwmUjWznGfwB7sGtAtor5BgofDuzaRj4kSQAqDakTsKORa3Q3xKi3gE1fhl71KRMqrdZ2AWNNg/YOhQyrVBnb+i+nEg4bsDA+egAAAABJRU5ErkJggg==
Subject: Re: PDO - Cannot retrieve warnings with emulated prepares disabled
Newsgroups: comp.lang.php
References: <l4mohq$9ea$1@news.albasani.net>
MIME-Version: 1.0
Lines: 102
NNTP-Posting-Date: 29 Oct 2013 13:10:52 CET
NNTP-Posting-Host: a76b2eb2.newsspool4.arcor-online.net
X-Trace: DXC=L=cTd3lCFC5RadXUBHgFh34IUK<Cl32<14Fo<]lROoR18kF<OcfhCO;7EWL1O4@eW;DZm8W4\YJN<YUVHKH;GI^7FgT<1=<dKe7Ekd2GbQ69e9
X-Complaints-To: usenet-abuse@arcor.de
Xref: csiph.com comp.lang.php:11621

Thomas Mlynarczyk wrote:

> When I do this:
> 
>      $pdo = new PDO( /* MySQL connection */ );
>      // $pdo->setAttribute( PDO::ATTR_EMULATE_PREPARES, false );
>      $stmt = $pdo->prepare( 'SELECT 5 + "Five"' );
>      $stmt->execute();
>      var_dump( $pdo->query( 'SHOW WARNINGS' )
>          ->fetchAll( PDO::FETCH_ASSOC ) );
> 
> I get a warning back:
> 
>      Warning 1292 Truncated incorrect DOUBLE value: 'Five'
> 
> But when I uncomment the second line (disabling emulation of prepared
> statements), "SHOW WARNINGS" returns an empty array. Why?

I cannot reproduce that.

---------------------------------------------------------------------------
$ php -r '
  $pdo = new PDO("mysql:host=localhost", "…", "…");
  $stmt = $pdo->prepare("SELECT 5 + \"Five\"");
  $stmt->execute();
  var_dump($pdo->query("SHOW WARNINGS")->fetchAll(PDO::FETCH_ASSOC));
  var_dump($stmt->fetchAll());'
array(1) {
  [0] =>
  array(3) {
    'Level' =>
    string(7) "Warning"
    'Code' =>
    string(4) "1292"
    'Message' =>
    string(40) "Truncated incorrect DOUBLE value: 'Five'"
  }
}
array(1) {
  [0] =>
  array(2) {
    '5 + "Five"' =>
    string(1) "5"
    [0] =>
    string(1) "5"
  }
}

$ php -r '
  $pdo = new PDO("mysql:host=localhost", "…", "…");
  $pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
  $stmt = $pdo->prepare("SELECT 5 + \"Five\"");
  $stmt->execute();
  var_dump($pdo->query("SHOW WARNINGS")->fetchAll(PDO::FETCH_ASSOC));
  var_dump($stmt->fetchAll());'
array(1) {
  [0] =>
  array(3) {
    'Level' =>
    string(7) "Warning"
    'Code' =>
    string(4) "1292"
    'Message' =>
    string(40) "Truncated incorrect DOUBLE value: 'Five'"
  }
}
array(1) {
  [0] =>
  array(2) {
    '5 + "Five"' =>
    string(1) "5"
    [0] =>
    string(1) "5"
  }
}

$ php -v
PHP 5.4.15-1 (cli) (built: May 12 2013 12:17:45) 
Copyright (c) 1997-2013 The PHP Group
Zend Engine v2.4.0, Copyright (c) 1998-2013 Zend Technologies
    with XCache v3.0.1, Copyright (c) 2005-2013, by mOo
    with Xdebug v2.2.1, Copyright (c) 2002-2012, by Derick Rethans
    with XCache Optimizer v3.0.1, Copyright (c) 2005-2013, by mOo
    with XCache Cacher v3.0.1, Copyright (c) 2005-2013, by mOo
    with XCache Coverager v3.0.1, Copyright (c) 2005-2013, by mOo

$ mysql -V
mysql  Ver 14.14 Distrib 5.5.33, for debian-linux-gnu (i686) using readline 
6.2
---------------------------------------------------------------------------

PDO::ATTR_EMULATE_PREPARES == false should be the effective default for 
PDO_MySQL unless you are using an ancient MySQL version (why?) that does not 
support Prepared Statements.


PointedEars
-- 
Prototype.js was written by people who don't know javascript for people
who don't know javascript. People who don't know javascript are not
the best source of advice on designing systems that use javascript.
  -- Richard Cornford, cljs, <f806at$ail$1$8300dec7@news.demon.co.uk>