Re: [sqlite] Please confirm this is a bug !

2004-07-23 Thread D. Richard Hipp
Andrew Clark wrote: Not knowing the code that well but guessing I would say that because the statements are on a single line I believe maybe the SQL interpreter is reading the BEGIN (start a transaction) but not reading the rest of the commands when an error occurs and therefore doesn't see the

[sqlite] Please confirm this is a bug !

2004-07-23 Thread Andrew Clark
Hi, Using the C API if i submit the statements: BEGIN; CREATE TABLE test (id, name); COMMIT; within a single Exec command (or as a single line on the command line tool) then it works the first time and displays an error the second time as expected due to the table already existing. However,