On Tue, 8 Jun 2010 12:42:19 +0100, Tim Bunce <tim.bu...@pobox.com> wrote:
> On Fri, Jun 04, 2010 at 04:12:18AM -0700, rehs...@cvs.perl.org 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/
