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
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.