Package: libsqlite3-0
Version: 3.5.9-3
Severity: grave
Justification: causes non-serious data loss
The following series of statements produces incorrect results in version
3.5.9 of sqlite:
CREATE TABLE foo(foo TEXT);
INSERT INTO foo VALUES ('a');
INSERT INTO foo VALUES ('b');
CREATE INDEX foo_foo ON foo(foo);
SELECT DISTINCT foo FROM foo WHERE foo IS NOT NULL;
[EMAIL PROTECTED]:~> sqlite3 < ~/foo.sql
b
The correct results are:
[EMAIL PROTECTED]:~> ./sqlite3-3.6.0.bin < ~/foo.sql
a
b
The underlying table is unaffected, so there is no direct data loss, but
implicit data loss may occur as a result of applications receiving
incomplete data in response to their queries, so I believe the grave
severity is justified.
-- System Information:
Debian Release: lenny/sid
APT prefers unstable
APT policy: (500, 'unstable'), (500, 'testing'), (1, 'experimental')
Architecture: amd64 (x86_64)
Kernel: Linux 2.6.26-1-amd64 (SMP w/1 CPU core)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Versions of packages libsqlite3-0 depends on:
ii libc6 2.7-13 GNU C Library: Shared libraries
libsqlite3-0 recommends no packages.
libsqlite3-0 suggests no packages.
-- no debconf information
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
