skip to main | skip to sidebar

Deva's MySQL / Linux blog

Ramblings about MySQL, Linux, scripting languages like Perl, PHP, Bash, Python... What ever I run into at work or play :)

19 February 2009

Bug in savepoints getting fixed

It looks like this bug finally got some attention, and a patch is queued.
http://bugs.mysql.com/bug.php?id=38187

In brief, the bug happens when you alternate and reuse names of savepoints. Quoting from the bug page:
InnoDB treats the savepoints like a stack, e.g.,    SAVEPOINT a;   SAVEPOINT b;   SAVEPOINT c;   SAVEPOINT b; <- Will delete c too
at 12:16 PM Labels: bug, MySQL
0 comments
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)
My Photo
Devananda vdv
View my complete profile

Links

  • MyCAT project
  • Planet MySQL
  • MySQL Reference Manual

Subscribe To

Posts
Atom
Posts
All Comments
Atom
All Comments

Blog Archive

  • ▼  2009 (4)
    • ►  April (1)
      • check your my.cnf with "mysqld --help --verbose"
    • ▼  February (1)
      • Bug in savepoints getting fixed
    • ►  January (2)
      • Tokutek challenge vs. 128GB RAM
      • Twitter
  • ►  2008 (5)
    • ►  July (5)
      • SAVEPOINTs just got more problematic
      • Error 153 when creating savepoints
      • Mycat beta 0.3.0 released
      • How to replicate LOAD DATA from 4.1 to 5.1
      • Performance of JOIN using columns of different num...
  • ►  2006 (1)
    • ►  January (1)
      • Think I found a bug ....
  • ►  2005 (8)
    • ►  November (2)
      • Added 'rcall' to mycat project
      • Replication Monitor finished!
    • ►  October (2)
      • Replication Monitor preview posted
      • Open Source
    • ►  August (4)
      • Python Challenge
      • Distributed database, a few tables at a time
      • Previously, MySQL Cluster
      • Initializing...