Re: [sqlite] Backwards compatibility from 3.8.4.3 to 3.6.20

2014-04-07 Thread Richard Hipp
On Mon, Apr 7, 2014 at 10:48 AM, RSmith wrote: > On 2014/04/07 16:44, Richard Hipp wrote: > >> On Mon, Apr 7, 2014 at 10:41 AM, Alejandro Santos > >wrote: >> >> On Mon, Apr 7, 2014 at 3:32 PM, Alejandro Santos >>> wrote: >>>

Re: [sqlite] Backwards compatibility from 3.8.4.3 to 3.6.20

2014-04-07 Thread RSmith
On 2014/04/07 16:44, Richard Hipp wrote: On Mon, Apr 7, 2014 at 10:41 AM, Alejandro Santos wrote: On Mon, Apr 7, 2014 at 3:32 PM, Alejandro Santos wrote: Changing the journal_mode does not solve my issue :( A self contained test case: $

Re: [sqlite] Backwards compatibility from 3.8.4.3 to 3.6.20

2014-04-07 Thread Richard Hipp
On Mon, Apr 7, 2014 at 10:41 AM, Alejandro Santos wrote: > On Mon, Apr 7, 2014 at 3:32 PM, Alejandro Santos > wrote: > > > > Changing the journal_mode does not solve my issue :( > > > > A self contained test case: > > $ LD_LIBRARY_PATH= ./sqlite3

Re: [sqlite] Backwards compatibility from 3.8.4.3 to 3.6.20

2014-04-07 Thread Alejandro Santos
On Mon, Apr 7, 2014 at 3:32 PM, Alejandro Santos wrote: > > Changing the journal_mode does not solve my issue :( > A self contained test case: $ LD_LIBRARY_PATH= ./sqlite3 /tmp/broken2.sqlite SQLite version 3.8.4.3 2014-04-03 16:53:12 Enter ".help" for usage hints. sqlite>

Re: [sqlite] Backwards compatibility from 3.8.4.3 to 3.6.20

2014-04-07 Thread Alejandro Santos
On Mon, Apr 7, 2014 at 11:47 AM, Alejandro Santos wrote: > Hi, > > I've been using latest v3.8.4.3 to write a database file, but when I > try to open the file with my current distro's sqlite shell I get this > error: > For some reason I can see Richard Hipp answer on the Web

Re: [sqlite] Backwards compatibility from 3.8.4.3 to 3.6.20

2014-04-07 Thread Richard Hipp
On Mon, Apr 7, 2014 at 5:47 AM, Alejandro Santos wrote: > Hi, > > I've been using latest v3.8.4.3 to write a database file, but when I > try to open the file with my current distro's sqlite shell I get this > error: > > $ sqlite3 file.sqlite > SQLite version 3.6.20 > Enter

[sqlite] Backwards compatibility from 3.8.4.3 to 3.6.20

2014-04-07 Thread Alejandro Santos
Hi, I've been using latest v3.8.4.3 to write a database file, but when I try to open the file with my current distro's sqlite shell I get this error: $ sqlite3 file.sqlite SQLite version 3.6.20 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .schema Error: file

Re: [sqlite] backwards compatibility

2006-04-16 Thread Michael P. Soulier
On 16/04/06 [EMAIL PROTECTED] said: > 3.3.5 is backwards compatible. It will read and write a 3.2.2 > database file. But 3.2.2 is not forwards compatible to 3.3.5. > > SQLite 3 will always be backwards compatible. Forwards compatibility > is a goal but is not guaranteed. Ah, right. > If you

Re: [sqlite] backwards compatibility

2006-04-16 Thread Derrell . Lipman
"Michael P. Soulier" <[EMAIL PROTECTED]> writes: > Hello, > > I just got a nasty surprise. I installed an sqlite 3.3.5 .dll on windows with > pysqlite2, and I used an application to create a database file. I then scp'd > the file home to my linux box where I have sqlite 3.2.2 installed, and I got

[sqlite] backwards compatibility

2006-04-16 Thread Michael P. Soulier
Hello, I just got a nasty surprise. I installed an sqlite 3.3.5 .dll on windows with pysqlite2, and I used an application to create a database file. I then scp'd the file home to my linux box where I have sqlite 3.2.2 installed, and I got this: sqlite> .tables Error: unsupported file format