Hello, 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. Bye. -- Guillaume FOUGNIES Eulerian Technologies