If I have a table:
create table tmp (
x integer,
y integer
)
And a an index with compound key:
create unique index idx on tmp (x, y);
And I did a query:
select * from tmp where x = 9
Would sqlite know how to use the index to find records where x = 9? Or
would it opt for a scan
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
populated by passing in to configure as my notes had indicated, but by
manually editing the Makefile and adding the desired flags to
OPT_FEATURE_FLAGS.
On 4/26/2012 7:31 PM, nn6eumtr wrote:
In response to Stepheen Beal's previous comments I do understand that
not all combinations of -DSQLITE_OMIT
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
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
Steps to recreate:
1) wget -nd -nH -c -t 0 -w 1
http://www.sqlite.org/src/tarball/SQLite-bf1dc7907cf1a5c7.tar.gz?uuid=bf1dc7907cf1a5c7e19b04fa1278b2089316c30a
2) mv -v
SQLite-bf1dc7907cf1a5c7.tar.gz?uuid=bf1dc7907cf1a5c7e19b04fa1278b2089316c30a
SQLite-bf1dc7907cf1a5c7.tar.gz
3) tar -xzf