Return to bug53551.phpt CVS log

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

Annotation of embedaddon/php/ext/pdo_mysql/tests/bug53551.phpt, revision 1.1

1.1     ! misho       1: --TEST--
        !             2: Bug #44327 (PDORow::queryString property & numeric offsets / Crash)
        !             3: --SKIPIF--
        !             4: <?php
        !             5: require_once(dirname(__FILE__) . DIRECTORY_SEPARATOR . 'skipif.inc');
        !             6: require_once(dirname(__FILE__) . DIRECTORY_SEPARATOR . 'mysql_pdo_test.inc');
        !             7: MySQLPDOTest::skip();
        !             8: $db = MySQLPDOTest::factory();
        !             9: ?>
        !            10: --FILE--
        !            11: <?php
        !            12: include __DIR__ . DIRECTORY_SEPARATOR . 'mysql_pdo_test.inc';
        !            13: $db = MySQLPDOTest::factory();
        !            14: 
        !            15: $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0);
        !            16: 
        !            17: $createSql = "CREATE TABLE `bug53551` (
        !            18:   `count` bigint(20) unsigned NOT NULL DEFAULT '0'
        !            19: )";
        !            20: 
        !            21: $db->exec('drop table if exists bug53551');
        !            22: $db->exec($createSql);
        !            23: $db->exec("insert into bug53551 set `count` = 1 ");
        !            24: $db->exec("SET sql_mode = 'Traditional'");
        !            25: $sql = 'UPDATE bug53551 SET `count` = :count';
        !            26: $stmt = $db->prepare($sql);
        !            27: 
        !            28: $values = array (
        !            29:     'count' => NULL,
        !            30: );
        !            31: 
        !            32: echo "1\n";
        !            33: $stmt->execute($values);
        !            34: var_dump($stmt->errorInfo());
        !            35: 
        !            36: echo "2\n";
        !            37: $stmt->execute($values);
        !            38: var_dump($stmt->errorInfo());
        !            39: 
        !            40: echo "\ndone\n";
        !            41: 
        !            42: ?>
        !            43: --CLEAN--
        !            44: <?php
        !            45: include __DIR__ . DIRECTORY_SEPARATOR . 'mysql_pdo_test.inc';
        !            46: $db = MySQLPDOTest::factory();
        !            47: $db->exec('DROP TABLE IF EXISTS bug53551');
        !            48: ?>
        !            49: --EXPECTF--
        !            50: 1
        !            51: 
        !            52: Warning: PDOStatement::execute(): SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'count' cannot be null in %s on line %d
        !            53: array(3) {
        !            54:   [0]=>
        !            55:   string(5) "23000"
        !            56:   [1]=>
        !            57:   int(1048)
        !            58:   [2]=>
        !            59:   string(29) "Column 'count' cannot be null"
        !            60: }
        !            61: 2
        !            62: 
        !            63: Warning: PDOStatement::execute(): SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'count' cannot be null in %s on line %d
        !            64: array(3) {
        !            65:   [0]=>
        !            66:   string(5) "23000"
        !            67:   [1]=>
        !            68:   int(1048)
        !            69:   [2]=>
        !            70:   string(29) "Column 'count' cannot be null"
        !            71: }
        !            72: 
        !            73: done