SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Need help on Partitioned Views
 New Topic  Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

Kristen
Test

United Kingdom
22403 Posts

Posted - 01/28/2010 :  04:33:39  Show Profile  Reply with Quote
ALLOW_INVALID_DATES

good grief!!


0000-00-00? Y2K here we come again ...
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 01/28/2010 :  06:55:42  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
This is the database engine that, at least at one point ignored foreign key and unique constraints and silently set data that failed data type conversion to null.

--
Gail Shaw
SQL Server MVP

Edited by - GilaMonster on 01/28/2010 06:58:45
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 01/28/2010 :  07:51:59  Show Profile  Reply with Quote
Grave marketing error to not fix those things early, IMHO. I believe they have been fixed for some years, but I expect in the eyes of IT Managers MySQL is still seen as being unreliable.

And in the eyes of most other people MySQL is "free" - which isn't true either (unless the application is under the same "free to use" licence as MySQL IIRC)
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 01/28/2010 :  08:22:32  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
I believe they were intended as features, not bugs. At least, these limitations were fully documented and justified.

Even now, only one of the MySQL database engines (not the default one) supports foreign keys and unique constraints at all (and transactions, locks other than table-level and a few other things). Even when using that engine, it's possible to set session-level settings to disable unique and foreign key checks

Interestingly enough, the MySQL DB engine that supports foreign keys, unique constraints and transactions does not support clustering, full text indexing or geo-spatial indexing.

--
Gail Shaw
SQL Server MVP

Edited by - GilaMonster on 01/28/2010 08:28:23
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000