Compiling dll 3.7.3 issue was [BUG] JOIN subquery in FROM with FTS3 table

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Compiling dll 3.7.3 issue was [BUG] JOIN subquery in FROM with FTS3 table

Shopsland gmail
Hi,

Thanks Dan, Richard and Max for the (ultra) fast answer and Dan and
Richard for the fix, because, as Max says, the bug is fixed now in
3.7.3.

But I have a problem compiling sqlite with VC++. I was able to compile
3.7.2 without issues.

With 3.7.3 The linker says:

'error LNK2001: unresolved external symbol sqlite3_rtree_geometry_callback'

Keep up the good work! :-)

Jochi Martinez
www.bfreenews.com
_______________________________________________
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Compiling dll 3.7.3 issue was [BUG] JOIN subquery in FROM with FTS3 table

Shane Harrelson-2
You'll get this if your .DEF file includes any APIs that are not
compiled into your build.
A few sources are:

SQLITE_OMIT_LOAD_EXTENSION=1
SQLITE_ENABLE_COLUMN_METADATA=1
SQLITE_ENABLE_STAT2=1
SQLITE_ENABLE_FTS3=1
SQLITE_ENABLE_RTREE=1

Depending on how you're compiling, you have a couple of options.

1) enable RTREE extensions in your build
2) remove the RTREE APIs from your .DEF file
3) don't use the .DEF (see below)

All of the external SQLite APIs are prefixed with the define
SQLITE_API.  This is usually not defined to any value.  You could try
changing this to use the export declspec directive.  Something like
the following should work:

#define SQLITE_API __declspec(dllexport)

HTH.
-SHane


On Fri, Oct 8, 2010 at 10:03 AM, Shopsland gmail <[hidden email]> wrote:

> Hi,
>
> Thanks Dan, Richard and Max for the (ultra) fast answer and Dan and
> Richard for the fix, because, as Max says, the bug is fixed now in
> 3.7.3.
>
> But I have a problem compiling sqlite with VC++. I was able to compile
> 3.7.2 without issues.
>
> With 3.7.3 The linker says:
>
> 'error LNK2001: unresolved external symbol sqlite3_rtree_geometry_callback'
>
> Keep up the good work! :-)
>
> Jochi Martinez
> www.bfreenews.com
> _______________________________________________
> sqlite-users mailing list
> [hidden email]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[hidden email]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users