Skip Menu |

This queue is for tickets about the DBD-SQLite CPAN distribution.

Report information
The Basics
Id: 18008
Status: rejected
Worked: 15 min
Priority: 0/
Queue: DBD-SQLite
People
Owner: Nobody in particular
Requestors: SCRESTO [...] cpan.org
Cc: matt [...] sergeant.org
AdminCc:
Bug Information
Severity: Normal
Broken in: 1.11
Fixed in: (no value)

History Show all quoted text
  Mon Mar 06 07:29:03 2006 SCRESTO [...] cpan.org - Ticket created
CC: matt [...] sergeant.org
Subject: SUM returns truncated values with CHAR columns
SUM returns truncated values with CHAR columns. Exemple: create table test (v varchar(50)); insert into test values ('0.10'); insert into test values ('0.35'); With sqlite3 "select sum(v) from test" return 0.45. Same with DBD::SQLite return 0.
  Mon Mar 06 07:34:54 2006 SCRESTO [...] cpan.org - Correspondence added 15 min
This problem is in func.c file. Here a patch to fix this problem and an already patched "func.c" file.
837c837 < if( type==SQLITE_FLOAT ){ --- > if( type==SQLITE_FLOAT || type==SQLITE_TEXT ){ 839c839 < } --- > }

Message body is not shown because it is too large.

  Mon Mar 06 07:34:59 2006 SCRESTO [...] cpan.org - Status changed from 'new' to 'open'
  Thu Sep 07 23:51:36 2006 msergeant [...] cpan.org - Correspondence added
If the problem is in func.c, then that's in sqlite core. Please file the bug with them, not me.
  Thu Sep 07 23:51:37 2006 msergeant [...] cpan.org - Status changed from 'open' to 'rejected'