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]
-----------------------------------------------------------------------------


Reply via email to