On 25 Jun 2012, at 1:24pm, "Black, Michael (IS)" <michael.bla...@ngc.com> wrote:
> I'd be surprised if the shell behaves differently on the Mac...that' s just > Unix-like under the hood so I'd figure it would act just like Linux. Does > the shell compile differently for Mac? I can tell you about 3.7.12 on a Mac. Starting the shell tool with something like sqlite3 ~/Desktop/test.sqlite and then quitting does not make a file. Issuing '.tables' makes a file which is zero bytes long. Issuing instead a SELECT command on either sqlite_master or any other TABLE (which, of course, doesn't exist) also makes a file which is zero bytes long. I'm not sure about the semantics of making a zero byte file. It doesn't agree with the SQLite documentation in that that states that every file should have the header, but it doesn't seem to actually cause any problems if you have SQLite to open the database later. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
