MySQL Forums
Forum List  »  General

What is happening with mySQL?
Posted by: Er Abbott
Date: June 18, 2005 04:29PM

I'm a teacher at an IT course in my city and I started today a mySQL oriented SQL and Database modeling course.

I'm honestly very disappointed. So disappointed I really don't know what to say, so I'll just state the things all my students and I realized when we were testing our newly created databases:

1) Even using InnoDB tables mySQL didn't took care of referential integrity AT ALL. It was a Bug-Fest:

• Inserting FK data that just don't exist
• Updating to FK data that don't exist either
• Deleting FK data present on other tables

2) NOT NULL? Don't think so...

• Inserting NULL values on NN columns
• Updating to NULL values on NN columns
• My personal favourite: Updating A PRIMARY KEY to a NULL value

Just fantastic...

I've posed as a clown to my students, and today's class was a big joke.

Someone can just explain how mySQL can still be called a "database"? Or how it would be possible - if ever - to restore our trust on this product?

The version we were using was 4.1.10a running under Windows, so it's a pretty recent one.

TIA,

Er Galvao Abbott
Web Developer

Options: ReplyQuote


Subject
Written By
Posted
What is happening with mySQL?
June 18, 2005 04:29PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.