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

taosdata / TDengine / #5045

07 May 2026 07:27AM UTC coverage: 73.161% (-0.008%) from 73.169%
#5045

push

travis-ci

web-flow
feat(parser): add support for QUARTER duration alias and related tests (#35268)

6 of 6 new or added lines in 2 files covered. (100.0%)

809 existing lines in 126 files now uncovered.

277725 of 379607 relevant lines covered (73.16%)

137835559.97 hits per line

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

79.55
/source/libs/nodes/src/nodesToSQLFuncs.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 "cmdnodes.h"
17
#include "nodesUtil.h"
18
#include "plannodes.h"
19
#include "querynodes.h"
20
#include "taos.h"
21
#include "taoserror.h"
22
#include "thash.h"
23

24
const char *operatorTypeStr(EOperatorType type) {
158,695,229✔
25
  switch (type) {
158,695,229✔
26
    case OP_TYPE_ADD:
259,247✔
27
      return "+";
259,247✔
28
    case OP_TYPE_SUB:
3,280✔
29
      return "-";
3,280✔
30
    case OP_TYPE_MULTI:
3,280✔
31
      return "*";
3,280✔
32
    case OP_TYPE_DIV:
2,870✔
33
      return "/";
2,870✔
34
    case OP_TYPE_REM:
2,870✔
35
      return "%";
2,870✔
36
    case OP_TYPE_MINUS:
3,690✔
37
      return "-";
3,690✔
38
    case OP_TYPE_BIT_AND:
3,280✔
39
      return "&";
3,280✔
40
    case OP_TYPE_BIT_OR:
3,280✔
41
      return "|";
3,280✔
42
    case OP_TYPE_GREATER_THAN:
18,804,217✔
43
      return ">";
18,804,217✔
44
    case OP_TYPE_GREATER_EQUAL:
29,986,396✔
45
      return ">=";
29,986,396✔
46
    case OP_TYPE_LOWER_THAN:
13,831,404✔
47
      return "<";
13,831,404✔
48
    case OP_TYPE_LOWER_EQUAL:
28,551,744✔
49
      return "<=";
28,551,744✔
50
    case OP_TYPE_EQUAL:
34,351,307✔
51
      return "=";
34,351,307✔
52
    case OP_TYPE_NOT_EQUAL:
1,498,628✔
53
      return "<>";
1,498,628✔
54
    case OP_TYPE_IN:
1,433,046✔
55
      return "IN";
1,433,046✔
56
    case OP_TYPE_NOT_IN:
1,050,283✔
57
      return "NOT IN";
1,050,283✔
58
    case OP_TYPE_LIKE:
2,501,544✔
59
      return "LIKE";
2,501,544✔
60
    case OP_TYPE_NOT_LIKE:
1,640✔
61
      return "NOT LIKE";
1,640✔
62
    case OP_TYPE_MATCH:
11,813,823✔
63
      return "MATCH";
11,813,823✔
64
    case OP_TYPE_NMATCH:
564,942✔
65
      return "NMATCH";
564,942✔
66
    case OP_TYPE_IS_NULL:
4,315,518✔
67
      return "IS NULL";
4,315,518✔
68
    case OP_TYPE_IS_NOT_NULL:
9,439,156✔
69
      return "IS NOT NULL";
9,439,156✔
70
    case OP_TYPE_IS_TRUE:
276,572✔
71
      return "IS TRUE";
276,572✔
72
    case OP_TYPE_IS_FALSE:
×
73
      return "IS FALSE";
×
74
    case OP_TYPE_IS_UNKNOWN:
×
75
      return "IS UNKNOWN";
×
76
    case OP_TYPE_IS_NOT_TRUE:
×
77
      return "IS NOT TRUE";
×
78
    case OP_TYPE_IS_NOT_FALSE:
×
79
      return "IS NOT FALSE";
×
80
    case OP_TYPE_IS_NOT_UNKNOWN:
×
81
      return "IS NOT UNKNOWN";
×
82
    case OP_TYPE_EXISTS:
×
83
      return "EXISTS";
×
84
    case OP_TYPE_NOT_EXISTS:
×
85
      return "NOT EXISTS";
×
86
    case OP_TYPE_JSON_GET_VALUE:
×
87
      return "=>";
×
88
    case OP_TYPE_JSON_CONTAINS:
×
89
      return "CONTAINS";
×
90
    case OP_TYPE_ASSIGN:
×
91
      return "=";
×
92
    default:
205✔
93
      break;
205✔
94
  }
95
  return "UNKNOWN";
205✔
96
}
97

98
const char *operatorTypeStrEx(EOperatorType type, bool isNegative) {
14,549,929✔
99
  if (isNegative) {
14,549,929✔
100
    switch (type) {
88,308✔
101
      case OP_TYPE_IN:
×
102
        return "!= ANY";
×
103
      case OP_TYPE_NOT_IN:
88,308✔
104
        return "= ALL";
88,308✔
105
      default:
×
106
        break;
×
107
    }
108
    return "UNKNOWN";
×
109
  }
110

111
  return operatorTypeStr(type);
14,461,621✔
112
}
113

114
const char *logicConditionTypeStr(ELogicConditionType type) {
852,798✔
115
  switch (type) {
852,798✔
116
    case LOGIC_COND_TYPE_AND:
562,494✔
117
      return "AND";
562,494✔
118
    case LOGIC_COND_TYPE_OR:
290,494✔
119
      return "OR";
290,494✔
120
    case LOGIC_COND_TYPE_NOT:
×
121
      return "NOT";
×
122
    default:
×
123
      break;
×
124
  }
125
  return "UNKNOWN";
×
126
}
127

128
int32_t nodesNodeToSQL(SNode *pNode, char *buf, int32_t bufSize, int32_t *len) {
13,371,871✔
129
  return nodesNodeToSQLFormat(pNode, buf, bufSize, len, false);
13,371,871✔
130
}
131

132
int32_t nodesNodeToSQLFormat(SNode *pNode, char *buf, int32_t bufSize, int32_t *len, bool longFormat) {
42,614,572✔
133
  switch (pNode->type) {
42,614,572✔
134
    case QUERY_NODE_COLUMN: {
12,375,098✔
135
      SColumnNode *colNode = (SColumnNode *)pNode;
12,375,098✔
136
      if (colNode->dbName[0]) {
12,375,098✔
137
        *len += snprintf(buf + *len, bufSize - *len, "`%s`.", colNode->dbName);
11,673,791✔
138
      }
139

140
      if (colNode->tableAlias[0]) {
12,375,098✔
141
        *len += snprintf(buf + *len, bufSize - *len, "`%s`.", colNode->tableAlias);
11,711,831✔
142
      } else if (colNode->tableName[0]) {
663,267✔
143
        *len += snprintf(buf + *len, bufSize - *len, "`%s`.", colNode->tableName);
×
144
      }
145

146
      if (colNode->node.userAlias[0]) {
12,375,098✔
147
        *len += snprintf(buf + *len, bufSize - *len, "`%s`", colNode->node.userAlias);
12,362,671✔
148
      } else {
149
        *len += snprintf(buf + *len, bufSize - *len, "`%s`", colNode->colName);
12,803✔
150
      }
151

152
      return TSDB_CODE_SUCCESS;
12,375,098✔
153
    }
154
    case QUERY_NODE_VALUE: {
5,739,483✔
155
      SValueNode *colNode = (SValueNode *)pNode;
5,739,483✔
156
      char       *t = nodesGetStrValueFromNode(colNode);
5,739,483✔
157
      if (NULL == t) {
5,739,388✔
158
        // NULL type value (e.g. ELSE NULL in CASE WHEN)
159
        *len += tsnprintf(buf + *len, bufSize - *len, "NULL");
1,136✔
160
        return TSDB_CODE_SUCCESS;
1,136✔
161
      }
162

163
      int32_t tlen = strlen(t);
5,738,347✔
164
      if (longFormat) {
5,738,347✔
165
        *len += snprintf(buf + *len, bufSize - *len, "%s", t);
5,732,923✔
166
      } else {
167
        if (tlen > 32) {
5,424✔
168
          *len += snprintf(buf + *len, bufSize - *len, "%.*s...%s", 32, t, t + tlen - 1);
×
169
        } else {
170
          *len += snprintf(buf + *len, bufSize - *len, "%s", t);
5,424✔
171
        }
172
      }
173

174
      taosMemoryFree(t);
5,738,347✔
175

176
      return TSDB_CODE_SUCCESS;
5,738,254✔
177
    }
178
    case QUERY_NODE_OPERATOR: {
14,549,770✔
179
      SOperatorNode *pOpNode = (SOperatorNode *)pNode;
14,549,770✔
180
      *len += snprintf(buf + *len, bufSize - *len, "(");
14,549,770✔
181
      if (pOpNode->pLeft) {
14,549,770✔
182
        NODES_ERR_RET(nodesNodeToSQLFormat(pOpNode->pLeft, buf, bufSize, len, true));
14,550,201✔
183
      }
184

185
      *len += tsnprintf(buf + *len, bufSize - *len, " %s ", operatorTypeStrEx(pOpNode->opType, pOpNode->flag & OPERATOR_FLAG_NEGATIVE_OP));
14,549,941✔
186

187
      if (pOpNode->pRight) {
14,550,571✔
188
        NODES_ERR_RET(nodesNodeToSQLFormat(pOpNode->pRight, buf, bufSize, len, true));
12,611,215✔
189
      }
190

191
      *len += snprintf(buf + *len, bufSize - *len, ")");
14,550,385✔
192

193
      return TSDB_CODE_SUCCESS;
14,550,385✔
194
    }
195
    case QUERY_NODE_LOGIC_CONDITION: {
844,686✔
196
      SLogicConditionNode *pLogicNode = (SLogicConditionNode *)pNode;
844,686✔
197
      SNode               *node = NULL;
844,686✔
198
      bool                 first = true;
844,686✔
199

200
      *len += snprintf(buf + *len, bufSize - *len, "(");
844,686✔
201

202
      FOREACH(node, pLogicNode->pParameterList) {
2,542,360✔
203
        if (!first) {
1,697,674✔
204
          *len += snprintf(buf + *len, bufSize - *len, " %s ", logicConditionTypeStr(pLogicNode->condType));
852,988✔
205
        }
206
        NODES_ERR_RET(nodesNodeToSQLFormat(node, buf, bufSize, len, true));
1,697,674✔
207
        first = false;
1,697,674✔
208
      }
209

210
      *len += snprintf(buf + *len, bufSize - *len, ")");
844,686✔
211

212
      return TSDB_CODE_SUCCESS;
844,686✔
213
    }
214
    case QUERY_NODE_FUNCTION: {
227,368✔
215
      SFunctionNode *pFuncNode = (SFunctionNode *)pNode;
227,368✔
216
      SNode         *node = NULL;
227,368✔
217
      bool           first = true;
227,368✔
218

219
      *len += snprintf(buf + *len, bufSize - *len, "%s(", pFuncNode->functionName);
227,368✔
220

221
      FOREACH(node, pFuncNode->pParameterList) {
500,191✔
222
        if (!first) {
272,728✔
223
          *len += snprintf(buf + *len, bufSize - *len, ", ");
45,360✔
224
        }
225
        NODES_ERR_RET(nodesNodeToSQLFormat(node, buf, bufSize, len, true));
272,728✔
226
        first = false;
272,823✔
227
      }
228

229
      *len += snprintf(buf + *len, bufSize - *len, ")");
227,463✔
230

231
      return TSDB_CODE_SUCCESS;
227,463✔
232
    }
233
    case QUERY_NODE_NODE_LIST: {
9,006✔
234
      SNodeListNode *pListNode = (SNodeListNode *)pNode;
9,006✔
235
      SNode         *node = NULL;
9,006✔
236
      bool           first = true;
9,006✔
237
      int32_t        num = 0;
9,006✔
238

239
      *len += snprintf(buf + *len, bufSize - *len, "(");
9,006✔
240

241
      FOREACH(node, pListNode->pNodeList) {
35,996✔
242
        if (!first) {
26,990✔
243
          *len += snprintf(buf + *len, bufSize - *len, ", ");
17,984✔
244
          if (!longFormat) {
17,984✔
245
            if (++num >= 10) {
×
246
              *len += snprintf(buf + *len, bufSize - *len, "...");
×
247
              break;
×
248
            }
249
          }
250
        }
251
        NODES_ERR_RET(nodesNodeToSQLFormat(node, buf, bufSize, len, true));
26,990✔
252
        first = false;
26,990✔
253
      }
254

255
      *len += snprintf(buf + *len, bufSize - *len, ")");
9,006✔
256

257
      return TSDB_CODE_SUCCESS;
9,006✔
258
    }
259
    case QUERY_NODE_REMOTE_VALUE: {
7,023,240✔
260
      SRemoteValueNode* pRemote = (SRemoteValueNode*)pNode;
7,023,240✔
261
      *len += snprintf(buf + *len, bufSize - *len, "$(InitPlan %d)", pRemote->subQIdx + 1);
7,023,240✔
262
      return TSDB_CODE_SUCCESS;
7,023,240✔
263
    }
264
    case QUERY_NODE_REMOTE_VALUE_LIST: {
1,540,324✔
265
      SRemoteValueListNode* pRemote = (SRemoteValueListNode*)pNode;
1,540,324✔
266
      *len += tsnprintf(buf + *len, bufSize - *len, "$(InitPlan %d)", pRemote->subQIdx + 1);
1,540,324✔
267
      return TSDB_CODE_SUCCESS;
1,540,501✔
268
    }
269
    case QUERY_NODE_REMOTE_ROW: {
181,144✔
270
      SRemoteRowNode* pRemote = (SRemoteRowNode*)pNode;
181,144✔
271
      *len += tsnprintf(buf + *len, bufSize - *len, "$(InitPlan %d)", pRemote->subQIdx + 1);
181,144✔
272
      return TSDB_CODE_SUCCESS;
181,144✔
273
    }
274
    case QUERY_NODE_REMOTE_ZERO_ROWS: {
118,596✔
275
      SRemoteZeroRowsNode* pRemote = (SRemoteZeroRowsNode*)pNode;
118,596✔
276
      *len += tsnprintf(buf + *len, bufSize - *len, "$(InitPlan %d)", pRemote->subQIdx + 1);
118,596✔
277
      return TSDB_CODE_SUCCESS;
118,596✔
278
    }
279
    case QUERY_NODE_REMOTE_TABLE: {
×
280
      SRemoteTableNode* pRemote = (SRemoteTableNode*)pNode;
×
281
      *len += tsnprintf(buf + *len, bufSize - *len, "$(InitPlan %d)", pRemote->subQIdx + 1);
×
282
      return TSDB_CODE_SUCCESS;
×
283
    }
284
    case QUERY_NODE_WHEN_THEN: {
3,408✔
285
      SWhenThenNode *pWhenThen = (SWhenThenNode *)pNode;
3,408✔
286
      *len += tsnprintf(buf + *len, bufSize - *len, "WHEN ");
3,408✔
287
      NODES_ERR_RET(nodesNodeToSQLFormat(pWhenThen->pWhen, buf, bufSize, len, true));
3,408✔
288
      *len += tsnprintf(buf + *len, bufSize - *len, " THEN ");
3,408✔
289
      NODES_ERR_RET(nodesNodeToSQLFormat(pWhenThen->pThen, buf, bufSize, len, true));
3,408✔
290
      return TSDB_CODE_SUCCESS;
3,408✔
291
    }
292
    case QUERY_NODE_CASE_WHEN: {
3,408✔
293
      SCaseWhenNode *pCaseWhen = (SCaseWhenNode *)pNode;
3,408✔
294
      *len += tsnprintf(buf + *len, bufSize - *len, "CASE");
3,408✔
295
      if (pCaseWhen->pCase) {
3,408✔
296
        *len += tsnprintf(buf + *len, bufSize - *len, " ");
×
297
        NODES_ERR_RET(nodesNodeToSQLFormat(pCaseWhen->pCase, buf, bufSize, len, true));
×
298
      }
299
      SNode *pWhenThen = NULL;
3,408✔
300
      FOREACH(pWhenThen, pCaseWhen->pWhenThenList) {
6,816✔
301
        *len += tsnprintf(buf + *len, bufSize - *len, " ");
3,408✔
302
        NODES_ERR_RET(nodesNodeToSQLFormat(pWhenThen, buf, bufSize, len, true));
3,408✔
303
      }
304
      if (pCaseWhen->pElse) {
3,408✔
305
        *len += tsnprintf(buf + *len, bufSize - *len, " ELSE ");
3,408✔
306
        NODES_ERR_RET(nodesNodeToSQLFormat(pCaseWhen->pElse, buf, bufSize, len, true));
3,408✔
307
      }
308
      *len += tsnprintf(buf + *len, bufSize - *len, " END");
3,408✔
309
      return TSDB_CODE_SUCCESS;
3,408✔
310
    }
UNCOV
311
    default:
×
UNCOV
312
      break;
×
313
  }
314

UNCOV
315
  nodesError("nodesNodeToSQL unknown node = %s", nodesNodeName(pNode->type));
×
316
  NODES_RET(TSDB_CODE_APP_ERROR);
×
317
}
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