Apologies if this topic has been discussed before ...

I just came across a surprising behaviour when executing this command:
PRAGMA journal_mode=<something>;

I would have expected that sqlite3_step() will return SQLITE_DONE with this
command, as is the case with (AFAIK) any other PRAGMA command that assigns
a value, i.e. a "=" is contained.

However, SQLITE_ROW ist returned instead because the command not only sets
the new value but also returns the current (?) one.

Is this behaviour intended? It can bee watched in the CLI also.

Wolfgang

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to