Category Archives: SQL

SQL, such as from MySQL, Postgres, or SQLite

MySQL Cascade Delete Problem

Posted on October 15, 2010 by Walt Stoneburner

MySQL 5.1.51 introduced a nasty little bug that has the potential to really cause some production servers some ill — cascading delete and updates can sometimes fail if you’re dealing with “too much” data at once. Where “too much” is a relatively small amount. You may get bit if you have a one-to-many relationship. Continue reading →

Posted in Bug Report, Disclosure, How To, MySQL, Software, SQL, Workaround | Tagged , , , , , , , , , , , , , , , , , , , , , | 1 Comment

Hibernate Schema Update Problems

Posted on July 5, 2008 by Walt Stoneburner

For a while I’ve been having problems trying to get a SchemaUpdate working with Hibernate. Turns out the problem was me, not Hibernate. Newly created tables had a blank ACL, and I just needed to set them. Continue reading →

Posted in Geek, Hibernate, How To, Programming, Software, SQL | Tagged , , , , , , , | 1 Comment

SQLite Functions

Posted on March 25, 2008 by Walt Stoneburner

I was trying to figure out how to display an integer as a date and time in SQLite3. And it’s documented, and documented very, very well. Problem is, so is the code base, so when I looked for time conversion functions for SQLite, even browsing the Wiki, I kept getting the developer pages, not the SQL core functions. But, I found them. And now I’m documenting where so I can get to them at a later date. Continue reading →

Posted in How To, Programming, Software, SQL | Tagged , , , , , , , | Leave a comment