On 11/5/15, H.Merijn Brand <h.m.brand at xs4all.nl> wrote: > I am not a list member, so please Cc me if you reply > > I was asked to post the problem here by charsbar, after I noted that > DBD::SQLite started to fail on HP-UX 64bit IPF (Itanium 64bit) > > charsbar asked me to build sqlite3 from source and retry the fail with > plain SQL. I built from scratch using HP C-ANSI-C in 64bitall mode > > -Ae -AC99 -O2 +Onolimit +Z -z +DD64
Can you get me temporary ssh access to the HP-UX 64bit IPF machine so that I can debug the problem? > > $ wget http://sqlite.org/2015/sqlite-autoconf-3090200.tar.gz > $ tgz x sqlite-autoconf-3090200.tbz > $ cd sqlite-autoconf-3090200/ > $ configure --prefix=/pro/local > $ make > $ ./sqlite3 > SQLite version 3.9.2 2015-11-02 18:31:45 > Enter ".help" for usage hints. > Connected to a transient in-memory database. > Use ".open FILENAME" to reopen on a persistent database. > sqlite> create table foo (c_foo integer, foo varchar (4)); > sqlite> insert into foo values (-2147483646, "foo"); > sqlite> select * from foo; > 2147483650|foo > sqlite> > > > --- Some of the compilation warnings ? (the 51880 one might be important) > "sqlite3.c", line 9564: warning #2047-D: incompatible redefinition of macro > "MIN" (declared at line 442 of "/usr/include/sys/param.h") > #define MIN(A,B) ((A)<(B)?(A):(B)) > ^ > > "sqlite3.c", line 9565: warning #2047-D: incompatible redefinition of macro > "MAX" (declared at line 443 of "/usr/include/sys/param.h") > #define MAX(A,B) ((A)>(B)?(A):(B)) > ^ > > "sqlite3.c", line 25014: warning #4069-D: floating point overflow exception > result = 1e308*1e308*s; /* Infinity */ > ^ > > "sqlite3.c", line 51880: warning #4232-D: conversion from "volatile ht_slot > *" > to a more strictly aligned type "u32 *" may cause misaligned > access > nEntry = (int)((u32*)aHash - (u32*)aPgno); > ^ > > "sqlite3.c", line 80887: warning #2191-D: type qualifier is meaningless on > cast type > const u8 * const p1 = (const u8 * const)pKey1; > ^ > > "sqlite3.c", line 80888: warning #2191-D: type qualifier is meaningless on > cast type > const u8 * const p2 = (const u8 * const)pKey2; > ^ > > "sqlite3.c", line 80928: warning #2191-D: type qualifier is meaningless on > cast type > const u8 * const p1 = (const u8 * const)pKey1; > ^ > > "sqlite3.c", line 80929: warning #2191-D: type qualifier is meaningless on > cast type > const u8 * const p2 = (const u8 * const)pKey2; > ^ > > "sqlite3.c", line 156586: warning #4232-D: conversion from "int *" to a > more > strictly aligned type "RtreeDValue *" may cause misaligned access > aDistance = (RtreeDValue *)&aSpare[n]; > ^ > > > > -- > H.Merijn Brand http://tux.nl Perl Monger http://amsterdam.pm.org/ > using perl5.00307 .. 5.23 porting perl5 on HP-UX, AIX, and openSUSE > http://mirrors.develooper.com/hpux/ http://www.test-smoke.org/ > http://qa.perl.org http://www.goldmark.org/jeff/stupid-disclaimers/ > -- D. Richard Hipp drh at sqlite.org
