On Fri, 19 Sep 2003, Joshua D. Drake wrote:
> Hello, > > Sorry guys I made the unbelievable mistake of talking on the #mysql > channel today. Can you believe that they > actually feel that the fact that you can insert data outside the > boundaries of the data type (int for example) and > mySQL won't throw an exception is still valid ACID compliance. > > There argument is that the application (user) should not have tried to > insert bad data. I was completely blown > away. The C in ACID explictly states that internal (data type boundaries > anyone) AND user defined constraints > can not be violated. > > I am just flabbergasted. I am going to come back to my safe PostgreSQL > world. Boy, I'm flabbergasted that you actually believed them ... tsk tsk ... ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings