Re: DBD::File insert/update (was: [svn:dbi] r14096 - dbi/trunk/lib/DBD)

On Tue, 8 Jun 2010 12:42:19 +0100, Tim Bunce <[email protected]>
wrote:

> On Fri, Jun 04, 2010 at 04:12:18AM -0700, [email protected] wrote:
> >  
> > +This modules uses hash interfaces of two column file databases. While
> > +none of supported SQL engines have a support for indeces, following
> 
> s/indeces/indices/

Already fixed in 14115

> > +statements really do the same (even if they mean something completely
> > +different):
> > +
> > +  $sth->do( "insert into foo values (1, 'hello')" );
> > +
> > +  # this statement does ...
> > +  $sth->do( "update foo set v='world' where k=1" );
> > +  # ... the same as this statement
> > +  $sth->do( "insert into foo values (1, 'world')" );
> 
> Is this really necessary? Can't we get duplicate inserts and
> updates of non-existent rows to behave in a sane manner?
> 
> The hash/DBM style databases should be modeled as two column tables
> with a unique constraint on the key column.

-- 
H.Merijn Brand  http://tux.nl      Perl Monger  http://amsterdam.pm.org/
using 5.00307 through 5.12 and porting perl5.13.x on HP-UX 10.20, 11.00,
11.11, 11.23, and 11.31, OpenSuSE 10.3, 11.0, and 11.1, AIX 5.2 and 5.3.
http://mirrors.develooper.com/hpux/           http://www.test-smoke.org/
http://qa.perl.org      http://www.goldmark.org/jeff/stupid-disclaimers/