[sqlite] Journal deletion: no directory fsync?

After finishing a transaction and deleting the rollback journal, no directory fsync is performed. If the system crashes immediately after a commit returns to the caller, the unlink may not have been flushed to disk, causing the journal to be rolled back and undoing a commit that had already return

Re: [sqlite] sqlite3_prepare_v2 and error reporting

On Sun, Jul 20, 2008 at 11:50:20PM -0400, Glenn Maynard wrote: > Why does the attached test case show the expected "cannot rollback - > no transaction is active" error with the v1 interface, but the > generic "SQL logic error or missing database" error when using the v2 > interface? > > If I add a

Re: [sqlite] Convert the CURRENT_TIMESTAMP

Thanks Igor! It worked. JP - Original Message From: Igor Tandetnik <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Friday, July 25, 2008 9:21:26 PM Subject: Re: [sqlite] Convert the CURRENT_TIMESTAMP "Joanne Pham" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi

Re: [sqlite] empty result sets without column names?

"Markus Hoenicka" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > according to my experience, sqlite3_get_table() does not return a row > containing the column names and sets numcols to zero if a query > returns zero rows. This is in contrast to other database engines like > MySQL, Po

[sqlite] empty result sets without column names?

Hi, according to my experience, sqlite3_get_table() does not return a row containing the column names and sets numcols to zero if a query returns zero rows. This is in contrast to other database engines like MySQL, PostgreSQL, and Oracle which return the column information even if there are no row