php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #58116 Sequence handling is broken
Submitted: 2008-03-25 05:08 UTC Modified: 2009-05-18 06:14 UTC
From: alexander dot thiem at ingres dot com Assigned:
Status: Not a bug Package: ingres (PECL)
PHP Version: 5.2.1 OS: Linux
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 you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: alexander dot thiem at ingres dot com
New email:
PHP Version: OS:

 

 [2008-03-25 05:08 UTC] alexander dot thiem at ingres dot com
Description:
------------
Inserting into a table with an auto-sequence and then trying to get the inserted id fails with fatal error when using the code below.




Reproduce code:
---------------
create table my_table (i integer with default my_seq.nextval)

<?php
$link = ingres2_connect("database");
ingres2_autocommit($link);
ingres2_query($link, "insert into my_table values (default)");
$res = ingres2_query($link, "select current value for my_seq");
$row = ingres2_fetch_array($res);
?>

Expected result:
----------------
It should return the last ID for that sequence

Actual result:
--------------
It gives a fatal error with internal commit

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2009-05-18 06:14 UTC] grant dot croker at ingres dot com
Thank you for taking the time to write to us, but this is not
a bug.

Unfortunately this is expected with Ingres and auto-commit enabled.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sat Dec 21 18:01:29 2024 UTC