Re: [sqlite] Problem with DETACH on 2.8.16
Dennis Cote wrote: D. Richard Hipp wrote: On Tue, 2005-09-13 at 09:08 +0200, Laurent wrote: I get the error : Assertion failed: xHash!=0, file hash.c, line 299 Abnormal program termination I tried the same sequence of commands and it worked fine for me. Richard, I can confirm Laurent's problem exists in the 2.8.15 version of the shell under Windows. I have copied a a session log of the commands below: C:\Documents and Settings\DennisC>sqlite x1.dbx SQLite version 2.8.15 Enter ".help" for instructions sqlite> create table documents (a); sqlite> create index i on documents(a); sqlite> .q C:\Documents and Settings\DennisC>sqlite x2.dbx SQLite version 2.8.15 Enter ".help" for instructions sqlite> create table documents (a); sqlite> create index i on documents(a); sqlite> .q C:\Documents and Settings\DennisC>sqlite SQLite version 2.8.15 Enter ".help" for instructions sqlite> attach 'x1.dbx' as d1; sqlite> attach 'x2.dbx' as d2; sqlite> detach d1; Assertion failed: xHash!=0, file ../sqlite/src/hash.c, line 299 This application has requested the Runtime to terminate it in an unusual way. Please contact the application's support team for more information. C:\Documents and Settings\DennisC> I don't have 2.8.16 handy, so I can't try that version. I will try again with latest as well. Dennis Cote This sequence of commands works correctly with sqlite 3.2.2. Dennis Cote
Re: [sqlite] Problem with DETACH on 2.8.16
D. Richard Hipp wrote: On Tue, 2005-09-13 at 09:08 +0200, Laurent wrote: I get the error : Assertion failed: xHash!=0, file hash.c, line 299 Abnormal program termination I tried the same sequence of commands and it worked fine for me. Richard, I can confirm Laurent's problem exists in the 2.8.15 version of the shell under Windows. I have copied a a session log of the commands below: C:\Documents and Settings\DennisC>sqlite x1.dbx SQLite version 2.8.15 Enter ".help" for instructions sqlite> create table documents (a); sqlite> create index i on documents(a); sqlite> .q C:\Documents and Settings\DennisC>sqlite x2.dbx SQLite version 2.8.15 Enter ".help" for instructions sqlite> create table documents (a); sqlite> create index i on documents(a); sqlite> .q C:\Documents and Settings\DennisC>sqlite SQLite version 2.8.15 Enter ".help" for instructions sqlite> attach 'x1.dbx' as d1; sqlite> attach 'x2.dbx' as d2; sqlite> detach d1; Assertion failed: xHash!=0, file ../sqlite/src/hash.c, line 299 This application has requested the Runtime to terminate it in an unusual way. Please contact the application's support team for more information. C:\Documents and Settings\DennisC> I don't have 2.8.16 handy, so I can't try that version. I will try again with latest as well. Dennis Cote
Re: [sqlite] Problem with DETACH on 2.8.16
Hello Richard,I'm sorry, but if I do :1. Create a new directory.2. Download sqlite 2.8.16 (Windows version for sqlite.org).3. Create 2 files script1 and script2 (see attached):4. Run the commands: sqlite x1.dbx sqlite x2.dbx sqlite myfileI get this error on Windows XP and Windows W2K.Best regards,Laurent.=== attach 'x1.dbx' as d1; attach 'x2.dbx' as d2; detach d1; create table documents (a); create index i on documents(a);
Re: [sqlite] Problem with DETACH on 2.8.16
On Tue, 2005-09-13 at 09:08 +0200, Laurent wrote: > I get the error : > >Assertion failed: xHash!=0, file hash.c, line 299 >Abnormal program termination > I tried the same sequence of commands and it worked fine for me. -- D. Richard Hipp <[EMAIL PROTECTED]>
[sqlite] Problem with DETACH on 2.8.16
Hello, I'm using sqlite 2.8.16. I have 2 databases, x1.dbx and x2.dbx, created with the same commands: create table documents (a); create index i on documents(a); Then, if I run : attach 'x1.dbx' as d1; attach 'x2.dbx' as d2; detach d1; I get the error : Assertion failed: xHash!=0, file hash.c, line 299 Abnormal program termination This error will occur using the command line (under Windows) or the DLL. Could you please check. Thanks in advance. Laurent.