Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

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.


Comment on Re: SQLite and Custom Aggregates
Download Code
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 5.16.3.1 #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?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1031595]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (7)
As of 2015-07-04 17:08 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (60 votes), past polls