Bug#502370: sqlite3: missing output for select 100/1.5

2008-10-17 Thread Ansgar Burchardt 
retitle 502370 sqlite3: Should depend on newer libsqlite3-0
severity 502370 important
thanks

Mark Ng wrote:
 On Fri, Oct 17, 2008 at 08:53, Ansgar Burchardt [EMAIL PROTECTED]wrote:
  You problem with SQLite should have been fixed in 3.5.9-4 [1], but you
  somehow still have an older version of libsqlite3-0 installed.
 
 that was because I encounter the bug in 3.5.9-3 then did a upgrade install
 of sqlite3, but that didn't upgrade libsqlite3-0.  Maybe update the
 dependencies?

That sounds like a good idea to me, but should not be release critical.

Regards,
Ansgar

-- 
PGP: 1024D/595FAD19  739E 2D09 0969 BEA9 9797  B055 DDB0 2FF7 595F AD19




-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]

Bug#502370: sqlite3: missing output for select 100/1.5;

2008-10-16 Thread Dmitry E. Oboukhov 
unreproducible on my system :)

$ sqlite3  
SQLite version 3.5.9
Enter .help for instructions
sqlite select 100/2.5;
40.0
sqlite select 100/2;
50
sqlite select 100/3;
33
sqlite select 100/3.1;
32.258064516129
sqlite select 100/1.5;
66.7
sqlite select 100/1.25;
80.0

MNVersions of packages sqlite3 depends on:
MN ii  libc6  2.7-13 GNU C Library: Shared libraries
MN ii  libreadline5   5.2-3  GNU readline and history libraries
MN ii  libsqlite3-0   3.5.9-3SQLite 3 shared library

lenny contains libsqlite3-0 version 3.5.9-5, your system - 3.5.9-3


--
... mpd is off

. ''`.   Dmitry E. Oboukhov
: :’  :   email: [EMAIL PROTECTED] jabber://[EMAIL PROTECTED]
`. `~’  GPGKey: 1024D / F8E26537 2006-11-21
  `- 1B23 D4F8 8EC0 D902 0555  E438 AB8C 00CF F8E2 6537


signature.asc
Description: Digital signature

Bug#502370: sqlite3: missing output for select 100/1.5;

2008-10-16 Thread Dmitry E. Oboukhov 

MN Versions of packages sqlite3 depends on:
MN ii  libc6  2.7-13 GNU C Library: Shared libraries
MN ii  libreadline5   5.2-3  GNU readline and history libraries
MN ii  libsqlite3-0   3.5.9-3SQLite 3 shared library

DEO lenny contains libsqlite3-0 version 3.5.9-5, your system - 3.5.9-3

may be package needs to change the depends?

for example:

--- debian/control  2008-10-16 11:08:02.0 +0400
+++ debian/control.new  2008-10-16 11:12:31.0 +0400
@@ -22,7 +22,7 @@
 Package: sqlite3
 Section: misc
 Architecture: any
-Depends: ${shlibs:Depends}
+Depends: ${shlibs:Depends}, libsqlite3-0 (= ${binary:Version})
 Suggests: sqlite3-doc
 Description: A command line interface for SQLite 3
  SQLite is a C library that implements an SQL database engine. 

--
... mpd is off

. ''`.   Dmitry E. Oboukhov
: :’  :   email: [EMAIL PROTECTED] jabber://[EMAIL PROTECTED]
`. `~’  GPGKey: 1024D / F8E26537 2006-11-21
  `- 1B23 D4F8 8EC0 D902 0555  E438 AB8C 00CF F8E2 6537


signature.asc
Description: Digital signature

Bug#502370: sqlite3: missing output for select 100/1.5

2008-10-16 Thread Ansgar Burchardt 
Hi,

You problem with SQLite should have been fixed in 3.5.9-4 [1], but you
somehow still have an older version of libsqlite3-0 installed.

Can you install the libsqlite3-0 package from testing (currently
3.5.9-4) and try again?

Regards,
Ansgar

[1] http://bugs.debian.org/488864

-- 
PGP: 1024D/595FAD19  739E 2D09 0969 BEA9 9797  B055 DDB0 2FF7 595F AD19




-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]

Bug#502370: sqlite3: missing output for select 100/1.5;

2008-10-15 Thread Mark Ng 
Package: sqlite3
Version: 3.5.9-5
Severity: serious



SQLite3 doesn't return values for some divisions. 100/1.5, 100/3.1 returns
no output.


; sqlite3
SQLite version 3.5.9
Enter .help for instructions
sqlite select 100/1.5;

sqlite select 100/2.5;
40.0
sqlite select 100/2;
50
sqlite select 100/3;
33
sqlite select 100/3.1;

sqlite select 100/1.5;

sqlite select 100/1.25;
80.0


... it doesn't work as it should compared to in sqlite2

; sqlite
SQLite version 2.8.17
Enter .help for instructions
sqlite select 100/1.25;
80
sqlite select 100/1.5;
66.7
sqlite select 100/1.25;
80
sqlite select 100/3;
33
sqlite select 100/3.0;
33.3
sqlite select 100/3.1;
32.258064516129
sqlite




-- System Information:
Debian Release: lenny/sid
  APT prefers testing
  APT policy: (500, 'testing')
Architecture: i386 (i686)

Kernel: Linux 2.6.22tickless
Locale: LANG=en_AU.UTF-8, LC_CTYPE=en_AU.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash

Versions of packages sqlite3 depends on:
ii  libc6 2.7-13 GNU C Library: Shared libraries
ii  libreadline5  5.2-3  GNU readline and history
libraries
ii  libsqlite3-0  3.5.9-3SQLite 3 shared library

sqlite3 recommends no packages.

Versions of packages sqlite3 suggests:
ii  sqlite3-doc   3.5.9-3SQLite 3 documentation

-- no debconf information