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

taosdata / TDengine / #4898

26 Dec 2025 09:58AM UTC coverage: 65.061% (-0.7%) from 65.717%
#4898

push

travis-ci

web-flow
feat: support encryption of configuration files, data files and metadata files (#33801)

350 of 1333 new or added lines in 31 files covered. (26.26%)

2796 existing lines in 159 files now uncovered.

184024 of 282850 relevant lines covered (65.06%)

113940470.33 hits per line

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

88.11
/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) {
30,863,772✔
107
  if (pFunc->pSrcFuncRef) return AVG_RES_GET_SIZE(pFunc->pSrcFuncRef->srcFuncInputType.type);
30,863,772✔
108
  return AVG_RES_GET_SIZE(pFunc->srcFuncInputType.type);
23,410,784✔
109
}
110

111
bool getAvgFuncEnv(SFunctionNode* pFunc, SFuncExecEnv* pEnv) {
23,420,228✔
112
  pEnv->calcMemSize =getAvgInfoSize(pFunc);
23,420,228✔
113
  return true;
23,411,364✔
114
}
115

116
int32_t avgFunctionSetup(SqlFunctionCtx* pCtx, SResultRowEntryInfo* pResultInfo) {
1,418,324,368✔
117
  if (pResultInfo->initialized) {
1,418,324,368✔
118
    return TSDB_CODE_SUCCESS;
×
119
  }
120
  if (TSDB_CODE_SUCCESS != functionSetup(pCtx, pResultInfo)) {
1,422,333,569✔
121
    return TSDB_CODE_FUNC_SETUP_ERROR;
×
122
  }
123

124
  void* pRes = GET_ROWCELL_INTERBUF(pResultInfo);
1,423,348,608✔
125
  (void)memset(pRes, 0, pCtx->resDataInfo.interBufSize);
1,421,951,196✔
126
  return TSDB_CODE_SUCCESS;
1,423,359,634✔
127
}
128

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

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

146
  *pNumOfElem = numOfElem;
1,016,576✔
147
  return 0;
1,016,576✔
148
}
149

150
static int32_t doAddNumericVector(SColumnInfoData* pCol, int32_t type, SInputColumnInfoData *pInput, void* pRes, int32_t* pNumOfElem) {
1,033,214,476✔
151
  int32_t start = pInput->startRowIndex;
1,033,214,476✔
152
  int32_t numOfRows = pInput->numOfRows;
1,033,694,639✔
153
  int32_t numOfElems = 0;
1,033,155,691✔
154

155
  switch (type) {
1,033,155,691✔
156
    case TSDB_DATA_TYPE_TINYINT: {
66,541,429✔
157
      int8_t* plist = (int8_t*)pCol->pData;
66,541,429✔
158
      for (int32_t i = start; i < numOfRows + start; ++i) {
246,152,879✔
159
        if (colDataIsNull_f(pCol, i)) {
179,610,052✔
160
          continue;
96,253,582✔
161
        }
162

163
        numOfElems += 1;
83,357,402✔
164
        AVG_RES_INC_COUNT(pRes, TSDB_DATA_TYPE_TINYINT, 1);
83,357,402✔
165
        CHECK_OVERFLOW_SUM_SIGNED(pRes, plist[i]);
83,356,936✔
166
      }
167

168
      break;
66,542,827✔
169
    }
170

171
    case TSDB_DATA_TYPE_SMALLINT: {
738,020✔
172
      int16_t* plist = (int16_t*)pCol->pData;
738,020✔
173
      for (int32_t i = start; i < numOfRows + start; ++i) {
26,555,950✔
174
        if (colDataIsNull_f(pCol, i)) {
25,817,930✔
175
          continue;
7,984,296✔
176
        }
177

178
        numOfElems += 1;
17,833,634✔
179
        AVG_RES_INC_COUNT(pRes, TSDB_DATA_TYPE_SMALLINT, 1);
17,833,634✔
180
        CHECK_OVERFLOW_SUM_SIGNED(pRes, plist[i]);
17,833,634✔
181
      }
182
      break;
738,020✔
183
    }
184

185
    case TSDB_DATA_TYPE_INT: {
54,161,604✔
186
      int32_t* plist = (int32_t*)pCol->pData;
54,161,604✔
187
      for (int32_t i = start; i < numOfRows + start; ++i) {
306,189,391✔
188
        if (colDataIsNull_f(pCol, i)) {
252,028,205✔
189
          continue;
118,118,984✔
190
        }
191

192
        numOfElems += 1;
133,910,627✔
193
        AVG_RES_INC_COUNT(pRes, TSDB_DATA_TYPE_INT, 1);
133,910,627✔
194
        CHECK_OVERFLOW_SUM_SIGNED(pRes, plist[i]);
133,908,200✔
195
      }
196

197
      break;
54,161,186✔
198
    }
199

200
    case TSDB_DATA_TYPE_BIGINT: {
770,196,707✔
201
      int64_t* plist = (int64_t*)pCol->pData;
770,196,707✔
202
      for (int32_t i = start; i < numOfRows + start; ++i) {
1,695,050,429✔
203
        if (colDataIsNull_f(pCol, i)) {
923,751,642✔
204
          continue;
857,747,889✔
205
        }
206

207
        numOfElems += 1;
66,592,561✔
208
        AVG_RES_INC_COUNT(pRes, TSDB_DATA_TYPE_BIGINT, 1);
66,592,561✔
209
        CHECK_OVERFLOW_SUM_SIGNED(pRes, plist[i]);
66,592,561✔
210
      }
211
      break;
771,298,787✔
212
    }
213

214
    case TSDB_DATA_TYPE_UTINYINT: {
4,908✔
215
      uint8_t* plist = (uint8_t*)pCol->pData;
4,908✔
216
      for (int32_t i = start; i < numOfRows + start; ++i) {
16,364,908✔
217
        if (colDataIsNull_f(pCol, i)) {
16,360,000✔
UNCOV
218
          continue;
×
219
        }
220

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

226
      break;
4,908✔
227
    }
228

229
    case TSDB_DATA_TYPE_USMALLINT: {
4,908✔
230
      uint16_t* plist = (uint16_t*)pCol->pData;
4,908✔
231
      for (int32_t i = start; i < numOfRows + start; ++i) {
16,364,908✔
232
        if (colDataIsNull_f(pCol, i)) {
16,360,000✔
UNCOV
233
          continue;
×
234
        }
235

236
        numOfElems += 1;
16,360,000✔
237
        AVG_RES_INC_COUNT(pRes, TSDB_DATA_TYPE_USMALLINT, 1);
16,360,000✔
238
        CHECK_OVERFLOW_SUM_UNSIGNED(pRes, plist[i]);
16,360,000✔
239
      }
240
      break;
4,908✔
241
    }
242

243
    case TSDB_DATA_TYPE_UINT: {
28,827✔
244
      uint32_t* plist = (uint32_t*)pCol->pData;
28,827✔
245
      for (int32_t i = start; i < numOfRows + start; ++i) {
16,463,948✔
246
        if (colDataIsNull_f(pCol, i)) {
16,435,121✔
247
          continue;
2,924✔
248
        }
249

250
        numOfElems += 1;
16,432,197✔
251
        AVG_RES_INC_COUNT(pRes, TSDB_DATA_TYPE_UINT, 1);
16,432,197✔
252
        CHECK_OVERFLOW_SUM_UNSIGNED(pRes, plist[i]);
16,432,197✔
253
      }
254

255
      break;
28,827✔
256
    }
257

258
    case TSDB_DATA_TYPE_UBIGINT: {
8,242✔
259
      uint64_t* plist = (uint64_t*)pCol->pData;
8,242✔
260
      for (int32_t i = start; i < numOfRows + start; ++i) {
16,373,300✔
261
        if (colDataIsNull_f(pCol, i)) {
16,365,058✔
262
          continue;
2,472✔
263
        }
264

265
        numOfElems += 1;
16,362,586✔
266
        AVG_RES_INC_COUNT(pRes, TSDB_DATA_TYPE_UBIGINT, 1);
16,362,586✔
267
        CHECK_OVERFLOW_SUM_UNSIGNED(pRes, plist[i]);
16,362,586✔
268
        
269
      }
270
      break;
8,242✔
271
    }
272

273
    case TSDB_DATA_TYPE_FLOAT: {
58,935,446✔
274
      float* plist = (float*)pCol->pData;
58,935,446✔
275
      for (int32_t i = start; i < numOfRows + start; ++i) {
249,514,395✔
276
        if (colDataIsNull_f(pCol, i)) {
190,578,949✔
277
          continue;
125,317,440✔
278
        }
279

280
        numOfElems += 1;
65,261,509✔
281
        AVG_RES_INC_COUNT(pRes, TSDB_DATA_TYPE_FLOAT, 1);
65,261,509✔
282
        SUM_RES_INC_DSUM(&AVG_RES_GET_SUM(pRes), plist[i]);
65,261,509✔
283
      }
284
      break;
58,935,446✔
285
    }
286

287
    case TSDB_DATA_TYPE_DOUBLE: {
82,510,960✔
288
      double* plist = (double*)pCol->pData;
82,510,960✔
289
      for (int32_t i = start; i < numOfRows + start; ++i) {
705,727,770✔
290
        if (colDataIsNull_f(pCol, i)) {
623,212,888✔
291
          continue;
119,883,291✔
292
        }
293

294
        numOfElems += 1;
503,334,693✔
295
        AVG_RES_INC_COUNT(pRes, TSDB_DATA_TYPE_DOUBLE, 1);
503,334,693✔
296
        SUM_RES_INC_DSUM(&AVG_RES_GET_SUM(pRes), plist[i]);
503,344,923✔
297
      }
298
      break;
82,514,882✔
299
    }
300
    case TSDB_DATA_TYPE_DECIMAL64:
24,640✔
301
    case TSDB_DATA_TYPE_DECIMAL: {
302
      const char* pDec = pCol->pData;
24,640✔
303
      for (int32_t i = start; i < numOfRows + start; ++i) {
23,312,960✔
304
        if (colDataIsNull_f(pCol, i)) {
23,289,728✔
305
          continue;
352,000✔
306
        }
307

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

319
  *pNumOfElem = numOfElems;
1,034,261,265✔
320
  return 0;
1,033,408,515✔
321
}
322

323
int32_t avgFunction(SqlFunctionCtx* pCtx) {
2,052,182,037✔
324
  int32_t       numOfElem = 0;
2,052,182,037✔
325
  const int32_t THRESHOLD_SIZE = 8;
2,054,966,605✔
326

327
  SInputColumnInfoData* pInput = &pCtx->input;
2,054,966,605✔
328
  SColumnDataAgg*       pAgg = pInput->pColumnDataAgg[0];
2,055,769,648✔
329
  int32_t               type = pInput->pData[0]->info.type;
2,058,453,650✔
330
  pCtx->inputType = type;
2,058,538,635✔
331

332
  void* pAvgRes = GET_ROWCELL_INTERBUF(GET_RES_INFO(pCtx));
2,058,342,297✔
333

334
  // computing based on the true data block
335
  SColumnInfoData* pCol = pInput->pData[0];
2,058,300,994✔
336

337
  int32_t start = pInput->startRowIndex;
2,058,376,055✔
338
  int32_t numOfRows = pInput->numOfRows;
2,054,493,722✔
339

340
  if (IS_NULL_TYPE(type)) {
2,058,118,738✔
341
    goto _over;
939,072✔
342
  }
343

344
  AVG_RES_SET_TYPE(pAvgRes, pCtx->inputType, type);
2,057,179,666✔
345
  if (IS_DECIMAL_TYPE(type)) AVG_RES_SET_INPUT_SCALE(pAvgRes, pInput->pData[0]->info.scale);
2,055,720,963✔
346

347
  if (pInput->colDataSMAIsSet) {  // try to use SMA if available
2,056,412,246✔
348
    int32_t code = calculateAvgBySMAInfo(pAvgRes, numOfRows, type, pAgg, &numOfElem);
1,016,576✔
349
    if (code != 0) return code;
1,016,576✔
350
  } else if (!pCol->hasNull) {  // try to employ the simd instructions to speed up the loop
2,052,850,469✔
351
    numOfElem = pInput->numOfRows;
1,022,705,130✔
352
    AVG_RES_INC_COUNT(pAvgRes, pCtx->inputType, pInput->numOfRows);
1,022,553,114✔
353

354
    switch(type) {
1,022,706,608✔
355
      case TSDB_DATA_TYPE_UTINYINT:
1,771,769✔
356
      case TSDB_DATA_TYPE_TINYINT: {
357
        const int8_t* plist = (const int8_t*) pCol->pData;
1,771,769✔
358

359
        for (int32_t i = pInput->startRowIndex; i < pInput->numOfRows + pInput->startRowIndex; ++i) {
49,597,594✔
360
          if (type == TSDB_DATA_TYPE_TINYINT) {
47,822,993✔
361
            CHECK_OVERFLOW_SUM_SIGNED(pAvgRes, plist[i]);
46,548,683✔
362
          } else {
363
            CHECK_OVERFLOW_SUM_UNSIGNED(pAvgRes, (uint8_t)plist[i]);
1,274,310✔
364
          }
365
        }
366
        break;
1,772,241✔
367
      }
368

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

373
        for (int32_t i = pInput->startRowIndex; i < pInput->numOfRows + pInput->startRowIndex; ++i) {
12,565,509✔
374
          if (type == TSDB_DATA_TYPE_SMALLINT) {
10,922,031✔
375
            CHECK_OVERFLOW_SUM_SIGNED(pAvgRes, plist[i]);
9,647,721✔
376
          } else {
377
            CHECK_OVERFLOW_SUM_UNSIGNED(pAvgRes, (uint16_t)plist[i]);
1,274,310✔
378
          }
379
        }
380
        break;
1,643,478✔
381
      }
382

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

387
        for (int32_t i = pInput->startRowIndex; i < pInput->numOfRows + pInput->startRowIndex; ++i) {
2,147,483,647✔
388
          if (type == TSDB_DATA_TYPE_INT) {
2,147,483,647✔
389
            CHECK_OVERFLOW_SUM_SIGNED(pAvgRes, plist[i]);
2,147,483,647✔
390
          } else {
391
            CHECK_OVERFLOW_SUM_UNSIGNED(pAvgRes, (uint32_t)plist[i]);
2,342,446✔
392
          }
393
        }
394
        break;
17,412,183✔
395
      }
396

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

401
        for (int32_t i = pInput->startRowIndex; i < pInput->numOfRows + pInput->startRowIndex; ++i) {
2,147,483,647✔
402
          if (type == TSDB_DATA_TYPE_BIGINT) {
1,983,289,018✔
403
            CHECK_OVERFLOW_SUM_SIGNED(pAvgRes, plist[i]);
1,981,247,473✔
404
          } else {
405
            CHECK_OVERFLOW_SUM_UNSIGNED(pAvgRes, (uint64_t)plist[i]);
2,041,545✔
406
          }
407
        }
408
        break;
844,906,615✔
409
      }
410

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

414
        for (int32_t i = pInput->startRowIndex; i < pInput->numOfRows + pInput->startRowIndex; ++i) {
185,932,358✔
415
          SUM_RES_INC_DSUM(&AVG_RES_GET_SUM(pAvgRes), plist[i]);
159,721,293✔
416
        }
417
        break;
26,214,521✔
418
      }
419
      case TSDB_DATA_TYPE_DOUBLE: {
130,513,346✔
420
        const double* plist = (const double*)pCol->pData;
130,513,346✔
421

422
        for (int32_t i = pInput->startRowIndex; i < pInput->numOfRows + pInput->startRowIndex; ++i) {
1,557,115,762✔
423
          SUM_RES_INC_DSUM(&AVG_RES_GET_SUM(pAvgRes), plist[i]);
1,426,868,124✔
424
        }
425
        break;
130,502,586✔
426
      }
427
      case TSDB_DATA_TYPE_DECIMAL:
153,472✔
428
      case TSDB_DATA_TYPE_DECIMAL64: {
429
        const char* pDec = pCol->pData;
153,472✔
430
        for (int32_t i = pInput->startRowIndex; i < pInput->numOfRows + pInput->startRowIndex; ++i) {
306,944✔
431
          bool overflow = false;
153,472✔
432
          if (type == TSDB_DATA_TYPE_DECIMAL64) {
153,472✔
433
            SUM_RES_INC_DECIMAL_SUM(&AVG_RES_GET_DECIMAL_SUM(pAvgRes), (const void*)(pDec + i * tDataTypes[type].bytes),
153,472✔
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;
153,472✔
440
        }
441
      } break;
153,472✔
442
      default:
×
443
        return TSDB_CODE_FUNC_FUNTION_PARA_TYPE;
×
444
    }
445
  } else {
446
    int32_t code = doAddNumericVector(pCol, type, pInput, pAvgRes, &numOfElem);
1,029,168,120✔
447
    if (code) return code;
1,032,612,747✔
448
  }
449

450
_over:
2,057,172,083✔
451
  // data in the check operation are all null, not output
452
  SET_VAL(GET_RES_INFO(pCtx), numOfElem, 1);
2,054,344,551✔
453
  return TSDB_CODE_SUCCESS;
2,056,700,036✔
454
}
455

456
static int32_t avgTransferInfo(SqlFunctionCtx* pCtx, void* pInput, void* pOutput) {
775,331,120✔
457
  int32_t inputDT = pCtx->pExpr->pExpr->_function.pFunctNode->srcFuncInputType.type;
775,331,120✔
458
  int32_t type = AVG_RES_GET_TYPE(pInput, inputDT);
775,331,120✔
459
  pCtx->inputType = type;
775,331,120✔
460
  if (IS_NULL_TYPE(type)) {
775,331,120✔
461
    return 0;
756,915✔
462
  }
463

464

465
  AVG_RES_SET_TYPE(pOutput, inputDT, type);
774,574,205✔
466
  if (IS_SIGNED_NUMERIC_TYPE(type)) {
1,429,063,451✔
467
    bool overflow = AVG_RES_GET_SUM_OVERFLOW(pInput, false, 0);
654,489,246✔
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);
654,489,246✔
469
  } else if (IS_UNSIGNED_NUMERIC_TYPE(type)) {
120,098,215✔
470
    bool overflow = AVG_RES_GET_SUM_OVERFLOW(pInput, false, 0);
13,256✔
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);
13,256✔
472
  } else if (IS_DECIMAL_TYPE(type)) {
120,075,927✔
473
    AVG_RES_SET_INPUT_SCALE(pOutput, AVG_RES_GET_INPUT_SCALE(pInput));
4,224✔
474
    bool overflow = false;
4,224✔
475
    SUM_RES_INC_DECIMAL_SUM(&AVG_RES_GET_DECIMAL_SUM(pOutput), &AVG_RES_GET_DECIMAL_SUM(pInput), TSDB_DATA_TYPE_DECIMAL);
4,224✔
476
    if (overflow) return TSDB_CODE_DECIMAL_OVERFLOW;
4,224✔
477
  } else {
478
    SUM_RES_INC_DSUM(&AVG_RES_GET_SUM(pOutput), SUM_RES_GET_DSUM(&AVG_RES_GET_SUM(pInput)));
120,067,479✔
479
  }
480

481
  AVG_RES_INC_COUNT(pOutput, type, AVG_RES_GET_COUNT(pInput, true, type));
774,574,205✔
482
  return 0;
774,574,205✔
483
}
484

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

489
  if (IS_NULL_TYPE(pCol->info.type)) {
366,610,045✔
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) {
366,610,045✔
495
    return TSDB_CODE_FUNC_FUNTION_PARA_TYPE;
×
496
  }
497

498
  void* pInfo = GET_ROWCELL_INTERBUF(GET_RES_INFO(pCtx));
366,610,045✔
499

500
  int32_t start = pInput->startRowIndex;
366,610,045✔
501

502
  for (int32_t i = start; i < start + pInput->numOfRows; ++i) {
1,141,941,165✔
503
    if(colDataIsNull_s(pCol, i)) continue;
1,550,662,240✔
504
    char*    data = colDataGetData(pCol, i);
775,331,120✔
505
    void* pInputInfo = varDataVal(data);
775,331,120✔
506
    int32_t code = avgTransferInfo(pCtx, pInputInfo, pInfo);
775,331,120✔
507
    if (code != 0) return code;
775,331,120✔
508
  }
509

510
  SET_VAL(GET_RES_INFO(pCtx), 1, 1);
366,610,045✔
511

512
  return TSDB_CODE_SUCCESS;
366,610,045✔
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) {
585,073,086✔
543
  SResultRowEntryInfo* pEntryInfo = GET_RES_INFO(pCtx);
585,073,086✔
544

545
  void*   pRes = GET_ROWCELL_INTERBUF(pEntryInfo);
585,074,811✔
546
  int32_t type = AVG_RES_GET_TYPE(pRes, pCtx->inputType);
585,074,811✔
547
  int64_t count = AVG_RES_GET_COUNT(pRes, true, type);
585,071,361✔
548

549
  if (AVG_RES_GET_COUNT(pRes, true, pCtx->inputType) > 0) {
585,071,361✔
550
    
551
    if(AVG_RES_GET_SUM_OVERFLOW(pRes, true, pCtx->inputType)) {
506,587,852✔
552
      AVG_RES_GET_AVG(pRes) = SUM_RES_GET_DSUM(&AVG_RES_GET_SUM(pRes)) / ((double)AVG_RES_GET_COUNT(pRes, false, 0));
1,122,775✔
553
    }else if (IS_SIGNED_NUMERIC_TYPE(type)) {
505,467,274✔
554
      AVG_RES_GET_AVG(pRes) = SUM_RES_GET_ISUM(&AVG_RES_GET_SUM(pRes)) / ((double)AVG_RES_GET_COUNT(pRes, false, 0));
314,245,551✔
555
    } else if (IS_UNSIGNED_NUMERIC_TYPE(type)) {
191,221,723✔
556
      AVG_RES_GET_AVG(pRes) = SUM_RES_GET_USUM(&AVG_RES_GET_SUM(pRes)) / ((double)AVG_RES_GET_COUNT(pRes, false, 0));
33,745✔
557
    } else if (IS_DECIMAL_TYPE(type)) {
191,347,082✔
558
      int32_t          slotId = pCtx->pExpr->base.resSchema.slotId;
162,554✔
559
      SColumnInfoData* pCol = taosArrayGet(pBlock->pDataBlock, slotId);
159,104✔
560
      SDataType        sumDt = {.type = TSDB_DATA_TYPE_DECIMAL,
159,104✔
561
                                .bytes = tDataTypes[TSDB_DATA_TYPE_DECIMAL].bytes,
318,208✔
562
                                .precision = pCol->info.precision,
159,104✔
563
                                .scale = AVG_RES_GET_INPUT_SCALE(pRes)};
159,104✔
564
      SDataType        countDt = {
159,104✔
565
                 .type = TSDB_DATA_TYPE_BIGINT, .bytes = tDataTypes[TSDB_DATA_TYPE_BIGINT].bytes, .precision = 0, .scale = 0};
159,104✔
566
      SDataType avgDt = {.type = TSDB_DATA_TYPE_DECIMAL,
159,104✔
567
                         .bytes = tDataTypes[TSDB_DATA_TYPE_DECIMAL].bytes,
318,208✔
568
                         .precision = pCol->info.precision,
159,104✔
569
                         .scale = pCol->info.scale};
159,104✔
570
      int64_t   count = AVG_RES_GET_COUNT(pRes, true, type);
159,104✔
571
      int32_t   code =
572
          decimalOp(OP_TYPE_DIV, &sumDt, &countDt, &avgDt, &SUM_RES_GET_DECIMAL_SUM(&AVG_RES_GET_DECIMAL_SUM(pRes)),
159,104✔
573
                    &count, &AVG_RES_GET_DECIMAL_AVG(pRes));
159,104✔
574
      if (code != TSDB_CODE_SUCCESS) {
159,104✔
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));
191,025,424✔
579
    }
580
  }
581
  if (AVG_RES_GET_COUNT(pRes, true, pCtx->inputType) == 0) {
585,069,164✔
582
    pEntryInfo->numOfRes = 0;
78,483,612✔
583
  } else if (!IS_DECIMAL_TYPE(pCtx->inputType)) {
506,583,252✔
584
    if (isinf(AVG_RES_GET_AVG(pRes)) || isnan(AVG_RES_GET_AVG(pRes))) pEntryInfo->numOfRes = 0;
506,428,173✔
585
  } else {
586
    pEntryInfo->numOfRes = 1;
155,654✔
587
  }
588

589
  return functionFinalize(pCtx, pBlock);
585,072,039✔
590
}
591

592
int32_t avgPartialFinalize(SqlFunctionCtx* pCtx, SSDataBlock* pBlock) {
829,602,676✔
593
  SResultRowEntryInfo* pResInfo = GET_RES_INFO(pCtx);
829,602,676✔
594
  void*                pInfo = GET_ROWCELL_INTERBUF(GET_RES_INFO(pCtx));
829,894,033✔
595
  int32_t              resultBytes = AVG_RES_GET_SIZE(pCtx->inputType);
829,909,252✔
596
  char*                res = taosMemoryCalloc(resultBytes + VARSTR_HEADER_SIZE, sizeof(char));
829,904,896✔
597
  int32_t              code = TSDB_CODE_SUCCESS;
829,384,017✔
598
  if (NULL == res) {
829,384,017✔
599
    return terrno;
×
600
  }
601
  (void)memcpy(varDataVal(res), pInfo, resultBytes);
829,384,017✔
602
  varDataSetLen(res, resultBytes);
829,409,345✔
603

604
  int32_t          slotId = pCtx->pExpr->base.resSchema.slotId;
829,671,049✔
605
  SColumnInfoData* pCol = taosArrayGet(pBlock->pDataBlock, slotId);
829,748,359✔
606
  if(NULL == pCol) {
829,890,116✔
607
    code = TSDB_CODE_OUT_OF_RANGE;
×
608
    goto _exit;
×
609
  }
610

611
  code = colDataSetVal(pCol, pBlock->info.rows, res, false);
829,890,116✔
612

613
_exit:
829,835,805✔
614
  taosMemoryFree(res);
829,835,805✔
615
  return code;
829,598,249✔
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