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

taosdata / TDengine / #4835

31 Oct 2025 03:37AM UTC coverage: 58.506% (-0.3%) from 58.764%
#4835

push

travis-ci

SallyHuo-TAOS
Merge remote-tracking branch 'origin/cover/3.0' into cover/3.0

# Conflicts:
#	test/ci/run.sh

149104 of 324176 branches covered (45.99%)

Branch coverage included in aggregate %.

198232 of 269498 relevant lines covered (73.56%)

236558065.91 hits per line

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

69.2
/source/libs/executor/src/projectoperator.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 "executorInt.h"
17
#include "filter.h"
18
#include "functionMgt.h"
19
#include "operator.h"
20
#include "querytask.h"
21
#include "taoserror.h"
22
#include "tdatablock.h"
23

24
typedef struct SProjectOperatorInfo {
25
  SOptrBasicInfo binfo;
26
  SAggSupporter  aggSup;
27
  SArray*        pPseudoColInfo;
28
  SLimitInfo     limitInfo;
29
  bool           mergeDataBlocks;
30
  SSDataBlock*   pFinalRes;
31
  bool           inputIgnoreGroup;
32
  bool           outputIgnoreGroup;
33
} SProjectOperatorInfo;
34

35
typedef struct SIndefOperatorInfo {
36
  SOptrBasicInfo binfo;
37
  SAggSupporter  aggSup;
38
  SArray*        pPseudoColInfo;
39
  SExprSupp      scalarSup;
40
  uint64_t       groupId;
41
  SSDataBlock*   pNextGroupRes;
42
} SIndefOperatorInfo;
43

44
static int32_t      doGenerateSourceData(SOperatorInfo* pOperator);
45
static int32_t      doProjectOperation(SOperatorInfo* pOperator, SSDataBlock** pResBlock);
46
static int32_t      doApplyIndefinitFunction(SOperatorInfo* pOperator, SSDataBlock** pResBlock);
47

48
static void destroyProjectOperatorInfo(void* param) {
342,671,312✔
49
  if (NULL == param) {
342,671,312!
50
    return;
×
51
  }
52

53
  SProjectOperatorInfo* pInfo = (SProjectOperatorInfo*)param;
342,671,312✔
54
  cleanupBasicInfo(&pInfo->binfo);
342,671,312✔
55
  cleanupAggSup(&pInfo->aggSup);
342,698,326✔
56
  taosArrayDestroy(pInfo->pPseudoColInfo);
342,669,057✔
57

58
  blockDataDestroy(pInfo->pFinalRes);
342,668,961✔
59
  taosMemoryFreeClear(param);
342,672,608!
60
}
61

62
static void destroyIndefinitOperatorInfo(void* param) {
15,272,730✔
63
  SIndefOperatorInfo* pInfo = (SIndefOperatorInfo*)param;
15,272,730✔
64
  if (pInfo == NULL) {
15,272,730!
65
    return;
×
66
  }
67

68
  cleanupBasicInfo(&pInfo->binfo);
15,272,730✔
69
  taosArrayDestroy(pInfo->pPseudoColInfo);
15,273,419✔
70
  cleanupAggSup(&pInfo->aggSup);
15,273,419✔
71
  cleanupExprSupp(&pInfo->scalarSup);
15,271,664✔
72

73
  taosMemoryFreeClear(param);
15,271,664!
74
}
75

76
void streamOperatorReleaseState(SOperatorInfo* pOperator) {
×
77
  SOperatorInfo* downstream = pOperator->pDownstream[0];
×
78
  if (downstream->fpSet.releaseStreamStateFn) {
×
79
    downstream->fpSet.releaseStreamStateFn(downstream);
×
80
  }
81
}
×
82

83
void streamOperatorReloadState(SOperatorInfo* pOperator) {
×
84
  SOperatorInfo* downstream = pOperator->pDownstream[0];
×
85
  if (downstream->fpSet.reloadStreamStateFn) {
×
86
    downstream->fpSet.reloadStreamStateFn(downstream);
×
87
  }
88
}
×
89

90
static int32_t resetProjectOperState(SOperatorInfo* pOper) {
31,204,560✔
91
  SProjectOperatorInfo* pProject = pOper->info;
31,204,560✔
92
  SExecTaskInfo*           pTaskInfo = pOper->pTaskInfo;
31,204,560✔
93
  pOper->status = OP_NOT_OPENED;
31,204,560✔
94

95
  resetBasicOperatorState(&pProject->binfo);
31,204,560✔
96
  SProjectPhysiNode* pPhynode = (SProjectPhysiNode*)pOper->pPhyNode;
31,205,843✔
97

98
  pProject->limitInfo = (SLimitInfo){0};
31,205,843✔
99
  initLimitInfo(pPhynode->node.pLimit, pPhynode->node.pSlimit, &pProject->limitInfo);
31,205,843✔
100

101
  blockDataCleanup(pProject->pFinalRes);
31,205,843✔
102

103
  int32_t code = resetAggSup(&pOper->exprSupp, &pProject->aggSup, pTaskInfo, pPhynode->pProjections, NULL,
62,403,145✔
104
    sizeof(int64_t) * 2 + POINTER_BYTES, pTaskInfo->id.str, pTaskInfo->streamInfo.pState,
31,205,843✔
105
    &pTaskInfo->storageAPI.functionStore);
106
  if (code == 0){
31,199,366!
107
    code = setFunctionResultOutput(pOper, &pProject->binfo, &pProject->aggSup, MAIN_SCAN, pOper->exprSupp.numOfExprs);
31,199,366✔
108
  }
109
  return 0;
31,198,062✔
110
}
111

112
int32_t createProjectOperatorInfo(SOperatorInfo* downstream, SProjectPhysiNode* pProjPhyNode, SExecTaskInfo* pTaskInfo,
342,548,888✔
113
                                  SOperatorInfo** pOptrInfo) {
114
  QRY_PARAM_CHECK(pOptrInfo);
342,548,888!
115

116
  int32_t code = TSDB_CODE_SUCCESS;
342,602,488✔
117
  SProjectOperatorInfo* pInfo = taosMemoryCalloc(1, sizeof(SProjectOperatorInfo));
342,602,488✔
118
  SOperatorInfo*        pOperator = taosMemoryCalloc(1, sizeof(SOperatorInfo));
342,339,663✔
119
  if (pInfo == NULL || pOperator == NULL) {
342,408,341!
120
    code = terrno;
×
121
    goto _error;
×
122
  }
123

124
  pOperator->pPhyNode = pProjPhyNode;
342,413,789✔
125
  pOperator->exprSupp.hasWindowOrGroup = false;
342,418,778✔
126
  pOperator->pTaskInfo = pTaskInfo;
342,437,796✔
127

128
  int32_t    lino = 0;
342,484,478✔
129

130
  SSDataBlock* pResBlock = createDataBlockFromDescNode(pProjPhyNode->node.pOutputDataBlockDesc);
342,484,478✔
131
  TSDB_CHECK_NULL(pResBlock, code, lino, _error, terrno);
342,625,756!
132

133
  initLimitInfo(pProjPhyNode->node.pLimit, pProjPhyNode->node.pSlimit, &pInfo->limitInfo);
342,625,756✔
134

135
  pInfo->binfo.pRes = pResBlock;
342,650,872✔
136
  pInfo->pFinalRes = NULL;
342,640,908✔
137

138
  code = createOneDataBlock(pResBlock, false, &pInfo->pFinalRes);
342,602,378✔
139
  TSDB_CHECK_CODE(code, lino, _error);
342,576,119!
140

141
  pInfo->binfo.inputTsOrder = pProjPhyNode->node.inputTsOrder;
342,576,119✔
142
  pInfo->binfo.outputTsOrder = pProjPhyNode->node.outputTsOrder;
342,555,491✔
143
  pInfo->inputIgnoreGroup = pProjPhyNode->inputIgnoreGroup;
342,564,420!
144
  pInfo->outputIgnoreGroup = pProjPhyNode->ignoreGroupId;
342,511,581!
145

146
  if (pTaskInfo->execModel == OPTR_EXEC_MODEL_QUEUE) {
342,456,057✔
147
    pInfo->mergeDataBlocks = false;
888,459✔
148
  } else {
149
    if (!pProjPhyNode->ignoreGroupId) {
341,580,865✔
150
      pInfo->mergeDataBlocks = false;
5,273,735✔
151
    } else {
152
      pInfo->mergeDataBlocks = pProjPhyNode->mergeDataBlock;
336,275,039!
153
    }
154
  }
155

156
  int32_t numOfRows = 4096;
342,544,238✔
157
  size_t  keyBufSize = sizeof(int64_t) + sizeof(int64_t) + POINTER_BYTES;
342,544,238✔
158

159
  // Make sure the size of SSDataBlock will never exceed the size of 2MB.
160
  int32_t TWOMB = 2 * 1024 * 1024;
342,544,238✔
161
  if (numOfRows * pResBlock->info.rowSize > TWOMB) {
342,544,238✔
162
    numOfRows = TWOMB / pResBlock->info.rowSize;
20,716,178!
163
  }
164

165
  initResultSizeInfo(&pOperator->resultInfo, numOfRows);
342,485,963✔
166
  
167
  int32_t    numOfCols = 0;
342,518,670✔
168
  SExprInfo* pExprInfo = NULL;
342,542,512✔
169
  code = createExprInfo(pProjPhyNode->pProjections, NULL, &pExprInfo, &numOfCols);
342,522,486✔
170
  TSDB_CHECK_CODE(code, lino, _error);
342,511,417!
171
  code = initAggSup(&pOperator->exprSupp, &pInfo->aggSup, pExprInfo, numOfCols, keyBufSize, pTaskInfo->id.str,
685,091,931✔
172
                    pTaskInfo->streamInfo.pState, &pTaskInfo->storageAPI.functionStore);
342,514,078✔
173
  TSDB_CHECK_CODE(code, lino, _error);
342,472,564!
174

175
  initBasicInfo(&pInfo->binfo, pResBlock);
342,472,564✔
176
  code = setFunctionResultOutput(pOperator, &pInfo->binfo, &pInfo->aggSup, MAIN_SCAN, numOfCols);
342,503,520✔
177
  TSDB_CHECK_CODE(code, lino, _error);
342,394,536!
178

179
  code = filterInitFromNode((SNode*)pProjPhyNode->node.pConditions, &pOperator->exprSupp.pFilterInfo, 0,
342,505,130✔
180
                            pTaskInfo->pStreamRuntimeInfo);
342,394,536✔
181
  TSDB_CHECK_CODE(code, lino, _error);
342,478,001!
182

183
  code = setRowTsColumnOutputInfo(pOperator->exprSupp.pCtx, numOfCols, &pInfo->pPseudoColInfo);
342,478,001✔
184
  TSDB_CHECK_CODE(code, lino, _error);
342,317,542!
185

186
  setOperatorInfo(pOperator, "ProjectOperator", QUERY_NODE_PHYSICAL_PLAN_PROJECT, false, OP_NOT_OPENED, pInfo,
342,317,542✔
187
                  pTaskInfo);
188
  pOperator->fpSet = createOperatorFpSet(optrDummyOpenFn, doProjectOperation, NULL, destroyProjectOperatorInfo,
342,500,211✔
189
                                         optrDefaultBufFn, NULL, optrDefaultGetNextExtFn, NULL);
190
  setOperatorStreamStateFn(pOperator, streamOperatorReleaseState, streamOperatorReloadState);
342,510,077✔
191
  setOperatorResetStateFn(pOperator, resetProjectOperState);
342,421,932✔
192

193
  if (NULL != downstream) {
342,511,130✔
194
    code = appendDownstream(pOperator, &downstream, 1);
341,372,011✔
195
    if (code != TSDB_CODE_SUCCESS) {
341,363,801!
196
      goto _error;
×
197
    }
198
  }
199

200
  *pOptrInfo = pOperator;
342,502,920✔
201
  return TSDB_CODE_SUCCESS;
342,400,079✔
202

203
_error:
×
204
  if (pInfo != NULL) destroyProjectOperatorInfo(pInfo);
×
205
  destroyOperatorAndDownstreams(pOperator, &downstream, 1);
×
206
  pTaskInfo->code = code;
×
207
  return code;
×
208
}
209

210
static int32_t discardGroupDataBlock(SSDataBlock* pBlock, SLimitInfo* pLimitInfo) {
1,132,463,480✔
211
  if (pLimitInfo->remainGroupOffset > 0) {
1,132,463,480✔
212
    // it is the first group
213
    if (pLimitInfo->currentGroupId == 0 || pLimitInfo->currentGroupId == pBlock->info.id.groupId) {
4,018,272✔
214
      pLimitInfo->currentGroupId = pBlock->info.id.groupId;
1,815,647✔
215
      return PROJECT_RETRIEVE_CONTINUE;
1,815,647✔
216
    } else if (pLimitInfo->currentGroupId != pBlock->info.id.groupId) {
2,202,625!
217
      // now it is the data from a new group
218
      pLimitInfo->remainGroupOffset -= 1;
2,202,625✔
219
      pLimitInfo->currentGroupId = pBlock->info.id.groupId;
2,202,625✔
220

221
      // ignore data block in current group
222
      if (pLimitInfo->remainGroupOffset > 0) {
2,202,625✔
223
        return PROJECT_RETRIEVE_CONTINUE;
2,031,106✔
224
      }
225

226
      pLimitInfo->currentGroupId = 0;
171,519✔
227
    }
228
  }
229

230
  return PROJECT_RETRIEVE_DONE;
1,128,562,745✔
231
}
232

233
static int32_t setInfoForNewGroup(SSDataBlock* pBlock, SLimitInfo* pLimitInfo, SOperatorInfo* pOperator) {
1,128,582,079✔
234
  // remainGroupOffset == 0
235
  // here check for a new group data, we need to handle the data of the previous group.
236
  if (!(pLimitInfo->remainGroupOffset == 0 || pLimitInfo->remainGroupOffset == -1)) {
1,128,582,079!
237
    qError("project failed at: %s:%d", __func__, __LINE__);
×
238
    return TSDB_CODE_INVALID_PARA;
×
239
  }
240

241
  bool newGroup = false;
1,128,850,992✔
242
  if (0 == pBlock->info.id.groupId) {
1,128,850,992✔
243
    pLimitInfo->numOfOutputGroups = 1;
983,272,285✔
244
  } else if (pLimitInfo->currentGroupId != pBlock->info.id.groupId) {
145,181,435✔
245
    pLimitInfo->currentGroupId = pBlock->info.id.groupId;
127,924,204✔
246
    pLimitInfo->numOfOutputGroups += 1;
127,924,204✔
247
    newGroup = true;
127,923,652✔
248
  } else {
249
    return PROJECT_RETRIEVE_CONTINUE;
17,257,231✔
250
  }
251

252
  if ((pLimitInfo->slimit.limit >= 0) && (pLimitInfo->slimit.limit < pLimitInfo->numOfOutputGroups)) {
1,111,409,604✔
253
    setOperatorCompleted(pOperator);
423,180✔
254
    return PROJECT_RETRIEVE_DONE;
423,180✔
255
  }
256

257
  // reset the value for a new group data
258
  // existing rows that belongs to previous group.
259
  if (newGroup) {
1,110,942,475✔
260
    resetLimitInfoForNextGroup(pLimitInfo);
127,501,024✔
261
  }
262

263
  return PROJECT_RETRIEVE_CONTINUE;
1,110,839,458✔
264
}
265

266
// todo refactor
267
static int32_t doIngroupLimitOffset(SLimitInfo* pLimitInfo, uint64_t groupId, SSDataBlock* pBlock,
1,129,259,617✔
268
                                    SOperatorInfo* pOperator) {
269
  // set current group id
270
  pLimitInfo->currentGroupId = groupId;
1,129,259,617✔
271
  bool limitReached = applyLimitOffset(pLimitInfo, pBlock, pOperator->pTaskInfo);
1,129,476,514✔
272
  if (pBlock->info.rows == 0 && 0 != pLimitInfo->limit.limit) {
1,129,470,521✔
273
    return PROJECT_RETRIEVE_CONTINUE;
21,205,768✔
274
  } else {
275
    if (limitReached && (pLimitInfo->slimit.limit >= 0 && pLimitInfo->slimit.limit <= pLimitInfo->numOfOutputGroups)) {
1,108,276,909✔
276
      setOperatorCompleted(pOperator);
176,670✔
277
    } else if (limitReached && groupId == 0) {
1,108,101,314✔
278
      setOperatorCompleted(pOperator);
37,095,280✔
279
    }
280
  }
281

282
  return PROJECT_RETRIEVE_DONE;
1,107,895,146✔
283
}
284

285
int32_t doProjectOperation(SOperatorInfo* pOperator, SSDataBlock** pResBlock) {
1,082,836,436✔
286
  QRY_PARAM_CHECK(pResBlock);
1,082,836,436!
287

288
  SProjectOperatorInfo* pProjectInfo = pOperator->info;
1,082,861,833✔
289
  SOptrBasicInfo*       pInfo = &pProjectInfo->binfo;
1,082,843,483✔
290
  SExprSupp*            pSup = &pOperator->exprSupp;
1,082,846,226✔
291
  SSDataBlock*          pRes = pInfo->pRes;
1,082,807,093✔
292
  SSDataBlock*          pFinalRes = pProjectInfo->pFinalRes;
1,082,804,855✔
293
  int32_t               code = 0;
1,082,817,758✔
294
  int32_t               lino = 0;
1,082,817,758✔
295
  int64_t               st = 0;
1,082,817,758✔
296
  int32_t               order = pInfo->inputTsOrder;
1,082,817,758✔
297
  int32_t               scanFlag = 0;
1,082,787,630✔
298

299
  blockDataCleanup(pFinalRes);
1,082,787,630✔
300
  SExecTaskInfo* pTaskInfo = pOperator->pTaskInfo;
1,082,788,488✔
301

302
  if (pOperator->status == OP_EXEC_DONE) {
1,082,799,317✔
303
    return code;
237,319,930✔
304
  }
305

306
  if (pOperator->cost.openCost == 0) {
845,477,960✔
307
    st = taosGetTimestampUs();
344,825,726✔
308
  }
309

310
  SOperatorInfo* downstream = pOperator->numOfDownstream > 0 ? pOperator->pDownstream[0] : NULL;
845,466,890✔
311
  SLimitInfo*    pLimitInfo = &pProjectInfo->limitInfo;
845,521,632✔
312

313
  if (downstream == NULL) {
845,487,980✔
314
    code = doGenerateSourceData(pOperator);
1,041,234✔
315
    QUERY_CHECK_CODE(code, lino, _end);
1,041,234!
316

317
    if (pProjectInfo->outputIgnoreGroup) {
1,041,234!
318
      pRes->info.id.groupId = 0;
1,041,234✔
319
    }
320

321
    *pResBlock = (pRes->info.rows > 0)? pRes:NULL;
1,041,234!
322
    return code;
1,041,234✔
323
  }
324

325
  while (1) {
642,012,363✔
326
    while (1) {
25,052,521✔
327
      blockDataCleanup(pRes);
1,511,511,630✔
328

329
      // The downstream exec may change the value of the newgroup, so use a local variable instead.
330
      SSDataBlock* pBlock = getNextBlockFromDownstream(pOperator, 0);
1,511,585,597✔
331
      if (pBlock == NULL) {
1,505,351,228✔
332
        qDebug("set op close, exec %d, status %d rows %" PRId64 , pTaskInfo->execModel, pOperator->status, pFinalRes->info.rows);
373,022,811✔
333
        setOperatorCompleted(pOperator);
373,042,012✔
334
        break;
373,049,131✔
335
      }
336
//      if (pTaskInfo->execModel == OPTR_EXEC_MODEL_QUEUE) {
337
//        qDebug("set status recv");
338
//        pOperator->status = OP_EXEC_RECV;
339
//      }
340

341
      // for stream interval
342
      if (pBlock->info.type == STREAM_RETRIEVE || pBlock->info.type == STREAM_DELETE_RESULT ||
1,132,328,417!
343
          pBlock->info.type == STREAM_DELETE_DATA || pBlock->info.type == STREAM_CREATE_CHILD_TABLE ||
1,132,748,466!
344
          pBlock->info.type == STREAM_CHECKPOINT || pBlock->info.type == STREAM_NOTIFY_EVENT) {
1,132,705,868!
345

346
        *pResBlock = pBlock;
×
347
        return code;
×
348
      }
349

350
      if (pProjectInfo->inputIgnoreGroup) {
1,132,595,881!
351
        pBlock->info.id.groupId = 0;
66,303,127✔
352
      }
353

354
      int32_t status = discardGroupDataBlock(pBlock, pLimitInfo);
1,132,556,792✔
355
      if (status == PROJECT_RETRIEVE_CONTINUE) {
1,132,434,529✔
356
        continue;
3,846,753✔
357
      }
358

359
      (void) setInfoForNewGroup(pBlock, pLimitInfo, pOperator);
1,128,587,776✔
360
      if (pOperator->status == OP_EXEC_DONE) {
1,128,380,331✔
361
        break;
423,180✔
362
      }
363

364
      if (pProjectInfo->mergeDataBlocks) {
1,128,467,218✔
365
        pFinalRes->info.scanFlag = scanFlag = pBlock->info.scanFlag;
717,147,461✔
366
      } else {
367
        pRes->info.scanFlag = scanFlag = pBlock->info.scanFlag;
411,329,885✔
368
      }
369

370
      code = setInputDataBlock(pSup, pBlock, order, scanFlag, false);
1,128,416,219✔
371
      QUERY_CHECK_CODE(code, lino, _end);
1,128,314,962!
372

373
      code = blockDataEnsureCapacity(pInfo->pRes, pInfo->pRes->info.rows + pBlock->info.rows);
1,128,314,962✔
374
      QUERY_CHECK_CODE(code, lino, _end);
1,128,362,102!
375

376
      code = projectApplyFunctions(pSup->pExprInfo, pInfo->pRes, pBlock, pSup->pCtx, pSup->numOfExprs,
1,128,425,575✔
377
                                   pProjectInfo->pPseudoColInfo, GET_STM_RTINFO(pOperator->pTaskInfo));
1,128,362,102✔
378
      QUERY_CHECK_CODE(code, lino, _end);
1,128,285,807✔
379

380
      status = doIngroupLimitOffset(pLimitInfo, pBlock->info.id.groupId, pInfo->pRes, pOperator);
1,128,235,197✔
381
      if (status == PROJECT_RETRIEVE_CONTINUE) {
1,128,108,439✔
382
        continue;
21,205,768✔
383
      }
384

385
      break;
1,106,902,671✔
386
    }
387

388
    if (pProjectInfo->mergeDataBlocks) {
1,480,374,982✔
389
      if (pRes->info.rows > 0) {
967,165,719✔
390
        pFinalRes->info.id.groupId = 0;  // clear groupId
703,436,553✔
391
        pFinalRes->info.version = pRes->info.version;
703,409,853✔
392

393
        // continue merge data, ignore the group id
394
        code = blockDataMerge(pFinalRes, pRes);
703,585,066✔
395
        QUERY_CHECK_CODE(code, lino, _end);
703,679,940!
396

397
        if (pFinalRes->info.rows + pRes->info.rows <= pOperator->resultInfo.threshold && (pOperator->status != OP_EXEC_DONE)) {
703,679,940✔
398
          continue;
642,144,247✔
399
        }
400
      }
401

402
      // do apply filter
403
      code = doFilter(pFinalRes, pOperator->exprSupp.pFilterInfo, NULL, NULL);
325,359,925✔
404
      QUERY_CHECK_CODE(code, lino, _end);
325,293,610!
405

406
      // when apply the limit/offset for each group, pRes->info.rows may be 0, due to limit constraint.
407
      if (pFinalRes->info.rows > 0 || (pOperator->status == OP_EXEC_DONE)) {
325,293,610!
408
        qDebug("project return %" PRId64 " rows, status %d", pFinalRes->info.rows, pOperator->status);
325,426,408✔
409
        break;
325,237,062✔
410
      }
411
    } else {
412
      // do apply filter
413
      if (pRes->info.rows > 0) {
513,306,062✔
414
        code = doFilter(pRes, pOperator->exprSupp.pFilterInfo, NULL, NULL);
402,878,523✔
415
        QUERY_CHECK_CODE(code, lino, _end);
402,850,188!
416

417
        if (pRes->info.rows == 0) {
402,850,188!
418
          continue;
×
419
        }
420
      }
421

422
      // no results generated
423
      break;
513,223,084✔
424
    }
425
  }
426

427
  SSDataBlock* p = pProjectInfo->mergeDataBlocks ? pFinalRes : pRes;
838,460,146✔
428
  pOperator->resultInfo.totalRows += p->info.rows;
838,466,861✔
429
  p->info.dataLoad = 1;
838,445,458✔
430

431
  if (pOperator->cost.openCost == 0) {
838,471,341✔
432
    pOperator->cost.openCost = (taosGetTimestampUs() - st) / 1000.0;
341,309,018✔
433
  }
434

435
  if (pProjectInfo->outputIgnoreGroup) {
838,462,003✔
436
    p->info.id.groupId = 0;
773,530,406✔
437
  }
438

439
  if (pTaskInfo->execModel == OPTR_EXEC_MODEL_STREAM) {
838,435,940✔
440
    printDataBlock(p, getStreamOpName(pOperator->operatorType), GET_TASKID(pTaskInfo), pTaskInfo->id.queryId);
24,602,653✔
441
  }
442

443
  *pResBlock = (p->info.rows > 0)? p:NULL;
838,462,163✔
444

445
_end:
838,484,635✔
446
  if (code != TSDB_CODE_SUCCESS) {
838,484,635✔
447
    qError("%s failed at line %d since %s", __func__, lino, tstrerror(code));
50,610!
448
    pTaskInfo->code = code;
50,610✔
449
    T_LONG_JMP(pTaskInfo->env, code);
50,610!
450
  }
451
  return code;
838,434,025✔
452
}
453

454
static int32_t resetIndefinitOutputOperState(SOperatorInfo* pOper) {
×
455
  SIndefOperatorInfo* pInfo = pOper->info;
×
456
  SExecTaskInfo*           pTaskInfo = pOper->pTaskInfo;
×
457
  SIndefRowsFuncPhysiNode* pPhynode = (SIndefRowsFuncPhysiNode*)pOper->pPhyNode;
×
458
  pOper->status = OP_NOT_OPENED;
×
459

460
  resetBasicOperatorState(&pInfo->binfo);
×
461

462
  pInfo->groupId = 0;
×
463
  pInfo->pNextGroupRes = NULL;
×
464
  int32_t code = resetAggSup(&pOper->exprSupp, &pInfo->aggSup, pTaskInfo, pPhynode->pFuncs, NULL,
×
465
    sizeof(int64_t) * 2 + POINTER_BYTES, pTaskInfo->id.str, pTaskInfo->streamInfo.pState,
×
466
    &pTaskInfo->storageAPI.functionStore);
467
  if (code == 0){
×
468
    code = setFunctionResultOutput(pOper, &pInfo->binfo, &pInfo->aggSup, MAIN_SCAN, pOper->exprSupp.numOfExprs);
×
469
  }
470

471
  if (code == 0) {
×
472
    code = resetExprSupp(&pInfo->scalarSup, pTaskInfo, pPhynode->pExprs, NULL,
×
473
                         &pTaskInfo->storageAPI.functionStore);
474
  }
475
  return 0;
×
476
}
477

478
int32_t createIndefinitOutputOperatorInfo(SOperatorInfo* downstream, SPhysiNode* pNode,
15,272,663✔
479
                                                 SExecTaskInfo* pTaskInfo, SOperatorInfo** pOptrInfo) {
480
  QRY_PARAM_CHECK(pOptrInfo);
15,272,663!
481
  int32_t code = 0;
15,271,907✔
482
  int32_t lino = 0;
15,271,907✔
483
  int32_t numOfRows = 4096;
15,271,907✔
484
  size_t  keyBufSize = sizeof(int64_t) + sizeof(int64_t) + POINTER_BYTES;
15,271,907✔
485

486
  SIndefOperatorInfo* pInfo = taosMemoryCalloc(1, sizeof(SIndefOperatorInfo));
15,271,907✔
487
  SOperatorInfo*      pOperator = taosMemoryCalloc(1, sizeof(SOperatorInfo));
15,269,000✔
488
  if (pInfo == NULL || pOperator == NULL) {
15,266,070!
489
    code = terrno;
×
490
    goto _error;
×
491
  }
492

493
  pOperator->pPhyNode = pNode;
15,266,070✔
494
  pOperator->pTaskInfo = pTaskInfo;
15,266,070✔
495

496
  SExprSupp* pSup = &pOperator->exprSupp;
15,266,070✔
497
  pSup->hasWindowOrGroup = false;
15,268,958✔
498

499
  SIndefRowsFuncPhysiNode* pPhyNode = (SIndefRowsFuncPhysiNode*)pNode;
15,270,024✔
500

501
  if (pPhyNode->pExprs != NULL) {
15,270,024✔
502
    int32_t    num = 0;
70,308✔
503
    SExprInfo* pSExpr = NULL;
70,308✔
504
    code = createExprInfo(pPhyNode->pExprs, NULL, &pSExpr, &num);
70,308✔
505
    QUERY_CHECK_CODE(code, lino, _error);
70,308!
506

507
    code = initExprSupp(&pInfo->scalarSup, pSExpr, num, &pTaskInfo->storageAPI.functionStore);
70,308✔
508
    if (code != TSDB_CODE_SUCCESS) {
70,308!
509
      goto _error;
×
510
    }
511
  }
512

513
  SSDataBlock* pResBlock = createDataBlockFromDescNode(pPhyNode->node.pOutputDataBlockDesc);
15,268,656✔
514
  TSDB_CHECK_NULL(pResBlock, code, lino, _error, terrno);
15,272,663!
515

516
  // Make sure the size of SSDataBlock will never exceed the size of 2MB.
517
  int32_t TWOMB = 2 * 1024 * 1024;
15,272,663✔
518
  if (numOfRows * pResBlock->info.rowSize > TWOMB) {
15,272,663!
519
    numOfRows = TWOMB / pResBlock->info.rowSize;
×
520
  }
521

522
  initBasicInfo(&pInfo->binfo, pResBlock);
15,272,663✔
523
  initResultSizeInfo(&pOperator->resultInfo, numOfRows);
15,272,353✔
524
  code = blockDataEnsureCapacity(pResBlock, numOfRows);
15,273,419✔
525
  TSDB_CHECK_CODE(code, lino, _error);
15,273,078!
526

527
  int32_t    numOfExpr = 0;
15,273,078✔
528
  SExprInfo* pExprInfo = NULL;
15,273,078✔
529
  code = createExprInfo(pPhyNode->pFuncs, NULL, &pExprInfo, &numOfExpr);
15,273,078✔
530
  TSDB_CHECK_CODE(code, lino, _error);
15,271,899!
531

532
  code = initAggSup(pSup, &pInfo->aggSup, pExprInfo, numOfExpr, keyBufSize, pTaskInfo->id.str,
30,541,459✔
533
                            pTaskInfo->streamInfo.pState, &pTaskInfo->storageAPI.functionStore);
15,271,899✔
534
  TSDB_CHECK_CODE(code, lino, _error);
15,269,270!
535

536
  code = setFunctionResultOutput(pOperator, &pInfo->binfo, &pInfo->aggSup, MAIN_SCAN, numOfExpr);
15,269,270✔
537
  TSDB_CHECK_CODE(code, lino, _error);
15,260,596!
538

539
  code = filterInitFromNode((SNode*)pPhyNode->node.pConditions, &pOperator->exprSupp.pFilterInfo, 0,
15,264,646✔
540
                            pTaskInfo->pStreamRuntimeInfo);
15,260,596✔
541
  TSDB_CHECK_CODE(code, lino, _error);
15,264,892!
542

543
  pInfo->binfo.pRes = pResBlock;
15,264,892✔
544
  pInfo->binfo.inputTsOrder = pNode->inputTsOrder;
15,264,370✔
545
  pInfo->binfo.outputTsOrder = pNode->outputTsOrder;
15,266,533✔
546
  code = setRowTsColumnOutputInfo(pSup->pCtx, numOfExpr, &pInfo->pPseudoColInfo);
15,264,211✔
547
  TSDB_CHECK_CODE(code, lino, _error);
15,262,661!
548

549
  setOperatorInfo(pOperator, "IndefinitOperator", QUERY_NODE_PHYSICAL_PLAN_INDEF_ROWS_FUNC, false, OP_NOT_OPENED, pInfo,
15,262,661✔
550
                  pTaskInfo);
551
  pOperator->fpSet = createOperatorFpSet(optrDummyOpenFn, doApplyIndefinitFunction, NULL, destroyIndefinitOperatorInfo,
15,271,036✔
552
                                         optrDefaultBufFn, NULL, optrDefaultGetNextExtFn, NULL);
553
                                         
554
  setOperatorResetStateFn(pOperator, resetIndefinitOutputOperState);
15,269,224✔
555
  code = appendDownstream(pOperator, &downstream, 1);
15,270,316✔
556
  if (code != TSDB_CODE_SUCCESS) {
15,266,634!
557
    goto _error;
×
558
  }
559

560
  *pOptrInfo = pOperator;
15,266,634✔
561
  return TSDB_CODE_SUCCESS;
15,268,451✔
562

563
_error:
×
564
  if (pInfo != NULL) destroyIndefinitOperatorInfo(pInfo);
×
565
  destroyOperatorAndDownstreams(pOperator, &downstream, 1);
×
566
  pTaskInfo->code = code;
×
567
  return code;
×
568
}
569

570
static void doHandleDataBlock(SOperatorInfo* pOperator, SSDataBlock* pBlock, SOperatorInfo* downstream,
205,871,886✔
571
                              SExecTaskInfo* pTaskInfo) {
572
  SIndefOperatorInfo* pIndefInfo = pOperator->info;
205,871,886✔
573
  SOptrBasicInfo*     pInfo = &pIndefInfo->binfo;
205,871,741✔
574
  SExprSupp*          pSup = &pOperator->exprSupp;
205,871,886✔
575

576
  int32_t order = pInfo->inputTsOrder;
205,871,886✔
577
  int32_t scanFlag = pBlock->info.scanFlag;
205,871,886✔
578
  int32_t code = TSDB_CODE_SUCCESS;
205,870,820✔
579

580
  // there is an scalar expression that needs to be calculated before apply the group aggregation.
581
  SExprSupp* pScalarSup = &pIndefInfo->scalarSup;
205,870,820✔
582
  if (pScalarSup->pExprInfo != NULL) {
205,871,886✔
583
    code = projectApplyFunctions(pScalarSup->pExprInfo, pBlock, pBlock, pScalarSup->pCtx, pScalarSup->numOfExprs,
220,101✔
584
                                 pIndefInfo->pPseudoColInfo, GET_STM_RTINFO(pOperator->pTaskInfo));
220,101!
585
    if (code != TSDB_CODE_SUCCESS) {
220,101!
586
      T_LONG_JMP(pTaskInfo->env, code);
×
587
    }
588
  }
589

590
  code = setInputDataBlock(pSup, pBlock, order, scanFlag, false);
205,871,886✔
591
  if (code) {
205,871,886!
592
    T_LONG_JMP(pTaskInfo->env, code);
×
593
  }
594

595
  code = blockDataEnsureCapacity(pInfo->pRes, pInfo->pRes->info.rows + pBlock->info.rows);
205,871,886✔
596
  if (code != TSDB_CODE_SUCCESS) {
205,871,741!
597
    T_LONG_JMP(pTaskInfo->env, code);
×
598
  }
599

600
  code = projectApplyFunctions(pSup->pExprInfo, pInfo->pRes, pBlock, pSup->pCtx, pSup->numOfExprs,
205,871,741✔
601
                               pIndefInfo->pPseudoColInfo, GET_STM_RTINFO(pOperator->pTaskInfo));
205,871,741!
602
  if (code != TSDB_CODE_SUCCESS) {
205,871,886✔
603
    T_LONG_JMP(pTaskInfo->env, code);
49,523!
604
  }
605
}
205,822,363✔
606

607
int32_t doApplyIndefinitFunction(SOperatorInfo* pOperator, SSDataBlock** pResBlock) {
50,997,652✔
608
  QRY_PARAM_CHECK(pResBlock);
50,997,652!
609
  SIndefOperatorInfo* pIndefInfo = pOperator->info;
50,997,808✔
610
  SOptrBasicInfo*     pInfo = &pIndefInfo->binfo;
50,999,062✔
611
  SExprSupp*          pSup = &pOperator->exprSupp;
50,998,088✔
612
  int64_t             st = 0;
50,996,340✔
613
  int32_t             code = TSDB_CODE_SUCCESS;
50,996,340✔
614
  int32_t             lino = 0;
50,996,340✔
615
  SSDataBlock*        pRes = pInfo->pRes;
50,996,340✔
616

617
  blockDataCleanup(pRes);
50,995,368✔
618

619
  SExecTaskInfo* pTaskInfo = pOperator->pTaskInfo;
50,999,652✔
620
  if (pOperator->status == OP_EXEC_DONE) {
50,999,652✔
621
    return code;
9,162,357✔
622
  }
623

624
  if (pOperator->cost.openCost == 0) {
41,837,099✔
625
    st = taosGetTimestampUs();
15,270,924✔
626
  }
627

628
  SOperatorInfo* downstream = pOperator->pDownstream[0];
41,839,891✔
629

630
  while (1) {
4,132,866✔
631
    // here we need to handle the existsed group results
632
    if (pIndefInfo->pNextGroupRes != NULL) {  // todo extract method
45,969,406✔
633
      for (int32_t k = 0; k < pSup->numOfExprs; ++k) {
103,245,102✔
634
        SqlFunctionCtx* pCtx = &pSup->pCtx[k];
76,603,590✔
635

636
        SResultRowEntryInfo* pResInfo = GET_RES_INFO(pCtx);
76,603,590✔
637
        pResInfo->initialized = false;
76,603,590✔
638
        pCtx->pOutput = NULL;
76,603,590✔
639
      }
640

641
      doHandleDataBlock(pOperator, pIndefInfo->pNextGroupRes, downstream, pTaskInfo);
26,641,512✔
642
      pIndefInfo->pNextGroupRes = NULL;
26,641,512✔
643
    }
644

645
    if (pInfo->pRes->info.rows < pOperator->resultInfo.threshold) {
45,967,232✔
646
      while (1) {
175,095,540✔
647
        // The downstream exec may change the value of the newgroup, so use a local variable instead.
648
        SSDataBlock* pBlock = getNextBlockFromDownstream(pOperator, 0);
221,059,449✔
649
        if (pBlock == NULL) {
221,069,394✔
650
          setOperatorCompleted(pOperator);
15,074,720✔
651
          break;
15,074,720✔
652
        }
653
        pInfo->pRes->info.scanFlag = pBlock->info.scanFlag;
205,994,674✔
654

655
        if (pIndefInfo->groupId == 0 && pBlock->info.id.groupId != 0) {
205,994,529✔
656
          pIndefInfo->groupId = pBlock->info.id.groupId;  // this is the initial group result
2,184,217✔
657
        } else {
658
          if (pIndefInfo->groupId != pBlock->info.id.groupId) {  // reset output buffer and computing status
203,810,457✔
659
            pIndefInfo->groupId = pBlock->info.id.groupId;
26,764,300✔
660
            pIndefInfo->pNextGroupRes = pBlock;
26,764,300✔
661
            break;
26,764,300✔
662
          }
663
        }
664

665
        doHandleDataBlock(pOperator, pBlock, downstream, pTaskInfo);
179,230,229✔
666
        if (pInfo->pRes->info.rows >= pOperator->resultInfo.threshold) {
179,179,640✔
667
          break;
4,084,245✔
668
        }
669
      }
670
    }
671

672
    code = doFilter(pInfo->pRes, pOperator->exprSupp.pFilterInfo, NULL, NULL);
45,927,849✔
673
    QUERY_CHECK_CODE(code, lino, _end);
45,923,265!
674

675
    size_t rows = pInfo->pRes->info.rows;
45,923,265✔
676
    if (rows > 0 || pOperator->status == OP_EXEC_DONE) {
45,923,265✔
677
      break;
678
    } else {
679
      blockDataCleanup(pInfo->pRes);
4,132,866✔
680
    }
681
  }
682

683
  size_t rows = pInfo->pRes->info.rows;
41,790,399✔
684
  pOperator->resultInfo.totalRows += rows;
41,789,188✔
685

686
  if (pOperator->cost.openCost == 0) {
41,789,333✔
687
    pOperator->cost.openCost = (taosGetTimestampUs() - st) / 1000.0;
15,220,553✔
688
  }
689

690
  *pResBlock = (rows > 0) ? pInfo->pRes : NULL;
41,788,267✔
691

692
_end:
41,788,267✔
693
  if (code != TSDB_CODE_SUCCESS) {
41,788,267!
694
    qError("%s failed at line %d since %s", __func__, lino, tstrerror(code));
×
695
    pTaskInfo->code = code;
×
696
    T_LONG_JMP(pTaskInfo->env, code);
×
697
  }
698
  return code;
41,788,267✔
699
}
700

701
int32_t initCtxOutputBuffer(SqlFunctionCtx* pCtx, int32_t size) {
388,975,830✔
702
  int32_t code = TSDB_CODE_SUCCESS;
388,975,830✔
703
  for (int32_t j = 0; j < size; ++j) {
1,909,072,217✔
704
    struct SResultRowEntryInfo* pResInfo = GET_RES_INFO(&pCtx[j]);
1,520,270,838✔
705
    if (isRowEntryInitialized(pResInfo) || fmIsPseudoColumnFunc(pCtx[j].functionId) || pCtx[j].functionId == -1 ||
1,736,490,440✔
706
        fmIsScalarFunc(pCtx[j].functionId)) {
216,248,170✔
707
      continue;
1,503,225,133✔
708
    }
709

710
    code = pCtx[j].fpSet.init(&pCtx[j], pCtx[j].resultInfo);
17,011,413✔
711
    if (code) {
16,871,826!
712
      return code;
×
713
    }
714
  }
715

716
  return 0;
388,801,379✔
717
}
718

719
/*
720
 * The start of each column SResultRowEntryInfo is denote by RowCellInfoOffset.
721
 * Note that in case of top/bottom query, the whole multiple rows of result is treated as only one row of results.
722
 * +------------+-----------------result column 1------------+------------------result column 2-----------+
723
 * | SResultRow | SResultRowEntryInfo | intermediate buffer1 | SResultRowEntryInfo | intermediate buffer 2|
724
 * +------------+--------------------------------------------+--------------------------------------------+
725
 *           offset[0]                                  offset[1]                                   offset[2]
726
 */
727
// TODO refactor: some function move away
728
int32_t setFunctionResultOutput(struct SOperatorInfo* pOperator, SOptrBasicInfo* pInfo, SAggSupporter* pSup, int32_t stage,
388,976,180✔
729
                             int32_t numOfExprs) {
730
  SExecTaskInfo*  pTaskInfo = pOperator->pTaskInfo;
388,976,180✔
731
  SqlFunctionCtx* pCtx = pOperator->exprSupp.pCtx;
389,095,536✔
732
  int32_t*        rowEntryInfoOffset = pOperator->exprSupp.rowEntryInfoOffset;
389,058,946✔
733

734
  SResultRowInfo* pResultRowInfo = &pInfo->resultRowInfo;
388,930,342✔
735
  initResultRowInfo(pResultRowInfo);
388,972,409✔
736

737
  int64_t     tid = 0;
388,871,915✔
738
  int64_t     groupId = 0;
388,877,870✔
739
  SResultRow* pRow = doSetResultOutBufByKey(pSup->pResultBuf, pResultRowInfo, (char*)&tid, sizeof(tid), true, groupId,
388,877,870✔
740
                                            pTaskInfo, false, pSup, true);
741
  if (pRow == NULL || pTaskInfo->code != 0) {
388,931,700!
742
    return pTaskInfo->code;
21,224✔
743
  }
744

745
  for (int32_t i = 0; i < numOfExprs; ++i) {
1,909,123,387✔
746
    struct SResultRowEntryInfo* pEntry = getResultEntryInfo(pRow, i, rowEntryInfoOffset);
1,520,212,814✔
747
    cleanupResultRowEntry(pEntry);
1,520,320,925✔
748

749
    pCtx[i].resultInfo = pEntry;
1,520,258,035✔
750
    pCtx[i].scanFlag = stage;
1,520,290,403✔
751
  }
752

753
  return initCtxOutputBuffer(pCtx, numOfExprs);
388,910,573✔
754
}
755

756
int32_t setRowTsColumnOutputInfo(SqlFunctionCtx* pCtx, int32_t numOfCols, SArray** pResList) {
357,781,978✔
757
  QRY_PARAM_CHECK(pResList);
357,781,978!
758
  SArray* pList = taosArrayInit(4, sizeof(int32_t));
357,820,785✔
759
  if (pList == NULL) {
357,874,951!
760
    return terrno;
×
761
  }
762

763
  for (int32_t i = 0; i < numOfCols; ++i) {
1,769,679,540✔
764
    if (fmIsPseudoColumnFunc(pCtx[i].functionId) && !fmIsPlaceHolderFunc(pCtx[i].functionId)) {
1,412,014,655!
765
      void* px = taosArrayPush(pList, &i);
×
766
      if (px == NULL) {
×
767
        return terrno;
×
768
      }
769
    }
770
  }
771

772
  *pResList = pList;
357,643,795✔
773
  return 0;
357,668,613✔
774
}
775

776
int32_t doGenerateSourceData(SOperatorInfo* pOperator) {
1,041,234✔
777
  SProjectOperatorInfo* pProjectInfo = pOperator->info;
1,041,234✔
778

779
  SExprSupp*   pSup = &pOperator->exprSupp;
1,041,234✔
780
  SSDataBlock* pRes = pProjectInfo->binfo.pRes;
1,041,234✔
781
  SExprInfo*   pExpr = pSup->pExprInfo;
1,041,234✔
782
  int64_t      st = taosGetTimestampUs();
1,041,234✔
783
  SExecTaskInfo* pTaskInfo = pOperator->pTaskInfo;
1,041,234✔
784

785
  int32_t code = blockDataEnsureCapacity(pRes, pOperator->resultInfo.capacity);
1,041,234✔
786
  if (code) {
1,041,234!
787
    return code;
×
788
  }
789

790
  for (int32_t k = 0; k < pSup->numOfExprs; ++k) {
2,090,464✔
791
    int32_t outputSlotId = pExpr[k].base.resSchema.slotId;
1,049,230✔
792

793
    if (pExpr[k].pExpr->nodeType == QUERY_NODE_VALUE) {
1,049,230!
794
      SColumnInfoData* pColInfoData = taosArrayGet(pRes->pDataBlock, outputSlotId);
1,049,230✔
795
      if (pColInfoData == NULL) {
1,049,230!
796
        return terrno;
×
797
      }
798

799
      int32_t type = pExpr[k].base.pParam[0].param.nType;
1,049,230✔
800
      if (TSDB_DATA_TYPE_NULL == type) {
1,049,230✔
801
        colDataSetNNULL(pColInfoData, 0, 1);
802
      } else {
803
        code = colDataSetVal(pColInfoData, 0, taosVariantGet(&pExpr[k].base.pParam[0].param, type), false);
1,032,754✔
804
        if (code) {
1,032,754!
805
          return code;
×
806
        }
807
      }
808
    } else if (pExpr[k].pExpr->nodeType == QUERY_NODE_FUNCTION) {
×
809
      SqlFunctionCtx* pfCtx = &pSup->pCtx[k];
×
810

811
      // UDF scalar functions will be calculated here, for example, select foo(n) from (select 1 n).
812
      // UDF aggregate functions will be handled in agg operator.
813
      if (fmIsScalarFunc(pfCtx->functionId)) {
×
814
        SArray* pBlockList = taosArrayInit(4, POINTER_BYTES);
×
815
        if (pBlockList == NULL) {
×
816
          return terrno;
×
817
        }
818

819
        void* px = taosArrayPush(pBlockList, &pRes);
×
820
        if (px == NULL) {
×
821
          return terrno;
×
822
        }
823

824
        SColumnInfoData* pResColData = taosArrayGet(pRes->pDataBlock, outputSlotId);
×
825
        if (pResColData == NULL) {
×
826
          return terrno;
×
827
        }
828

829
        SColumnInfoData  idata = {.info = pResColData->info, .hasNull = true};
×
830

831
        SScalarParam dest = {.columnData = &idata};
×
832
        code = scalarCalculate((SNode*)pExpr[k].pExpr->_function.pFunctNode, pBlockList, &dest, GET_STM_RTINFO(pOperator->pTaskInfo), NULL);
×
833
        if (code != TSDB_CODE_SUCCESS) {
×
834
          taosArrayDestroy(pBlockList);
×
835
          return code;
×
836
        }
837

838
        int32_t startOffset = pRes->info.rows;
×
839
        if (pRes->info.capacity <= 0) {
×
840
          qError("project failed at: %s:%d", __func__, __LINE__);
×
841
          return TSDB_CODE_QRY_EXECUTOR_INTERNAL_ERROR;
×
842
        }
843
        code = colDataAssign(pResColData, &idata, dest.numOfRows, &pRes->info);
×
844
        if (code) {
×
845
          return code;
×
846
        }
847

848
        colDataDestroy(&idata);
×
849
        taosArrayDestroy(pBlockList);
×
850
      } else {
851
        return TSDB_CODE_OPS_NOT_SUPPORT;
×
852
      }
853
    } else {
854
      return TSDB_CODE_OPS_NOT_SUPPORT;
×
855
    }
856
  }
857

858
  pRes->info.rows = 1;
1,041,234✔
859
  code = doFilter(pRes, pOperator->exprSupp.pFilterInfo, NULL, NULL);
1,041,234✔
860
  if (code) {
1,041,234!
861
    pTaskInfo->code = code;
×
862
    return code;
×
863
  }
864

865
  (void) doIngroupLimitOffset(&pProjectInfo->limitInfo, 0, pRes, pOperator);
1,041,234✔
866

867
  pOperator->resultInfo.totalRows += pRes->info.rows;
1,041,234✔
868

869
  setOperatorCompleted(pOperator);
1,041,234✔
870
  if (pOperator->cost.openCost == 0) {
1,041,234!
871
    pOperator->cost.openCost = (taosGetTimestampUs() - st) / 1000.0;
1,041,234✔
872
  }
873

874
  return code;
1,041,234✔
875
}
876

877
static void setPseudoOutputColInfo(SSDataBlock* pResult, SqlFunctionCtx* pCtx, SArray* pPseudoList) {
1,695,154,793✔
878
  size_t num = (pPseudoList != NULL) ? taosArrayGetSize(pPseudoList) : 0;
1,695,154,793✔
879
  for (int32_t i = 0; i < num; ++i) {
1,695,746,660!
880
    pCtx[i].pOutput = taosArrayGet(pResult->pDataBlock, i);
×
881
    if (pCtx[i].pOutput == NULL) {
×
882
      qError("failed to get the output buf, ptr is null");
×
883
    }
884
  }
885
}
1,695,746,660✔
886

887
int32_t projectApplyColumn(SSDataBlock* pResult, SSDataBlock* pSrcBlock, int32_t outputSlotId, SqlFunctionCtx* pfCtx, int32_t* numOfRows, bool createNewColModel) {
2,147,483,647✔
888
  int32_t code = 0, lino = 0;
2,147,483,647✔
889
  SInputColumnInfoData* pInputData = &pfCtx->input;
2,147,483,647✔
890
  SColumnInfoData* pColInfoData = taosArrayGet(pResult->pDataBlock, outputSlotId);
2,147,483,647✔
891
  TSDB_CHECK_NULL(pColInfoData, code, lino, _exit, terrno);
2,147,483,647!
892

893
  if (pResult->info.rows > 0 && !createNewColModel) {
2,147,483,647!
894
    if (pInputData->pData[0] == NULL) {
×
895
      int32_t slotId = pfCtx->param[0].pCol->slotId;
×
896

897
      SColumnInfoData* pInput = taosArrayGet(pSrcBlock->pDataBlock, slotId);
×
898
      TSDB_CHECK_NULL(pInput, code, lino, _exit, terrno);
×
899

900
      TAOS_CHECK_EXIT(colDataMergeCol(pColInfoData, pResult->info.rows, (int32_t*)&pResult->info.capacity, pInput,
×
901
                            pSrcBlock->info.rows));
902
      *numOfRows = pSrcBlock->info.rows;
×
903
      return code;
×
904
    }
905
    
906
    TAOS_CHECK_EXIT(colDataMergeCol(pColInfoData, pResult->info.rows, (int32_t*)&pResult->info.capacity,
×
907
                          pInputData->pData[0], pInputData->numOfRows));
908
    *numOfRows = pInputData->numOfRows;
×
909
    return code;
×
910
  } 
911
  
912
  if (pInputData->pData[0] == NULL) {
2,147,483,647!
913
    int32_t slotId = pfCtx->param[0].pCol->slotId;
×
914

915
    SColumnInfoData* pInput = taosArrayGet(pSrcBlock->pDataBlock, slotId);
×
916
    TSDB_CHECK_NULL(pInput, code, lino, _exit, terrno);
×
917

918
    TAOS_CHECK_EXIT(colDataAssign(pColInfoData, pInput, pSrcBlock->info.rows, &pResult->info));
×
919
    *numOfRows = pSrcBlock->info.rows;
×
920

921
    return code;
×
922
  }
923
  
924
  TAOS_CHECK_EXIT(colDataAssign(pColInfoData, pInputData->pData[0], pInputData->numOfRows, &pResult->info));
2,147,483,647!
925
  *numOfRows = pInputData->numOfRows;
2,147,483,647✔
926

927
_exit:
2,147,483,647✔
928

929
  if (code) {
2,147,483,647!
930
    qError("%s failed at line %d since %s", __func__, lino, tstrerror(code));
×
931
  }
932
  
933
  return code;
2,147,483,647✔
934
}
935

936

937
int32_t projectApplyValue(SExprInfo* pExpr, SSDataBlock* pResult, SSDataBlock* pSrcBlock, int32_t outputSlotId, int32_t* numOfRows, bool createNewColModel) {
100,858,426✔
938
  int32_t code = 0, lino = 0;
100,858,426✔
939
  SColumnInfoData* pColInfoData = taosArrayGet(pResult->pDataBlock, outputSlotId);
100,858,426✔
940
  TSDB_CHECK_NULL(pColInfoData, code, lino, _exit, terrno);
100,868,771!
941

942
  int32_t offset = createNewColModel ? 0 : pResult->info.rows;
100,868,771!
943
  int32_t type = pExpr->base.pParam[0].param.nType;
100,879,299✔
944
  if (TSDB_DATA_TYPE_NULL == type) {
100,860,557✔
945
    colDataSetNNULL(pColInfoData, offset, pSrcBlock->info.rows);
1,692,000!
946
  } else {
947
    char* p = taosVariantGet(&pExpr->base.pParam[0].param, type);
99,168,557✔
948
    for (int32_t i = 0; i < pSrcBlock->info.rows; ++i) {
2,147,483,647✔
949
      TAOS_CHECK_EXIT(colDataSetVal(pColInfoData, i + offset, p, false));
2,147,483,647!
950
    }
951
  }
952

953
  *numOfRows = pSrcBlock->info.rows;
82,340,754✔
954

955
_exit:
100,909,757✔
956

957
  if (code) {
100,909,757!
958
    qError("%s failed at line %d since %s", __func__, lino, tstrerror(code));
×
959
  }
960
  
961
  return code;
100,888,854✔
962
}
963

964

965

966
int32_t projectApplyOperator(SExprInfo* pExpr, SSDataBlock* pResult, SSDataBlock* pSrcBlock, int32_t outputSlotId, int32_t* numOfRows, bool createNewColModel, const void* pExtraParams) {
166,764,663✔
967
  int32_t code = 0, lino = 0;
166,764,663✔
968
  SArray* pBlockList = taosArrayInit(4, POINTER_BYTES);
166,764,663✔
969
  TSDB_CHECK_NULL(pBlockList, code, lino, _exit, terrno);
166,818,640!
970

971
  void* px = taosArrayPush(pBlockList, &pSrcBlock);
166,790,140✔
972
  TSDB_CHECK_NULL(px, code, lino, _exit, terrno);
166,790,140!
973

974
  SColumnInfoData* pResColData = taosArrayGet(pResult->pDataBlock, outputSlotId);
166,790,140✔
975
  TSDB_CHECK_NULL(pResColData, code, lino, _exit, terrno);
166,815,101!
976

977
  SColumnInfoData idata = {.info = pResColData->info, .hasNull = true};
166,815,101✔
978
  SScalarParam dest = {.columnData = &idata};
166,785,790✔
979
  TAOS_CHECK_EXIT(scalarCalculate(pExpr->pExpr->_optrRoot.pRootNode, pBlockList, &dest, pExtraParams, NULL));
166,773,945✔
980

981
  if (pResult->info.rows > 0 && !createNewColModel) {
166,776,868!
982
    code = colDataMergeCol(pResColData, pResult->info.rows, (int32_t*)&pResult->info.capacity, &idata, dest.numOfRows);
×
983
  } else {
984
    code = colDataAssign(pResColData, &idata, dest.numOfRows, &pResult->info);
166,788,324✔
985
  }
986

987
  colDataDestroy(&idata);
166,810,622✔
988
  TAOS_CHECK_EXIT(code);
166,816,173!
989

990
  *numOfRows = dest.numOfRows;
166,816,173✔
991
  
992
_exit:
166,822,814✔
993

994
  if (code < 0) {
166,801,202✔
995
    qError("%s failed at line %d since %s", __func__, lino, tstrerror(code));
7,070!
996
  }
997

998
  taosArrayDestroy(pBlockList);
166,801,202✔
999
  
1000
  return code;
166,799,577✔
1001
}
1002

1003

1004
int32_t projectApplyFunction(SqlFunctionCtx* pCtx, SqlFunctionCtx* pfCtx, SExprInfo* pExpr, SSDataBlock* pResult, SSDataBlock* pSrcBlock, 
1,488,661,281✔
1005
                                    int32_t outputSlotId, int32_t* numOfRows, bool createNewColModel, const void* pExtraParams, 
1006
                                    SArray* pPseudoList, SArray** processByRowFunctionCtx, bool doSelectFunc) {
1007
  int32_t code = 0, lino = 0;
1,488,661,281✔
1008
  SArray* pBlockList = NULL;
1,488,661,281✔
1009
  SColumnInfoData* pResColData = taosArrayGet(pResult->pDataBlock, outputSlotId);
1,488,661,281✔
1010
  TSDB_CHECK_NULL(pResColData, code, lino, _exit, terrno);
1,488,839,089!
1011

1012
  if (fmIsPlaceHolderFunc(pfCtx->functionId) && pExtraParams && pfCtx->pExpr->base.pParamList && 1 == pfCtx->pExpr->base.pParamList->length) {
1,488,839,089!
1013
    TAOS_CHECK_EXIT(scalarAssignPlaceHolderRes(pResColData, pResult->info.rows, pSrcBlock->info.rows, pfCtx->functionId, pExtraParams));
8,037,378!
1014
    *numOfRows = pSrcBlock->info.rows;
8,036,132✔
1015

1016
    return code;
8,037,378✔
1017
  }
1018

1019
  if (fmIsScalarFunc(pfCtx->functionId) || fmIsPlaceHolderFunc(pfCtx->functionId)) {
1,480,825,755!
1020
    pBlockList = taosArrayInit(4, POINTER_BYTES);
910,461,410✔
1021
    TSDB_CHECK_NULL(pBlockList, code, lino, _exit, terrno);
910,382,481!
1022

1023
    void* px = taosArrayPush(pBlockList, &pSrcBlock);
910,442,238✔
1024
    TSDB_CHECK_NULL(px, code, lino, _exit, terrno);
910,442,238!
1025

1026
    SColumnInfoData idata = {.info = pResColData->info, .hasNull = true};
910,442,238✔
1027
    SScalarParam dest = {.columnData = &idata};
910,249,199✔
1028
    TAOS_CHECK_EXIT(scalarCalculate((SNode*)pExpr->pExpr->_function.pFunctNode, pBlockList, &dest, pExtraParams, NULL));
910,387,128✔
1029

1030
    if (pResult->info.rows > 0 && !createNewColModel) {
910,229,317!
1031
      code = colDataMergeCol(pResColData, pResult->info.rows, (int32_t*)&pResult->info.capacity, &idata, dest.numOfRows);
×
1032
    } else {
1033
      SColumnInfo oriInfo = pResColData->info;
910,437,810✔
1034
      code = colDataAssign(pResColData, &idata, dest.numOfRows, &pResult->info);
910,461,244✔
1035
      // restore the original column info to satisfy the output column schema
1036
      pResColData->info = oriInfo;
910,450,380✔
1037
    }
1038

1039
    colDataDestroy(&idata);
910,458,345✔
1040
    taosArrayDestroy(pBlockList);
910,454,440✔
1041
    TAOS_CHECK_EXIT(code);
910,410,625!
1042

1043
    *numOfRows = dest.numOfRows;
910,410,625✔
1044

1045
    return code;
910,405,406✔
1046
  }
1047

1048
  if (fmIsIndefiniteRowsFunc(pfCtx->functionId)) {
570,407,468✔
1049
    SResultRowEntryInfo* pResInfo = GET_RES_INFO(pfCtx);
205,986,300✔
1050
    TAOS_CHECK_EXIT(pfCtx->fpSet.init(pfCtx, pResInfo));
205,986,300!
1051

1052

1053
    pfCtx->pOutput = (char*)pResColData;
205,987,056✔
1054
    TSDB_CHECK_NULL(pfCtx->pOutput, code, lino, _exit, terrno);
205,987,056!
1055

1056
    pfCtx->offset = createNewColModel ? 0 : pResult->info.rows;  // set the start offset
205,987,056!
1057

1058
    // set the timestamp(_rowts) output buffer
1059
    if (taosArrayGetSize(pPseudoList) > 0) {
205,987,056!
1060
      int32_t* outputColIndex = taosArrayGet(pPseudoList, 0);
×
1061
      TSDB_CHECK_NULL(outputColIndex, code, lino, _exit, terrno);
×
1062

1063
      pfCtx->pTsOutput = (SColumnInfoData*)pCtx[*outputColIndex].pOutput;
×
1064
    }
1065

1066
    // link pDstBlock to set selectivity value
1067
    if (pfCtx->subsidiaries.num > 0) {
205,987,056✔
1068
      pfCtx->pDstBlock = pResult;
186,491,302✔
1069
    }
1070

1071
    code = pfCtx->fpSet.process(pfCtx);
205,985,845✔
1072
    if (code != TSDB_CODE_SUCCESS) {
205,987,056✔
1073
      if (pfCtx->fpSet.cleanup != NULL) {
23,949!
1074
        pfCtx->fpSet.cleanup(pfCtx);
×
1075
      }
1076
      TAOS_CHECK_EXIT(code);
23,949!
1077
    }
1078

1079
    *numOfRows = pResInfo->numOfRes;
205,963,107✔
1080
    
1081
    if (fmIsProcessByRowFunc(pfCtx->functionId)) {
205,963,107✔
1082
      if (NULL == *processByRowFunctionCtx) {
191,490,107✔
1083
        *processByRowFunctionCtx = taosArrayInit(1, sizeof(SqlFunctionCtx*));
191,416,127✔
1084
        TSDB_CHECK_NULL(*processByRowFunctionCtx, code, lino, _exit, terrno);
191,416,127!
1085
      }
1086

1087
      void* px = taosArrayPush(*processByRowFunctionCtx, &pfCtx);
191,490,107✔
1088
      TSDB_CHECK_NULL(px, code, lino, _exit, terrno);
191,490,107!
1089
    }
1090

1091
    return code;
205,963,107✔
1092
  } 
1093

1094
  if (fmIsAggFunc(pfCtx->functionId)) {
364,421,168!
1095
    // selective value output should be set during corresponding function execution
1096
    if (!doSelectFunc && fmIsSelectValueFunc(pfCtx->functionId)) {
364,421,168!
1097
      return code;
186,790,282✔
1098
    }
1099
    
1100
    // _group_key function for "partition by tbname" + csum(col_name) query
1101
    int32_t slotId = pfCtx->param[0].pCol->slotId;
177,630,886✔
1102

1103
    // todo handle the json tag
1104
    SColumnInfoData* pInput = taosArrayGet(pSrcBlock->pDataBlock, slotId);
177,630,886✔
1105
    TSDB_CHECK_NULL(pInput, code, lino, _exit, terrno);
177,630,886!
1106

1107
    for (int32_t f = 0; f < pSrcBlock->info.rows; ++f) {
2,147,483,647✔
1108
      bool isNull = colDataIsNull_s(pInput, f);
2,147,483,647!
1109
      if (isNull) {
2,147,483,647✔
1110
        colDataSetNULL(pResColData, pResult->info.rows + f);
1,248,642,300!
1111
      } else {
1112
        char* data = colDataGetData(pInput, f);
2,147,483,647!
1113
        TAOS_CHECK_EXIT(colDataSetVal(pResColData, pResult->info.rows + f, data, isNull));
2,147,483,647!
1114
      }
1115
    }
1116

1117
    *numOfRows = pSrcBlock->info.rows;
177,630,886✔
1118

1119
    return code;
177,630,886✔
1120
  } 
1121
  
1122
  if (fmIsGroupIdFunc(pfCtx->functionId)) {
×
1123
    for (int32_t f = 0; f < pSrcBlock->info.rows; ++f) {
×
1124
      TAOS_CHECK_EXIT(colDataSetVal(pResColData, pResult->info.rows + f, (const char*)&pSrcBlock->info.id.groupId, false));
×
1125
    }
1126

1127
    *numOfRows = pSrcBlock->info.rows;
×
1128
    return code;
×
1129
  }
1130
  
1131
_exit:
×
1132

1133
  if (code) {
67,489!
1134
    qError("%s failed at line %d since %s", __func__, lino, tstrerror(code));
67,489!
1135
  }
1136

1137
  taosArrayDestroy(pBlockList);
67,489✔
1138
  
1139
  return code;
67,489✔
1140
}
1141

1142

1143
int32_t projectApplyFunctionsWithSelect(SExprInfo* pExpr, SSDataBlock* pResult, SSDataBlock* pSrcBlock,
1,695,220,089✔
1144
                                        SqlFunctionCtx* pCtx, int32_t numOfOutput, SArray* pPseudoList,
1145
                                        const void* pExtraParams, bool doSelectFunc, bool hasIndefRowsFunc) {
1146
  int32_t lino = 0;
1,695,220,089✔
1147
  int32_t code = TSDB_CODE_SUCCESS;
1,695,220,089✔
1148
  if (hasIndefRowsFunc) {
1,695,220,089!
1149
    setPseudoOutputColInfo(pResult, pCtx, pPseudoList);
1,695,359,681✔
1150
  }
1151
  pResult->info.dataLoad = 1;
1,695,225,238✔
1152

1153
  SArray* processByRowFunctionCtx = NULL;
1,695,423,922✔
1154
  if (pSrcBlock == NULL) {
1,695,153,201!
1155
    for (int32_t k = 0; k < numOfOutput; ++k) {
×
1156
      int32_t outputSlotId = pExpr[k].base.resSchema.slotId;
×
1157

1158
      if (pExpr[k].pExpr->nodeType != QUERY_NODE_VALUE) {
×
1159
        qError("project failed at: %s:%d", __func__, __LINE__);
×
1160
        TAOS_CHECK_EXIT(TSDB_CODE_INVALID_PARA);
×
1161
      }
1162
      SColumnInfoData* pColInfoData = taosArrayGet(pResult->pDataBlock, outputSlotId);
×
1163
      TSDB_CHECK_NULL(pColInfoData, code, lino, _exit, terrno);
×
1164

1165
      int32_t type = pExpr[k].base.pParam[0].param.nType;
×
1166
      if (TSDB_DATA_TYPE_NULL == type) {
×
1167
        colDataSetNNULL(pColInfoData, 0, 1);
1168
      } else {
1169
        TAOS_CHECK_EXIT(colDataSetVal(pColInfoData, 0, taosVariantGet(&pExpr[k].base.pParam[0].param, type), false));
×
1170
      }
1171
    }
1172

1173
    pResult->info.rows = 1;
×
1174
    goto _exit;
×
1175
  }
1176

1177
  if (pResult != pSrcBlock) {
1,695,153,201✔
1178
    pResult->info.id.groupId = pSrcBlock->info.id.groupId;
1,354,583,390✔
1179
    if (pSrcBlock->info.parTbName[0]) {
1,354,922,918!
1180
      tstrncpy(pResult->info.parTbName, pSrcBlock->info.parTbName, TSDB_TABLE_NAME_LEN);
×
1181
    }
1182
    qTrace("%s, parName:%s,groupId:%" PRIu64, __FUNCTION__, pSrcBlock->info.parTbName, pResult->info.id.groupId);
1,354,904,213!
1183
  }
1184

1185
  // if the source equals to the destination, it is to create a new column as the result of scalar
1186
  // function or some operators.
1187
  bool createNewColModel = (pResult == pSrcBlock);
1,695,067,519✔
1188
  if (createNewColModel) {
1,695,067,519✔
1189
    TAOS_CHECK_EXIT(blockDataEnsureCapacity(pResult, pResult->info.rows));
340,618,064!
1190
  }
1191

1192
  int32_t numOfRows = 0;
1,695,064,181✔
1193

1194
  for (int32_t k = 0; k < numOfOutput; ++k) {
2,147,483,647✔
1195
    int32_t               outputSlotId = pExpr[k].base.resSchema.slotId;
2,147,483,647✔
1196
    SqlFunctionCtx*       pfCtx = &pCtx[k];
2,147,483,647✔
1197
    switch (pExpr[k].pExpr->nodeType) {
2,147,483,647!
1198
      case QUERY_NODE_COLUMN: {
2,147,483,647✔
1199
        TAOS_CHECK_EXIT(projectApplyColumn(pResult, pSrcBlock, outputSlotId, pfCtx, &numOfRows, createNewColModel));
2,147,483,647!
1200
        break;
2,147,483,647✔
1201
      } 
1202
      case QUERY_NODE_VALUE: {
100,849,155✔
1203
        TAOS_CHECK_EXIT(projectApplyValue(&pExpr[k], pResult, pSrcBlock, outputSlotId, &numOfRows, createNewColModel));
100,849,155!
1204
        break;
100,889,304✔
1205
      } 
1206
      case QUERY_NODE_OPERATOR: {
166,758,916✔
1207
        TAOS_CHECK_EXIT(projectApplyOperator(&pExpr[k], pResult, pSrcBlock, outputSlotId, &numOfRows, createNewColModel, pExtraParams));
166,758,916✔
1208
        break;
166,790,887✔
1209
      } 
1210
      case QUERY_NODE_FUNCTION: {
1,488,725,767✔
1211
        TAOS_CHECK_EXIT(projectApplyFunction(pCtx, pfCtx, &pExpr[k], pResult, pSrcBlock, outputSlotId, &numOfRows, createNewColModel, pExtraParams, pPseudoList, &processByRowFunctionCtx, doSelectFunc));
1,488,725,767✔
1212
        break;
1,488,605,151✔
1213
      }
1214
      default: {
×
1215
        qError("invalid project expr nodeType:%d", pExpr[k].pExpr->nodeType);
×
1216
        TAOS_CHECK_EXIT(TSDB_CODE_OPS_NOT_SUPPORT);
×
1217
      }
1218
    }
1219
  }
1220

1221
  if (processByRowFunctionCtx && taosArrayGetSize(processByRowFunctionCtx) > 0) {
1,695,356,250!
1222
    SqlFunctionCtx** pfCtx = taosArrayGet(processByRowFunctionCtx, 0);
191,416,127✔
1223
    TSDB_CHECK_NULL(pfCtx, code, lino, _exit, terrno);
191,416,127!
1224

1225
    TAOS_CHECK_EXIT((*pfCtx)->fpSet.processFuncByRow(processByRowFunctionCtx));
191,416,127✔
1226
    numOfRows = (*pfCtx)->resultInfo->numOfRes;
191,390,553✔
1227
  }
1228

1229
  if (!createNewColModel) {
1,695,368,404✔
1230
    pResult->info.rows += numOfRows;
1,354,759,808✔
1231
  }
1232

1233
_exit:
1,695,616,338✔
1234
  if (processByRowFunctionCtx) {
1,695,607,701✔
1235
    taosArrayDestroy(processByRowFunctionCtx);
191,416,127✔
1236
  }
1237
  if (code) {
1,695,607,701✔
1238
    qError("%s failed at line %d since %s", __func__, lino, tstrerror(code));
100,133!
1239
  }
1240
  return code;
1,695,607,701✔
1241
}
1242

1243
int32_t projectApplyFunctions(SExprInfo* pExpr, SSDataBlock* pResult, SSDataBlock* pSrcBlock, SqlFunctionCtx* pCtx,
1,695,239,360✔
1244
                              int32_t numOfOutput, SArray* pPseudoList, const void* pExtraParams) {
1245
  return projectApplyFunctionsWithSelect(pExpr, pResult, pSrcBlock, pCtx, numOfOutput, pPseudoList, pExtraParams, false, true);
1,695,239,360✔
1246
}
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