Re: [sqlite] Trace callback is not called in a specific case

[Hody Crouch]

Well that's embarrassing.  There wasn't a binary in the current directory,
but I think the linker picked up the 3.8.5 binary from elsewhere (confirmed
by checking the sqlite3 version in the test app, which returned 3.8.5).

I retested (linking correctly this time) against both the 3.8.6
amalgamation and the 3.8.7 pre-release amalgamation.  The problem occurs in
3.8.6 and not in 3.8.7.  So the ticket I mentioned at the top of the thread
may have resolve this issue.

Thanks for the help.

On Sat, Sep 27, 2014 at 5:12 PM, Stephan Beal  wrote:

> On Sat, Sep 27, 2014 at 11:08 PM, Hody Crouch 
> wrote:
>
> > $ gcc -g -I. dbtest.c -l sqlite3 -ldl -lpthread
> > $ ./a.out
> > TRACE: SELECT val1, val2 from t where val2 = 'A%'
> >
>
> What is -l sqlite3 supposed to do? It's not a valid linker flag (-l and its
> argument should have no spaces between them). It looks to me like you are
> linking the sqlite3 _binary_ (from the current directory) into your dbtest
> app (which is a usage error).
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Trace callback is not called in a specific case

[Stephan Beal]

On Sat, Sep 27, 2014 at 11:08 PM, Hody Crouch  wrote:

> $ gcc -g -I. dbtest.c -l sqlite3 -ldl -lpthread
> $ ./a.out
> TRACE: SELECT val1, val2 from t where val2 = 'A%'
>

What is -l sqlite3 supposed to do? It's not a valid linker flag (-l and its
argument should have no spaces between them). It looks to me like you are
linking the sqlite3 _binary_ (from the current directory) into your dbtest
app (which is a usage error).

-- 
- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
"Freedom is sloppy. But since tyranny's the only guaranteed byproduct of
those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Trace callback is not called in a specific case

[Hody Crouch]

Thank you for looking into this.

In my test, I linked against sqlite3 using '-l sqlite3' in the gcc command
line.  I see that you compiled sqlite3 into an object file first.  If I
build using your command, the trace works as expected.  When I link against
the source directly, I see the unexpected behavior.

$ gcc -g -I. dbtest.c sqlite3.o -ldl -lpthread
$ ./a.out
TRACE: SELECT val1, val2 from t where val2 LIKE 'A%'
$ gcc -g -I. dbtest.c -l sqlite3 -ldl -lpthread
$ ./a.out
$

If I change the SQL query, I see the trace in both cases.
$ gcc -g -I. dbtest.c sqlite3.o -ldl -lpthread
$ ./a.out
TRACE: SELECT val1, val2 from t where val2 = 'A%'
$ gcc -g -I. dbtest.c -l sqlite3 -ldl -lpthread
$ ./a.out
TRACE: SELECT val1, val2 from t where val2 = 'A%'
$


On Fri, Sep 26, 2014 at 10:06 PM, Richard Hipp  wrote:

> On Fri, Sep 26, 2014 at 6:44 PM, Hody Crouch 
> wrote:
>
> > Test code is provided below.  If you change the sql query to include
> 'val2
> > = ?' rather than 'val2 LIKE ?', you will see trace output.
> >
>
> It works fine when I try it:
>
> drh@bella:~/sqlite/bld$ gcc -g -I. x1.c sqlite3.o -ldl -lpthread
> drh@bella:~/sqlite/bld$ ./a.out
> TRACE: SELECT val1, val2 from t where val2 LIKE 'A%'
> drh@bella:~/sqlite/bld$
>
>
>
> >
> > #include 
> > #include 
> > #include "sqlite3.h"
> >
> > static void trace_callback( void* udp, const char* sql ) {
> >   printf("TRACE: %s\n", sql);
> > };
> >
> > int main(int argc, char* argv[])
> > {
> >   sqlite3 *db;
> >   char *sql;
> >
> >   sqlite3_open("test.db", );
> >
> >   // Enable tracing
> >   sqlite3_trace(db, trace_callback, 0);
> >
> >   sql = "SELECT val1, val2 from t where val2 LIKE ?";
> >
> >   sqlite3_stmt* statement = NULL;
> >   sqlite3_prepare_v2(db, sql, -1, , NULL);
> >   sqlite3_bind_text(statement, 1, "A%", -1, NULL);
> >   sqlite3_step(statement);
> >   sqlite3_close(db);
> >   return 0;
> > }
> >
> > On Fri, Sep 26, 2014 at 6:20 PM, Richard Hipp  wrote:
> >
> > > On Thu, Sep 25, 2014 at 5:58 PM, Hody Crouch 
> > > wrote:
> > >
> > > > While using sqlite3 with node, I used trace and found that a specific
> > > query
> > > > did not result in a callback invocation.  I have only seen this
> > behavior
> > > if
> > > > all of the following conditions are met:
> > > > - sql query includes 'LIKE ?'
> > > > - prepare the query
> > > > - bind a parameter
> > > > - execute the query
> > > >
> > >
> > > I am unable to reproduce the problem.  Please send more hints.  Perhaps
> > > send source code.
> > >
> > >
> > > >
> > > > If I change the query to use '=' instead of 'LIKE', the trace
> callback
> > is
> > > > invoked as expected.
> > > >
> > > > I looked at http://www.sqlite.org/src/info/11d5aa455e0d98f3c1e6a08
> in
> > > > hopes
> > > > that this issue might be resolved.  Using
> > > sqlite-amalgamation-201409200035
> > > > and a test app in c, the issue is still reproducible.
> > > >
> > > > Test table schema: CREATE TABLE t (val1 TEXT, val2 TEXT);
> > > >
> > > > Query to reproduce the issue:
> > > > SELECT val1, val2 from t where val2 LIKE ?
> > > >
> > > > The description of the ticket I mentioned seems similar, but I don't
> > know
> > > > enough about the sqlite3 inner workings to offer much more than the
> > above
> > > > report.  Let me know if you need to see the test app as well.
> > > >
> > > > Thanks.
> > > > ___
> > > > sqlite-users mailing list
> > > > sqlite-users@sqlite.org
> > > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> > > >
> > >
> > >
> > >
> > > --
> > > D. Richard Hipp
> > > d...@sqlite.org
> > > ___
> > > 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
> >
>
>
>
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> 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

[sqlite] A new extension for sqlite to analyze the stringmetrics

[Andrea Peri]

https://github.com/aperi2007/libstringmetrics


>Andrea, where do I find it?
>
>thanks
>
>gert



-- 
-
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] A new extension for sqlite to analyze the stringmetrics

[Gert Van Assche]

Andrea, where do I find it?

thanks

gert

2014-09-27 13:48 GMT+02:00 Andrea Peri :

> Hi,
> I commit the new extension with the runtime statically liked.
> I test it on a clean machine and seem work.
>
> The extension is compiled on 32bit.
> So need a sqlite 32bit to work.
>
> I guess it should not work with a 64bit sqlite shell.
>
> Regards,
>
> A.
>
>
> 2014-09-26 17:38 GMT+02:00 Andrea Peri :
> >>For Andrea Peri's benefit, I did google and find where someone mentions
> the
> >>appropriate flags to statically link the dependency in, thus avoiding
> this
> >>problem.
> >>
> http://stackoverflow.com/questions/4702732/the-program-cant-start-because-li
> >>bgcc-s-dw2-1-dll-is-missing
> >>So Andrea may wish to rebuild and replace the existing dll for the
> benefit
> >>of the community.
> >
> > Thx for hints.
> > I dont notice the dll was commited in the github.
> > :)
> >
> > However, no problem to update the compile to produce a static-linkage
> version.
> > I guess a static linkage version of the lib is still compliant with
> > the license of sqlite and libsymmetric.
> >
> > Also I update the site and dll changing the settings as reported from
> > "keith" (thx).
> >
> > Unfortunately I have not a clean machine to test him for a true
> > static-linkage. Infact now it run for me , but I guess is still a
> > shared version.
> > I compile with minw and need some other lib to have a true
> static-linkage.
> >
> > I try to resolve in this week-end.
> >
> > Andrea
> > --
> > -
> > Andrea Peri
> > . . . . . . . . .
> > qwerty àèìòù
> > -
>
>
>
> --
> -
> Andrea Peri
> . . . . . . . . .
> qwerty àèìòù
> -
> ___
> 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] A new extension for sqlite to analyze the stringmetrics

[Andrea Peri]

Hi,
I commit the new extension with the runtime statically liked.
I test it on a clean machine and seem work.

The extension is compiled on 32bit.
So need a sqlite 32bit to work.

I guess it should not work with a 64bit sqlite shell.

Regards,

A.


2014-09-26 17:38 GMT+02:00 Andrea Peri :
>>For Andrea Peri's benefit, I did google and find where someone mentions the
>>appropriate flags to statically link the dependency in, thus avoiding this
>>problem.
>>http://stackoverflow.com/questions/4702732/the-program-cant-start-because-li
>>bgcc-s-dw2-1-dll-is-missing
>>So Andrea may wish to rebuild and replace the existing dll for the benefit
>>of the community.
>
> Thx for hints.
> I dont notice the dll was commited in the github.
> :)
>
> However, no problem to update the compile to produce a static-linkage version.
> I guess a static linkage version of the lib is still compliant with
> the license of sqlite and libsymmetric.
>
> Also I update the site and dll changing the settings as reported from
> "keith" (thx).
>
> Unfortunately I have not a clean machine to test him for a true
> static-linkage. Infact now it run for me , but I guess is still a
> shared version.
> I compile with minw and need some other lib to have a true static-linkage.
>
> I try to resolve in this week-end.
>
> Andrea
> --
> -
> Andrea Peri
> . . . . . . . . .
> qwerty àèìòù
> -



-- 
-
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users