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 |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
a43972e1eba46321e2b9d117bfccee05 |
User & Date: | dan 2013-06-03 06:45:31.295 |
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 | 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])); | | | 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); |
︙ | ︙ |