Bug #91055 for DBD-Mock: "insert IGNORE" doesn't raise last_insert

Fri Nov 29 08:44:13 2013 zurom [...] mail.ru - Ticket created

Subject:	"insert IGNORE" doesn't raise last_insert_id
Date:	Fri, 29 Nov 2013 17:43:47 +0400
To:	bug-DBD-Mock [...] rt.cpan.org
From:	Roman <zurom [...] mail.ru>

DBD::Mock v1.43 (maybe later versions too) This code doesn't work for 'insert *IGNORE *into Table' statement $dbh->{mock_start_insert_id} = ['Table', 100500]; After $dbh->do('insert ignore into Table...') $dbh->last_insert_id() returns "undef" *Without 'ignore*' it's work fine

Fri Nov 29 09:52:51 2013 http://zurom.id.mail.ru/ - Correspondence added

Subject:	insert IGNORE doesn't raise last_insert_id
From:	zurom [...] mail.ru

The proble is in this regexp (DBD::Mock::st line 130): if ( $dbh->{Statement} =~ /^\s*?insert\s+into\s+(\S+)/i ) {

Fri Nov 29 09:52:52 2013 The RT System itself - Status changed from 'new' to 'open'

Mon Sep 09 05:12:33 2019 JLCOOPER [...] cpan.org - Correspondence added

On Fri Nov 29 08:44:13 2013, zurom wrote: Show quoted text

> > DBD::Mock v1.43 (maybe later versions too) > > This code doesn't work for 'insert *IGNORE *into Table' statement > $dbh->{mock_start_insert_id} = ['Table', 100500]; > > After > $dbh->do('insert ignore into Table...') > > $dbh->last_insert_id() returns "undef" > > *Without 'ignore*' it's work fine

Hi, I've recently picked up support for DBD::Mock and had a look at this. There's now a fix for this in the DBD::Mock codebase and it'll be in the next release (v1.48). Regards, Jason.

Mon Sep 16 02:58:00 2019 JLCOOPER [...] cpan.org - Correspondence added

On Mon Sep 09 05:12:33 2019, JLCOOPER wrote: Show quoted text

> On Fri Nov 29 08:44:13 2013, zurom wrote:

> > > > DBD::Mock v1.43 (maybe later versions too) > > > > This code doesn't work for 'insert *IGNORE *into Table' statement > > $dbh->{mock_start_insert_id} = ['Table', 100500]; > > > > After > > $dbh->do('insert ignore into Table...') > > > > $dbh->last_insert_id() returns "undef" > > > > *Without 'ignore*' it's work fine

> > Hi, > I've recently picked up support for DBD::Mock and had a look at > this. There's now a fix for this in the DBD::Mock codebase and it'll > be in the next release (v1.48). > > Regards, > Jason.

Hi, DBD::Mock v1.48 was released at the end of last week (quickly followed by v1.49 that resolved some issues with old Perl versions). The new version includes a fix for the Insert Ignore issue, so I'll close this case, but if you find any problems with then open an new case and I'll take another look at it. Regards, Jason.

Mon Sep 16 02:58:01 2019 JLCOOPER [...] cpan.org - Status changed from 'open' to 'resolved'

Mon Sep 16 02:58:01 2019 JLCOOPER [...] cpan.org - Fixed in 1.48 added

Bug #91055 for DBD-Mock: "insert IGNORE" doesn't raise last_insert_id