Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix handling of text and blob values in the sum() function. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
a43972e1eba46321e2b9d117bfccee05 |
| User & Date: | dan 2013-06-03 06:45:31 |
Context
|
2013-06-03
| ||
| 11:47 | Modify the round() and abs() SQL functions to use decimal arithmetic. check-in: 7b3bb63808 user: dan tags: trunk | |
| 06:45 | Fix handling of text and blob values in the sum() function. check-in: a43972e1eb user: dan tags: trunk | |
|
2013-06-01
| ||
| 20:34 | Use decimal arithmetic in the sum(), total() and avg() functions. check-in: 23ded9b859 user: dan tags: trunk | |
Changes
Changes to src/func.c.
1189 1190 1191 1192 1193 1194 1195 1196 1197 1198 1199 1200 1201 1202 1203 |
assert( argc==1 );
UNUSED_PARAMETER(argc);
p = sqlite4_aggregate_context(context, sizeof(*p));
type = sqlite4_value_numeric_type(argv[0]);
if( p && type!=SQLITE4_NULL ){
p->cnt++;
p->sum = sqlite4_num_add(p->sum, sqlite4_value_num(argv[0]));
if( type==SQLITE4_FLOAT ){
p->approx = 1;
}
}
}
static void sumFinalize(sqlite4_context *context){
SumCtx *p;
p = sqlite4_aggregate_context(context, 0);
|
| |
1189 1190 1191 1192 1193 1194 1195 1196 1197 1198 1199 1200 1201 1202 1203 |
assert( argc==1 );
UNUSED_PARAMETER(argc);
p = sqlite4_aggregate_context(context, sizeof(*p));
type = sqlite4_value_numeric_type(argv[0]);
if( p && type!=SQLITE4_NULL ){
p->cnt++;
p->sum = sqlite4_num_add(p->sum, sqlite4_value_num(argv[0]));
if( type!=SQLITE4_INTEGER ){
p->approx = 1;
}
}
}
static void sumFinalize(sqlite4_context *context){
SumCtx *p;
p = sqlite4_aggregate_context(context, 0);
|