Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer

Re: SQLite and Custom Aggregates

by kennethk (Abbot)
on May 01, 2013 at 15:58 UTC ( #1031595=note: print w/replies, xml ) Need Help??

in reply to SQLite and Custom Aggregates

For the posted script, I get the output
$VAR1 = [ [ '0.0149999999994179' ], [ '0' ] ];
ActiveState v5.14.3 on Win7, DBD::SQLite 1.37. Also passed with ActiveState v5.16.2, DBD::SQLite 1.37. Confirmed failure for Linux, v5.10.1 with 1.27 and v5.14.2 with 1.35.

Maybe this is a bug that got fixed in the DBD between 1.35 and 1.37?

#11929 First ask yourself `How would I do this without a computer?' Then have the computer do it the same way.

Replies are listed 'Best First'.
Re^2: SQLite and Custom Aggregates
by Anonymous Monk on May 01, 2013 at 16:21 UTC
    I see that I have DBI 1.623 and DBD::SQLite 1.37 on my Strawberry perl version -- which did reproduce the failure.
    Here's the version string for Strawberry perl (I just downloaded the most obvious one from the website today):
    C:\>perl -V Summary of my perl5 (revision 5 version 16 subversion 3) configuration +: Platform: osname=MSWin32, osvers=4.0, archname=MSWin32-x86-multi-thread uname='Win32 strawberry-perl #1 Tue Mar 12 13:55:20 2013 +i386' config_args='undef' hint=recommended, useposix=true, d_sigaction=undef useithreads=define, usemultiplicity=define useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=und +ef use64bitint=undef, use64bitall=undef, uselongdouble=undef usemymalloc=n, bincompat5005=undef Compiler: cc='gcc', ccflags =' -s -O2 -DWIN32 -DPERL_TEXTMODE_SCRIPTS -DPER +L_IMPLICIT _CONTEXT -DPERL_IMPLICIT_SYS -fno-strict-aliasing -mms-bitfields', optimize='-s -O2', cppflags='-DWIN32' ccversion='', gccversion='4.6.3', gccosandvers='' intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234 d_longlong=undef, longlongsize=8, d_longdbl=define, longdblsize=12 ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='long lo +ng', lseek size=8 alignbytes=8, prototype=define Linker and Libraries: ld='g++', ldflags ='-s -L"C:\strawberry\perl\lib\CORE" -L"C:\straw +berry\c\li b"' libpth=C:\strawberry\c\lib C:\strawberry\c\i686-w64-mingw32\lib libs=-lmoldname -lkernel32 -luser32 -lgdi32 -lwinspool -lcomdlg32 +-ladvapi32 -lshell32 -lole32 -loleaut32 -lnetapi32 -luuid -lws2_32 -lmpr -lwinmm + -lversion -lodbc32 -lodbccp32 -lcomctl32 perllibs=-lmoldname -lkernel32 -luser32 -lgdi32 -lwinspool -lcomdl +g32 -ladva pi32 -lshell32 -lole32 -loleaut32 -lnetapi32 -luuid -lws2_32 -lmpr -lw +inmm -lver sion -lodbc32 -lodbccp32 -lcomctl32 libc=, so=dll, useshrplib=true, libperl=libperl516.a gnulibc_version='' Dynamic Linking: dlsrc=dl_win32.xs, dlext=dll, d_dlsymun=undef, ccdlflags=' ' cccdlflags=' ', lddlflags='-mdll -s -L"C:\strawberry\perl\lib\CORE +" -L"C:\st rawberry\c\lib"' Characteristics of this binary (from libperl): Compile-time options: HAS_TIMES HAVE_INTERP_INTERN MULTIPLICITY PERLIO_LAYERS PERL_DONT_CREATE_GVSV PERL_IMPLICIT_CONTEXT PERL_IMPLICIT_SYS PERL_MALLOC_WRAP PERL_PRESERVE_IVUV PL_OP_SLAB +_ALLOC USE_ITHREADS USE_LARGE_FILES USE_LOCALE USE_LOCALE_COLLATE USE_LOCALE_CTYPE USE_LOCALE_NUMERIC USE_PERLIO USE_PERL_ATOF Built under MSWin32 Compiled at Mar 12 2013 14:01:07 @INC: C:/strawberry/perl/site/lib C:/strawberry/perl/vendor/lib C:/strawberry/perl/lib .
      Okay, so the next obvious branches are ActiveState vs. Strawberry/Linux and Win 7 vs. Win XP/Linux. Any takers?

      #11929 First ask yourself `How would I do this without a computer?' Then have the computer do it the same way.

        I got it to work (no failure) with ActivePerl under XP.
        I see that in ActivePerl longdblsize=8 (but on my linux box and strawberry perl I have longdbsize=16 and 12, respectively.) I am wondering about this because of the "bus error" result.
Re^2: SQLite and Custom Aggregates
by Anonymous Monk on May 01, 2013 at 16:23 UTC
    Confirmed SQLite 1.37 on the linux box as well.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1031595]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (7)
As of 2017-10-24 06:40 GMT
Find Nodes?
    Voting Booth?
    My fridge is mostly full of:

    Results (286 votes). Check out past polls.