Return to bug_62024.phpt CVS log

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

Annotation of embedaddon/php/ext/pdo_firebird/tests/bug_62024.phpt, revision 1.1

1.1     ! misho       1: --TEST--
        !             2: Bug #62024 Cannot insert second row with null using parametrized query (Firebird PDO)
        !             3: --SKIPIF--
        !             4: <?php extension_loaded("pdo_firebird") or die("skip"); ?>
        !             5: <?php function_exists("ibase_query") or die("skip"); ?>
        !             6: --FILE--
        !             7: <?php
        !             8: 
        !             9: require("testdb.inc");
        !            10: 
        !            11: $dbh = new PDO("firebird:dbname=$test_base",$user,$password) or die;
        !            12: $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
        !            13: $value = '2';
        !            14: @$dbh->exec('DROP TABLE test_insert');
        !            15: $dbh->exec("CREATE TABLE test_insert (ID INTEGER NOT NULL, TEXT VARCHAR(10))");
        !            16: 
        !            17: $dbh->commit();
        !            18: 
        !            19: //start actual test
        !            20: 
        !            21: $sql = "insert into test_insert (id, text) values (?, ?)";
        !            22: $sttmt = $dbh->prepare($sql);
        !            23: 
        !            24: $args_ok = array(1, "test1");
        !            25: $args_err = array(2, null);
        !            26: 
        !            27: $res = $sttmt->execute($args_ok);
        !            28: var_dump($res);
        !            29: 
        !            30: $res = $sttmt->execute($args_err);
        !            31: var_dump($res);
        !            32: 
        !            33: $dbh->commit();
        !            34: 
        !            35: 
        !            36: //teardown test data
        !            37: $sttmt = $dbh->prepare('DELETE FROM test_insert');
        !            38: $sttmt->execute();
        !            39: 
        !            40: $dbh->commit();
        !            41: 
        !            42: $dbh->exec('DROP TABLE test_insert');
        !            43: 
        !            44: unset($sttmt);
        !            45: unset($dbh);
        !            46: 
        !            47: ?>
        !            48: --EXPECT--
        !            49: bool(true)
        !            50: bool(true)
        !            51: