diff options
| author | root <phackwer@gmail.com> | 2016-07-19 15:28:25 -0400 |
|---|---|---|
| committer | Anatol Belski <ab@php.net> | 2016-07-27 23:00:12 +0200 |
| commit | 12628e9a46b91a0aa92fd0619cdd545c409d25a6 (patch) | |
| tree | a3b7b93e02eedbdd0ef7987867bf18b4c1cb0b5d /ext/pdo_pgsql/tests | |
| parent | c52322707e4224a5b3c16d53e9b59512d3a188e9 (diff) | |
| download | php-git-12628e9a46b91a0aa92fd0619cdd545c409d25a6.tar.gz | |
Implemented FR #72633 Postgres PDO lastInsertId() should work without specifying a sequence
Diffstat (limited to 'ext/pdo_pgsql/tests')
| -rw-r--r-- | ext/pdo_pgsql/tests/bug_last_insert_id.phpt | 36 | ||||
| -rw-r--r-- | ext/pdo_pgsql/tests/common.phpt | 4 |
2 files changed, 38 insertions, 2 deletions
diff --git a/ext/pdo_pgsql/tests/bug_last_insert_id.phpt b/ext/pdo_pgsql/tests/bug_last_insert_id.phpt new file mode 100644 index 0000000000..24e889b30d --- /dev/null +++ b/ext/pdo_pgsql/tests/bug_last_insert_id.phpt @@ -0,0 +1,36 @@ +--TEST-- +currval() vs lastval() - PDO PgSQL Bug #1134 [BUG] New record, PostgreSQL and the Primary key https://github.com/phalcon/cphalcon/issues/1134 +--SKIPIF-- +<?php +if (!extension_loaded('pdo') || !extension_loaded('pdo_pgsql')) 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__) . '/../../../ext/pdo/tests/pdo_test.inc'; + +$db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt'); + +$db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false); + +@$db->query('CREATE TABLE test_last_id (id SERIAL NOT NULL, field1 VARCHAR(10))'); + +$stmt = $db->prepare("INSERT INTO test_last_id (field1) VALUES ('test')"); + +$stmt->execute(); + +/** + * No sequence name informed + */ +var_dump($db->lastInsertId()); +/** + * Sequence name informed + */ +var_dump($db->lastInsertId('test_last_id_id_seq')); +?> +--EXPECTREGEX-- +string\([0-9]*\)\ \"[0-9]*\" +string\([0-9]*\)\ \"[0-9]*\" diff --git a/ext/pdo_pgsql/tests/common.phpt b/ext/pdo_pgsql/tests/common.phpt index e764b39839..a484e69ea3 100644 --- a/ext/pdo_pgsql/tests/common.phpt +++ b/ext/pdo_pgsql/tests/common.phpt @@ -5,7 +5,7 @@ Postgres if (!extension_loaded('pdo_pgsql')) print 'skip'; ?> --REDIRECTTEST-- # magic auto-configuration -# Also update config.inc if you make changes here... +# Also update config.inc if you make changes here... $config = array( 'TESTS' => __DIR__ . '/ext/pdo/tests' @@ -20,5 +20,5 @@ if (false !== getenv('PDO_PGSQL_TEST_DSN')) { } else { $config['ENV']['PDOTEST_DSN'] = 'pgsql:host=localhost port=5432 dbname=test user= password='; } - + return $config; |