• 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

77.04
/source/libs/parser/src/parCalcConst.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 "functionMgt.h"
17
#include "parInt.h"
18
#include "scalar.h"
19
#include "ttime.h"
20

21
typedef struct SNodeReplaceContext {
22
  SNode* pTarget;
23
  SNode* pNew;
24
  bool   replaced;
25
} SNodeReplaceContext;
26

27
typedef struct SCalcConstContext {
28
  SParseContext*      pParseCxt;
29
  SNodeReplaceContext replaceCxt;
30
  SMsgBuf             msgBuf;
31
  int32_t             code;
32
} SCalcConstContext;
33

34
static int32_t calcConstQuery(SCalcConstContext* pCxt, SNode* pStmt, bool subquery);
35

36
static int32_t calcConstSubquery(SCalcConstContext* pCxt, STempTableNode* pTempTable) {
3,102✔
37
  return calcConstQuery(pCxt, pTempTable->pSubquery, true);
3,102✔
38
}
39

40
static int32_t calcConstNode(SNode** pNode) {
1,015,572✔
41
  if (NULL == *pNode) {
1,015,572✔
42
    return TSDB_CODE_SUCCESS;
769,458✔
43
  }
44

45
  SNode*  pNew = NULL;
246,114✔
46
  int32_t code = scalarCalculateConstants(*pNode, &pNew);
246,114✔
47
  if (TSDB_CODE_SUCCESS == code) {
246,244!
48
    *pNode = pNew;
246,245✔
49
  }
50
  return code;
246,244✔
51
}
52

53
static int32_t calcConstList(SNodeList* pList) {
774,736✔
54
  SNode* pNode = NULL;
774,736✔
55
  FOREACH(pNode, pList) {
787,660✔
56
    SNode*  pNew = NULL;
12,924✔
57
    int32_t code = scalarCalculateConstants(pNode, &pNew);
12,924✔
58
    if (TSDB_CODE_SUCCESS == code) {
12,924!
59
      REPLACE_NODE(pNew);
12,924✔
60
    } else {
61
      return code;
×
62
    }
63
  }
64
  return TSDB_CODE_SUCCESS;
774,736✔
65
}
66

67
static bool isCondition(const SNode* pNode) {
692,653✔
68
  if (QUERY_NODE_OPERATOR == nodeType(pNode)) {
692,653✔
69
    return nodesIsComparisonOp((const SOperatorNode*)pNode);
463,587✔
70
  }
71
  return (QUERY_NODE_LOGIC_CONDITION == nodeType(pNode));
229,066✔
72
}
73

74
static int32_t rewriteIsTrue(SNode* pSrc, SNode** pIsTrue) {
2,812✔
75
  SOperatorNode* pOp = NULL;
2,812✔
76
  int32_t        code = nodesMakeNode(QUERY_NODE_OPERATOR, (SNode**)&pOp);
2,812✔
77
  if (NULL == pOp) {
2,812!
78
    return code;
×
79
  }
80
  pOp->opType = OP_TYPE_IS_TRUE;
2,812✔
81
  pOp->pLeft = pSrc;
2,812✔
82
  pOp->node.resType.type = TSDB_DATA_TYPE_BOOL;
2,812✔
83
  pOp->node.resType.bytes = tDataTypes[TSDB_DATA_TYPE_BOOL].bytes;
2,812✔
84
  *pIsTrue = (SNode*)pOp;
2,812✔
85
  return TSDB_CODE_SUCCESS;
2,812✔
86
}
87

88
static EDealRes doRewriteCondition(SNode** pNode, void* pContext) {
2,255,625✔
89
  if (QUERY_NODE_LOGIC_CONDITION == nodeType(*pNode)) {
2,255,625✔
90
    SNode* pParam = NULL;
226,356✔
91
    FOREACH(pParam, ((SLogicConditionNode*)*pNode)->pParameterList) {
681,975!
92
      if (!isCondition(pParam)) {
455,599✔
93
        SNode* pIsTrue = NULL;
2,746✔
94
        if (TSDB_CODE_SUCCESS != rewriteIsTrue(pParam, &pIsTrue)) {
2,746!
95
          ((SCalcConstContext*)pContext)->code = TSDB_CODE_OUT_OF_MEMORY;
×
96
          return DEAL_RES_ERROR;
×
97
        }
98
        REPLACE_NODE(pIsTrue);
2,774✔
99
      }
100
    }
101
  }
102
  return DEAL_RES_CONTINUE;
2,255,645✔
103
}
104

105
static int32_t rewriteCondition(SCalcConstContext* pCxt, SNode** pNode) {
237,050✔
106
  if (!isCondition(*pNode)) {
237,050✔
107
    return rewriteIsTrue(*pNode, pNode);
38✔
108
  }
109
  nodesRewriteExprPostOrder(pNode, doRewriteCondition, pCxt);
237,036✔
110
  return pCxt->code;
237,094✔
111
}
112

113
static int32_t calcConstCondition(SCalcConstContext* pCxt, SNode** pNode) {
419✔
114
  int32_t code = rewriteCondition(pCxt, pNode);
419✔
115
  if (TSDB_CODE_SUCCESS == code) {
419!
116
    code = calcConstNode(pNode);
419✔
117
  }
118
  return code;
419✔
119
}
120

121
static EDealRes rewriteCalcConstValue(SNode** pNode, void* pContext) {
4,833✔
122
  int32_t                code = TSDB_CODE_SUCCESS;
4,833✔
123
  int32_t                lino = 0;
4,833✔
124
  SCalcConstContext* pCtx = (SCalcConstContext*)pContext;
4,833✔
125

126
  if (QUERY_NODE_LOGIC_CONDITION == nodeType(*pNode)) {
4,833✔
127
    return DEAL_RES_CONTINUE;
933✔
128
  } else if (QUERY_NODE_OPERATOR == nodeType(*pNode)) {
3,900!
129
    SOperatorNode* pOp = (SOperatorNode*)*pNode;
3,900✔
130
    if (OP_TYPE_EQUAL == pOp->opType && (TSDB_DATA_TYPE_TIMESTAMP == ((SExprNode*)pOp->pLeft)->resType.type || TSDB_DATA_TYPE_TIMESTAMP == ((SExprNode*)pOp->pRight)->resType.type)) {
3,900!
131
      code = calcConstNode(&pOp->pLeft);
3,481✔
132
      if (TSDB_CODE_SUCCESS == code) {
3,481!
133
        code = calcConstNode(&pOp->pRight);
3,481✔
134
      }
135
      
136
      goto _end;
3,481✔
137
    }
138
  }
139

140
  if (TSDB_CODE_SUCCESS == code) {
419!
141
    code = calcConstCondition(pCtx, pNode);
419✔
142
  }
143
  
144
_end:
×
145

146
  if (code != TSDB_CODE_SUCCESS) {
3,900!
147
    qError("%s failed at line %d since %s", __func__, lino, tstrerror(code));
×
148
    return DEAL_RES_ERROR;
×
149
  }
150
  
151
  return DEAL_RES_IGNORE_CHILD;
3,900✔
152
}
153

154
static int32_t rewriteConditionForFromTable(SCalcConstContext* pCxt, SNode* pTable) {
372,154✔
155
  int32_t code = TSDB_CODE_SUCCESS;
372,154✔
156
  switch (nodeType(pTable)) {
372,154✔
157
    case QUERY_NODE_TEMP_TABLE: {
3,102✔
158
      code = calcConstSubquery(pCxt, (STempTableNode*)pTable);
3,102✔
159
      break;
3,102✔
160
    }
161
    case QUERY_NODE_JOIN_TABLE: {
2,901✔
162
      SJoinTableNode* pJoin = (SJoinTableNode*)pTable;
2,901✔
163
      SNode* pCond = NULL;
2,901✔
164
      code = rewriteConditionForFromTable(pCxt, pJoin->pLeft);
2,901✔
165
      if (TSDB_CODE_SUCCESS == code) {
2,901!
166
        code = rewriteConditionForFromTable(pCxt, pJoin->pRight);
2,901✔
167
      }
168
      if (TSDB_CODE_SUCCESS == code && NULL != pJoin->pOnCond) {
2,901!
169
        code = rewriteCondition(pCxt, &pJoin->pOnCond);
2,893✔
170
      }
171
      if (TSDB_CODE_SUCCESS == code && NULL != pJoin->pOnCond) {
2,901!
172
        nodesRewriteExpr(&pJoin->pOnCond, rewriteCalcConstValue, pCxt);
2,893✔
173
      }
174

175
/*
176
      if (TSDB_CODE_SUCCESS == code && NULL != pJoin->pOnCond) {
177
        code = nodesCloneNode(pJoin->pOnCond, &pCond);
178
      }
179
      if (TSDB_CODE_SUCCESS == code && NULL != pJoin->pOnCond) {
180
        code = calcConstCondition(pCxt, &pJoin->pOnCond);
181
      }
182
      if (TSDB_CODE_SUCCESS == code && pJoin->pOnCond && QUERY_NODE_VALUE == nodeType(pJoin->pOnCond)) {
183
        nodesDestroyNode(pJoin->pOnCond);
184
        pJoin->pOnCond = pCond;
185
        pCond = NULL;
186
      }
187
      nodesDestroyNode(pCond);
188
*/
189
      // todo empty table
190
      break;
2,901✔
191
    }
192
    default:
366,151✔
193
      break;
366,151✔
194
  }
195
  return code;
372,154✔
196
}
197

198
static int32_t calcConstFromTable(SCalcConstContext* pCxt, SNode* pTable) {
366,339✔
199
  return rewriteConditionForFromTable(pCxt, pTable);
366,339✔
200
}
201

202
static void rewriteConstCondition(SNode** pCond, bool* pAlwaysFalse) {
233,812✔
203
  if (QUERY_NODE_VALUE != nodeType(*pCond)) {
233,812✔
204
    return;
233,088✔
205
  }
206
  if (((SValueNode*)*pCond)->datum.b) {
724!
207
    nodesDestroyNode(*pCond);
728✔
208
    *pCond = NULL;
728✔
209
  } else {
210
    *pAlwaysFalse = true;
×
211
  }
212
}
213

214
static int32_t calcConstStmtCondition(SCalcConstContext* pCxt, SNode** pCond, bool* pAlwaysFalse) {
624,432✔
215
  if (NULL == *pCond) {
624,432✔
216
    return TSDB_CODE_SUCCESS;
390,727✔
217
  }
218

219
  int32_t code = rewriteCondition(pCxt, pCond);
233,705✔
220
  if (TSDB_CODE_SUCCESS == code) {
233,820!
221
    code = calcConstNode(pCond);
233,822✔
222
  }
223
  if (TSDB_CODE_SUCCESS == code) {
233,799!
224
    rewriteConstCondition(pCond, pAlwaysFalse);
233,810✔
225
  }
226
  return code;
233,816✔
227
}
228

229
static EDealRes doFindAndReplaceNode(SNode** pNode, void* pContext) {
×
230
  SCalcConstContext* pCxt = pContext;
×
231
  if (pCxt->replaceCxt.pTarget == *pNode) {
×
232
    char aliasName[TSDB_COL_NAME_LEN] = {0};
×
233
    tstrncpy(aliasName, ((SExprNode*)*pNode)->aliasName, TSDB_COL_NAME_LEN);
×
234
    nodesDestroyNode(*pNode);
×
235
    *pNode = NULL;
×
236
    pCxt->code = nodesCloneNode(pCxt->replaceCxt.pNew, pNode);
×
237
    if (NULL == *pNode) {
×
238
      return DEAL_RES_ERROR;
×
239
    }
240
    tstrncpy(((SExprNode*)*pNode)->aliasName, aliasName, TSDB_COL_NAME_LEN);
×
241

242
    pCxt->replaceCxt.replaced = true;
×
243
    return DEAL_RES_END;
×
244
  }
245
  return DEAL_RES_CONTINUE;
×
246
}
247

248
static int32_t findAndReplaceNode(SCalcConstContext* pCxt, SNode** pRoot, SNode* pTarget, SNode* pNew, bool strict) {
×
249
  pCxt->replaceCxt.pNew = pNew;
×
250
  pCxt->replaceCxt.pTarget = pTarget;
×
251

252
  nodesRewriteExprPostOrder(pRoot, doFindAndReplaceNode, pCxt);
×
253
  if (TSDB_CODE_SUCCESS == pCxt->code && strict && !pCxt->replaceCxt.replaced) {
×
254
    parserError("target replace node not found, %p", pTarget);
×
255
    return TSDB_CODE_PAR_INTERNAL_ERROR;
×
256
  }
257
  return pCxt->code;
×
258
}
259

260
static int32_t calcConstProject(SCalcConstContext* pCxt, SNode* pProject, bool dual, SNode** pNew) {
418,872✔
261
  SArray* pAssociation = NULL;
418,872✔
262
  
263
  if (NULL != ((SExprNode*)pProject)->pAssociation) {
418,872✔
264
    pAssociation = taosArrayDup(((SExprNode*)pProject)->pAssociation, NULL);
8,425✔
265
    if (NULL == pAssociation) {
8,425!
266
      return terrno;
×
267
    }
268
  }
269

270
  char    aliasName[TSDB_COL_NAME_LEN] = {0}, srcTable[TSDB_TABLE_NAME_LEN] = {0};
418,881✔
271
  int32_t code = TSDB_CODE_SUCCESS;
418,881✔
272
  if (dual) {
418,881✔
273
    code = scalarCalculateConstantsFromDual(pProject, pNew);
2,939✔
274
  } else {
275
    code = scalarCalculateConstants(pProject, pNew);
415,942✔
276
  }
277
  if (TSDB_CODE_SUCCESS == code) {
418,966✔
278
    if (QUERY_NODE_VALUE == nodeType(*pNew) && NULL != pAssociation) {
418,935✔
279
      int32_t size = taosArrayGetSize(pAssociation);
2,679✔
280
      for (int32_t i = 0; i < size; ++i) {
6,505✔
281
        SAssociationNode* pAssNode = taosArrayGet(pAssociation, i);
3,826✔
282
        SNode**           pCol = pAssNode->pPlace;
3,826✔
283
        if (((SExprNode*)pAssNode->pAssociationNode)->joinSrc) {
3,826✔
284
          //((SExprNode*)pAssNode->pAssociationNode)->constValue = true;
285
          continue;
2,089✔
286
        }
287
        
288
        if (*pCol == pAssNode->pAssociationNode) {
1,737!
289
          tstrncpy(aliasName, ((SExprNode*)*pCol)->aliasName, TSDB_COL_NAME_LEN);
1,737✔
290
          if (QUERY_NODE_COLUMN == nodeType(*pCol)) {
1,737!
291
            tstrncpy(srcTable, ((SColumnNode*)*pCol)->tableAlias, TSDB_TABLE_NAME_LEN);
1,737✔
292
          }
293
          SArray* pOrigAss = NULL;
1,737✔
294
          TSWAP(((SExprNode*)*pCol)->pAssociation, pOrigAss);
1,737✔
295
          nodesDestroyNode(*pCol);
1,737✔
296
          *pCol = NULL;
1,737✔
297
          code = nodesCloneNode(*pNew, pCol);
1,737✔
298
          if (TSDB_CODE_SUCCESS == code) {
1,737!
299
            tstrncpy(((SExprNode*)*pCol)->aliasName, aliasName, TSDB_COL_NAME_LEN);
1,737✔
300
            if (srcTable[0]) {
1,737!
301
              tstrncpy(((SExprNode*)*pCol)->srcTable, srcTable, TSDB_TABLE_NAME_LEN);
1,737✔
302
            }
303
            TSWAP(pOrigAss, ((SExprNode*)*pCol)->pAssociation);
1,737✔
304
          }
305
          taosArrayDestroy(pOrigAss);
1,737✔
306
          if (TSDB_CODE_SUCCESS != code) {
1,737!
307
            break;
×
308
          }
309
        } else {
310
          code = findAndReplaceNode(pCxt, pCol, pAssNode->pAssociationNode, *pNew, true);
×
311
          if (TSDB_CODE_SUCCESS != code) {
×
312
            break;
×
313
          }
314
        }
315
      }
316
    }
317
  }
318
  taosArrayDestroy(pAssociation);
418,966✔
319
  return code;
418,906✔
320
}
321

322
typedef struct SIsUselessColCtx {
323
  bool isUseless;
324
} SIsUselessColCtx;
325

326
EDealRes checkUselessCol(SNode* pNode, void* pContext) {
15,208✔
327
  SIsUselessColCtx* ctx = (SIsUselessColCtx*)pContext;
15,208✔
328
  if (QUERY_NODE_FUNCTION == nodeType(pNode) && !fmIsScalarFunc(((SFunctionNode*)pNode)->funcId) &&
15,208✔
329
      !fmIsPseudoColumnFunc(((SFunctionNode*)pNode)->funcId)) {
2,308✔
330
    ctx->isUseless = false;
2,042✔
331
    return DEAL_RES_END;
2,042✔
332
  }
333

334
  return DEAL_RES_CONTINUE;
13,166✔
335
}
336

337
static bool isUselessCol(SExprNode* pProj) {
13,102✔
338
  SIsUselessColCtx ctx = {.isUseless = true};
13,102✔
339
  nodesWalkExpr((SNode*)pProj, checkUselessCol, (void*)&ctx);
13,102✔
340
  if (!ctx.isUseless) {
13,102✔
341
    return false;
2,042✔
342
  }
343
  return NULL == ((SExprNode*)pProj)->pAssociation;
11,060✔
344
}
345

346
static int32_t createConstantValue(SValueNode** ppNode) {
27✔
347
  SValueNode* pVal = NULL;
27✔
348
  int32_t     code = nodesMakeNode(QUERY_NODE_VALUE, (SNode**)&pVal);
27✔
349
  if (NULL == pVal) {
27!
350
    return code;
×
351
  }
352
  pVal->node.resType.type = TSDB_DATA_TYPE_INT;
27✔
353
  pVal->node.resType.bytes = tDataTypes[TSDB_DATA_TYPE_INT].bytes;
27✔
354
  const int32_t val = 1;
27✔
355
  code = nodesSetValueNodeValue(pVal, (void*)&val);
27✔
356
  if (TSDB_CODE_SUCCESS == code) {
27!
357
    pVal->translate = true;
27✔
358
    *ppNode = pVal;
27✔
359
  } else {
360
    nodesDestroyNode((SNode*)pVal);
×
361
  }
362
  return code;
27✔
363
}
364

365
static int32_t calcConstProjections(SCalcConstContext* pCxt, SSelectStmt* pSelect, bool subquery) {
261,045✔
366
  SNode* pProj = NULL;
261,045✔
367
  WHERE_EACH(pProj, pSelect->pProjectionList) {
683,894!
368
    if (subquery && !pSelect->isDistinct && !pSelect->tagScan && isUselessCol((SExprNode*)pProj) && (pSelect->pFromTable && nodeType(pSelect->pFromTable) != QUERY_NODE_VIRTUAL_TABLE)) {
422,820!
369
      ERASE_NODE(pSelect->pProjectionList);
3,914✔
370
      continue;
3,914✔
371
    }
372
    SNode*  pNew = NULL;
418,906✔
373
    int32_t code = calcConstProject(pCxt, pProj, (NULL == pSelect->pFromTable), &pNew);
418,906✔
374
    if (TSDB_CODE_SUCCESS == code) {
418,928!
375
      REPLACE_NODE(pNew);
418,935✔
376
    } else {
377
      return code;
×
378
    }
379
    WHERE_NEXT;
418,935✔
380
  }
381
  if (0 == LIST_LENGTH(pSelect->pProjectionList)) {
261,074!
382
    SValueNode* pVal = NULL;
41✔
383
    int32_t     code = createConstantValue(&pVal);
41✔
384
    if (TSDB_CODE_SUCCESS == code) {
27!
385
      return nodesListStrictAppend(pSelect->pProjectionList, (SNode*)pVal);
27✔
386
    }
387
  }
388
  return TSDB_CODE_SUCCESS;
261,033✔
389
}
390

391
static int32_t calcConstGroupBy(SCalcConstContext* pCxt, SSelectStmt* pSelect) {
258,134✔
392
  int32_t code = calcConstList(pSelect->pGroupByList);
258,134✔
393
  if (TSDB_CODE_SUCCESS == code) {
258,164✔
394
    SNode* pNode = NULL;
258,158✔
395
    FOREACH(pNode, pSelect->pGroupByList) {
259,580✔
396
      bool   hasNotValue = false;
1,422✔
397
      SNode* pGroupPara = NULL;
1,422✔
398
      FOREACH(pGroupPara, ((SGroupingSetNode*)pNode)->pParameterList) {
1,437!
399
        if (QUERY_NODE_VALUE != nodeType(pGroupPara)) {
1,422✔
400
          hasNotValue = true;
1,407✔
401
          break;
1,407✔
402
        }
403
      }
404
      if (!hasNotValue) {
1,422✔
405
        if (pSelect->hasAggFuncs) {
15!
406
          ERASE_NODE(pSelect->pGroupByList);
×
407
        } else {
408
          if (!cell->pPrev && !cell->pNext) continue;
15!
409
          ERASE_NODE(pSelect->pGroupByList);
×
410
        }
411
      }
412
    }
413
  }
414
  return code;
258,164✔
415
}
416

417
static int32_t calcConstSelectWithoutFrom(SCalcConstContext* pCxt, SSelectStmt* pSelect, bool subquery) {
2,937✔
418
  return calcConstProjections(pCxt, pSelect, subquery);
2,937✔
419
}
420

421
static int32_t calcConstSelectFrom(SCalcConstContext* pCxt, SSelectStmt* pSelect, bool subquery) {
258,126✔
422
  int32_t code = calcConstFromTable(pCxt, pSelect->pFromTable);
258,126✔
423
  if (TSDB_CODE_SUCCESS == code && QUERY_NODE_TEMP_TABLE == nodeType(pSelect->pFromTable) &&
258,137!
424
      ((STempTableNode*)pSelect->pFromTable)->pSubquery != NULL &&
741!
425
      QUERY_NODE_SELECT_STMT == nodeType(((STempTableNode*)pSelect->pFromTable)->pSubquery) &&
741✔
426
      ((SSelectStmt*)((STempTableNode*)pSelect->pFromTable)->pSubquery)->isEmptyResult) {
681!
427
    pSelect->isEmptyResult = true;
×
428
    return code;
×
429
  }
430
  if (pSelect->mixSysTableAndActualTable) {
258,137!
431
    return code;
×
432
  }
433
  if (TSDB_CODE_SUCCESS == code) {
258,137✔
434
    code = calcConstProjections(pCxt, pSelect, subquery);
258,130✔
435
  }
436
  if (TSDB_CODE_SUCCESS == code) {
258,163!
437
    code = calcConstStmtCondition(pCxt, &pSelect->pWhere, &pSelect->isEmptyResult);
258,165✔
438
  }
439
  if (TSDB_CODE_SUCCESS == code) {
258,175✔
440
    code = calcConstList(pSelect->pPartitionByList);
258,163✔
441
  }
442
  if (TSDB_CODE_SUCCESS == code) {
258,181✔
443
    code = calcConstNode(&pSelect->pWindow);
258,173✔
444
  }
445
  if (TSDB_CODE_SUCCESS == code) {
258,177✔
446
    code = calcConstGroupBy(pCxt, pSelect);
258,169✔
447
  }
448
  if (TSDB_CODE_SUCCESS == code) {
258,127!
449
    code = calcConstStmtCondition(pCxt, &pSelect->pHaving, &pSelect->isEmptyResult);
258,167✔
450
  }
451
  if (TSDB_CODE_SUCCESS == code) {
258,133!
452
    code = calcConstList(pSelect->pOrderByList);
258,159✔
453
  }
454
  if (TSDB_CODE_SUCCESS == code) {
258,148!
455
    code = calcConstNode(&pSelect->pFill);
258,175✔
456
  }
457
  if (TSDB_CODE_SUCCESS == code) {
258,148!
458
    code = calcConstNode(&pSelect->pTimeRange);
258,173✔
459
  }
460
  return code;
258,174✔
461
}
462

463
static int32_t calcConstSelect(SCalcConstContext* pCxt, SSelectStmt* pSelect, bool subquery) {
261,051✔
464
  if (NULL == pSelect->pFromTable) {
261,051✔
465
    return calcConstSelectWithoutFrom(pCxt, pSelect, subquery);
2,937✔
466
  } else {
467
    return calcConstSelectFrom(pCxt, pSelect, subquery);
258,114✔
468
  }
469
}
470

471
static int32_t calcConstDelete(SCalcConstContext* pCxt, SDeleteStmt* pDelete) {
108,198✔
472
  int32_t code = calcConstFromTable(pCxt, pDelete->pFromTable);
108,198✔
473
  if (TSDB_CODE_SUCCESS == code) {
108,207!
474
    code = calcConstStmtCondition(pCxt, &pDelete->pWhere, &pDelete->deleteZeroRows);
108,209✔
475
  }
476
  if (code == TSDB_CODE_SUCCESS && pDelete->timeRange.skey > pDelete->timeRange.ekey) {
108,203!
477
    pDelete->deleteZeroRows = true;
×
478
  }
479
  return code;
108,203✔
480
}
481

482
static int32_t calcConstInsert(SCalcConstContext* pCxt, SInsertStmt* pInsert) {
31✔
483
  int32_t code = calcConstFromTable(pCxt, pInsert->pTable);
31✔
484
  if (TSDB_CODE_SUCCESS == code) {
31!
485
    code = calcConstQuery(pCxt, pInsert->pQuery, false);
31✔
486
  }
487
  return code;
31✔
488
}
489

490
static SNodeList* getChildProjection(SNode* pStmt) {
48✔
491
  switch (nodeType(pStmt)) {
48!
492
    case QUERY_NODE_SELECT_STMT:
48✔
493
      return ((SSelectStmt*)pStmt)->pProjectionList;
48✔
494
    case QUERY_NODE_SET_OPERATOR:
×
495
      return ((SSetOperator*)pStmt)->pProjectionList;
×
496
    default:
×
497
      break;
×
498
  }
499
  return NULL;
×
500
}
501

502
static void eraseSetOpChildProjection(SSetOperator* pSetOp, int32_t index) {
12✔
503
  SNodeList* pLeftProjs = getChildProjection(pSetOp->pLeft);
12✔
504
  (void)nodesListErase(pLeftProjs, nodesListGetCell(pLeftProjs, index));
12✔
505
  if (QUERY_NODE_SET_OPERATOR == nodeType(pSetOp->pLeft)) {
12!
506
    eraseSetOpChildProjection((SSetOperator*)pSetOp->pLeft, index);
×
507
  }
508
  SNodeList* pRightProjs = getChildProjection(pSetOp->pRight);
12✔
509
  (void)nodesListErase(pRightProjs, nodesListGetCell(pRightProjs, index));
12✔
510
  if (QUERY_NODE_SET_OPERATOR == nodeType(pSetOp->pRight)) {
12!
511
    eraseSetOpChildProjection((SSetOperator*)pSetOp->pRight, index);
×
512
  }
513
}
12✔
514

515
typedef struct SNotRefByOrderByCxt {
516
  SColumnNode* pCol;
517
  bool         hasThisCol;
518
} SNotRefByOrderByCxt;
519

520
static EDealRes notRefByOrderByImpl(SNode* pNode, void* pContext) {
×
521
  if (QUERY_NODE_COLUMN == nodeType(pNode)) {
×
522
    SNotRefByOrderByCxt* pCxt = (SNotRefByOrderByCxt*)pContext;
×
523
    if (nodesEqualNode((SNode*)pCxt->pCol, pNode)) {
×
524
      pCxt->hasThisCol = true;
×
525
      return DEAL_RES_END;
×
526
    }
527
  }
528
  return DEAL_RES_CONTINUE;
×
529
}
530

531
static bool notRefByOrderBy(SColumnNode* pCol, SNodeList* pOrderByList) {
117✔
532
  SNotRefByOrderByCxt cxt = {.pCol = pCol, .hasThisCol = false};
117✔
533
  nodesWalkExprs(pOrderByList, notRefByOrderByImpl, &cxt);
117✔
534
  return !cxt.hasThisCol;
117✔
535
}
536

537
static bool isDistinctSubQuery(SNode* pNode) {
24✔
538
  if (NULL == pNode) {
24!
539
    return false;
×
540
  }
541
  switch (nodeType(pNode)) {
24!
542
    case QUERY_NODE_SELECT_STMT:
24✔
543
      return ((SSelectStmt*)pNode)->isDistinct;
24✔
544
    case QUERY_NODE_SET_OPERATOR:
×
545
      return isDistinctSubQuery((((SSetOperator*)pNode)->pLeft)) || isDistinctSubQuery((((SSetOperator*)pNode)->pLeft));
×
546
    default:
×
547
      break;
×
548
  }
549
  return false;
×
550
}
551

552
static bool isSetUselessCol(SSetOperator* pSetOp, int32_t index, SExprNode* pProj) {
117✔
553
  if (!isUselessCol(pProj)) {
117✔
554
    return false;
105✔
555
  }
556

557
  SNodeList* pLeftProjs = getChildProjection(pSetOp->pLeft);
12✔
558
  if (!isUselessCol((SExprNode*)nodesListGetNode(pLeftProjs, index)) || isDistinctSubQuery(pSetOp->pLeft)) {
12!
559
    return false;
×
560
  }
561

562
  SNodeList* pRightProjs = getChildProjection(pSetOp->pRight);
12✔
563
  if (!isUselessCol((SExprNode*)nodesListGetNode(pRightProjs, index)) || isDistinctSubQuery(pSetOp->pLeft)) {
12!
564
    return false;
×
565
  }
566

567
  return true;
12✔
568
}
569

570
static int32_t calcConstSetOpProjections(SCalcConstContext* pCxt, SSetOperator* pSetOp, bool subquery) {
292✔
571
  if (subquery && pSetOp->opType == SET_OP_TYPE_UNION) {
292✔
572
    return TSDB_CODE_SUCCESS;
6✔
573
  }
574
  int32_t index = 0;
286✔
575
  SNode*  pProj = NULL;
286✔
576
  WHERE_EACH(pProj, pSetOp->pProjectionList) {
919!
577
    if (subquery && notRefByOrderBy((SColumnNode*)pProj, pSetOp->pOrderByList) &&
750!
578
        isSetUselessCol(pSetOp, index, (SExprNode*)pProj)) {
117✔
579
      ERASE_NODE(pSetOp->pProjectionList);
12✔
580
      eraseSetOpChildProjection(pSetOp, index);
12✔
581
      continue;
12✔
582
    }
583
    ++index;
621✔
584
    WHERE_NEXT;
621✔
585
  }
586
  if (0 == LIST_LENGTH(pSetOp->pProjectionList)) {
286!
587
    SValueNode* pVal = NULL;
×
588
    int32_t     code = createConstantValue(&pVal);
×
589
    if (TSDB_CODE_SUCCESS == code) {
×
590
      return nodesListStrictAppend(pSetOp->pProjectionList, (SNode*)pVal);
×
591
    }
592
  }
593
  return TSDB_CODE_SUCCESS;
286✔
594
}
595

596
static int32_t calcConstSetOperator(SCalcConstContext* pCxt, SSetOperator* pSetOp, bool subquery) {
292✔
597
  int32_t code = calcConstSetOpProjections(pCxt, pSetOp, subquery);
292✔
598
  if (TSDB_CODE_SUCCESS == code) {
292!
599
    code = calcConstQuery(pCxt, pSetOp->pLeft, false);
292✔
600
  }
601
  if (TSDB_CODE_SUCCESS == code) {
292!
602
    code = calcConstQuery(pCxt, pSetOp->pRight, false);
292✔
603
  }
604
  if (TSDB_CODE_SUCCESS == code) {
292!
605
    code = calcConstList(pSetOp->pOrderByList);
292✔
606
  }
607
  return code;
292✔
608
}
609

610
static int32_t calcConstQuery(SCalcConstContext* pCxt, SNode* pStmt, bool subquery) {
425,984✔
611
  int32_t code = TSDB_CODE_SUCCESS;
425,984✔
612
  switch (nodeType(pStmt)) {
425,984✔
613
    case QUERY_NODE_SELECT_STMT:
261,100✔
614
      code = calcConstSelect(pCxt, (SSelectStmt*)pStmt, subquery);
261,100✔
615
      break;
261,079✔
616
    case QUERY_NODE_EXPLAIN_STMT:
399✔
617
      code = calcConstQuery(pCxt, ((SExplainStmt*)pStmt)->pQuery, subquery);
399✔
618
      break;
399✔
619
    case QUERY_NODE_SET_OPERATOR: {
292✔
620
      code = calcConstSetOperator(pCxt, (SSetOperator*)pStmt, subquery);
292✔
621
      break;
292✔
622
    }
623
    case QUERY_NODE_DELETE_STMT:
108,201✔
624
      code = calcConstDelete(pCxt, (SDeleteStmt*)pStmt);
108,201✔
625
      break;
108,204✔
626
    case QUERY_NODE_INSERT_STMT:
31✔
627
      code = calcConstInsert(pCxt, (SInsertStmt*)pStmt);
31✔
628
      break;
31✔
629
    default:
55,961✔
630
      break;
55,961✔
631
  }
632
  return code;
425,966✔
633
}
634

635
static bool isEmptyResultQuery(SNode* pStmt) {
422,531✔
636
  bool isEmptyResult = false;
422,531✔
637
  switch (nodeType(pStmt)) {
422,531✔
638
    case QUERY_NODE_SELECT_STMT:
257,675✔
639
      isEmptyResult = ((SSelectStmt*)pStmt)->isEmptyResult;
257,675✔
640
      break;
257,675✔
641
    case QUERY_NODE_EXPLAIN_STMT:
399✔
642
      isEmptyResult = isEmptyResultQuery(((SExplainStmt*)pStmt)->pQuery);
399✔
643
      break;
399✔
644
    case QUERY_NODE_SET_OPERATOR: {
229✔
645
      SSetOperator* pSetOp = (SSetOperator*)pStmt;
229✔
646
      isEmptyResult = isEmptyResultQuery(pSetOp->pLeft);
229✔
647
      if (isEmptyResult) {
229!
648
        isEmptyResult = isEmptyResultQuery(pSetOp->pRight);
×
649
      }
650
      break;
229✔
651
    }
652
    case QUERY_NODE_DELETE_STMT:
108,200✔
653
      isEmptyResult = ((SDeleteStmt*)pStmt)->deleteZeroRows;
108,200✔
654
      break;
108,200✔
655
    default:
56,028✔
656
      break;
56,028✔
657
  }
658
  return isEmptyResult;
422,531✔
659
}
660

661
static void resetProjectNullTypeImpl(SNodeList* pProjects) {
257,664✔
662
  SNode* pProj = NULL;
257,664✔
663
  FOREACH(pProj, pProjects) {
655,079!
664
    SExprNode* pExpr = (SExprNode*)pProj;
397,415✔
665
    if (TSDB_DATA_TYPE_NULL == pExpr->resType.type) {
397,415✔
666
      pExpr->resType.type = TSDB_DATA_TYPE_VARCHAR;
18✔
667
      pExpr->resType.bytes = VARSTR_HEADER_SIZE;
18✔
668
    }
669
  }
670
}
257,664✔
671

672
static void resetProjectNullType(SNode* pStmt) {
422,276✔
673
  switch (nodeType(pStmt)) {
422,276✔
674
    case QUERY_NODE_SELECT_STMT:
257,457✔
675
      resetProjectNullTypeImpl(((SSelectStmt*)pStmt)->pProjectionList);
257,457✔
676
      break;
257,513✔
677
    case QUERY_NODE_SET_OPERATOR: {
229✔
678
      SSetOperator* pSetOp = (SSetOperator*)pStmt;
229✔
679
      resetProjectNullTypeImpl(pSetOp->pProjectionList);
229✔
680
      if (pSetOp->pLeft)
229!
681
        resetProjectNullType(pSetOp->pLeft);
229✔
682
      if (pSetOp->pRight)
229!
683
        resetProjectNullType(pSetOp->pRight);
229✔
684
      break;
229✔
685
    }
686
    default:
164,590✔
687
      break;
164,590✔
688
  }
689
}
422,332✔
690

691
int32_t calculateConstant(SParseContext* pParseCxt, SQuery* pQuery) {
421,733✔
692
  SCalcConstContext cxt = {.pParseCxt = pParseCxt,
421,733✔
693
                           .msgBuf.buf = pParseCxt->pMsg,
421,733✔
694
                           .msgBuf.len = pParseCxt->msgLen,
421,733✔
695
                           .code = TSDB_CODE_SUCCESS};
696

697
  int32_t code = calcConstQuery(&cxt, pQuery->pRoot, false);
421,733✔
698
  if (TSDB_CODE_SUCCESS == code) {
421,882!
699
    resetProjectNullType(pQuery->pRoot);
421,885✔
700
    if (isEmptyResultQuery(pQuery->pRoot)) {
421,902✔
701
      pQuery->execMode = QUERY_EXEC_MODE_EMPTY_RESULT;
13✔
702
    }
703
  }
704
  return code;
421,921✔
705
}
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