Hi,
a)I want to use sqlite library in my project software.In the website it is
listed as TH3 achieves 100% branch test coverage.I want all the test
results of the SQLite software which shows that the software has *100%
statement+branch coverage*.Can any one tell me how to get these test
results ??
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 23/06/14 23:09, Kishore Reddy wrote:
a)I want to use sqlite library in my project software.In the website it
is listed as TH3 achieves 100% branch test coverage.
The SQLite software as released has already been tested with TH3 and
passed. You
Jerry Krinock wrote:
On 2014 Jun 23, at 21:49, Igor Tandetnik i...@tandetnik.org wrote:
The data corruption happens to affect the area of the file where
this index is stored.
The culprit is byte 2048, the first byte in the 3rd page. In the Good
file, it is 0x0A and in the Bad file, its
On Mon, 23 Jun 2014 20:16:44 -0700
Jerry Krinock je...@ieee.org wrote:
How can it be that adding a WHERE clause to a successful query causes
‘database disk image is malformed’?
My database has one table named `itemTable`. This table has two
columns, `key` which is type text and `value`
Hi all,
I have some rows in a table (not very many, typically less than 20) and I
want to generate a unique, sequential number for each row. In another dbms
I've used a row_number function (amongst others) to achieve this but I can't
see anything with equivalent functionality in sqlite3. My
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 24/06/14 13:02, Dave Wellman wrote:
I have some rows in a table (not very many, typically less than 20) and
I want to generate a unique, sequential number for each row.
http://www.sqlite.org/autoinc.html
Roger
-BEGIN PGP SIGNATURE-
(I think it’s cleaner to reply to three replies in one message; here goes…)
On 2014 Jun 23, at 22:43, Keith Medcalf kmedc...@dessus.com wrote:
Unique is implemented (as it must be) via a unique index.
Very good, Keith. So my database *does* have an index.
You should be able to rebuild the
On Tue, Jun 24, 2014 at 4:29 PM, Jerry Krinock je...@ieee.org wrote:
Thank you, Clemens. 0x0A=index. 0x0D=table. I suppose that is a
sensible re-use of “carrige return” and “line feed”.
Indexes and tables can have several different initial bytes, depending on
circumstances. Any
Hi Roger,
Many thanks for that, I think its close to what I'm looking for. However,
according to that document page the autoincr feature doesn't gaurantee
'sequential' numbers. Included in that page is the following:
Note that monotonically increasing does not imply that the ROWID always
On Jun 24, 2014, at 10:47 PM, Dave Wellman dwell...@ward-analytics.com wrote:
I need the values to be sequential.
Well… if your data set is as small as you mentioned (20 records or less)… you
could roll your own numbering schema with the simple expedient of attaching a
trigger to your tables
On 25/06/2014, at 8:29 am, Jerry Krinock je...@ieee.org wrote:
On 2014 Jun 24, at 00:06, Clemens Ladisch clem...@ladisch.de wrote:
Is there any other 0x0A byte in the good file?
No, only that one.
That leads to a plausible theory: had you done anything with the good
database along the
SqliteAdmin V 1.3.5 is now available for download at
www.lcsql.com/sqliteadmin.html.
This version includes support for several recent language additions such as
CREATE TABLE WITHOUT ROWID and the CREATE INDEX WHERE clause. Several other
enhancements are included and the full release notes can be
SELECT * FROM itemTable WHERE +key = 'profileName' ;
Note the + sign - this suppresses the use of index.
--
Igor Tandetnik
That's really interesting - I've never seen that use of the + sign
mentioned in the docs.
Pete
lcSQL Software http://www.lcsql.com
Home of lcStackBrowser
On 6/24/2014 6:04 PM, Peter Haworth wrote:
SELECT * FROM itemTable WHERE +key = 'profileName' ;
Note the + sign - this suppresses the use of index.
That's really interesting - I've never seen that use of the + sign
mentioned in the docs.
http://www.sqlite.org/optoverview.html
To be usable
On 24 Jun 2014, at 9:47pm, Dave Wellman dwell...@ward-analytics.com wrote:
Included in that page is the following:
Note that monotonically increasing does not imply that the ROWID always
increases by exactly one. One is the usual increment. However, if an insert
fails due to (for example)
On 2014 Jun 24, at 14:46, David Empson demp...@emptech.co.nz wrote:
The most likely explanation is that it got processed by something which
thought it should be treated as ASCII text and was doing a spurious LF-to-CR
translation. If there was only one 0x0A byte in the good file, then that
16 matches
Mail list logo