php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #56428 nextval() always returns NULL
Submitted: 2005-06-25 14:02 UTC Modified: 2005-06-29 09:57 UTC
From: bjori at jeshus dot com Assigned:
Status: Closed Package: PDO_PGSQL (PECL)
PHP Version: 5.0.3 OS: FreeBSD 5.3-RELEASE
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If this is not your bug, you can add a comment by following this link.
If this is your bug, but you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: bjori at jeshus dot com
New email:
PHP Version: OS:

 

 [2005-06-25 14:02 UTC] bjori at jeshus dot com
Description:
------------
(running PHP5.0.4, not .3)
PDO 0.3
PDO_PGSQL 0.2
select nextval() *always* returns NULL

Reproduce code:
---------------
<?php
    $PDO = new PDO(...);
    $PDO->setAttribute(PDO_ATTR_CASE, PDO_CASE_UPPER);
    
    $sql = "CREATE TABLE foo(id serial not null primary key)";
    $PDO->exec($sql);
    
    $sql = "INSERT INTO foo VALUES(1);";
    $PDO->exec($sql);
    
    $sql = "SELECT nextval('foo_id_seq')";
    $PDOStatement = $PDO->prepare($sql);
    $PDOStatement->execute();
    
    $PDOStatement->bindColumn("NEXTVAL", $id);
    $row = $PDOStatement->fetchAll();
    
    var_dump($id, $row, $PDO->errorInfo(), $PDOStatement->errorInfo());
    
    $sql = "DROP TABLE foo";
    $PDO->exec($sql);
?>


Expected result:
----------------
2
array(1) {
  [0]=>
  array(2) {
    ["NEXTVAL"]=>
    2
    [0]=>
    2
  }
}
array(1) {
  [0]=>
  string(5) "00000"
}
array(1) {
  [0]=>
  string(5) "00000"
}


Actual result:
--------------
NULL
array(1) {
  [0]=>
  array(2) {
    ["NEXTVAL"]=>
    NULL
    [0]=>
    NULL
  }
}
array(1) {
  [0]=>
  string(5) "00000"
}
array(1) {
  [0]=>
  string(5) "00000"
}


Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-06-28 18:36 UTC] edink at emini dot dk
Could you please try the latest CVS version. There I get 
the correct result, 1 (and not 2).

PDO is bundled in the latest 5.1 snapshots.
 [2005-06-29 09:57 UTC] bjori at jeshus dot com
Works like a charm in CVS. Thanks
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Fri Mar 29 14:01:28 2024 UTC