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

taosdata / TDengine / #4906

30 Dec 2025 10:52AM UTC coverage: 65.514% (+0.09%) from 65.423%
#4906

push

travis-ci

web-flow
enh: drop multi-stream (#33962)

60 of 106 new or added lines in 4 files covered. (56.6%)

4080 existing lines in 123 files now uncovered.

193840 of 295877 relevant lines covered (65.51%)

120444601.14 hits per line

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

64.67
/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) {
105,107,423✔
25
  switch (type) {
105,107,423✔
26
    case OP_TYPE_ADD:
15,004✔
27
      return "+";
15,004✔
28
    case OP_TYPE_SUB:
×
29
      return "-";
×
30
    case OP_TYPE_MULTI:
×
31
      return "*";
×
32
    case OP_TYPE_DIV:
×
33
      return "/";
×
34
    case OP_TYPE_REM:
×
35
      return "%";
×
36
    case OP_TYPE_MINUS:
×
37
      return "-";
×
38
    case OP_TYPE_BIT_AND:
×
39
      return "&";
×
40
    case OP_TYPE_BIT_OR:
×
41
      return "|";
×
42
    case OP_TYPE_GREATER_THAN:
11,378,493✔
43
      return ">";
11,378,493✔
44
    case OP_TYPE_GREATER_EQUAL:
19,536,474✔
45
      return ">=";
19,536,474✔
46
    case OP_TYPE_LOWER_THAN:
9,040,280✔
47
      return "<";
9,040,280✔
48
    case OP_TYPE_LOWER_EQUAL:
19,229,280✔
49
      return "<=";
19,229,280✔
50
    case OP_TYPE_EQUAL:
23,465,731✔
51
      return "=";
23,465,731✔
52
    case OP_TYPE_NOT_EQUAL:
×
53
      return "<>";
×
54
    case OP_TYPE_IN:
167,775✔
55
      return "IN";
167,775✔
56
    case OP_TYPE_NOT_IN:
×
57
      return "NOT IN";
×
58
    case OP_TYPE_LIKE:
2,212,312✔
59
      return "LIKE";
2,212,312✔
60
    case OP_TYPE_NOT_LIKE:
×
61
      return "NOT LIKE";
×
62
    case OP_TYPE_MATCH:
10,060,100✔
63
      return "MATCH";
10,060,100✔
64
    case OP_TYPE_NMATCH:
502,084✔
65
      return "NMATCH";
502,084✔
66
    case OP_TYPE_IS_NULL:
2,474,900✔
67
      return "IS NULL";
2,474,900✔
68
    case OP_TYPE_IS_NOT_NULL:
7,026,093✔
69
      return "IS NOT NULL";
7,026,093✔
70
    case OP_TYPE_IS_TRUE:
×
71
      return "IS TRUE";
×
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_JSON_GET_VALUE:
×
83
      return "=>";
×
84
    case OP_TYPE_JSON_CONTAINS:
×
85
      return "CONTAINS";
×
86
    case OP_TYPE_ASSIGN:
×
87
      return "=";
×
UNCOV
88
    default:
×
UNCOV
89
      break;
×
90
  }
UNCOV
91
  return "UNKNOWN";
×
92
}
93

94
const char *logicConditionTypeStr(ELogicConditionType type) {
21,024✔
95
  switch (type) {
21,024✔
96
    case LOGIC_COND_TYPE_AND:
13,925✔
97
      return "AND";
13,925✔
98
    case LOGIC_COND_TYPE_OR:
7,099✔
99
      return "OR";
7,099✔
100
    case LOGIC_COND_TYPE_NOT:
×
101
      return "NOT";
×
102
    default:
×
103
      break;
×
104
  }
105
  return "UNKNOWN";
×
106
}
107

108
int32_t nodesNodeToSQL(SNode *pNode, char *buf, int32_t bufSize, int32_t *len) {
377,941✔
109
  return nodesNodeToSQLFormat(pNode, buf, bufSize, len, false);
377,941✔
110
}
111

112
int32_t nodesNodeToSQLFormat(SNode *pNode, char *buf, int32_t bufSize, int32_t *len, bool longFormat) {
1,416,416✔
113
  switch (pNode->type) {
1,416,416✔
114
    case QUERY_NODE_COLUMN: {
600,652✔
115
      SColumnNode *colNode = (SColumnNode *)pNode;
600,652✔
116
      if (colNode->dbName[0]) {
600,652✔
117
        *len += tsnprintf(buf + *len, bufSize - *len, "`%s`.", colNode->dbName);
570,673✔
118
      }
119

120
      if (colNode->tableAlias[0]) {
600,652✔
121
        *len += tsnprintf(buf + *len, bufSize - *len, "`%s`.", colNode->tableAlias);
585,977✔
122
      } else if (colNode->tableName[0]) {
14,675✔
123
        *len += tsnprintf(buf + *len, bufSize - *len, "`%s`.", colNode->tableName);
×
124
      }
125

126
      if (colNode->tableAlias[0]) {
600,652✔
127
        *len += tsnprintf(buf + *len, bufSize - *len, "`%s`", colNode->node.userAlias);
585,977✔
128
      } else {
129
        *len += tsnprintf(buf + *len, bufSize - *len, "%s", colNode->node.userAlias);
14,675✔
130
      }
131

132
      return TSDB_CODE_SUCCESS;
600,652✔
133
    }
134
    case QUERY_NODE_VALUE: {
321,670✔
135
      SValueNode *colNode = (SValueNode *)pNode;
321,670✔
136
      char       *t = nodesGetStrValueFromNode(colNode);
321,670✔
137
      if (NULL == t) {
321,670✔
138
        nodesError("fail to get str value from valueNode");
×
139
        NODES_ERR_RET(TSDB_CODE_APP_ERROR);
×
140
      }
141

142
      int32_t tlen = strlen(t);
321,670✔
143
      if (longFormat) {
321,670✔
144
        *len += tsnprintf(buf + *len, bufSize - *len, "%s", t);
321,670✔
145
      } else {
146
        if (tlen > 32) {
×
147
          *len += tsnprintf(buf + *len, bufSize - *len, "%.*s...%s", 32, t, t + tlen - 1);
×
148
        } else {
149
          *len += tsnprintf(buf + *len, bufSize - *len, "%s", t);
×
150
        }
151
      }
152

153
      taosMemoryFree(t);
321,670✔
154

155
      return TSDB_CODE_SUCCESS;
321,670✔
156
    }
157
    case QUERY_NODE_OPERATOR: {
447,405✔
158
      SOperatorNode *pOpNode = (SOperatorNode *)pNode;
447,405✔
159
      *len += tsnprintf(buf + *len, bufSize - *len, "(");
447,405✔
160
      if (pOpNode->pLeft) {
447,405✔
161
        NODES_ERR_RET(nodesNodeToSQLFormat(pOpNode->pLeft, buf, bufSize, len, true));
447,405✔
162
      }
163

164
      *len += tsnprintf(buf + *len, bufSize - *len, " %s ", operatorTypeStr(pOpNode->opType));
447,405✔
165

166
      if (pOpNode->pRight) {
447,405✔
167
        NODES_ERR_RET(nodesNodeToSQLFormat(pOpNode->pRight, buf, bufSize, len, true));
443,525✔
168
      }
169

170
      *len += tsnprintf(buf + *len, bufSize - *len, ")");
447,405✔
171

172
      return TSDB_CODE_SUCCESS;
447,405✔
173
    }
174
    case QUERY_NODE_LOGIC_CONDITION: {
21,024✔
175
      SLogicConditionNode *pLogicNode = (SLogicConditionNode *)pNode;
21,024✔
176
      SNode               *node = NULL;
21,024✔
177
      bool                 first = true;
21,024✔
178

179
      *len += tsnprintf(buf + *len, bufSize - *len, "(");
21,024✔
180

181
      FOREACH(node, pLogicNode->pParameterList) {
63,072✔
182
        if (!first) {
42,048✔
183
          *len += tsnprintf(buf + *len, bufSize - *len, " %s ", logicConditionTypeStr(pLogicNode->condType));
21,024✔
184
        }
185
        NODES_ERR_RET(nodesNodeToSQLFormat(node, buf, bufSize, len, true));
42,048✔
186
        first = false;
42,048✔
187
      }
188

189
      *len += tsnprintf(buf + *len, bufSize - *len, ")");
21,024✔
190

191
      return TSDB_CODE_SUCCESS;
21,024✔
192
    }
193
    case QUERY_NODE_FUNCTION: {
12,276✔
194
      SFunctionNode *pFuncNode = (SFunctionNode *)pNode;
12,276✔
195
      SNode         *node = NULL;
12,276✔
196
      bool           first = true;
12,276✔
197

198
      *len += tsnprintf(buf + *len, bufSize - *len, "%s(", pFuncNode->functionName);
12,276✔
199

200
      FOREACH(node, pFuncNode->pParameterList) {
61,380✔
201
        if (!first) {
49,104✔
202
          *len += tsnprintf(buf + *len, bufSize - *len, ", ");
36,828✔
203
        }
204
        NODES_ERR_RET(nodesNodeToSQLFormat(node, buf, bufSize, len, true));
49,104✔
205
        first = false;
49,104✔
206
      }
207

208
      *len += tsnprintf(buf + *len, bufSize - *len, ")");
12,276✔
209

210
      return TSDB_CODE_SUCCESS;
12,276✔
211
    }
212
    case QUERY_NODE_NODE_LIST: {
7,281✔
213
      SNodeListNode *pListNode = (SNodeListNode *)pNode;
7,281✔
214
      SNode         *node = NULL;
7,281✔
215
      bool           first = true;
7,281✔
216
      int32_t        num = 0;
7,281✔
217

218
      *len += tsnprintf(buf + *len, bufSize - *len, "(");
7,281✔
219

220
      FOREACH(node, pListNode->pNodeList) {
30,082✔
221
        if (!first) {
22,801✔
222
          *len += tsnprintf(buf + *len, bufSize - *len, ", ");
15,520✔
223
          if (!longFormat) {
15,520✔
224
            if (++num >= 10) {
×
225
              *len += tsnprintf(buf + *len, bufSize - *len, "...");
×
226
              break;
×
227
            }
228
          }
229
        }
230
        NODES_ERR_RET(nodesNodeToSQLFormat(node, buf, bufSize, len, true));
22,801✔
231
        first = false;
22,801✔
232
      }
233

234
      *len += tsnprintf(buf + *len, bufSize - *len, ")");
7,281✔
235

236
      return TSDB_CODE_SUCCESS;
7,281✔
237
    }
238
    case QUERY_NODE_REMOTE_VALUE: {
6,108✔
239
      SRemoteValueNode* pRemote = (SRemoteValueNode*)pNode;
6,108✔
240
      *len += tsnprintf(buf + *len, bufSize - *len, "$(InitPlan %d)", pRemote->subQIdx + 1);
6,108✔
241
      return TSDB_CODE_SUCCESS;
6,108✔
242
    }
243
    default:
×
244
      break;
×
245
  }
246

247
  nodesError("nodesNodeToSQL unknown node = %s", nodesNodeName(pNode->type));
×
248
  NODES_RET(TSDB_CODE_APP_ERROR);
×
249
}
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