Return to bug_44454.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / pdo_mysql / tests

Annotation of embedaddon/php/ext/pdo_mysql/tests/bug_44454.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: Bug #44454 (Unexpected exception thrown in foreach() statement)
                      3: --SKIPIF--
                      4: <?php
                      5: if (!extension_loaded('pdo') || !extension_loaded('pdo_mysql')) die('skip not loaded');
                      6: require dirname(__FILE__) . '/config.inc';
                      7: require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc';
                      8: PDOTest::skip();
                      9: ?>
                     10: --FILE--
                     11: <?php
                     12: require dirname(__FILE__) . '/config.inc';
                     13: require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc';
                     14: $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
                     15: 
                     16: function bug_44454($db) {
                     17: 
                     18:        try {
                     19: 
                     20:                $db->exec('DROP TABLE IF EXISTS test');
                     21:                $db->exec('CREATE TABLE test(a INT, b INT, UNIQUE KEY idx_ab (a, b))');
                     22:                $db->exec('INSERT INTO test(a, b) VALUES (1, 1)');
                     23: 
                     24:                $stmt = $db->query('SELECT a, b FROM test');
                     25:                printf("... SELECT has returned %d row...\n", $stmt->rowCount());
                     26:                while ($row = $stmt->fetch()) {
                     27:                        try {
                     28:                                printf("... INSERT should fail...\n");
                     29:                                $db->exec('INSERT INTO test(a, b) VALUES (1, 1)');
                     30:                        } catch (Exception $e) {
                     31:                                printf("... STMT - %s\n", var_export($stmt->errorCode(), true));
                     32:                                printf("... PDO  - %s\n", var_export($db->errorInfo(), true));
                     33:                        }
                     34:                }
                     35: 
                     36:                $db->exec('DROP TABLE IF EXISTS test');
                     37:                $db->exec('CREATE TABLE test(a INT, b INT, UNIQUE KEY idx_ab (a, b))');
                     38:                $db->exec('INSERT INTO test(a, b) VALUES (1, 1)');
                     39: 
                     40:        } catch (Exception $e) {
                     41:                printf("... While error %s\n", $e->getMessage()); ;
                     42:        }
                     43: 
                     44:        $stmt = $db->query('SELECT a, b FROM test');
                     45:        printf("... SELECT has returned %d row...\n", $stmt->rowCount());
                     46:        foreach ($stmt as $row) {
                     47:                try {
                     48:                        printf("... INSERT should fail...\n");
                     49:                        $db->exec('INSERT INTO test(a, b) VALUES (1, 1)');
                     50:                } catch (Exception $e) {
                     51:                        printf("... STMT - %s\n", var_export($stmt->errorCode(), true));
                     52:                        printf("... PDO  - %s\n", var_export($db->errorInfo(), true));
                     53:                }
                     54:        }
                     55: 
                     56: }
                     57: 
                     58: $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
                     59: 
                     60: print "Native Prepared Statements\n";
                     61: $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0);
                     62: bug_44454($db);
                     63: 
                     64: print "\nEmulated Prepared Statements\n";
                     65: $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1);
                     66: bug_44454($db);
                     67: 
                     68: print "done!";
                     69: ?>
                     70: --CLEAN--
                     71: <?php
                     72: require dirname(__FILE__) . '/mysql_pdo_test.inc';
                     73: $db = MySQLPDOTest::factory();
                     74: $db->exec('DROP TABLE IF EXISTS test');
                     75: ?>
                     76: --XFAIL--
                     77: For some reason the exception gets thrown at the wrong place
                     78: --EXPECTF--
                     79: Native Prepared Statements
                     80: ... SELECT has returned 1 row...
                     81: ... INSERT should fail...
                     82: ... STMT - '00000'
                     83: ... PDO  - array (
                     84:   0 => '23000',
                     85:   1 => 1062,
                     86:   2 => 'Duplicate entry \'1-1\' for key %s',
                     87: )
                     88: ... SELECT has returned 1 row...
                     89: ... INSERT should fail...
                     90: ... STMT - '00000'
                     91: ... PDO  - array (
                     92:   0 => '23000',
                     93:   1 => 1062,
                     94:   2 => 'Duplicate entry \'1-1\' for key %s',
                     95: )
                     96: 
                     97: Emulated Prepared Statements
                     98: ... SELECT has returned 1 row...
                     99: ... INSERT should fail...
                    100: ... STMT - '00000'
                    101: ... PDO  - array (
                    102:   0 => '23000',
                    103:   1 => 1062,
                    104:   2 => 'Duplicate entry \'1-1\' for key %s',
                    105: )
                    106: ... SELECT has returned 1 row...
                    107: ... INSERT should fail...
                    108: ... STMT - '00000'
                    109: ... PDO  - array (
                    110:   0 => '23000',
                    111:   1 => 1062,
                    112:   2 => 'Duplicate entry \'1-1\' for key %s',
                    113: )
                    114: done!