Re^3: DBI and last_insert

Ok, here are a couple more thoughts. First, is there possibly another insert in your real code between the first insert and your call to last_insert_id? A side effect of some sub call maybe?

Second, you definitely should be able to see data you inserted during a transaction with a SELECT, even if the data is not committed yet, provided your queries are all coming from the same connection. That sounds very suspicious to me.

Comment on Re^3: DBI and last_insert_id

Replies are listed 'Best First'.
Re^4: DBI and last_insert_id by cog (Parson) on Jan 29, 2009 at 18:17 UTC
... is there possibly another insert in your real code between ... No, the statements are just one after the other and there's no call to any other methods in between. ... you definitely should be able to see data you inserted during a transaction with a SELECT ... I was under that impression too, but didn't think too much of it. Now that I have someone telling me that, I'm going to look into that. Thanks.	[reply]

Replies are listed 'Best First'.

Re^4: DBI and last_insert_id
by cog (Parson) on Jan 29, 2009 at 18:17 UTC

... is there possibly another insert in your real code between ...

No, the statements are just one after the other and there's no call to any other methods in between.

... you definitely should be able to see data you inserted during a transaction with a SELECT ...

I was under that impression too, but didn't think too much of it. Now that I have someone telling me that, I'm going to look into that. Thanks.

[reply]