Re: AW: bind parameter guessing corrupts results

On Tue, Feb 28, 2012 at 10:20:34PM +0100, "Selke, Gisbert W." <Gisbert.Se=
[email protected]> wrote:
> > -----Urspr=FCngliche Nachricht-----
> > Von: Marc Lehmann [mailto:[email protected]]
> > Gesendet: Donnerstag, 23. Februar 2012 04:28
> > It would be great if this were actually implemented, but the current =
code
> > is data-dependent and quotes some numbers but not others.
> Same, btw, for Gisle Aas's data::Dump -- it quotes some numbers but not=
 others (unless you use quote(), in which case it consistently quotes all=
 numbers).
> That's the price you pay for dwimmyness: sometimes it bites you. Especi=
ally when you least expect it.

Well, the solution I outlined has the advantage of being dwim but at
the same time doesn't suffer from arbitraryness - that is, there is a
consistent way of marking numbers as numbers, even with perl.

So your argument is wrong - the problem is not dwim here.

The problem is the arbitraryness - even if perl thinks something is a
number and doesn't even have alternatives, dbd::mysql would still quote i=
t
if it becomes too big, and this behaviour isn't even clearly documented.

--=20
                The choice of a       Deliantra, the free code+content MO=
RPG
      -----=3D=3D-     _GNU_              http://www.deliantra.net
      ----=3D=3D-- _       generation
      ---=3D=3D---(_)__  __ ____  __      Marc Lehmann
      --=3D=3D---/ / _ \/ // /\ \/ /      [email protected]
      -=3D=3D=3D=3D=3D/_/_//_/\_,_/ /_/\_\

--=20
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/perl