[#ZF-10160] Zend_Db_Adapter_Pdo_Pgsql (lastInsertId) - Zend Framework Issue Tracker

Details

Type: Bug
Status: Resolved
Priority: Major
Resolution: Fixed
Affects Version/s: 1.10.6
Fix Version/s: 1.10.7
Component/s: Zend_Db
Labels:
None

Description

line [325]
file Zend/Db/Adapter/Pdo/Pgsql.php
now return $this->lastSequenceId($sequenceName);
need return $this->lastSequenceId('"' . $sequenceName . '"');

example:
$table = 'User';
$row = "ID";

PostgreSQL considers 'User_ID_seq' == 'user_id_seq', but '"User_ID_seq"' != '"user_id_seq"'

Options
- Show All
- Show Open

Sub-Tasks

nextSequenceId overquotes schema/sequence name

Resolved

Ramon Henrique Ornelas

Activity

Ascending order - Click to sort in descending order

Hide

Permalink

Ramon Henrique Ornelas added a comment - 15/Jul/10 3:56 PM - edited

The problem not is in the called and yes within Zend_Db_Adapter_Pdo_Pgsql:>lastSequenceId().

See line 284:
Current code:

$value = $this->fetchOne("SELECT CURRVAL(".$this->quote($sequenceName).")");

Could be;

$value = $this->fetchOne("SELECT CURRVAL('".$this->quoteIdentifier($sequenceName, true)."')");

Problem applicant too in Zend_Db_Adapter_Pdo_Pgsql:>nextSequenceId()

Show

Ramon Henrique Ornelas added a comment - 15/Jul/10 3:56 PM - edited The problem not is in the called and yes within Zend_Db_Adapter_Pdo_Pgsql:>lastSequenceId(). See line 284: Current code:

$value = $this->fetchOne("SELECT CURRVAL(".$this->quote($sequenceName).")");

Could be;

$value = $this->fetchOne("SELECT CURRVAL('".$this->quoteIdentifier($sequenceName, true)."')");

Problem applicant too in Zend_Db_Adapter_Pdo_Pgsql:>nextSequenceId()

Hide

Permalink

Ramon Henrique Ornelas added a comment - 15/Jul/10 7:10 PM

Thanks by the report, fixed in r22566,

Show

Ramon Henrique Ornelas added a comment - 15/Jul/10 7:10 PM Thanks by the report, fixed in r22566,

People

Assignee:

Ramon Henrique Ornelas

Reporter:

Lexa Dobrynin

Vote (0)

Watch (2)

Dates

Created:

15/Jul/10 3:33 AM

Updated:

15/Jul/10 7:10 PM

Resolved:

15/Jul/10 7:10 PM