Re: [sqlite] Cannot delete a Database file?

On 2 Jul 2017, at 5:06am, domonic wrote: > The database file I am trying to delete is in use when I try to delete it, so > it's obviously still open. From whqt you wrote so far, you might have an anti-virus package installed which is still checking the database when you

Re: [sqlite] Cannot delete a Database file?

The database file I am trying to delete is in use when I try to delete it, so it's obviously still open. This is what I've done. I have made my connection to the database (sqlite3 *handle) global. If this is the case then just before I delete the file I could close the connection

[sqlite] Doc bug: wal.html should mention proper way to remove wal and shm files

file:///usr/share/doc/sqlite3-doc/wal.html should mention the common case where the user (let's say someone from a different project) has encountered cookies.db cookies.db-shm cookies.db-wal left behind by some program. User wishs to clean this up, leaving only cookies.db. Of course he could

Re: [sqlite] Documentation bug: lang_insert.html needs examples

Actually there would be six since you can either specify or omit the columns list for each ... -- ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı > -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of Simon Slavin > Sent:

Re: [sqlite] BUG: whitespace in schemas?!

On 2 Jul 2017, at 12:15am, 積丹尼 Dan Jacobson wrote: > This tells me that sqlite3 is storing schemas in some inefficient wrong way! SQLite stores the statements needed to create the schema. For example, the structure of a table is not stored in any structured way, instead

[sqlite] sorry I glued these all into the same thread

Sorry I glued these all into the same thread. I'll be more careful next time. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] BUG: whitespace in schemas?!

You really should standardize how the schemas are stored. Differing whitespace should not be significant and stored in this case: file epiphany/cookies.sqlite midori/cookies.db epiphany/cookies.sqlite: SQLite 3.x database, last written using SQLite version 3019003 midori/cookies.db: SQLite

Re: [sqlite] Documentation bug: lang_insert.html needs examples

On 2 Jul 2017, at 12:08am, 積丹尼 Dan Jacobson wrote: > So near the top of the article add this synopsis of the three basic forms, > INSERT INTO moz_cookies VALUES(1,'Bart',12); > INSERT INTO moz_cookies SELECT . > INSERT INTO moz_cookies DEFAUT_VALUES ??? If those

[sqlite] Documentation bug: lang_insert.html needs examples

file:///usr/share/doc/sqlite3-doc/lang_insert.html says "The INSERT statement comes in three basic forms." OK, but you need to add examples of all three. E.g., you say "The first form (with the "VALUES" keyword)" well there is no example. So near the top of the article add this synopsis of the

[sqlite] Documentation bug: cli.html#csv_import should warn about NULLs

sqlite3-doc/cli.html#csv_import should warn that there is no way to preserve NULL with CSV. You can even add a proof if you want, $ sqlite3 mydata.db

Re: [sqlite] Documentation bug: remove gmane address on Bug Report page

By the way, you might want to unlock http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/ as one can read it on Nabble anyway. Then you could just tell users to see the Archives. ___ sqlite-users mailing list

[sqlite] Documentation bug: remove gmane address on Bug Report page

Please fix https://www.sqlite.org/src/wiki?name=Bug+Reports . It says to see http://news.gmane.org/gmane.comp.db.sqlite.general but that page is no longer working. Maybe tell them to see http://sqlite.1065341.n5.nabble.com/ (But I don't know if that is the canonical URL.)

Re: [sqlite] clusterfuzz-found issue in GDAL, Ubuntu packages

On 7/1/17, Even Rouault wrote: > On samedi 1 juillet 2017 06:07:30 CEST Richard Hipp wrote: >> I'm confused... >> >> Are you reporting that clusterfuzz found a bug in SQLite that was >> fixed in version 3.17.0? > > Seth, I can turn the Launchpad bug report as public if

Re: [sqlite] clusterfuzz-found issue in GDAL, Ubuntu packages

On samedi 1 juillet 2017 06:07:30 CEST Richard Hipp wrote: > I'm confused... > > Are you reporting that clusterfuzz found a bug in SQLite that was > fixed in version 3.17.0? Seth, I can turn the Launchpad bug report as public if you wish. I marked it privately if Ubuntu felt it was better. I

Re: [sqlite] clusterfuzz-found issue in GDAL, Ubuntu packages

I'm confused... Are you reporting that clusterfuzz found a bug in SQLite that was fixed in version 3.17.0? On 6/30/17, Seth Arnold wrote: > Hello; Even Rouault privately reported to Ubuntu Launchpad a bug in > sqlite3 as shipped in Ubuntu 16.04 LTS (and possibly other

[sqlite] clusterfuzz-found issue in GDAL, Ubuntu packages

Hello; Even Rouault privately reported to Ubuntu Launchpad a bug in sqlite3 as shipped in Ubuntu 16.04 LTS (and possibly other releases, so far I've not tested the others). Valgrind reports multiple 1 byte invalid reads. This bug was discovered by Google's clusterfuzz project when fuzzing GDAL.