Category: "MySQL"

29. May 2003

mySQL 3.23 is making me sick!

  • No referential integrity
  • No transactions (at least not enabled by default so hosting providers would have them)
  • No subqueries in DELETE statements
  • No UNION statement (can you believe it?)
  • and of course no triggers of any kind...

Not that I think mySQL is a bad thing... just that I don't understand how this can be called 3.23! Actually, 0.3.23 would be more appropriate! :>>

I'm so close to making 0.4 (some call it 4.0 :>>) a requirement for b2evolution!

10. May 2003

mySQL DISTINCT FUNCTION(...) bug

Looks like mySQL is not able to to perform the DISTINCT selection in cases like this:

SELECT DISTINCT YEAR(post_date), MONTH(post_date) 
  FROM whatever1 INNER JOIN whatever2 ON field1 = field2
 ORDER BY post_date

This can be worked around, but it seems ridiculous!...

SELECT DISTINCT YEAR(post_date), MONTH(post_date) 
  FROM whatever1 INNER JOIN whatever2 ON field1 = field2
 ORDER BY YEAR(post_date), MONTH(post_date)