Re: [sqlite] parameters in a view, disallowed? (docs issue)

2012-12-21 Thread Kevin Benson
On Fri, Dec 21, 2012 at 12:53 AM, Larry Brasfield wrote: > On 12/20/2012 4:10 PM, Larry Brasfield wrote: >> > Igor Tandetnik wrote: >> [regarding where parameters allowed, "where literals are"] >> >> > >> >> > How did you discern this? >> >> >> >> I know from

[sqlite] instr() documentation error

2012-12-21 Thread Bernd
I think there is a documentation error on http://sqlite.org/lang_corefunc.html for the instr() function. The site says: The instr(X,Y) function finds the first occurrence of string X within string Y ... where it should be ...finds the first occurrence of string Y within string X... Thanks,

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

2012-12-21 Thread Marco ten Thije
Hello, We are facing a problem with the '.backup' command using the SQLite command line interface. The resulting backup-database seems to be corrupt. We ran into this problem on a ARM9 platform using SQLite 3.7.5, but it can also be reproduced on the latest 3.7.15.1 version on Intel. I

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

2012-12-21 Thread Eric Minbiole
Can you please try running "pragma integrity_check;" on the original database? That will give an indication of whether the original database has any data corruption. On Fri, Dec 21, 2012 at 4:13 AM, Marco ten Thije < marco.tenth...@usetechnology.nl> wrote: > Hello, > > We are facing a problem

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

2012-12-21 Thread Marco ten Thije
It returns 'ok': ./sqlite3 energy.sqlite SQLite version 3.7.15.1 2012-12-19 20:39:10 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> pragma integrity_check; ok sqlite> So, the original database looks ok. I have compared the two databases (original and backup)

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

2012-12-21 Thread Dan Kennedy
On 12/21/2012 08:46 PM, Marco ten Thije wrote: It returns 'ok': ./sqlite3 energy.sqlite SQLite version 3.7.15.1 2012-12-19 20:39:10 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> pragma integrity_check; ok sqlite> So, the original database looks ok. I have

Re: [sqlite] Suggested SQLite benchmarks?

2012-12-21 Thread Simon Slavin
On 20 Dec 2012, at 11:16pm, Arun Jagatheesan wrote: > Are there any community standard benchmarks (scripts) that are more > sqlite oriented available? If you're looking for speed tests, then there isn't really anything relevant. The amount of time SQLite

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

2012-12-21 Thread Marco ten Thije
What is the size of the two database files? The size of both files is 160768 bytes. Also, can we have the first 6 lines of each hex dump (i.e. enough to see the first 100 bytes)? The first bytes of the original database: 000 5153 694c 6574 6620 726f 616d 2074 0033 010 0004 0101

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

2012-12-21 Thread Dan Kennedy
On 12/21/2012 10:54 PM, Marco ten Thije wrote: What is the size of the two database files? The size of both files is 160768 bytes. Also, can we have the first 6 lines of each hex dump (i.e. enough to see the first 100 bytes)? The first bytes of the original database: 000 5153 694c