in reply to DBI limitation???

The table being created is approximately 2.2B records.

That's close to a known number. I'll guess you are on a 32-bit perl? Returning 0 instead of an int overflow seems like a sensible compromise. You should test for undef on error, not false.

Replies are listed 'Best First'.
Re^2: DBI limitation?
by kyledba2013 (Initiate) on Apr 05, 2016 at 20:09 UTC
    yes, i think this is how we will have to go. Is there a way to avoid the integer overflow. (please don't say reduce the number of rows created :) ) possibly changing the dataype to a floating number instead of a integer?
[reply]

In Section Seekers of Perl Wisdom