Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#320 executemany loops for inserts with upper-case VALUES keyword

MySQLdb-1.2
closed
Andy Dustman
MySQLdb (285)
5
2012-09-19
2012-03-25
Anonymous
No

Version 1.2.3 the regex in executemany is case-sensitive so it matches insert ... values but not INSERT ... VALUES which causes the code to execute individual queries with a loop instead of issuing a bulk insert.

I don't know if this has been fixed in a never version of if it's been posted before, but just wanted to make sure it didn't go unnoticed.

Discussion


  • Anonymous
    2012-04-11

    Thanks for pointing this out. Spend the day trying to figure out why inserts spiked like crazy.

    This is really bad.

     
  • Andy Dustman
    Andy Dustman
    2012-09-07

    Fixed in rev 658, to be in version 1.2.4