Bug #105556 for DBD-SQLite: roundtrip bigint fail on Itanium

Mon Jun 29 12:40:34 2015 HMBRAND [...] cpan.org - Ticket created

Subject:

roundtrip bigint fail on Itanium

# Failed test 'Proper roundtrip (insert/select) of value '-2147483646' with DBI::SQL_INTEGER bindtype on 'bigint' column' # at t/rt_76395_int_overflow.t line 106. # Structures begin differing at: # $got->[0][0] = '2147483650' # $expected->[0][0] = '-2147483646' # Failed test 'Proper roundtrip (insert/select) of value '-2147483647' with DBI::SQL_BIGINT bindtype on 'int' column' # at t/rt_76395_int_overflow.t line 106. # Structures begin differing at: # $got->[0][0] = '2147483649' # $expected->[0][0] = '-2147483647' Test Summary Report ------------------- t/rt_76395_int_overflow.t (Wstat: 4608 Tests: 1153 Failed: 18) Failed tests: 907, 913, 919, 925, 931, 937, 943, 949 955, 961, 967, 973, 979, 985, 991, 997 1003, 1009 Non-zero exit status: 18 Files=99, Tests=3519, 26 wallclock secs ( 1.05 usr 0.44 sys + 12.88 cusr 2.10 csys = 16.47 CPU) Result: FAIL Failed 1/99 test programs. 18/3519 subtests failed. $ perl -V Summary of my perl5 (revision 5 version 14 subversion 2) configuration: Platform: osname=hpux, osvers=11.31, archname=IA64.ARCHREV_0-LP64-ld uname='hp-ux x2 b.11.31 u ia64 2977233888 unlimited-user license ' config_args='-Dusedevel -Duselongdouble -Duse64bitall -Uversiononly -Dinc_version_list=none -des' hint=recommended, useposix=true, d_sigaction=define useithreads=undef, usemultiplicity=undef useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef use64bitint=define, use64bitall=define, uselongdouble=define usemymalloc=n, bincompat5005=undef Compiler: cc='cc', ccflags =' -Ae -DPERL_DONT_CREATE_GVSV +Z -z -D_HPUX_SOURCE -Wl,+vnocompatwarnings +DD64 -I/pro/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 ', optimize='+O2 +Onolimit', cppflags='-Aa -D__STDC_EXT__ -DPERL_DONT_CREATE_GVSV +Z -z -D_HPUX_SOURCE -Ae -DPERL_DONT_CREATE_GVSV +Z -z -D_HPUX_SOURCE -Wl,+vnocompatwarnings +DD64 -I/pro/local/include' ccversion='B3910B', gccversion='', gccosandvers='' intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=87654321 d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16 ivtype='long', ivsize=8, nvtype='long double', nvsize=16, Off_t='off_t', lseeksize=8 alignbytes=16, prototype=define Linker and Libraries: ld='/usr/bin/ld', ldflags ='-L/pro/local/lib +DD64 -L/usr/lib/hpux64' libpth=/pro/local/lib /usr/lib/hpux64 /lib /usr/lib /usr/ccs/lib /usr/local/lib libs=-lcl -lpthread -lnsl -lnm -ldb -ldl -ldld -lm -lsec -lc perllibs=-lcl -lpthread -lnsl -lnm -ldl -ldld -lm -lsec -lc libc=/usr/lib/hpux64/libc.so, so=so, useshrplib=false, libperl=libperl.a gnulibc_version='' Dynamic Linking: dlsrc=dl_hpux.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E -Wl,-B,deferred ' cccdlflags='+Z', lddlflags='-b +vnocompatwarnings -L/pro/local/lib -L/usr/lib/hpux64' Characteristics of this binary (from libperl): Compile-time options: PERL_DONT_CREATE_GVSV PERL_MALLOC_WRAP PERL_PRESERVE_IVUV PERL_USE_DEVEL USE_64_BIT_ALL USE_64_BIT_INT USE_LARGE_FILES USE_LONG_DOUBLE USE_PERLIO USE_PERL_ATOF Built under hpux Compiled at Jan 18 2012 16:14:49 @INC: /pro/lib/perl5/site_perl/5.14.2/IA64.ARCHREV_0-LP64-ld /pro/lib/perl5/site_perl/5.14.2 /pro/lib/perl5/5.14.2/IA64.ARCHREV_0-LP64-ld /pro/lib/perl5/5.14.2 . $ perl -MV=DBI,Scalar::Util,Tie::Hash DBI /pro/lib/perl5/site_perl/5.14.2/IA64.ARCHREV_0-LP64-ld/DBI.pm: 1.633 Scalar::Util /pro/lib/perl5/site_perl/5.14.2/IA64.ARCHREV_0-LP64-ld/Scalar/Util.pm: 1.42 Tie::Hash /pro/lib/perl5/5.14.2/Tie/Hash.pm: 1.04

Thu Nov 05 00:24:35 2015 ishigaki [...] cpan.org - Correspondence added

Could you tell me what you get 1) if you insert -2147483646 using DBD::SQLite and select the last inserted row using sqlite3 executable, and 2) if you insert the same number using sqlite3 and select the row using DBD::SQLite? On Tue Jun 30 01:40:34 2015, HMBRAND wrote: Show quoted text

> # Failed test 'Proper roundtrip (insert/select) of value '- > 2147483646' with DBI::SQL_INTEGER bindtype on 'bigint' column' > # at t/rt_76395_int_overflow.t line 106. > # Structures begin differing at: > # $got->[0][0] = '2147483650' > # $expected->[0][0] = '-2147483646' > > # Failed test 'Proper roundtrip (insert/select) of value '- > 2147483647' with DBI::SQL_BIGINT bindtype on 'int' column' > # at t/rt_76395_int_overflow.t line 106. > # Structures begin differing at: > # $got->[0][0] = '2147483649' > # $expected->[0][0] = '-2147483647' > > > Test Summary Report > ------------------- > t/rt_76395_int_overflow.t (Wstat: 4608 > Tests: 1153 Failed: 18) > Failed tests: 907, 913, 919, 925, 931, 937, 943, 949 > 955, 961, 967, 973, 979, 985, 991, 997 > 1003, 1009 > Non-zero exit status: 18 > Files=99, Tests=3519, 26 wallclock secs ( 1.05 usr 0.44 sys + 12.88 > cusr 2.10 csys = 16.47 CPU) > Result: FAIL > Failed 1/99 test programs. 18/3519 subtests failed. > > $ perl -V > Summary of my perl5 (revision 5 version 14 subversion 2) > configuration: > > Platform: > osname=hpux, osvers=11.31, archname=IA64.ARCHREV_0-LP64-ld > uname='hp-ux x2 b.11.31 u ia64 2977233888 unlimited-user license ' > config_args='-Dusedevel -Duselongdouble -Duse64bitall -Uversiononly > -Dinc_version_list=none -des' > hint=recommended, useposix=true, d_sigaction=define > useithreads=undef, usemultiplicity=undef > useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef > use64bitint=define, use64bitall=define, uselongdouble=define > usemymalloc=n, bincompat5005=undef > Compiler: > cc='cc', ccflags =' -Ae -DPERL_DONT_CREATE_GVSV +Z -z -D_HPUX_SOURCE > -Wl,+vnocompatwarnings +DD64 -I/pro/local/include -D_LARGEFILE_SOURCE > -D_FILE_OFFSET_BITS=64 ', > optimize='+O2 +Onolimit', > cppflags='-Aa -D__STDC_EXT__ -DPERL_DONT_CREATE_GVSV +Z -z > -D_HPUX_SOURCE -Ae -DPERL_DONT_CREATE_GVSV +Z -z -D_HPUX_SOURCE > -Wl,+vnocompatwarnings +DD64 -I/pro/local/include' > ccversion='B3910B', gccversion='', gccosandvers='' > intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=87654321 > d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16 > ivtype='long', ivsize=8, nvtype='long double', nvsize=16, > Off_t='off_t', lseeksize=8 > alignbytes=16, prototype=define > Linker and Libraries: > ld='/usr/bin/ld', ldflags ='-L/pro/local/lib +DD64 > -L/usr/lib/hpux64' > libpth=/pro/local/lib /usr/lib/hpux64 /lib /usr/lib /usr/ccs/lib > /usr/local/lib > libs=-lcl -lpthread -lnsl -lnm -ldb -ldl -ldld -lm -lsec -lc > perllibs=-lcl -lpthread -lnsl -lnm -ldl -ldld -lm -lsec -lc > libc=/usr/lib/hpux64/libc.so, so=so, useshrplib=false, > libperl=libperl.a > gnulibc_version='' > Dynamic Linking: > dlsrc=dl_hpux.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E -Wl,- > B,deferred ' > cccdlflags='+Z', lddlflags='-b +vnocompatwarnings -L/pro/local/lib > -L/usr/lib/hpux64' > > > Characteristics of this binary (from libperl): > Compile-time options: PERL_DONT_CREATE_GVSV PERL_MALLOC_WRAP > PERL_PRESERVE_IVUV PERL_USE_DEVEL > USE_64_BIT_ALL > USE_64_BIT_INT USE_LARGE_FILES USE_LONG_DOUBLE > USE_PERLIO USE_PERL_ATOF > Built under hpux > Compiled at Jan 18 2012 16:14:49 > @INC: > /pro/lib/perl5/site_perl/5.14.2/IA64.ARCHREV_0-LP64-ld > /pro/lib/perl5/site_perl/5.14.2 > /pro/lib/perl5/5.14.2/IA64.ARCHREV_0-LP64-ld > /pro/lib/perl5/5.14.2 > . > $ perl -MV=DBI,Scalar::Util,Tie::Hash > DBI > /pro/lib/perl5/site_perl/5.14.2/IA64.ARCHREV_0-LP64-ld/DBI.pm: > 1.633 > Scalar::Util > /pro/lib/perl5/site_perl/5.14.2/IA64.ARCHREV_0-LP64- > ld/Scalar/Util.pm: 1.42 > Tie::Hash > /pro/lib/perl5/5.14.2/Tie/Hash.pm: 1.04

Thu Nov 05 00:24:35 2015 The RT System itself - Status changed from 'new' to 'open'

Mon Jan 11 12:45:30 2016 ishigaki [...] cpan.org - Correspondence added

I hope this is fixed in 1.49_05 with SQLite 3.10.0. On Tue Jun 30 01:40:34 2015, HMBRAND wrote: Show quoted text

> # Failed test 'Proper roundtrip (insert/select) of value '- > 2147483646' with DBI::SQL_INTEGER bindtype on 'bigint' column' > # at t/rt_76395_int_overflow.t line 106. > # Structures begin differing at: > # $got->[0][0] = '2147483650' > # $expected->[0][0] = '-2147483646' > > # Failed test 'Proper roundtrip (insert/select) of value '- > 2147483647' with DBI::SQL_BIGINT bindtype on 'int' column' > # at t/rt_76395_int_overflow.t line 106. > # Structures begin differing at: > # $got->[0][0] = '2147483649' > # $expected->[0][0] = '-2147483647' > > > Test Summary Report > ------------------- > t/rt_76395_int_overflow.t (Wstat: 4608 > Tests: 1153 Failed: 18) > Failed tests: 907, 913, 919, 925, 931, 937, 943, 949 > 955, 961, 967, 973, 979, 985, 991, 997 > 1003, 1009 > Non-zero exit status: 18 > Files=99, Tests=3519, 26 wallclock secs ( 1.05 usr 0.44 sys + 12.88 > cusr 2.10 csys = 16.47 CPU) > Result: FAIL > Failed 1/99 test programs. 18/3519 subtests failed. > > $ perl -V > Summary of my perl5 (revision 5 version 14 subversion 2) > configuration: > > Platform: > osname=hpux, osvers=11.31, archname=IA64.ARCHREV_0-LP64-ld > uname='hp-ux x2 b.11.31 u ia64 2977233888 unlimited-user license ' > config_args='-Dusedevel -Duselongdouble -Duse64bitall -Uversiononly > -Dinc_version_list=none -des' > hint=recommended, useposix=true, d_sigaction=define > useithreads=undef, usemultiplicity=undef > useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef > use64bitint=define, use64bitall=define, uselongdouble=define > usemymalloc=n, bincompat5005=undef > Compiler: > cc='cc', ccflags =' -Ae -DPERL_DONT_CREATE_GVSV +Z -z -D_HPUX_SOURCE > -Wl,+vnocompatwarnings +DD64 -I/pro/local/include -D_LARGEFILE_SOURCE > -D_FILE_OFFSET_BITS=64 ', > optimize='+O2 +Onolimit', > cppflags='-Aa -D__STDC_EXT__ -DPERL_DONT_CREATE_GVSV +Z -z > -D_HPUX_SOURCE -Ae -DPERL_DONT_CREATE_GVSV +Z -z -D_HPUX_SOURCE > -Wl,+vnocompatwarnings +DD64 -I/pro/local/include' > ccversion='B3910B', gccversion='', gccosandvers='' > intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=87654321 > d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16 > ivtype='long', ivsize=8, nvtype='long double', nvsize=16, > Off_t='off_t', lseeksize=8 > alignbytes=16, prototype=define > Linker and Libraries: > ld='/usr/bin/ld', ldflags ='-L/pro/local/lib +DD64 > -L/usr/lib/hpux64' > libpth=/pro/local/lib /usr/lib/hpux64 /lib /usr/lib /usr/ccs/lib > /usr/local/lib > libs=-lcl -lpthread -lnsl -lnm -ldb -ldl -ldld -lm -lsec -lc > perllibs=-lcl -lpthread -lnsl -lnm -ldl -ldld -lm -lsec -lc > libc=/usr/lib/hpux64/libc.so, so=so, useshrplib=false, > libperl=libperl.a > gnulibc_version='' > Dynamic Linking: > dlsrc=dl_hpux.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E -Wl,- > B,deferred ' > cccdlflags='+Z', lddlflags='-b +vnocompatwarnings -L/pro/local/lib > -L/usr/lib/hpux64' > > > Characteristics of this binary (from libperl): > Compile-time options: PERL_DONT_CREATE_GVSV PERL_MALLOC_WRAP > PERL_PRESERVE_IVUV PERL_USE_DEVEL > USE_64_BIT_ALL > USE_64_BIT_INT USE_LARGE_FILES USE_LONG_DOUBLE > USE_PERLIO USE_PERL_ATOF > Built under hpux > Compiled at Jan 18 2012 16:14:49 > @INC: > /pro/lib/perl5/site_perl/5.14.2/IA64.ARCHREV_0-LP64-ld > /pro/lib/perl5/site_perl/5.14.2 > /pro/lib/perl5/5.14.2/IA64.ARCHREV_0-LP64-ld > /pro/lib/perl5/5.14.2 > . > $ perl -MV=DBI,Scalar::Util,Tie::Hash > DBI > /pro/lib/perl5/site_perl/5.14.2/IA64.ARCHREV_0-LP64-ld/DBI.pm: > 1.633 > Scalar::Util > /pro/lib/perl5/site_perl/5.14.2/IA64.ARCHREV_0-LP64- > ld/Scalar/Util.pm: 1.42 > Tie::Hash > /pro/lib/perl5/5.14.2/Tie/Hash.pm: 1.04

Mon Jan 11 12:45:36 2016 ishigaki [...] cpan.org - Status changed from 'open' to 'patched'

Mon Jan 11 13:03:37 2016 HMBRAND [...] cpan.org - Correspondence added

On Mon Jan 11 12:45:30 2016, ISHIGAKI wrote: Show quoted text

> I hope this is fixed in 1.49_05 with SQLite 3.10.0.

HP-UX 11.31/64 U rx2660/64 Itanium 2 9100/1710(2) ia64 4075 Mb This is perl 5, version 14, subversion 2 (v5.14.2) built for IA64.ARCHREV_0-LP64-ld All tests successful. Files=103, Tests=3561, 27 wallclock secs ( 1.09 usr 0.43 sys + 13.59 cusr 2.22 csys = 17.33 CPU) Result: PASS HP-UX 11.23/64 U rx1620/64 Itanium 2/1600(2) ia64 2037 Mb This is perl 5, version 14, subversion 2 (v5.14.2) built for IA64.ARCHREV_0-LP64-ld All tests successful. Files=103, Tests=3561, 37 wallclock secs ( 1.60 usr 0.45 sys + 19.40 cusr 3.14 csys = 24.59 CPU) Result: PASS

Wed Feb 10 10:05:51 2016 ishigaki [...] cpan.org - Correspondence added

Closed as 1.50 was shipped. Thanks.

Wed Feb 10 10:05:59 2016 ishigaki [...] cpan.org - Status changed from 'patched' to 'resolved'