Jump to Navigation

Recently created

MySQL limitations

I am writing some queries and stored procedure on MySQL these days. Coming from an Oracle background that can be somewhat frustrating at times. Some query constructs are not available, but also the procedural language is quite limited compared to PL/SQL.

I must say, most limitations are well documented. That means that at least you have some closure when things do not work out. Examples I encountered are:

Trying to contribute

One of the nice things about Open Source programs is that you can squash the bugs that bite you. Of course, not everyone is able to do that, but still. And though there is no obligation to do so, it is nice if you share your patches with the rest of the world.

Sometimes, though, the sharing part just does not work out. I recently encountered two such cases, where I tried to do the right thing but my patches will probably never be used.

Things I did not know about MySQL

Did you know that MySQL can join at most 61 tables in one query?

Did you know that table data is by default stored as latin1 with theĀ  latin1_swedish_ci collation?

Things I did not know but should have - as I encountered both issues the same day.

Subscribe to Recently created


by Dr. Radut