|List:||General Discussion||« Previous MessageNext Message »|
|From:||Jay Blanchard||Date:||June 9 2005 2:30pm|
|Subject:||RE: Seriously.. When are we going to get subqueries?!|
|View as plain text|
[snip] Well, Oracle, DB2, SQL Server, Access, PostgreSQL, and Sybase SQL Anywhere all do this. I looked at my copy of "A Guide to The SQL Standard" by Chris Date. It pretty plainly states that DEFAULT allows niladic (no argument) functions. Its about time MySQL stopped complaining about things being hacks, and started getting its compatibility and functionality equal to other databases. [/snip] This is the great thing about products, you can implement the features that you want along the time line that you want. I have never seen anyone from MySQL complain about anything being a hack. We have provided several solutions for your problem. [snip] I guess the real issue is portability and compatibility. If any SQL application uses more than the absolute bare minimum features, it will not port to mysql. [/snip] IIRC MySQL was built with a nod towards speed and efficiency, acknowledging that several features would have to be left out. The development team has steadily added features while keeping an eye towards the original intent. Many database applications port very nicely to MySQL while others do not. As George so eloquently put it earlier, "horses for courses". If you are not pleased with MySQL you have some options. 1. Join the development work. B. Find a product more suitable to your needs.