[Asterisk-Dev] Re: Asterisk-Dev Digest, Vol 13, Issue 31

Tue Aug 9 13:45:14 MST 2005

Would I get a mac question answered here with regard
to asterisk?
I know there's a mac list (astmasters.net) available.

thnxx

--- asterisk-dev-request at lists.digium.com wrote:

> Send Asterisk-Dev mailing list submissions to
> 	asterisk-dev at lists.digium.com
> 
> To subscribe or unsubscribe via the World Wide Web,
> visit
> 
>
http://lists.digium.com/mailman/listinfo/asterisk-dev
> or, via email, send a message with subject or body
> 'help' to
> 	asterisk-dev-request at lists.digium.com
> 
> You can reach the person managing the list at
> 	asterisk-dev-owner at lists.digium.com
> 
> When replying, please edit your Subject line so it
> is more specific
> than "Re: Contents of Asterisk-Dev digest..."
> 
> 
> Today's Topics:
> 
>    1. Re: Re: PostgreSQL support in Asterisk 1.2?
> (Bob Goddard)
>    2. Re: PostgreSQL support in Asterisk 1.2? (Peter
> Nixon)
>    3. Re: Re: PostgreSQL support in Asterisk 1.2?
> (Brian West)
>    4. Re: PostgreSQL support in Asterisk 1.2? (Peter
> Nixon)
>    5. Re: Re: PostgreSQL support in Asterisk 1.2?
> (Andrew Kohlsmith)
>    6. Re: Re: PostgreSQL support in Asterisk 1.2?
> (Daniel Pocock)
>    7. Re: Re: PostgreSQL support in Asterisk 1.2?
> (Brian West)
> 
> 
>
----------------------------------------------------------------------
> 
> Message: 1
> Date: Tue, 9 Aug 2005 18:09:24 +0100
> From: Bob Goddard <asterisk at bgcomp.co.uk>
> Subject: Re: [Asterisk-Dev] Re: PostgreSQL support
> in Asterisk 1.2?
> To: Asterisk Developers Mailing List
> <asterisk-dev at lists.digium.com>
> Message-ID:
> <200508091809.24532.asterisk at bgcomp.co.uk>
> Content-Type: text/plain;  charset="utf-8"
> 
> 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.
> 
> 
> ------------------------------
> 
> Message: 2
> Date: Tue, 9 Aug 2005 20:33:45 +0300
> From: Peter Nixon <listuser at peternixon.net>
> Subject: [Asterisk-Dev] Re: PostgreSQL support in
> Asterisk 1.2?
> To: Asterisk Developers Mailing List
> <asterisk-dev at lists.digium.com>
> Message-ID:
> <200508092033.46300.listuser at peternixon.net>
> Content-Type: text/plain;  charset="iso-8859-1"
> 
> On Tuesday 09 August 2005 19:34, Bob Goddard wrote:
> > On Tuesday 09 Aug 2005 17:22, Peter Nixon wrote:
> > > On Wednesday 03 August 2005 22:34, Bob Goddard
> wrote:
> > > > On Wednesday 03 Aug 2005 18:58, Andrew
> Kohlsmith wrote:
> > > > > On Wednesday 03 August 2005 10:00, Matthew
> Simpson wrote:
> > > > > > What a crock of crap.  I've been running
> mysql for years and
> > > > > > never once had "mangled data".
> > > > >
> > > > > Only because you're taking the DB's job of
> data consistency in
> > > > > your own apps. Any DB that'll let me insert
> text values into
> > > > > numeric fields, accept totally bogus dates
> or even chop text
> > > > > fields without so much as throwing a WARNING
> is no good.  Period.
> > > >
> > > > I think you are basing your argument on old
> code.
> > > > For both inserts with the bogus data, I get
> warning
> > > > and "blank" data.
> > > >
> > > >
> > > > eth5:# mysql -u root -p
> > > > Enter password:
> > > > Welcome to the MySQL monitor.  Commands end
> with ; or \g.
> > > > Your MySQL connection id is 17923 to server
> version: 4.1.10a-Max
> > > >
> > > > Type 'help;' or '\h' for help. Type '\c' to
> clear the buffer.
> > > >
> > > > mysql> create database crap;
> > > > Query OK, 1 row affected (0.06 sec)
> > > >
> > > > mysql> use crap;
> > > > Database changed
> > > > mysql> create table crap (crap1 int(10), crap2
> date);
> > > > Query OK, 0 rows affected (0.13 sec)
> > > >
> > > > mysql> insert into crap values (22,
> "2005-11-11");
> > > > Query OK, 1 row affected (0.00 sec)
> > > >
> > > > mysql> insert into crap values ("crap",
> "crap");
> > > > Query OK, 1 row affected, 2 warnings (0.00
> sec)
> > > >
> > > > mysql> insert into crap values ("crap",
> "2005-43-43");
> > > > Query OK, 1 row affected, 2 warnings (0.00
> sec)
> > > >
> > > > mysql> select * from crap;
> > > > +-------+------------+
> > > >
> > > > | crap1 | crap2      |
> > > >
> > > > +-------+------------+
> > > >
> > > > |    22 | 2005-11-11 |
> > > > |     0 | 0000-00-00 |
> > > > |     0 | 0000-00-00 |
> > > >
> > > > +-------+------------+
> > > > 3 rows in set (0.01 sec)
> > >
> > > 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.
> 
> No. It is NOT valid. It is WRONG. The garbage
> inserted fits the schema, but 
> it is still garbage data!!!
> 
> -- 
> 
> Peter Nixon
> http://www.peternixon.net/
> 
=== message truncated ===

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 