for completeness, here are the step-by-step details to reproduce the
error at hand,


cd /Users/snowcrash/projects
rm -rf sqlite-3.3.8*
wget http://www.sqlite.org/sqlite-3.3.8.tar.gz
gnutar zxvf sqlite-3.3.8.tar.gz
cd sqlite-3.3.8

unsetenv CFLAGS CPPFLAGS CXX CXXFLAGS LDFLAGS LDDLFLAGS LD_PREBIND
EXTRA_LDFLAGS EXTRA_LIBS LC_ALL LANG LINGUAS
setenv LDFLAGS "-L/usr/local/lib -lreadline -L/usr/local/ncurses/lib -lncurses"
setenv CPPFLAGS "-no-cpp-precomp -I/usr/local/include/readline
-I/usr/local/ncurses/include"

aclocal
glibtoolize -f -c
autoconf -f

mkdir build
cd build

../configure --prefix=/usr/local/sqlite --enable-tcl --enable-shared
--enable-static --enable-debug

chown -R snowcrash /Users/snowcrash/projects/sqlite-3.3.8
make
make install

cp /Users/snowcrash/projects/sqlite-3.3.8/build/.libs/*tcl*.dylib
/usr/local/sqlite/lib/
cp /Users/snowcrash/projects/sqlite-3.3.8/build/.libs/*tcl*.la
/usr/local/sqlite/lib/
cp /Users/snowcrash/projects/sqlite-3.3.8/build/.libs/*tcl*.a
/usr/local/sqlite/lib/
cp /usr/local/sqlite/lib/pkgconfig/* /usr/local/lib/pkgconfig/
cp /Users/snowcrash/projects/sqlite-3.3.8/sqlite3.1
/usr/local/man/man1/sqlite3.1
chown root:wheel /usr/local/man/man1/sqlite3.1
chmod 644 /usr/local/man/man1/sqlite3.1


ls -alR /usr/local/sqlite/
        /usr/local/sqlite/:
        total 0
        drwxr-xr-x  5 root    wheel  170 Dec 31 12:33 ./
        drwxrwxr-x 38 snowcrash wheel 1292 Dec 31 15:06 ../
        drwxr-xr-x  3 root    wheel  102 Jan  1 23:45 bin/
        drwxr-xr-x  3 root    wheel  102 Jan  1 23:45 include/
        drwxr-xr-x 13 root    wheel  442 Jan  1 23:45 lib/
        
        /usr/local/sqlite/bin:
        total 64
        drwxr-xr-x 3 root wheel   102 Jan  1 23:45 ./
        drwxr-xr-x 5 root wheel   170 Dec 31 12:33 ../
        -rwxr-xr-x 1 root wheel 64076 Jan  1 23:45 sqlite3
        
        /usr/local/sqlite/include:
        total 80
        drwxr-xr-x 3 root wheel   102 Jan  1 23:45 ./
        drwxr-xr-x 5 root wheel   170 Dec 31 12:33 ../
        -rw-r--r-- 1 root wheel 79013 Jan  1 23:45 sqlite3.h
        
        /usr/local/sqlite/lib:
        total 9988
        drwxr-xr-x 13 root wheel     442 Jan  1 23:45 ./
        drwxr-xr-x  5 root wheel     170 Dec 31 12:33 ../
        -rwxr-xr-x  1 root wheel 1530008 Jan  1 23:45 libsqlite3.0.8.6.dylib
        lrwxr-xr-x  1 root wheel      22 Jan  1 23:45 libsqlite3.0.dylib ->
libsqlite3.0.8.6.dylib
        -rw-r--r--  1 root wheel 1907048 Jan  1 23:45 libsqlite3.a
        lrwxr-xr-x  1 root wheel      22 Jan  1 23:45 libsqlite3.dylib ->
libsqlite3.0.8.6.dylib
        -rwxr-xr-x  1 root wheel     843 Jan  1 23:45 libsqlite3.la
        -rw-r--r--  1 root wheel 1590908 Jan  1 23:46 libtclsqlite3.0.8.6.dylib
        -rw-r--r--  1 root wheel 1590908 Jan  1 23:46 libtclsqlite3.0.dylib
        -rw-r--r--  1 root wheel 1990360 Jan  1 23:46 libtclsqlite3.a
        -rw-r--r--  1 root wheel 1590908 Jan  1 23:46 libtclsqlite3.dylib
        -rw-r--r--  1 root wheel     932 Jan  1 23:46 libtclsqlite3.la
        drwxr-xr-x  3 root wheel     102 Jan  1 23:45 pkgconfig/
        
        /usr/local/sqlite/lib/pkgconfig:
        total 4
        drwxr-xr-x  3 root wheel 102 Jan  1 23:45 ./
        drwxr-xr-x 13 root wheel 442 Jan  1 23:45 ../
        -rw-r--r--  1 root wheel 275 Jan  1 23:45 sqlite3.pc

which sqlite3
        /usr/local/sqlite/bin/sqlite3

sqlite3 -version
        3.3.8


ls -al testfixture
        /usr/local/bin/ls: cannot access testfixture: No such file or directory

make testfixture
        ./libtool --mode=link gcc -g -O2 -DOS_UNIX=1 -DHAVE_USLEEP=1 -I.
-I../src -DSQLITE_DEBUG=1
-I/Library/Frameworks/Tcl.framework/Versions/8.4/Headers
-DTHREADSAFE=0 -DSQLITE_THREAD_OVERRIDE_LOCK=-1 -DSQLITE_OMIT_CURSOR
-DTCLSH=1 -DSQLITE_TEST=1 -DSQLITE_CRASH_TEST=1 \
                                        -DSQLITE_NO_SYNC=1 -DTEMP_STORE=1 \
        ...

ls -al testfixture
        -rwxr-xr-x 1 root 100 3312 Jan  1 23:50 testfixture

./testfixture ../test/autovacuum_ioerr2.test
        autovacuum-ioerr2-1.1.1...
        Error: no such function: randstr
        autovacuum-ioerr2-1.1.2... Ok
        autovacuum-ioerr2-1.1.3...
        Expected: [1]
                 Got: [0]
        autovacuum-ioerr2-2.1.1...
        Error: no such function: randstr
        autovacuum-ioerr2-2.1.2... Ok
        autovacuum-ioerr2-2.1.3...
        Expected: [1]
                 Got: [0]
        autovacuum-ioerr2-3.1.1... Ok
        autovacuum-ioerr2-3.1.2... Ok
        autovacuum-ioerr2-3.1.3... Ok
        autovacuum-ioerr2-4.1.1...
        Error: no such function: randstr
        autovacuum-ioerr2-4.1.2... Ok
        autovacuum-ioerr2-4.1.3...
        Expected: [1]
                 Got: [0]
        Thread-specific data deallocated properly
        6 errors out of 13 tests
        Failures on these tests: autovacuum-ioerr2-1.1.1
autovacuum-ioerr2-1.1.3 autovacuum-ioerr2-2.1.1
autovacuum-ioerr2-2.1.3 autovacuum-ioerr2-4.1.1
autovacuum-ioerr2-4.1.3


despite 'make testfixture' being built with "-DSQLITE_TEST=1", as per
'src/func.c',

        ...
        #ifdef SQLITE_TEST
        /*
        ** This function generates a string of random characters.  Used for
        ** generating test data.
        */
        static void randStr(sqlite3_context *context, int argc, sqlite3_value 
**arg
        ...

i get the,

        "Error: no such function: randstr"

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to