[Asterisk-Dev] Re: PostgreSQL support in Asterisk 1.2?

[Bob Goddard]

On Tuesday 09 Aug 2005 17:39, Brian West wrote:
> On Aug 9, 2005, at 11:34 AM, Bob Goddard wrote:
> >> What you have done here is proven exactly why you shouldn't use
> >> MySQL.
> >>
> >> The 2nd and 3rd queries should have FAILED with an error, NOT
> >> inserted
> >> mangled data. The problem you now have is that you don't know if
> >> the zeros
> >> you have in your table were inserted by you, or plucked our of the
> >> air by
> >> MySQL!! You have now compromised the integrity your entire table!!!
> >
> > The issue was that it would insert crap data without errors or
> > warnings.
> > What was inserted, although it may not be what you want, is valid.
> > The other point is that it was flagged as a warning.
>
> It still should have failed and NOT inserted the information.

Yes, it should have failed, but the op said it did not even
produce a warning. Nor did it insert characters into an int field.