bug with progress handler and sql functions.

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

bug with progress handler and sql functions.

Guillaume Fougnies

Using sqlite3_progress_handler with functions in the sql
request (like ifnull()) seems to make the nProgressOps
(in vdbe.c) not increment properly.

Set a sqlite3_progress_handler with a frequency of 10
virtual machine opcodes.
The sql request contains 9 calls on ifnull.
sqlite3_step never activate the progress handler.

I've corrected the problem by adding a nProgressOpsI in
the sqlite3 structure which increments properly despite
many sqlite3VdbeExec calls. The patch is trivial.

Guillaume FOUGNIES
Eulerian Technologies