• Home
  • Features
  • Pricing
  • Docs
  • Announcements
  • Sign In

taosdata / TDengine / #4799

13 Oct 2025 06:50AM UTC coverage: 58.524% (+0.09%) from 58.433%
#4799

push

travis-ci

web-flow
Merge pull request #33213 from taosdata/fix/huoh/timemoe_model_directory

fix: fix tdgpt timemoe model directory

139292 of 303332 branches covered (45.92%)

Branch coverage included in aggregate %.

210815 of 294900 relevant lines covered (71.49%)

23992095.37 hits per line

Source File
Press 'n' to go to next uncovered line, 'b' for previous

66.42
/source/libs/function/src/detail/tavgfunction.c
1
/*
2
 * Copyright (c) 2019 TAOS Data, Inc. <jhtao@taosdata.com>
3
 *
4
 * This program is free software: you can use, redistribute, and/or modify
5
 * it under the terms of the GNU Affero General Public License, version 3
6
 * or later ("AGPL"), as published by the Free Software Foundation.
7
 *
8
 * This program is distributed in the hope that it will be useful, but WITHOUT
9
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
10
 * FITNESS FOR A PARTICULAR PURPOSE.
11
 *
12
 * You should have received a copy of the GNU Affero General Public License
13
 * along with this program. If not, see <http://www.gnu.org/licenses/>.
14
 */
15

16
#include "builtinsimpl.h"
17
#include "function.h"
18
#include "tdatablock.h"
19
#include "tfunctionInt.h"
20
#include "tglobal.h"
21

22
#define SET_VAL(_info, numOfElem, res) \
23
  do {                                 \
24
    if ((numOfElem) <= 0) {            \
25
      break;                           \
26
    }                                  \
27
    (_info)->numOfRes = (res);         \
28
  } while (0)
29

30
#define LIST_AVG_N(sumT, T)                                               \
31
  do {                                                                    \
32
    T* plist = (T*)pCol->pData;                                           \
33
    for (int32_t i = start; i < numOfRows + pInput->startRowIndex; ++i) { \
34
      if (colDataIsNull_f(pCol, i)) {                         \
35
        continue;                                                         \
36
      }                                                                   \
37
                                                                          \
38
      numOfElem += 1;                                                     \
39
      pAvgRes->count -= 1;                                                \
40
      sumT -= plist[i];                                                   \
41
    }                                                                     \
42
  } while (0)
43

44
// define signed number sum with check overflow
45
#define CHECK_OVERFLOW_SUM_SIGNED(pAvgRes, val)                                    \
46
  do {                                                                             \
47
    SAvgRes* out = pAvgRes;                                                        \
48
    if (out->sum.overflow) {                                                       \
49
      out->sum.dsum += val;                                                        \
50
    } else if (out->sum.isum > 0 && val > 0 && INT64_MAX - out->sum.isum <= val || \
51
               out->sum.isum < 0 && val < 0 && INT64_MIN - out->sum.isum >= val) { \
52
      double dsum = (double)out->sum.isum;                                         \
53
      out->sum.overflow = true;                                                    \
54
      out->sum.dsum = dsum + val;                                                  \
55
    } else {                                                                       \
56
      out->sum.isum += val;                                                        \
57
    }                                                                              \
58
  } while (0)
59

60
// val is big than INT64_MAX, val come from merge
61
#define CHECK_OVERFLOW_SUM_SIGNED_BIG(pAvgRes, val, big)                                  \
62
  do {                                                                                    \
63
    SAvgRes* out = pAvgRes;                                                               \
64
    if (out->sum.overflow) {                                                              \
65
      out->sum.dsum += val;                                                               \
66
    } else if (out->sum.isum > 0 && val > 0 && INT64_MAX - out->sum.isum <= val ||        \
67
               out->sum.isum < 0 && val < 0 && INT64_MIN - out->sum.isum >= val || big) { \
68
      double dsum = (double)out->sum.isum;                                                \
69
      out->sum.overflow = true;                                                           \
70
      out->sum.dsum = dsum + val;                                                         \
71
    } else {                                                                              \
72
      SUM_RES_INC_ISUM(&AVG_RES_GET_SUM(out), val);                                       \
73
    }                                                                                     \
74
  } while (0)
75

76
// define unsigned number sum with check overflow
77
#define CHECK_OVERFLOW_SUM_UNSIGNED(pAvgRes, val)   \
78
  do {                                              \
79
    SAvgRes* out = pAvgRes;                         \
80
    if (out->sum.overflow) {                        \
81
      out->sum.dsum += val;                         \
82
    } else if (UINT64_MAX - out->sum.usum <= val) { \
83
      double dsum = (double)out->sum.usum;          \
84
      out->sum.overflow = true;                     \
85
      out->sum.dsum = dsum + val;                   \
86
    } else {                                        \
87
      out->sum.usum += val;                         \
88
    }                                               \
89
  } while (0)
90

91
// val is big than UINT64_MAX, val come from merge
92
#define CHECK_OVERFLOW_SUM_UNSIGNED_BIG(pAvgRes, val, big) \
93
  do {                                                     \
94
    SAvgRes* out = pAvgRes;                                \
95
    if (out->sum.overflow) {                               \
96
      out->sum.dsum += val;                                \
97
    } else if (UINT64_MAX - out->sum.usum <= val || big) { \
98
      double dsum = (double)out->sum.usum;                 \
99
      out->sum.overflow = true;                            \
100
      out->sum.dsum = dsum + val;                          \
101
    } else {                                               \
102
      out->sum.usum += val;                                \
103
    }                                                      \
104
  } while (0)
105

106
int32_t getAvgInfoSize(SFunctionNode* pFunc) {
114,763✔
107
  if (pFunc->pSrcFuncRef) return AVG_RES_GET_SIZE(pFunc->pSrcFuncRef->srcFuncInputType.type);
114,763!
108
  return AVG_RES_GET_SIZE(pFunc->srcFuncInputType.type);
114,639!
109
}
110

111
bool getAvgFuncEnv(SFunctionNode* pFunc, SFuncExecEnv* pEnv) {
114,645✔
112
  pEnv->calcMemSize =getAvgInfoSize(pFunc);
114,645✔
113
  return true;
114,729✔
114
}
115

116
int32_t avgFunctionSetup(SqlFunctionCtx* pCtx, SResultRowEntryInfo* pResultInfo) {
10,562,289✔
117
  if (pResultInfo->initialized) {
10,562,289!
118
    return TSDB_CODE_SUCCESS;
×
119
  }
120
  if (TSDB_CODE_SUCCESS != functionSetup(pCtx, pResultInfo)) {
10,562,289!
121
    return TSDB_CODE_FUNC_SETUP_ERROR;
×
122
  }
123

124
  void* pRes = GET_ROWCELL_INTERBUF(pResultInfo);
10,563,023✔
125
  (void)memset(pRes, 0, pCtx->resDataInfo.interBufSize);
10,563,023✔
126
  return TSDB_CODE_SUCCESS;
10,563,023✔
127
}
128

129
static int32_t calculateAvgBySMAInfo(void* pRes, int32_t numOfRows, int32_t type, const SColumnDataAgg* pAgg, int32_t* pNumOfElem) {
580✔
130
  int32_t numOfElem = numOfRows - pAgg->numOfNull;
580✔
131

132
  AVG_RES_INC_COUNT(pRes, type, numOfElem);
580!
133
  if (IS_SIGNED_NUMERIC_TYPE(type)) {
580!
134
    CHECK_OVERFLOW_SUM_SIGNED(pRes, pAgg->sum);
580!
135
  } else if (IS_UNSIGNED_NUMERIC_TYPE(type)) {
×
136
    CHECK_OVERFLOW_SUM_UNSIGNED(pRes, pAgg->sum);
×
137
  } else if (IS_FLOAT_TYPE(type)) {
×
138
    SUM_RES_INC_DSUM(&AVG_RES_GET_SUM(pRes), GET_DOUBLE_VAL((const char*)&(pAgg->sum)));
×
139
  } else if (IS_DECIMAL_TYPE(type)) {
×
140
    bool overflow = pAgg->overflow;
×
141
    if (overflow) return TSDB_CODE_DECIMAL_OVERFLOW;
×
142
    SUM_RES_INC_DECIMAL_SUM(&AVG_RES_GET_DECIMAL_SUM(pRes), &pAgg->decimal128Sum, TSDB_DATA_TYPE_DECIMAL);
×
143
    if (overflow) return TSDB_CODE_DECIMAL_OVERFLOW;
×
144
  }
145

146
  *pNumOfElem = numOfElem;
580✔
147
  return 0;
580✔
148
}
149

150
static int32_t doAddNumericVector(SColumnInfoData* pCol, int32_t type, SInputColumnInfoData *pInput, void* pRes, int32_t* pNumOfElem) {
16,775,129✔
151
  int32_t start = pInput->startRowIndex;
16,775,129✔
152
  int32_t numOfRows = pInput->numOfRows;
16,775,129✔
153
  int32_t numOfElems = 0;
16,775,129✔
154

155
  switch (type) {
16,775,129!
156
    case TSDB_DATA_TYPE_TINYINT: {
1,409,502✔
157
      int8_t* plist = (int8_t*)pCol->pData;
1,409,502✔
158
      for (int32_t i = start; i < numOfRows + start; ++i) {
4,910,555✔
159
        if (colDataIsNull_f(pCol, i)) {
3,501,053✔
160
          continue;
1,985,754✔
161
        }
162

163
        numOfElems += 1;
1,515,299✔
164
        AVG_RES_INC_COUNT(pRes, TSDB_DATA_TYPE_TINYINT, 1);
1,515,299✔
165
        CHECK_OVERFLOW_SUM_SIGNED(pRes, plist[i]);
1,515,299!
166
      }
167

168
      break;
1,409,502✔
169
    }
170

171
    case TSDB_DATA_TYPE_SMALLINT: {
3,425,542✔
172
      int16_t* plist = (int16_t*)pCol->pData;
3,425,542✔
173
      for (int32_t i = start; i < numOfRows + start; ++i) {
10,266,013✔
174
        if (colDataIsNull_f(pCol, i)) {
6,840,471!
175
          continue;
1,430,050✔
176
        }
177

178
        numOfElems += 1;
5,410,421✔
179
        AVG_RES_INC_COUNT(pRes, TSDB_DATA_TYPE_SMALLINT, 1);
5,410,421✔
180
        CHECK_OVERFLOW_SUM_SIGNED(pRes, plist[i]);
5,410,421!
181
      }
182
      break;
3,425,542✔
183
    }
184

185
    case TSDB_DATA_TYPE_INT: {
1,020,046✔
186
      int32_t* plist = (int32_t*)pCol->pData;
1,020,046✔
187
      for (int32_t i = start; i < numOfRows + start; ++i) {
3,780,435✔
188
        if (colDataIsNull_f(pCol, i)) {
2,760,389!
189
          continue;
1,320,399✔
190
        }
191

192
        numOfElems += 1;
1,439,990✔
193
        AVG_RES_INC_COUNT(pRes, TSDB_DATA_TYPE_INT, 1);
1,439,990✔
194
        CHECK_OVERFLOW_SUM_SIGNED(pRes, plist[i]);
1,439,990!
195
      }
196

197
      break;
1,020,046✔
198
    }
199

200
    case TSDB_DATA_TYPE_BIGINT: {
1,013,557✔
201
      int64_t* plist = (int64_t*)pCol->pData;
1,013,557✔
202
      for (int32_t i = start; i < numOfRows + start; ++i) {
3,476,436✔
203
        if (colDataIsNull_f(pCol, i)) {
2,462,879!
204
          continue;
1,426,485✔
205
        }
206

207
        numOfElems += 1;
1,036,394✔
208
        AVG_RES_INC_COUNT(pRes, TSDB_DATA_TYPE_BIGINT, 1);
1,036,394✔
209
        CHECK_OVERFLOW_SUM_SIGNED(pRes, plist[i]);
1,036,394✔
210
      }
211
      break;
1,013,557✔
212
    }
213

214
    case TSDB_DATA_TYPE_UTINYINT: {
958,712✔
215
      uint8_t* plist = (uint8_t*)pCol->pData;
958,712✔
216
      for (int32_t i = start; i < numOfRows + start; ++i) {
3,145,348✔
217
        if (colDataIsNull_f(pCol, i)) {
2,186,636!
218
          continue;
1,226,636✔
219
        }
220

221
        numOfElems += 1;
960,000✔
222
        AVG_RES_INC_COUNT(pRes, TSDB_DATA_TYPE_UTINYINT, 1);
960,000✔
223
        CHECK_OVERFLOW_SUM_UNSIGNED(pRes, plist[i]);
960,000!
224
      }
225

226
      break;
958,712✔
227
    }
228

229
    case TSDB_DATA_TYPE_USMALLINT: {
958,712✔
230
      uint16_t* plist = (uint16_t*)pCol->pData;
958,712✔
231
      for (int32_t i = start; i < numOfRows + start; ++i) {
3,145,348✔
232
        if (colDataIsNull_f(pCol, i)) {
2,186,636!
233
          continue;
1,226,636✔
234
        }
235

236
        numOfElems += 1;
960,000✔
237
        AVG_RES_INC_COUNT(pRes, TSDB_DATA_TYPE_USMALLINT, 1);
960,000✔
238
        CHECK_OVERFLOW_SUM_UNSIGNED(pRes, plist[i]);
960,000!
239
      }
240
      break;
958,712✔
241
    }
242

243
    case TSDB_DATA_TYPE_UINT: {
1,811,023✔
244
      uint32_t* plist = (uint32_t*)pCol->pData;
1,811,023✔
245
      for (int32_t i = start; i < numOfRows + start; ++i) {
5,519,654✔
246
        if (colDataIsNull_f(pCol, i)) {
3,708,631!
247
          continue;
1,791,968✔
248
        }
249

250
        numOfElems += 1;
1,916,663✔
251
        AVG_RES_INC_COUNT(pRes, TSDB_DATA_TYPE_UINT, 1);
1,916,663✔
252
        CHECK_OVERFLOW_SUM_UNSIGNED(pRes, plist[i]);
1,916,663!
253
      }
254

255
      break;
1,811,023✔
256
    }
257

258
    case TSDB_DATA_TYPE_UBIGINT: {
958,718✔
259
      uint64_t* plist = (uint64_t*)pCol->pData;
958,718✔
260
      for (int32_t i = start; i < numOfRows + start; ++i) {
3,145,364✔
261
        if (colDataIsNull_f(pCol, i)) {
2,186,646!
262
          continue;
1,426,640✔
263
        }
264

265
        numOfElems += 1;
760,006✔
266
        AVG_RES_INC_COUNT(pRes, TSDB_DATA_TYPE_UBIGINT, 1);
760,006✔
267
        CHECK_OVERFLOW_SUM_UNSIGNED(pRes, plist[i]);
760,006✔
268
        
269
      }
270
      break;
958,718✔
271
    }
272

273
    case TSDB_DATA_TYPE_FLOAT: {
1,072,623✔
274
      float* plist = (float*)pCol->pData;
1,072,623✔
275
      for (int32_t i = start; i < numOfRows + start; ++i) {
3,910,898✔
276
        if (colDataIsNull_f(pCol, i)) {
2,838,275✔
277
          continue;
1,487,654✔
278
        }
279

280
        numOfElems += 1;
1,350,621✔
281
        AVG_RES_INC_COUNT(pRes, TSDB_DATA_TYPE_FLOAT, 1);
1,350,621✔
282
        SUM_RES_INC_DSUM(&AVG_RES_GET_SUM(pRes), plist[i]);
1,350,621✔
283
      }
284
      break;
1,072,623✔
285
    }
286

287
    case TSDB_DATA_TYPE_DOUBLE: {
4,146,696✔
288
      double* plist = (double*)pCol->pData;
4,146,696✔
289
      for (int32_t i = start; i < numOfRows + start; ++i) {
13,004,740✔
290
        if (colDataIsNull_f(pCol, i)) {
8,858,044✔
291
          continue;
1,766,594✔
292
        }
293

294
        numOfElems += 1;
7,091,450✔
295
        AVG_RES_INC_COUNT(pRes, TSDB_DATA_TYPE_DOUBLE, 1);
7,091,450✔
296
        SUM_RES_INC_DSUM(&AVG_RES_GET_SUM(pRes), plist[i]);
7,091,450✔
297
      }
298
      break;
4,146,696✔
299
    }
300
    case TSDB_DATA_TYPE_DECIMAL64:
×
301
    case TSDB_DATA_TYPE_DECIMAL: {
302
      const char* pDec = pCol->pData;
×
303
      for (int32_t i = start; i < numOfRows + start; ++i) {
×
304
        if (colDataIsNull_f(pCol, i)) {
×
305
          continue;
×
306
        }
307

308
        numOfElems += 1;
×
309
        AVG_RES_INC_COUNT(pRes, type, 1);
×
310
        bool overflow = false;
×
311
        SUM_RES_INC_DECIMAL_SUM(&AVG_RES_GET_DECIMAL_SUM(pRes), (const void*)(pDec + i * tDataTypes[type].bytes), type);
×
312
        if (overflow) return TSDB_CODE_DECIMAL_OVERFLOW;
×
313
      }
314
    } break;
×
315
    default:
×
316
      break;
×
317
  }
318

319
  *pNumOfElem = numOfElems;
16,775,129✔
320
  return 0;
16,775,129✔
321
}
322

323
int32_t avgFunction(SqlFunctionCtx* pCtx) {
21,009,644✔
324
  int32_t       numOfElem = 0;
21,009,644✔
325
  const int32_t THRESHOLD_SIZE = 8;
21,009,644✔
326

327
  SInputColumnInfoData* pInput = &pCtx->input;
21,009,644✔
328
  SColumnDataAgg*       pAgg = pInput->pColumnDataAgg[0];
21,009,644✔
329
  int32_t               type = pInput->pData[0]->info.type;
21,009,644✔
330
  pCtx->inputType = type;
21,009,644✔
331

332
  void* pAvgRes = GET_ROWCELL_INTERBUF(GET_RES_INFO(pCtx));
21,009,644✔
333

334
  // computing based on the true data block
335
  SColumnInfoData* pCol = pInput->pData[0];
21,009,644✔
336

337
  int32_t start = pInput->startRowIndex;
21,009,644✔
338
  int32_t numOfRows = pInput->numOfRows;
21,009,644✔
339

340
  if (IS_NULL_TYPE(type)) {
21,009,644✔
341
    goto _over;
1,599✔
342
  }
343

344
  AVG_RES_SET_TYPE(pAvgRes, pCtx->inputType, type);
21,008,045✔
345
  if (IS_DECIMAL_TYPE(type)) AVG_RES_SET_INPUT_SCALE(pAvgRes, pInput->pData[0]->info.scale);
21,008,045!
346

347
  if (pInput->colDataSMAIsSet) {  // try to use SMA if available
21,008,045✔
348
    int32_t code = calculateAvgBySMAInfo(pAvgRes, numOfRows, type, pAgg, &numOfElem);
580✔
349
    if (code != 0) return code;
580!
350
  } else if (!pCol->hasNull) {  // try to employ the simd instructions to speed up the loop
21,007,465✔
351
    numOfElem = pInput->numOfRows;
4,232,298✔
352
    AVG_RES_INC_COUNT(pAvgRes, pCtx->inputType, pInput->numOfRows);
4,232,298✔
353

354
    switch(type) {
4,232,298!
355
      case TSDB_DATA_TYPE_UTINYINT:
6,006✔
356
      case TSDB_DATA_TYPE_TINYINT: {
357
        const int8_t* plist = (const int8_t*) pCol->pData;
6,006✔
358

359
        for (int32_t i = pInput->startRowIndex; i < pInput->numOfRows + pInput->startRowIndex; ++i) {
1,575,708✔
360
          if (type == TSDB_DATA_TYPE_TINYINT) {
1,569,702✔
361
            CHECK_OVERFLOW_SUM_SIGNED(pAvgRes, plist[i]);
1,559,692!
362
          } else {
363
            CHECK_OVERFLOW_SUM_UNSIGNED(pAvgRes, (uint8_t)plist[i]);
10,010!
364
          }
365
        }
366
        break;
6,006✔
367
      }
368

369
      case TSDB_DATA_TYPE_USMALLINT:
1,361,007✔
370
      case TSDB_DATA_TYPE_SMALLINT: {
371
        const int16_t* plist = (const int16_t*)pCol->pData;
1,361,007✔
372

373
        for (int32_t i = pInput->startRowIndex; i < pInput->numOfRows + pInput->startRowIndex; ++i) {
6,082,738✔
374
          if (type == TSDB_DATA_TYPE_SMALLINT) {
4,721,731✔
375
            CHECK_OVERFLOW_SUM_SIGNED(pAvgRes, plist[i]);
4,711,721!
376
          } else {
377
            CHECK_OVERFLOW_SUM_UNSIGNED(pAvgRes, (uint16_t)plist[i]);
10,010!
378
          }
379
        }
380
        break;
1,361,007✔
381
      }
382

383
      case TSDB_DATA_TYPE_UINT:
33,045✔
384
      case TSDB_DATA_TYPE_INT: {
385
        const int32_t* plist = (const int32_t*) pCol->pData;
33,045✔
386

387
        for (int32_t i = pInput->startRowIndex; i < pInput->numOfRows + pInput->startRowIndex; ++i) {
2,442,276✔
388
          if (type == TSDB_DATA_TYPE_INT) {
2,409,231✔
389
            CHECK_OVERFLOW_SUM_SIGNED(pAvgRes, plist[i]);
2,356,849!
390
          } else {
391
            CHECK_OVERFLOW_SUM_UNSIGNED(pAvgRes, (uint32_t)plist[i]);
52,382!
392
          }
393
        }
394
        break;
33,045✔
395
      }
396

397
      case TSDB_DATA_TYPE_UBIGINT:
268,794✔
398
      case TSDB_DATA_TYPE_BIGINT: {
399
        const int64_t* plist = (const int64_t*) pCol->pData;
268,794✔
400

401
        for (int32_t i = pInput->startRowIndex; i < pInput->numOfRows + pInput->startRowIndex; ++i) {
3,123,108✔
402
          if (type == TSDB_DATA_TYPE_BIGINT) {
2,854,314✔
403
            CHECK_OVERFLOW_SUM_SIGNED(pAvgRes, plist[i]);
2,843,764!
404
          } else {
405
            CHECK_OVERFLOW_SUM_UNSIGNED(pAvgRes, (uint64_t)plist[i]);
10,550✔
406
          }
407
        }
408
        break;
268,794✔
409
      }
410

411
      case TSDB_DATA_TYPE_FLOAT: {
53,462✔
412
        const float* plist = (const float*) pCol->pData;
53,462✔
413

414
        for (int32_t i = pInput->startRowIndex; i < pInput->numOfRows + pInput->startRowIndex; ++i) {
907,736✔
415
          SUM_RES_INC_DSUM(&AVG_RES_GET_SUM(pAvgRes), plist[i]);
854,274✔
416
        }
417
        break;
53,462✔
418
      }
419
      case TSDB_DATA_TYPE_DOUBLE: {
2,509,013✔
420
        const double* plist = (const double*)pCol->pData;
2,509,013✔
421

422
        for (int32_t i = pInput->startRowIndex; i < pInput->numOfRows + pInput->startRowIndex; ++i) {
13,396,406✔
423
          SUM_RES_INC_DSUM(&AVG_RES_GET_SUM(pAvgRes), plist[i]);
10,887,393✔
424
        }
425
        break;
2,509,013✔
426
      }
427
      case TSDB_DATA_TYPE_DECIMAL:
×
428
      case TSDB_DATA_TYPE_DECIMAL64: {
429
        const char* pDec = pCol->pData;
×
430
        for (int32_t i = pInput->startRowIndex; i < pInput->numOfRows + pInput->startRowIndex; ++i) {
×
431
          bool overflow = false;
×
432
          if (type == TSDB_DATA_TYPE_DECIMAL64) {
×
433
            SUM_RES_INC_DECIMAL_SUM(&AVG_RES_GET_DECIMAL_SUM(pAvgRes), (const void*)(pDec + i * tDataTypes[type].bytes),
×
434
                                    TSDB_DATA_TYPE_DECIMAL64);
435
          } else {
436
            SUM_RES_INC_DECIMAL_SUM(&AVG_RES_GET_DECIMAL_SUM(pAvgRes), (const void*)(pDec + i * tDataTypes[type].bytes),
×
437
                                    TSDB_DATA_TYPE_DECIMAL);
438
          }
439
          if (overflow) return TSDB_CODE_DECIMAL_OVERFLOW;
×
440
        }
441
      } break;
×
442
      default:
971✔
443
        return TSDB_CODE_FUNC_FUNTION_PARA_TYPE;
971✔
444
    }
445
  } else {
446
    int32_t code = doAddNumericVector(pCol, type, pInput, pAvgRes, &numOfElem);
16,775,167✔
447
    if (code) return code;
16,775,147!
448
  }
449

450
_over:
16,775,147✔
451
  // data in the check operation are all null, not output
452
  SET_VAL(GET_RES_INFO(pCtx), numOfElem, 1);
21,008,653✔
453
  return TSDB_CODE_SUCCESS;
21,008,653✔
454
}
455

456
static int32_t avgTransferInfo(SqlFunctionCtx* pCtx, void* pInput, void* pOutput) {
2,329,819✔
457
  int32_t inputDT = pCtx->pExpr->pExpr->_function.pFunctNode->srcFuncInputType.type;
2,329,819✔
458
  int32_t type = AVG_RES_GET_TYPE(pInput, inputDT);
2,329,819!
459
  pCtx->inputType = type;
2,329,819✔
460
  if (IS_NULL_TYPE(type)) {
2,329,819✔
461
    return 0;
1,444✔
462
  }
463

464

465
  AVG_RES_SET_TYPE(pOutput, inputDT, type);
2,328,375!
466
  if (IS_SIGNED_NUMERIC_TYPE(type)) {
3,310,968!
467
    bool overflow = AVG_RES_GET_SUM_OVERFLOW(pInput, false, 0);
982,593✔
468
    CHECK_OVERFLOW_SUM_SIGNED_BIG(pOutput, (overflow ? SUM_RES_GET_DSUM(&AVG_RES_GET_SUM(pInput)) : SUM_RES_GET_ISUM(&AVG_RES_GET_SUM(pInput))), overflow);
982,593!
469
  } else if (IS_UNSIGNED_NUMERIC_TYPE(type)) {
1,345,810!
470
    bool overflow = AVG_RES_GET_SUM_OVERFLOW(pInput, false, 0);
28✔
471
    CHECK_OVERFLOW_SUM_UNSIGNED_BIG(pOutput, (overflow ? SUM_RES_GET_DSUM(&AVG_RES_GET_SUM(pInput)) : SUM_RES_GET_USUM(&AVG_RES_GET_SUM(pInput))), overflow);
28!
472
  } else if (IS_DECIMAL_TYPE(type)) {
1,345,754!
473
    AVG_RES_SET_INPUT_SCALE(pOutput, AVG_RES_GET_INPUT_SCALE(pInput));
×
474
    bool overflow = false;
×
475
    SUM_RES_INC_DECIMAL_SUM(&AVG_RES_GET_DECIMAL_SUM(pOutput), &AVG_RES_GET_DECIMAL_SUM(pInput), TSDB_DATA_TYPE_DECIMAL);
×
476
    if (overflow) return TSDB_CODE_DECIMAL_OVERFLOW;
×
477
  } else {
478
    SUM_RES_INC_DSUM(&AVG_RES_GET_SUM(pOutput), SUM_RES_GET_DSUM(&AVG_RES_GET_SUM(pInput)));
1,345,754✔
479
  }
480

481
  AVG_RES_INC_COUNT(pOutput, type, AVG_RES_GET_COUNT(pInput, true, type));
2,328,375!
482
  return 0;
2,328,375✔
483
}
484

485
int32_t avgFunctionMerge(SqlFunctionCtx* pCtx) {
2,296,397✔
486
  SInputColumnInfoData* pInput = &pCtx->input;
2,296,397✔
487
  SColumnInfoData*      pCol = pInput->pData[0];
2,296,397✔
488

489
  if (IS_NULL_TYPE(pCol->info.type)) {
2,296,397!
490
    SET_VAL(GET_RES_INFO(pCtx), 0, 1);
×
491
    return TSDB_CODE_SUCCESS;
×
492
  }
493

494
  if (pCol->info.type != TSDB_DATA_TYPE_BINARY) {
2,296,397!
495
    return TSDB_CODE_FUNC_FUNTION_PARA_TYPE;
×
496
  }
497

498
  void* pInfo = GET_ROWCELL_INTERBUF(GET_RES_INFO(pCtx));
2,296,397✔
499

500
  int32_t start = pInput->startRowIndex;
2,296,397✔
501

502
  for (int32_t i = start; i < start + pInput->numOfRows; ++i) {
4,626,216✔
503
    if(colDataIsNull_s(pCol, i)) continue;
4,659,638!
504
    char*    data = colDataGetData(pCol, i);
2,329,819!
505
    void* pInputInfo = varDataVal(data);
2,329,819✔
506
    int32_t code = avgTransferInfo(pCtx, pInputInfo, pInfo);
2,329,819✔
507
    if (code != 0) return code;
2,329,819!
508
  }
509

510
  SET_VAL(GET_RES_INFO(pCtx), 1, 1);
2,296,397✔
511

512
  return TSDB_CODE_SUCCESS;
2,296,397✔
513
}
514

515
int32_t avgCombine(SqlFunctionCtx* pDestCtx, SqlFunctionCtx* pSourceCtx) {
×
516
  SResultRowEntryInfo* pDResInfo = GET_RES_INFO(pDestCtx);
×
517
  void*                pDBuf = GET_ROWCELL_INTERBUF(pDResInfo);
×
518
  int32_t              type = AVG_RES_GET_TYPE(pDBuf, pDestCtx->inputType);
×
519

520
  SResultRowEntryInfo* pSResInfo = GET_RES_INFO(pSourceCtx);
×
521
  void*                pSBuf = GET_ROWCELL_INTERBUF(pSResInfo);
×
522
  type = (type == TSDB_DATA_TYPE_NULL) ? AVG_RES_GET_TYPE(pSBuf, pDestCtx->inputType) : type;
×
523

524
  if (IS_SIGNED_NUMERIC_TYPE(type)) {
×
525
    CHECK_OVERFLOW_SUM_SIGNED(pDBuf, SUM_RES_GET_ISUM(&AVG_RES_GET_SUM(pSBuf)));
×
526
  } else if (IS_UNSIGNED_NUMERIC_TYPE(type)) {
×
527
    CHECK_OVERFLOW_SUM_UNSIGNED(pDBuf, SUM_RES_GET_USUM(&AVG_RES_GET_SUM(pSBuf)));
×
528
  } else if (IS_DECIMAL_TYPE(type)) {
×
529
    bool overflow = false;
×
530
    SUM_RES_INC_DECIMAL_SUM(&AVG_RES_GET_DECIMAL_SUM(pDBuf), &SUM_RES_GET_DECIMAL_SUM(&AVG_RES_GET_DECIMAL_SUM(pSBuf)), type);
×
531
    if (overflow) {
532

533
    }
534
  } else {
535
    SUM_RES_INC_DSUM(&AVG_RES_GET_SUM(pDBuf), SUM_RES_GET_DSUM(&AVG_RES_GET_SUM(pSBuf)));
×
536
  }
537
  AVG_RES_INC_COUNT(pDBuf, pDestCtx->inputType, AVG_RES_GET_COUNT(pSBuf, true, pDestCtx->inputType));
×
538

539
  return TSDB_CODE_SUCCESS;
×
540
}
541

542
int32_t avgFinalize(SqlFunctionCtx* pCtx, SSDataBlock* pBlock) {
7,718,458✔
543
  SResultRowEntryInfo* pEntryInfo = GET_RES_INFO(pCtx);
7,718,458✔
544

545
  void*   pRes = GET_ROWCELL_INTERBUF(pEntryInfo);
7,718,458✔
546
  int32_t type = AVG_RES_GET_TYPE(pRes, pCtx->inputType);
7,718,458!
547
  int64_t count = AVG_RES_GET_COUNT(pRes, true, type);
7,718,458!
548

549
  if (AVG_RES_GET_COUNT(pRes, true, pCtx->inputType) > 0) {
7,718,458!
550
    
551
    if(AVG_RES_GET_SUM_OVERFLOW(pRes, true, pCtx->inputType)) {
7,581,954!
552
      AVG_RES_GET_AVG(pRes) = SUM_RES_GET_DSUM(&AVG_RES_GET_SUM(pRes)) / ((double)AVG_RES_GET_COUNT(pRes, false, 0));
11,156✔
553
    }else if (IS_SIGNED_NUMERIC_TYPE(type)) {
7,570,798!
554
      AVG_RES_GET_AVG(pRes) = SUM_RES_GET_ISUM(&AVG_RES_GET_SUM(pRes)) / ((double)AVG_RES_GET_COUNT(pRes, false, 0));
3,268,030✔
555
    } else if (IS_UNSIGNED_NUMERIC_TYPE(type)) {
4,302,768!
556
      AVG_RES_GET_AVG(pRes) = SUM_RES_GET_USUM(&AVG_RES_GET_SUM(pRes)) / ((double)AVG_RES_GET_COUNT(pRes, false, 0));
61,089✔
557
    } else if (IS_DECIMAL_TYPE(type)) {
4,241,679!
558
      int32_t          slotId = pCtx->pExpr->base.resSchema.slotId;
×
559
      SColumnInfoData* pCol = taosArrayGet(pBlock->pDataBlock, slotId);
×
560
      SDataType        sumDt = {.type = TSDB_DATA_TYPE_DECIMAL,
×
561
                                .bytes = tDataTypes[TSDB_DATA_TYPE_DECIMAL].bytes,
×
562
                                .precision = pCol->info.precision,
×
563
                                .scale = AVG_RES_GET_INPUT_SCALE(pRes)};
×
564
      SDataType        countDt = {
×
565
                 .type = TSDB_DATA_TYPE_BIGINT, .bytes = tDataTypes[TSDB_DATA_TYPE_BIGINT].bytes, .precision = 0, .scale = 0};
×
566
      SDataType avgDt = {.type = TSDB_DATA_TYPE_DECIMAL,
×
567
                         .bytes = tDataTypes[TSDB_DATA_TYPE_DECIMAL].bytes,
×
568
                         .precision = pCol->info.precision,
×
569
                         .scale = pCol->info.scale};
×
570
      int64_t   count = AVG_RES_GET_COUNT(pRes, true, type);
×
571
      int32_t   code =
572
          decimalOp(OP_TYPE_DIV, &sumDt, &countDt, &avgDt, &SUM_RES_GET_DECIMAL_SUM(&AVG_RES_GET_DECIMAL_SUM(pRes)),
×
573
                    &count, &AVG_RES_GET_DECIMAL_AVG(pRes));
×
574
      if (code != TSDB_CODE_SUCCESS) {
×
575
        return code;
×
576
      }
577
    } else {
578
      AVG_RES_GET_AVG(pRes) = SUM_RES_GET_DSUM(&AVG_RES_GET_SUM(pRes)) / ((double)AVG_RES_GET_COUNT(pRes, false, 0));
4,241,688✔
579
    }
580
  }
581
  if (AVG_RES_GET_COUNT(pRes, true, pCtx->inputType) == 0) {
7,718,467!
582
    pEntryInfo->numOfRes = 0;
136,509✔
583
  } else if (!IS_DECIMAL_TYPE(pCtx->inputType)) {
7,581,958!
584
    if (isinf(AVG_RES_GET_AVG(pRes)) || isnan(AVG_RES_GET_AVG(pRes))) pEntryInfo->numOfRes = 0;
7,581,958!
585
  } else {
586
    pEntryInfo->numOfRes = 1;
×
587
  }
588

589
  return functionFinalize(pCtx, pBlock);
7,718,467✔
590
}
591

592
int32_t avgPartialFinalize(SqlFunctionCtx* pCtx, SSDataBlock* pBlock) {
2,325,252✔
593
  SResultRowEntryInfo* pResInfo = GET_RES_INFO(pCtx);
2,325,252✔
594
  void*                pInfo = GET_ROWCELL_INTERBUF(GET_RES_INFO(pCtx));
2,325,252✔
595
  int32_t              resultBytes = AVG_RES_GET_SIZE(pCtx->inputType);
2,325,252!
596
  char*                res = taosMemoryCalloc(resultBytes + VARSTR_HEADER_SIZE, sizeof(char));
2,325,252!
597
  int32_t              code = TSDB_CODE_SUCCESS;
2,329,066✔
598
  if (NULL == res) {
2,329,066!
599
    return terrno;
×
600
  }
601
  (void)memcpy(varDataVal(res), pInfo, resultBytes);
2,329,066✔
602
  varDataSetLen(res, resultBytes);
2,329,066✔
603

604
  int32_t          slotId = pCtx->pExpr->base.resSchema.slotId;
2,329,066✔
605
  SColumnInfoData* pCol = taosArrayGet(pBlock->pDataBlock, slotId);
2,329,066✔
606
  if(NULL == pCol) {
2,328,788!
607
    code = TSDB_CODE_OUT_OF_RANGE;
×
608
    goto _exit;
×
609
  }
610

611
  code = colDataSetVal(pCol, pBlock->info.rows, res, false);
2,328,788✔
612

613
_exit:
2,328,873✔
614
  taosMemoryFree(res);
2,328,873!
615
  return code;
2,329,528✔
616
}
STATUS · Troubleshooting · Open an Issue · Sales · Support · CAREERS · ENTERPRISE · START FREE · SCHEDULE DEMO
ANNOUNCEMENTS · TWITTER · TOS & SLA · Supported CI Services · What's a CI service? · Automated Testing

© 2026 Coveralls, Inc