Dan,
Here are some results for you.
AA == Autoconf Amalgamated.
I did not run make install any any of the systems. But localized testing of
sqlite3 seemed to work on all platforms.
My configure flags
./configure --enable-threadsafe --disable-tcl --enable-tempstore
All Platforms: libsqlite3.so.0.0.0 was created instead of libsqlite3.so.0.8.6
On sun, hpux, linux: sqlite3 produced a database and seemed functional.
AIX had issues. See below.
On aix, only
-rwxr-xr-x 1 users users 481108 Jan 09 11:57 libsqlite3.so.0
On linux:
-rw-r--r-- 1 users users 1945550 2008-01-09 11:11 libsqlite3.a -- AA
-rw-r--r-- 1 users users 701744 2007-12-17 12:50 libsqlite3.a -- My build.
Compilation using CFLAGS="-Os" yields a much smaller library.
-rw-r--r-- 1 users users 456606 2008-01-09 11:19 libsqlite3.a -AA
ON hpux: (pa risc, Version 11)
Lots of compilier complaints about:
/var/tmp//ccRC7kfY.s:208564: Warning: .stabs: description field '121c0' too
big, try a different debug format
-rw-rw-rw- 1 users users 1269784 Jan 9 11:27 libsqlite3.a
After Cflags = "-Os"
No stabs warnings...
-rw-rw-rw- 1 users users 489618 Jan 9 11:35 libsqlite3.a
ON Solaris: (sparc, solaris version 8)
-rw-r--r-- 1 users users 1373552 Jan 9 11:49 libsqlite3.a -- AA
After Cflags ="-Os"
-rw-r--r-- 1 users users 393620 Jan 9 11:54 libsqlite3.a
On AIX: version 5.3 , risc processor.
-rw-r--r-- 1 users users 1530663 Jan 09 11:52 libsqlite3.a
after Cflags="-Os"
-rw-r--r-- 1 users sers 493733 Jan 09 11:57 libsqlite3.a
AIX compiler warnings:
gcc -DPACKAGE_NAME=\"sqlite\" -DPACKAGE_TARNAME=\"sqlite\"
-DPACKAGE_VERSION=\"3.5.4\" "-DPACKAGE_STRING=\"sqlite 3.5.4\""
-DPACKAGE_BUGREPORT=\"http://www.sqlite.org\" -DPACKAGE=\"sqlite\"
-DVERSION=\"3.5.4\" -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1 -DHAVE_SYS_STAT_H=1
-DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1 -DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1
-DHAVE_INTTYPES_H=1 -DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DHAVE_DLFCN_H=1
-DHAVE_FDATASYNC=1 -DHAVE_USLEEP=1 -DHAVE_LOCALTIME_R=1 -DHAVE_GMTIME_R=1 -I.
-I. -DSQLITE_THREADSAFE=1 -Os -MT sqlite3.lo -MD -MP -MF .deps/sqlite3.Tpo -c
sqlite3.c -DPIC -o .libs/sqlite3.o
sqlite3.c: In function 'displayP4':
sqlite3.c:35137: warning: case label value is less than minimum value for type
sqlite3.c:35166: warning: case label value is less than minimum value for type
sqlite3.c:35171: warning: case label value is less than minimum value for type
sqlite3.c:35176: warning: case label value is less than minimum value for type
sqlite3.c:35180: warning: case label value is less than minimum value for type
sqlite3.c:35184: warning: case label value is less than minimum value for type
sqlite3.c:35188: warning: case label value is less than minimum value for type
sqlite3.c:35202: warning: case label value is less than minimum value for type
sqlite3.c: In function 'sqlite3VdbeExec':
sqlite3.c:38861: warning: comparison is always false due to limited range of
data type
sqlite3.c:38921: warning: comparison is always false due to limited range of
data type
sqlite3.c:38927: warning: comparison is always false due to limited range of
data type
sqlite3.c:39398: warning: comparison is always false due to limited range of
data type
sqlite3.c:40276: warning: comparison is always false due to limited range of
data type
sqlite3.c:40886: warning: comparison is always false due to limited range of
data type
sqlite3.c:40919: warning: comparison is always false due to limited range of
data type
sqlite3.c:40920: warning: comparison is always true due to limited range of
data type
sqlite3.c:40927: warning: comparison is always true due to limited range of
data type
sqlite3.c: In function 'sqlite3RunVacuum':
sqlite3.c:64923: warning: comparison is always true due to limited range of
data type
./sqlite3 k.db
exec(): 0509-036 Cannot load program ./sqlite3 because of the following errors:
0509-150 Dependent module libsqlite3.a(libsqlite3.so.0) could not be
loaded.
0509-022 Cannot load module libsqlite3.a(libsqlite3.so.0).
0509-026 System error: A file or directory in the path name does not
exist.
Setting up the LD_LIBRARY_PATH resolved the above error.
Running a create table seemed to be successful. But the .schema command cored.
./sqlite3 k.db
SQLite version 3.5.4
Enter ".help" for instructions
sqlite> .schema
Segmentation fault (core dumped)
-bash-3.1$
sqlite> select * from sqlite_master;
table|x|x|2|CREATE TABLE x (id integer)
sqlite>
Also ; and enter did not seem to terminate the sql statment. So only way to
exit was cntrl-c (this may be an issue with my system libraries)
If you want me to check anything else please let me know.
Regards,
Ken
Dan <[EMAIL PROTECTED]> wrote:
Hi,
Experimenting with distributing an autoconf configure script
with the amalgamation package. So that it can do the usual
"./configure && make install" installation.
Prototype here:
http://www.sqlite.org/sqlite-3.5.4-autoconf.tar.gz
Could anybody who has time to try this out post if it fails
to install, fails to detect readline, fails to build shared
library on your AIX system, that sort of thing. Thanks in
advance.
Dan.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------