File:
[ELWIX - Embedded LightWeight unIX -] /
embedaddon /
php /
ext /
pdo_mysql /
tests /
bug_44454.phpt
Revision
1.1.1.1 (vendor branch):
download - view:
text,
annotated -
select for diffs -
revision graph
Tue Feb 21 23:47:59 2012 UTC (12 years, 6 months ago) by
misho
Branches:
php,
MAIN
CVS tags:
v5_4_3elwix,
v5_4_29p0,
v5_4_29,
v5_4_20p0,
v5_4_20,
v5_4_17p0,
v5_4_17,
v5_3_10,
HEAD
php
--TEST--
Bug #44454 (Unexpected exception thrown in foreach() statement)
--SKIPIF--
<?php
if (!extension_loaded('pdo') || !extension_loaded('pdo_mysql')) die('skip not loaded');
require dirname(__FILE__) . '/config.inc';
require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc';
PDOTest::skip();
?>
--FILE--
<?php
require dirname(__FILE__) . '/config.inc';
require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc';
$db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
function bug_44454($db) {
try {
$db->exec('DROP TABLE IF EXISTS test');
$db->exec('CREATE TABLE test(a INT, b INT, UNIQUE KEY idx_ab (a, b))');
$db->exec('INSERT INTO test(a, b) VALUES (1, 1)');
$stmt = $db->query('SELECT a, b FROM test');
printf("... SELECT has returned %d row...\n", $stmt->rowCount());
while ($row = $stmt->fetch()) {
try {
printf("... INSERT should fail...\n");
$db->exec('INSERT INTO test(a, b) VALUES (1, 1)');
} catch (Exception $e) {
printf("... STMT - %s\n", var_export($stmt->errorCode(), true));
printf("... PDO - %s\n", var_export($db->errorInfo(), true));
}
}
$db->exec('DROP TABLE IF EXISTS test');
$db->exec('CREATE TABLE test(a INT, b INT, UNIQUE KEY idx_ab (a, b))');
$db->exec('INSERT INTO test(a, b) VALUES (1, 1)');
} catch (Exception $e) {
printf("... While error %s\n", $e->getMessage()); ;
}
$stmt = $db->query('SELECT a, b FROM test');
printf("... SELECT has returned %d row...\n", $stmt->rowCount());
foreach ($stmt as $row) {
try {
printf("... INSERT should fail...\n");
$db->exec('INSERT INTO test(a, b) VALUES (1, 1)');
} catch (Exception $e) {
printf("... STMT - %s\n", var_export($stmt->errorCode(), true));
printf("... PDO - %s\n", var_export($db->errorInfo(), true));
}
}
}
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
print "Native Prepared Statements\n";
$db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0);
bug_44454($db);
print "\nEmulated Prepared Statements\n";
$db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1);
bug_44454($db);
print "done!";
?>
--CLEAN--
<?php
require dirname(__FILE__) . '/mysql_pdo_test.inc';
$db = MySQLPDOTest::factory();
$db->exec('DROP TABLE IF EXISTS test');
?>
--XFAIL--
For some reason the exception gets thrown at the wrong place
--EXPECTF--
Native Prepared Statements
... SELECT has returned 1 row...
... INSERT should fail...
... STMT - '00000'
... PDO - array (
0 => '23000',
1 => 1062,
2 => 'Duplicate entry \'1-1\' for key %s',
)
... SELECT has returned 1 row...
... INSERT should fail...
... STMT - '00000'
... PDO - array (
0 => '23000',
1 => 1062,
2 => 'Duplicate entry \'1-1\' for key %s',
)
Emulated Prepared Statements
... SELECT has returned 1 row...
... INSERT should fail...
... STMT - '00000'
... PDO - array (
0 => '23000',
1 => 1062,
2 => 'Duplicate entry \'1-1\' for key %s',
)
... SELECT has returned 1 row...
... INSERT should fail...
... STMT - '00000'
... PDO - array (
0 => '23000',
1 => 1062,
2 => 'Duplicate entry \'1-1\' for key %s',
)
done!
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>