Re: [sqlite] Possible bug when rebuilding amalgamation without triggers or altertable

2012-04-27 Thread nn6eumtr
In response to Stepheen Beal's previous comments I do understand that 
not all combinations of -DSQLITE_OMIT statements will work, and past 
experience has shown its usually because the dependencies between the 
various options are not clear in the documentation.


However someone has invested the effort to write the 
-DSQLITE_OMIT_ALTERTABLE and -DSQLITE_OMIT_FOREIGN_KEY functionality, 
and the person who did that may be concerned that these features do not 
work in current builds of SQLite, or they may have a fix which isn't 
part of the source distribution yet, or they may know other dependencies 
that need to be resolved.


Those are the people I am attempting to reach via this list. If that 
isn't you or your not interested in a solution, then I would ask that 
you please don't discourage others from responding.


On 4/25/2012 7:11 PM, nn6eumtr wrote:

To clarify, the below steps to reproduce include building the
amalgamation from scratch, and the errors I demonstrate occur after
building and compiling a new amalgamation with -DSQLITE_OMIT_ALTERTABLE
and -DSQLITE_OMIT_FOREIGN_KEY.

In Stepheen Beal's earlier comments he appears to have not realized that
I was rebuilding the amalgamation and not trying to use the
-DSQLITE_OMIT_* flags with the distributed amalgamation. I still need
some assistance.

On 4/25/2012 1:09 AM, nn6eumtr wrote:

Steps to recreate:

1) wget -nd -nH -c -t 0 -w 1
http://www.sqlite.org/src/tarball/SQLite-9fb7da6904e479f4.tar.gz?uuid=9fb7da6904e479f4671eeebf1a4b7e4e4e4f2b7b


2) mv -v
SQLite-9fb7da6904e479f4.tar.gz?uuid=9fb7da6904e479f4671eeebf1a4b7e4e4e4f2b7b

SQLite-9fb7da6904e479f4.tar.gz
3) tar -xzf SQLite-9fb7da6904e479f4.tar.gz
4) cd SQLite-9fb7da6904e479f4
5) OPT_FEATURE_FLAGS=-DSQLITE_ENABLE_FTS3_PARENTHESIS
-DSQLITE_ENABLE_FTS4 \
-DSQLITE_ENABLE_LOCKING_STYLE=0 -DSQLITE_ENABLE_MEMORY_MANAGEMENT \
-DSQLITE_ENABLE_MEMSYS5 -DSQLITE_ENABLE_STAT3 -DSQLITE_OMIT_ALTERTABLE \
-DSQLITE_OMIT_AUTOINIT -DSQLITE_OMIT_AUTOVACUUM
-DSQLITE_OMIT_BUILTIN_TEST \
-DSQLITE_OMIT_COMPLETE -DSQLITE_OMIT_DATETIME_FUNCS \
-DSQLITE_OMIT_DEPRECATED -DSQLITE_OMIT_EXPLAIN
-DSQLITE_OMIT_FOREIGN_KEY \
-DSQLITE_OMIT_GET_TABLE -DSQLITE_OMIT_LOAD_EXTENSION \
-DSQLITE_OMIT_SHARED_CACHE -DSQLITE_OMIT_TCL_VARIABLE
-DSQLITE_OMIT_TRACE \
-DSQLITE_OMIT_TRIGGER -DSQLITE_OMIT_UTF16 -DSQLITE_THREADSAFE=0 \
./configure --disable-tcl --disable-readline
6) make sqlite3.c
8) Compile - gcc -c -Wall -DSQLITE_ENABLE_FTS3_PARENTHESIS \
-DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_LOCKING_STYLE=0 \
-DSQLITE_ENABLE_MEMORY_MANAGEMENT -DSQLITE_ENABLE_MEMSYS5 \
-DSQLITE_ENABLE_STAT3 -DSQLITE_OMIT_ALTERTABLE \
-DSQLITE_OMIT_AUTOINIT -DSQLITE_OMIT_AUTOVACUUM \
-DSQLITE_OMIT_BUILTIN_TEST -DSQLITE_OMIT_COMPLETE \
-DSQLITE_OMIT_DATETIME_FUNCS -DSQLITE_OMIT_DEPRECATED \
-DSQLITE_OMIT_EXPLAIN -DSQLITE_OMIT_FOREIGN_KEY \
-DSQLITE_OMIT_GET_TABLE -DSQLITE_OMIT_LOAD_EXTENSION \
-DSQLITE_OMIT_SHARED_CACHE -DSQLITE_OMIT_TCL_VARIABLE \
-DSQLITE_OMIT_TRACE -DSQLITE_OMIT_TRIGGER \
-DSQLITE_OMIT_UTF16 -DSQLITE_THREADSAFE=0 \
-DSQLITE_ZERO_MALLOC sqlite3.c

This will produce the following errors:

sqlite3.c:(.text+0x462d2): undefined reference to
`sqlite3AlterBeginAddColumn'
sqlite3.c:(.text+0x462fe): undefined reference to
`sqlite3AlterFinishAddColumn'
sqlite3.c:(.text+0x46331): undefined reference to
`sqlite3AlterRenameTable'
sqlite3.c:(.text+0x46482): undefined reference to `sqlite3DropTrigger'
sqlite3.c:(.text+0x4657b): undefined reference to
`sqlite3TriggerSelectStep'
sqlite3.c:(.text+0x465b9): undefined reference to
`sqlite3TriggerDeleteStep'
sqlite3.c:(.text+0x4660a): undefined reference to
`sqlite3TriggerInsertStep'
sqlite3.c:(.text+0x46661): undefined reference to
`sqlite3TriggerInsertStep'
sqlite3.c:(.text+0x466b0): undefined reference to
`sqlite3TriggerUpdateStep'
sqlite3.c:(.text+0x4688d): undefined reference to `sqlite3BeginTrigger'
sqlite3.c:(.text+0x468f8): undefined reference to `sqlite3FinishTrigger'


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Possible bug when rebuilding amalgamation without triggers or altertable

2012-04-27 Thread Stephan Beal
On Fri, Apr 27, 2012 at 1:31 AM, nn6eumtr nn6eu...@gmail.com wrote:

 In response to Stepheen Beal's previous comments I do understand that not
 all combinations of -DSQLITE_OMIT statements will work, and past experience
 has shown its usually because the dependencies between the various options
 are not clear in the documentation.


The documentation is clear that _all_ of the OMIT options are unsupported
and largely untested, i.e. their behaviour is undefined.

Those are the people I am attempting to reach via this list. If that isn't
 you or your not interested in a solution, then I would ask that you please
 don't discourage others from responding.


My point is that the docs already answer this definitively with two
Important Note blocks which the author felt compelled to emphasize, and
that any discussion on what might or might not work is all speculation
about undefined behaviour. There is no supported solution, at least
according to the docs.

-- 
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Possible bug when rebuilding amalgamation without triggers or altertable

2012-04-26 Thread nn6eumtr
To clarify, the below steps to reproduce include building the 
amalgamation from scratch, and the errors I demonstrate occur after 
building and compiling a new amalgamation with -DSQLITE_OMIT_ALTERTABLE 
and -DSQLITE_OMIT_FOREIGN_KEY.


In Stepheen Beal's earlier comments he appears to have not realized that 
I was rebuilding the amalgamation and not trying to use the 
-DSQLITE_OMIT_* flags with the distributed amalgamation. I still need 
some assistance.


On 4/25/2012 1:09 AM, nn6eumtr wrote:

Steps to recreate:

1) wget -nd -nH -c -t 0 -w 1
http://www.sqlite.org/src/tarball/SQLite-9fb7da6904e479f4.tar.gz?uuid=9fb7da6904e479f4671eeebf1a4b7e4e4e4f2b7b

2) mv -v
SQLite-9fb7da6904e479f4.tar.gz?uuid=9fb7da6904e479f4671eeebf1a4b7e4e4e4f2b7b
SQLite-9fb7da6904e479f4.tar.gz
3) tar -xzf SQLite-9fb7da6904e479f4.tar.gz
4) cd SQLite-9fb7da6904e479f4
5) OPT_FEATURE_FLAGS=-DSQLITE_ENABLE_FTS3_PARENTHESIS
-DSQLITE_ENABLE_FTS4 \
-DSQLITE_ENABLE_LOCKING_STYLE=0 -DSQLITE_ENABLE_MEMORY_MANAGEMENT \
-DSQLITE_ENABLE_MEMSYS5 -DSQLITE_ENABLE_STAT3 -DSQLITE_OMIT_ALTERTABLE \
-DSQLITE_OMIT_AUTOINIT -DSQLITE_OMIT_AUTOVACUUM
-DSQLITE_OMIT_BUILTIN_TEST \
-DSQLITE_OMIT_COMPLETE -DSQLITE_OMIT_DATETIME_FUNCS \
-DSQLITE_OMIT_DEPRECATED -DSQLITE_OMIT_EXPLAIN -DSQLITE_OMIT_FOREIGN_KEY \
-DSQLITE_OMIT_GET_TABLE -DSQLITE_OMIT_LOAD_EXTENSION \
-DSQLITE_OMIT_SHARED_CACHE -DSQLITE_OMIT_TCL_VARIABLE -DSQLITE_OMIT_TRACE \
-DSQLITE_OMIT_TRIGGER -DSQLITE_OMIT_UTF16 -DSQLITE_THREADSAFE=0 \
./configure --disable-tcl --disable-readline
6) make sqlite3.c
8) Compile - gcc -c -Wall -DSQLITE_ENABLE_FTS3_PARENTHESIS \
-DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_LOCKING_STYLE=0 \
-DSQLITE_ENABLE_MEMORY_MANAGEMENT -DSQLITE_ENABLE_MEMSYS5 \
-DSQLITE_ENABLE_STAT3 -DSQLITE_OMIT_ALTERTABLE \
-DSQLITE_OMIT_AUTOINIT -DSQLITE_OMIT_AUTOVACUUM \
-DSQLITE_OMIT_BUILTIN_TEST -DSQLITE_OMIT_COMPLETE \
-DSQLITE_OMIT_DATETIME_FUNCS -DSQLITE_OMIT_DEPRECATED \
-DSQLITE_OMIT_EXPLAIN -DSQLITE_OMIT_FOREIGN_KEY \
-DSQLITE_OMIT_GET_TABLE -DSQLITE_OMIT_LOAD_EXTENSION \
-DSQLITE_OMIT_SHARED_CACHE -DSQLITE_OMIT_TCL_VARIABLE \
-DSQLITE_OMIT_TRACE -DSQLITE_OMIT_TRIGGER \
-DSQLITE_OMIT_UTF16 -DSQLITE_THREADSAFE=0 \
-DSQLITE_ZERO_MALLOC sqlite3.c

This will produce the following errors:

sqlite3.c:(.text+0x462d2): undefined reference to
`sqlite3AlterBeginAddColumn'
sqlite3.c:(.text+0x462fe): undefined reference to
`sqlite3AlterFinishAddColumn'
sqlite3.c:(.text+0x46331): undefined reference to `sqlite3AlterRenameTable'
sqlite3.c:(.text+0x46482): undefined reference to `sqlite3DropTrigger'
sqlite3.c:(.text+0x4657b): undefined reference to
`sqlite3TriggerSelectStep'
sqlite3.c:(.text+0x465b9): undefined reference to
`sqlite3TriggerDeleteStep'
sqlite3.c:(.text+0x4660a): undefined reference to
`sqlite3TriggerInsertStep'
sqlite3.c:(.text+0x46661): undefined reference to
`sqlite3TriggerInsertStep'
sqlite3.c:(.text+0x466b0): undefined reference to
`sqlite3TriggerUpdateStep'
sqlite3.c:(.text+0x4688d): undefined reference to `sqlite3BeginTrigger'
sqlite3.c:(.text+0x468f8): undefined reference to `sqlite3FinishTrigger'


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Possible bug when rebuilding amalgamation without triggers or altertable

2012-04-26 Thread Stephan Beal
On Thu, Apr 26, 2012 at 1:11 AM, nn6eumtr nn6eu...@gmail.com wrote:

 In Stepheen Beal's earlier comments he appears to have not realized that I
 was rebuilding the amalgamation and not trying to use the -DSQLITE_OMIT_*
 flags with the distributed amalgamation. I still need some assistance.


The docs go on to say:

All of the SQLITE_OMIT_* options are unsupported.

*Important Note: The SQLITE_OMIT_* compile-time options are unsupported.*

The SQLITE_OMIT_* compile-time options are usually untested and are almost
certainly untested in combination. Any or all of these options may be
removed from the code in future releases and without warning. For any
particular release, some of these options may cause compile-time or
run-time failures, particularly when used in combination with other options.

-- 
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Possible bug when rebuilding amalgamation without triggers or altertable

2012-04-26 Thread Pavel Ivanov
 To clarify, the below steps to reproduce include building the amalgamation
 from scratch, and the errors I demonstrate occur after building and
 compiling a new amalgamation with -DSQLITE_OMIT_ALTERTABLE and
 -DSQLITE_OMIT_FOREIGN_KEY.

It's still not clear, did you define these OMITs while building your
new amalgamation? If no you must do it in order to build correct
amalgamation. If yes then these errors fall under the unsupported
options statement Stephan points you to. But probably SQLite team
will fix this in some future release if they have some spare time and
the fix is not too expensive for them.


Pavel


On Wed, Apr 25, 2012 at 7:11 PM, nn6eumtr nn6eu...@gmail.com wrote:
 To clarify, the below steps to reproduce include building the amalgamation
 from scratch, and the errors I demonstrate occur after building and
 compiling a new amalgamation with -DSQLITE_OMIT_ALTERTABLE and
 -DSQLITE_OMIT_FOREIGN_KEY.

 In Stepheen Beal's earlier comments he appears to have not realized that I
 was rebuilding the amalgamation and not trying to use the -DSQLITE_OMIT_*
 flags with the distributed amalgamation. I still need some assistance.


 On 4/25/2012 1:09 AM, nn6eumtr wrote:

 Steps to recreate:

 1) wget -nd -nH -c -t 0 -w 1

 http://www.sqlite.org/src/tarball/SQLite-9fb7da6904e479f4.tar.gz?uuid=9fb7da6904e479f4671eeebf1a4b7e4e4e4f2b7b

 2) mv -v

 SQLite-9fb7da6904e479f4.tar.gz?uuid=9fb7da6904e479f4671eeebf1a4b7e4e4e4f2b7b
 SQLite-9fb7da6904e479f4.tar.gz
 3) tar -xzf SQLite-9fb7da6904e479f4.tar.gz
 4) cd SQLite-9fb7da6904e479f4
 5) OPT_FEATURE_FLAGS=-DSQLITE_ENABLE_FTS3_PARENTHESIS
 -DSQLITE_ENABLE_FTS4 \
 -DSQLITE_ENABLE_LOCKING_STYLE=0 -DSQLITE_ENABLE_MEMORY_MANAGEMENT \
 -DSQLITE_ENABLE_MEMSYS5 -DSQLITE_ENABLE_STAT3 -DSQLITE_OMIT_ALTERTABLE \
 -DSQLITE_OMIT_AUTOINIT -DSQLITE_OMIT_AUTOVACUUM
 -DSQLITE_OMIT_BUILTIN_TEST \
 -DSQLITE_OMIT_COMPLETE -DSQLITE_OMIT_DATETIME_FUNCS \
 -DSQLITE_OMIT_DEPRECATED -DSQLITE_OMIT_EXPLAIN -DSQLITE_OMIT_FOREIGN_KEY \
 -DSQLITE_OMIT_GET_TABLE -DSQLITE_OMIT_LOAD_EXTENSION \
 -DSQLITE_OMIT_SHARED_CACHE -DSQLITE_OMIT_TCL_VARIABLE -DSQLITE_OMIT_TRACE
 \
 -DSQLITE_OMIT_TRIGGER -DSQLITE_OMIT_UTF16 -DSQLITE_THREADSAFE=0 \
 ./configure --disable-tcl --disable-readline
 6) make sqlite3.c
 8) Compile - gcc -c -Wall -DSQLITE_ENABLE_FTS3_PARENTHESIS \
 -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_LOCKING_STYLE=0 \
 -DSQLITE_ENABLE_MEMORY_MANAGEMENT -DSQLITE_ENABLE_MEMSYS5 \
 -DSQLITE_ENABLE_STAT3 -DSQLITE_OMIT_ALTERTABLE \
 -DSQLITE_OMIT_AUTOINIT -DSQLITE_OMIT_AUTOVACUUM \
 -DSQLITE_OMIT_BUILTIN_TEST -DSQLITE_OMIT_COMPLETE \
 -DSQLITE_OMIT_DATETIME_FUNCS -DSQLITE_OMIT_DEPRECATED \
 -DSQLITE_OMIT_EXPLAIN -DSQLITE_OMIT_FOREIGN_KEY \
 -DSQLITE_OMIT_GET_TABLE -DSQLITE_OMIT_LOAD_EXTENSION \
 -DSQLITE_OMIT_SHARED_CACHE -DSQLITE_OMIT_TCL_VARIABLE \
 -DSQLITE_OMIT_TRACE -DSQLITE_OMIT_TRIGGER \
 -DSQLITE_OMIT_UTF16 -DSQLITE_THREADSAFE=0 \
 -DSQLITE_ZERO_MALLOC sqlite3.c

 This will produce the following errors:

 sqlite3.c:(.text+0x462d2): undefined reference to
 `sqlite3AlterBeginAddColumn'
 sqlite3.c:(.text+0x462fe): undefined reference to
 `sqlite3AlterFinishAddColumn'
 sqlite3.c:(.text+0x46331): undefined reference to
 `sqlite3AlterRenameTable'
 sqlite3.c:(.text+0x46482): undefined reference to `sqlite3DropTrigger'
 sqlite3.c:(.text+0x4657b): undefined reference to
 `sqlite3TriggerSelectStep'
 sqlite3.c:(.text+0x465b9): undefined reference to
 `sqlite3TriggerDeleteStep'
 sqlite3.c:(.text+0x4660a): undefined reference to
 `sqlite3TriggerInsertStep'
 sqlite3.c:(.text+0x46661): undefined reference to
 `sqlite3TriggerInsertStep'
 sqlite3.c:(.text+0x466b0): undefined reference to
 `sqlite3TriggerUpdateStep'
 sqlite3.c:(.text+0x4688d): undefined reference to `sqlite3BeginTrigger'
 sqlite3.c:(.text+0x468f8): undefined reference to `sqlite3FinishTrigger'

 ___
 sqlite-users mailing list
 sqlite-users@sqlite.org
 http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Possible bug when rebuilding amalgamation without triggers or altertable

2012-04-26 Thread Stephan Beal
On Thu, Apr 26, 2012 at 4:05 PM, Pavel Ivanov paiva...@gmail.com wrote:

 amalgamation. If yes then these errors fall under the unsupported
 options statement Stephan points you to. But probably SQLite team
 will fix this in some future release if they have some spare time and
 the fix is not too expensive for them.


The second important note does not appear to be specific to the
amalgamation build. It appears to (in my interpretation) be making a
blanket statement about those options.

-- 
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Possible bug when rebuilding amalgamation without triggers or altertable

2012-04-26 Thread Pavel Ivanov
On Thu, Apr 26, 2012 at 10:09 AM, Stephan Beal sgb...@googlemail.com wrote:
 On Thu, Apr 26, 2012 at 4:05 PM, Pavel Ivanov paiva...@gmail.com wrote:
 amalgamation. If yes then these errors fall under the unsupported
 options statement Stephan points you to. But probably SQLite team
 will fix this in some future release if they have some spare time and
 the fix is not too expensive for them.


 The second important note does not appear to be specific to the
 amalgamation build. It appears to (in my interpretation) be making a
 blanket statement about those options.

Yes, you're right. I just noted that to execute building with OMITs
correctly (and to have a chance of successful build) one should define
those OMITs while building amalgamation. If this building procedure
was correctly followed then sorry, no luck, read important note.
I.e. developers didn't test this combination of OMITs and it doesn't
have to work. Maybe they fix this or you can propose a patch.


Pavel
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] Possible bug when rebuilding amalgamation without triggers or altertable

2012-04-25 Thread nn6eumtr

Steps to recreate:

1) wget -nd -nH -c -t 0 -w 1 
http://www.sqlite.org/src/tarball/SQLite-9fb7da6904e479f4.tar.gz?uuid=9fb7da6904e479f4671eeebf1a4b7e4e4e4f2b7b
2) mv -v 
SQLite-9fb7da6904e479f4.tar.gz?uuid=9fb7da6904e479f4671eeebf1a4b7e4e4e4f2b7b 
SQLite-9fb7da6904e479f4.tar.gz

3) tar -xzf SQLite-9fb7da6904e479f4.tar.gz
4) cd SQLite-9fb7da6904e479f4
5) OPT_FEATURE_FLAGS=-DSQLITE_ENABLE_FTS3_PARENTHESIS 
-DSQLITE_ENABLE_FTS4 \

-DSQLITE_ENABLE_LOCKING_STYLE=0 -DSQLITE_ENABLE_MEMORY_MANAGEMENT \
-DSQLITE_ENABLE_MEMSYS5 -DSQLITE_ENABLE_STAT3 -DSQLITE_OMIT_ALTERTABLE \
-DSQLITE_OMIT_AUTOINIT -DSQLITE_OMIT_AUTOVACUUM -DSQLITE_OMIT_BUILTIN_TEST \
-DSQLITE_OMIT_COMPLETE -DSQLITE_OMIT_DATETIME_FUNCS \
-DSQLITE_OMIT_DEPRECATED -DSQLITE_OMIT_EXPLAIN -DSQLITE_OMIT_FOREIGN_KEY \
-DSQLITE_OMIT_GET_TABLE -DSQLITE_OMIT_LOAD_EXTENSION \
-DSQLITE_OMIT_SHARED_CACHE -DSQLITE_OMIT_TCL_VARIABLE -DSQLITE_OMIT_TRACE \
-DSQLITE_OMIT_TRIGGER -DSQLITE_OMIT_UTF16 -DSQLITE_THREADSAFE=0 \
./configure --disable-tcl --disable-readline
6) make sqlite3.c
8) Compile - gcc -c -Wall -DSQLITE_ENABLE_FTS3_PARENTHESIS \
-DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_LOCKING_STYLE=0 \
-DSQLITE_ENABLE_MEMORY_MANAGEMENT -DSQLITE_ENABLE_MEMSYS5 \
-DSQLITE_ENABLE_STAT3 -DSQLITE_OMIT_ALTERTABLE \
-DSQLITE_OMIT_AUTOINIT -DSQLITE_OMIT_AUTOVACUUM \
-DSQLITE_OMIT_BUILTIN_TEST -DSQLITE_OMIT_COMPLETE \
-DSQLITE_OMIT_DATETIME_FUNCS -DSQLITE_OMIT_DEPRECATED \
-DSQLITE_OMIT_EXPLAIN -DSQLITE_OMIT_FOREIGN_KEY \
-DSQLITE_OMIT_GET_TABLE -DSQLITE_OMIT_LOAD_EXTENSION \
-DSQLITE_OMIT_SHARED_CACHE -DSQLITE_OMIT_TCL_VARIABLE \
-DSQLITE_OMIT_TRACE -DSQLITE_OMIT_TRIGGER \
-DSQLITE_OMIT_UTF16 -DSQLITE_THREADSAFE=0 \
-DSQLITE_ZERO_MALLOC sqlite3.c

This will produce the following errors:

sqlite3.c:(.text+0x462d2): undefined reference to 
`sqlite3AlterBeginAddColumn'
sqlite3.c:(.text+0x462fe): undefined reference to 
`sqlite3AlterFinishAddColumn'

sqlite3.c:(.text+0x46331): undefined reference to `sqlite3AlterRenameTable'
sqlite3.c:(.text+0x46482): undefined reference to `sqlite3DropTrigger'
sqlite3.c:(.text+0x4657b): undefined reference to `sqlite3TriggerSelectStep'
sqlite3.c:(.text+0x465b9): undefined reference to `sqlite3TriggerDeleteStep'
sqlite3.c:(.text+0x4660a): undefined reference to `sqlite3TriggerInsertStep'
sqlite3.c:(.text+0x46661): undefined reference to `sqlite3TriggerInsertStep'
sqlite3.c:(.text+0x466b0): undefined reference to `sqlite3TriggerUpdateStep'
sqlite3.c:(.text+0x4688d): undefined reference to `sqlite3BeginTrigger'
sqlite3.c:(.text+0x468f8): undefined reference to `sqlite3FinishTrigger'

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Possible bug when rebuilding amalgamation without triggers or altertable

2012-04-25 Thread Stephan Beal
On Wed, Apr 25, 2012 at 7:09 AM, nn6eumtr nn6eu...@gmail.com wrote:

 Steps to recreate:


http://www.sqlite.org/compile.html#omitfeatures

says:

*Important Note: The SQLITE_OMIT_* options do not work with the
amalgamationhttp://www.sqlite.org/amalgamation.html or
with pre-packaged C code files. SQLITE_OMIT_* compile-time options only
work correctly when SQLite is built from canonical source files.*


-- 
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users