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:
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>