Re: [sqlite] Problems (maybe a bug) when creating a backup using the command line interface '.backup' command

On 12/21/2012 05:18 PM, Dan Kennedy wrote: Thanks. I think it's this: http://www.sqlite.org/src/info/0cfd98ee20 Dan. Thanks. I have looked into ticket, but we also see this problem when the backup is written and read by the same SQLite version (3.7.5). I have recreated a backup using the

Re: [sqlite] Problems (maybe a bug) when creating a backup using the command line interface '.backup' command

On 01/02/2013 03:27 PM, Marco ten Thije wrote: On 12/21/2012 05:18 PM, Dan Kennedy wrote: Thanks. I think it's this: http://www.sqlite.org/src/info/0cfd98ee20 Dan. Thanks. I have looked into ticket, but we also see this problem when the backup is written and read by the same SQLite version

Re: [sqlite] Problems (maybe a bug) when creating a backup using the command line interface '.backup' command

On 01/02/2013 10:04 AM, Dan Kennedy wrote: What series of commands did you pass to 3.7.5 to create this file? This file was copied from an existing product which uses QT 4.7 libraries to populate the database. I cannot reproduce the exact commands which resulted in this file, because it is

Re: [sqlite] Multi-column index is not used with IN operator

Hi Richard, I tested the whole scenario one more time with the new SQLite version. As you suggested I put a plus sign in front of the Flag column and that really made the query much faster by using the multi column index (Tag, Flag, Id) instead of the primary index on the Id column. However

[sqlite] Full trace(s) of the CREATE, INSERT and SELECT functionalities of Sqlite

Dear members, We are still working on an SQLITE project; the primary focus at this point is to get a flow of execution for each of the the following commands:   CREATE TABLE , INSERT into (table) SELECT * (from table)   We are interested in the complete flow (from beginning to end) for each of

[sqlite] why i get the value of ROWID is equal to the value of field created as Primary key?

i create a table in sqlite3 with the SQL query: "CREATE TABLE a(sn INTEGER primary key, name TEXT)". and add some records as follows, sn | name 11 | Jos 13 | Mar 15 | Sor using SQL query: "SELECT * FROM a", i get the number of fields is 2. it is normal,

Re: [sqlite] why i get the value of ROWID is equal to the value of field created as Primary key?

On Wed, Jan 2, 2013 at 2:00 AM, genliu777 wrote: > is it the meaning of "the field created as INTEGER primary > is alias to the hidden ROWID field"? > 3rd paragraph in http://www.sqlite.org/lang_createtable.html#rowid -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Full trace(s) of the CREATE, INSERT and SELECT functionalities of Sqlite

On 1/1/2013 7:52 PM, u okafor wrote: We are interested in the complete flow (from beginning to end) for each of them. We use Visual Studio 2008 ide and the information we seek is similar to what is available in the Call Stack (see sample stack below). Unfortunately, the Call Stack does not go

Re: [sqlite] Problems (maybe a bug) when creating a backup using the command line interface '.backup' command

On 01/02/2013 11:03 AM, Marco ten Thije wrote: On 01/02/2013 10:04 AM, Dan Kennedy wrote: What series of commands did you pass to 3.7.5 to create this file? This file was copied from an existing product which uses QT 4.7 libraries to populate the database. I cannot reproduce the exact

[sqlite] Why does an undefined function call in a check constraint cause selecting from sqlite_master fail?

I'm a bit puzzled by this behavior.  If you define your own function, and reference it in a check constraint, and then try to select from sqlite_master, the select fails with Error: malformed database schema.  I've noticed this since 3.7.2 and it still happens at 3.7.15.1. Example (hopefully