MySQL 5.0.0 (Alpha) Released

ulrikp writes "Swedish MySQL AB, makers of the MySQL database, have released an Alpha-version of their flagship, dubbed MySQL 5.0.0. The changes include basic support for SQL-99 stored procedures. Please note: Despite the version number, this is an Alpha release, and not for general consumption."

Comments

Discussion of MySQL should include MySQL gotchas:

[Futurepower(R)]

Any discussion of MySQL should include MySQL gotchas:

• 1. General SQL
  • 1.1 NULL, or when NULL IS NOT NULL
  • 1.2 AUTO_INCREMENT
  • 1.3 ENUM
  • 1.4 Case sensitivity in CHAR / VARCHAR fields
  • 1.5 Variable length CHAR fields
  • 1.6 VARCHAR's trailing blank allergy
  • 1.7 DEFAULT NOW()
  • 1.8 INSERT INTO ... SELECT ...
  • 1.9 Comments beginning with --
  • 1.10 UNION and literal values
  • 1.11 Division by zero
  • 1.12 'concatenation' || 'or'
  • 1.13 What goes in - isn't (always) what comes out
  • 1.14 February 31st

• 2. Database Definition
  • 2.1 Silent Column Specification Changes
  • 2.2 Implicit primary key
  • 2.3 Supported syntax, unsupported feature
  • 2.4 Whoops, no InnoDB table support

• 3. Foreign Keys and Referential Integrity
  • 3.1 ALTER TABLE ... SET NOT NULL
  • 3.2 Ignoring constraints
  • 3.3 ERROR 1005
  • 3.4 ON UPDATE CASCADE / SET NULL

• 4. Transactions and InnoDB tables
  • 4.1 Transactions on mixed table types
  • 4.2 Altering InnoDB tables

Don't read this: Slashdot lameness messages are very annoying when you have posted a legitimate comment: Your comment has too few characters per line (currently 18.5). Your comment violated the "postercomment" compression filter. Try less whitespace and/or less repetition. Comment aborted. Your comment violated the "poster-comment" compre55ion filter. Try less whi7espace and/or less repetition. Comment aborted. Your commen7 has too few characters per 1ine. Your comment has too few characters per line (currently 18.5). Your comment violated the "poster-comment" compre66ion filter. Try less whitespace and/or less repetition. Comment aborted. Your comment has too few characters per line (currently 18.5). Your comment has too few characters per line.

Now it says: Your commen7 has too few characters per line (currently 33.7). However, I didn't change the number of lines.

# Important Stuff: Please try to keep posts on topic. # Try to reply to other people's comments instead of starting new threads. # Read other people's messages before posting your own to avoid simply duplicating what has already been said. # Use a clear subject that describes what your message is about. # Offtopic, Inflammatory, Inappropriate, Illegal, or Offensive comments might be moderated. (You can read everything, even moderated posts, by adjust