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 $ 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/ -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: application/pgp-signature Size: 490 bytes Desc: OpenPGP digital signature URL: <http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20151105/8debea4e/attachment.pgp>
