sqlrelay-discussion

[Sqlrelay-discussion] Bug in SQLRelay.pm

[Stephen C. <sca...@le...>]

In sqlrelay version 0.45, the function last_insert_id is missing the 
declaration for $dbh;

sub last_insert_id {

    # ignore parameters

    # get the last insert id
    return $dbh->FETCH('driver_connection')->getLastInsertId();
}


I'm not sure what uses it.

-- 
Stephen

Non est salvatori salvator.
Neque defensori vir.
Nec pater, nec mater,
nihil supernum.

Re: [Sqlrelay-discussion] Bug in SQLRelay.pm

[David M. <dav...@fi...>]

Yeah, I discovered the same bug a while back and it's fixed in CVS but 
not in any release yet.  Here's the code for that function in CVS if you 
want to patch your version:

sub last_insert_id {

	# get parameters
	my ($dbh)=@_;

	# get the last insert id
	return $dbh->FETCH('driver_connection')->getLastInsertId();
}

It's an obscure function.  Only a few databases support it.  I think it 
returns the internal row id of the most recent insert done in the 
current transaction.  Something like that.

I'm probably a week or so out from the next release and it should have 
this fix in it.

David Muse
dav...@fi...

On 08/09/2012 06:46 PM, Stephen Carville wrote:
> In sqlrelay version 0.45, the function last_insert_id is missing the
> declaration for $dbh;
>
> sub last_insert_id {
>
>      # ignore parameters
>
>      # get the last insert id
>      return $dbh->FETCH('driver_connection')->getLastInsertId();
> }
>
>
> I'm not sure what uses it.
>