Re^3: Perl DBI: problems inserting data to a table

From the DBI POD for "execute":

"For a non-SELECT statement, execute returns the number of rows affected, if known. If no rows were affected, then execute returns "0E0", which Perl will treat as 0 but will regard as true. Note that it is not an error for no rows to be affected by a statement. If the number of rows affected is not known, then execute returns -1."

A simple text search (ctrl-f) will find it.

It helps to remember that the primary goal is to drain the swamp even when you are hip-deep in alligators.

Comment on Re^3: Perl DBI: problems inserting data to a table

Replies are listed 'Best First'.
Re^4: Perl DBI: problems inserting data to a table by mje (Curate) on Nov 21, 2013 at 15:12 UTC
A simple text search does in deed find what you quoted. I never argued that. The quote however, does not say that when execute returns 0E0 it is an error and that is why I took your comment "That is, DBI can return a value of 0E0 when an error occurs" to be wrong. DBI execute returns undef when an error occurs, 0E0 would mean the execute completed successfully but inserted/updated/deleted no rows.	[reply]
Re^4: Perl DBI: problems inserting data to a table by runrig (Abbot) on Nov 21, 2013 at 17:03 UTC
For a simple insert statement, execute() should never return '0E0'. It will return undef if there's an error, or '1' if a row was inserted (though I would use RaiseError in which case it would die on error). For a 'insert into ... select ... from' type insert statement, it might return '0E0' if zero rows were selected/inserted (which is not an error), or more if rows were inserted, or (again) undef if there was an error.	[reply]
Re^5: Perl DBI: problems inserting data to a table by boftx (Deacon) on Nov 21, 2013 at 19:43 UTC
The OP indicates that RaiseError is being set. The only thing I could think of was that a field width constraint was being violated without throwing the exception. At this point, I think I would want to force an insert error and see if RaiseError does in fact fire. It helps to remember that the primary goal is to drain the swamp even when you are hip-deep in alligators.	[reply]