Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister

Re: Overflow of $DBI::rows

by mje (Curate)
on Dec 13, 2012 at 09:29 UTC ( #1008640=note: print w/replies, xml ) Need Help??

in reply to Overflow of $DBI::rows

You will find some changes in DBD-ODBC 1.42_1 which may be of interest to you. The interface between DBI and DBDs needs to change in order to support larger values of rows affected (it is an int right now). As this change would require all DBDs to be changed this is not going to happen right now. Until then I have made the following changes:

  • Add an odbc_rows method which returns the same as execute would except there is no overflowing.
  • changed execute so if it spots overflowing it will warn (if DBI Warn is set which it is by default) and then it returns INT_MAX so you can check for that.

I'd appreciate any feedback on this if you have a chance to try it out as you appear to be the first person to insert/update such a huge number of rows and notice the problem.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1008640]
Discipulus ignores..
Discipulus IE just maps to id est in my mind .. ;=)
[Corion]: marto: I believe nowadays, at least window.opener should not be set anymore (except maybe within the same domain)
[Corion]: But I wouldn't really know as I don't use iexplore much (except at $work) and mostly surf with JS disabled (except at $work :) )

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (7)
As of 2018-03-21 11:45 GMT
Find Nodes?
    Voting Booth?
    When I think of a mole I think of:

    Results (267 votes). Check out past polls.