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

taosdata / TDengine / #5017

09 Apr 2026 02:37PM UTC coverage: 72.248% (-0.05%) from 72.299%
#5017

push

travis-ci

web-flow
merge: from main to 3.0 branch #35095 

merge: from main to 3.0 branch

499 of 655 new or added lines in 34 files covered. (76.18%)

821 existing lines in 156 files now uncovered.

257359 of 356215 relevant lines covered (72.25%)

132044878.66 hits per line

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

79.42
/source/libs/command/src/command.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 "command.h"
17
#include "catalog.h"
18
#include "commandInt.h"
19
#include "decimal.h"
20
#include "osMemory.h"
21
#include "osString.h"
22
#include "scheduler.h"
23
#include "systable.h"
24
#include "taosdef.h"
25
#include "tdatablock.h"
26
#include "tdataformat.h"
27
#include "tglobal.h"
28
#include "tgrant.h"
29

30
#define COL_DATA_SET_VAL_AND_CHECK(pCol, rows, buf, isNull) \
31
  do {                                                      \
32
    int _code = colDataSetVal(pCol, rows, buf, isNull);     \
33
    if (TSDB_CODE_SUCCESS != _code) {                       \
34
      terrno = _code;                                       \
35
      return _code;                                         \
36
    }                                                       \
37
  } while (0)
38

39
extern SConfig* tsCfg;
40

41
static int32_t buildRetrieveTableRsp(SSDataBlock* pBlock, int32_t numOfCols, SRetrieveTableRsp** pRsp) {
3,329,219✔
42
  if (NULL == pBlock || NULL == pRsp) {
3,329,219✔
43
    return TSDB_CODE_INVALID_PARA;
×
44
  }
45
  size_t dataEncodeBufSize = blockGetEncodeSize(pBlock);
3,329,219✔
46
  size_t rspSize = sizeof(SRetrieveTableRsp) + dataEncodeBufSize + PAYLOAD_PREFIX_LEN;
3,329,219✔
47
  *pRsp = taosMemoryCalloc(1, rspSize);
3,329,219✔
48
  if (NULL == *pRsp) {
3,329,219✔
49
    return terrno;
×
50
  }
51

52
  (*pRsp)->useconds = 0;
3,329,219✔
53
  (*pRsp)->completed = 1;
3,329,219✔
54
  (*pRsp)->precision = 0;
3,329,219✔
55
  (*pRsp)->compressed = 0;
3,329,219✔
56

57
  (*pRsp)->numOfRows = htobe64((int64_t)pBlock->info.rows);
3,329,219✔
58
  (*pRsp)->numOfCols = htonl(numOfCols);
3,329,219✔
59

60
  int32_t len = 0;
3,329,219✔
61
  if (pBlock->info.rows > 0) {
3,329,219✔
62
    len = blockEncode(pBlock, (*pRsp)->data + PAYLOAD_PREFIX_LEN, dataEncodeBufSize, numOfCols);
3,328,977✔
63
    if (len < 0) {
3,328,940✔
64
      taosMemoryFree(*pRsp);
×
65
      *pRsp = NULL;
×
66
      return terrno;
×
67
    }
68
    SET_PAYLOAD_LEN((*pRsp)->data, len, len);
3,328,940✔
69
  }
70

71
  int32_t payloadLen = len + PAYLOAD_PREFIX_LEN;
3,329,182✔
72
  (*pRsp)->payloadLen = htonl(payloadLen);
3,329,182✔
73
  (*pRsp)->compLen = htonl(payloadLen);
3,329,182✔
74

75
  return TSDB_CODE_SUCCESS;
3,329,182✔
76
}
77

78
static int32_t getSchemaBytes(const SSchema* pSchema) {
63,928,999✔
79
  switch (pSchema->type) {
63,928,999✔
80
    case TSDB_DATA_TYPE_BINARY:
2,693,364✔
81
    case TSDB_DATA_TYPE_VARBINARY:
82
    case TSDB_DATA_TYPE_GEOMETRY:
83
      return (pSchema->bytes - VARSTR_HEADER_SIZE);
2,693,364✔
84
    case TSDB_DATA_TYPE_NCHAR:
4,446,059✔
85
    case TSDB_DATA_TYPE_JSON:
86
      return (pSchema->bytes - VARSTR_HEADER_SIZE) / TSDB_NCHAR_SIZE;
4,446,059✔
87
    default:
56,789,576✔
88
      return pSchema->bytes;
56,789,576✔
89
  }
90
}
91

92
static const char* expandIdentifier(const char* name, char* output) {
661,439✔
93
  if (NULL == name) return "";
661,439✔
94
  bool containsEscapeChar = false;
661,439✔
95
  for (const char* p = name; *p != '\0'; ++p) {
4,892,517✔
96
    if (*p == TS_ESCAPE_CHAR) {
4,279,858✔
97
      containsEscapeChar = true;
48,780✔
98
      break;
48,780✔
99
    }
100
  }
101
  if (!containsEscapeChar) return name;
661,439✔
102
  if (NULL == output) return "";
48,780✔
103
  char* out_ptr = output;
48,780✔
104
  for (const char* src = name; *src != '\0'; ++src) {
300,268✔
105
    if (*src == TS_ESCAPE_CHAR) {
251,488✔
106
      *out_ptr++ = TS_ESCAPE_CHAR;
122,492✔
107
      *out_ptr++ = TS_ESCAPE_CHAR;
122,492✔
108
    } else {
109
      *out_ptr++ = *src;
128,996✔
110
    }
111
  }
112
  *out_ptr = '\0';
48,780✔
113
  return output;
48,780✔
114
}
115

116
static int32_t buildDescResultDataBlock(SSDataBlock** pOutput) {
445,360✔
117
  QRY_PARAM_CHECK(pOutput);
445,360✔
118

119
  SSDataBlock* pBlock = NULL;
445,360✔
120
  int32_t      code = createDataBlock(&pBlock);
445,360✔
121
  if (code) {
445,360✔
122
    return code;
×
123
  }
124

125
  SColumnInfoData infoData = createColumnInfoData(TSDB_DATA_TYPE_VARCHAR, DESCRIBE_RESULT_FIELD_LEN, 1);
445,360✔
126
  code = blockDataAppendColInfo(pBlock, &infoData);
445,360✔
127
  if (TSDB_CODE_SUCCESS == code) {
445,360✔
128
    infoData = createColumnInfoData(TSDB_DATA_TYPE_VARCHAR, DESCRIBE_RESULT_TYPE_LEN, 2);
445,360✔
129
    code = blockDataAppendColInfo(pBlock, &infoData);
445,360✔
130
  }
131
  if (TSDB_CODE_SUCCESS == code) {
445,360✔
132
    infoData = createColumnInfoData(TSDB_DATA_TYPE_INT, tDataTypes[TSDB_DATA_TYPE_INT].bytes, 3);
445,360✔
133
    code = blockDataAppendColInfo(pBlock, &infoData);
445,360✔
134
  }
135
  if (TSDB_CODE_SUCCESS == code) {
445,360✔
136
    infoData = createColumnInfoData(TSDB_DATA_TYPE_VARCHAR, DESCRIBE_RESULT_NOTE_LEN, 4);
445,360✔
137
    code = blockDataAppendColInfo(pBlock, &infoData);
445,360✔
138
  }
139
  if (TSDB_CODE_SUCCESS == code) {
445,360✔
140
    infoData = createColumnInfoData(TSDB_DATA_TYPE_VARCHAR, DESCRIBE_RESULT_COPRESS_OPTION_LEN, 5);
445,360✔
141
    code = blockDataAppendColInfo(pBlock, &infoData);
445,360✔
142
  }
143
  if (TSDB_CODE_SUCCESS == code) {
445,360✔
144
    infoData = createColumnInfoData(TSDB_DATA_TYPE_VARCHAR, DESCRIBE_RESULT_COPRESS_OPTION_LEN, 6);
445,360✔
145
    code = blockDataAppendColInfo(pBlock, &infoData);
445,360✔
146
  }
147
  if (TSDB_CODE_SUCCESS == code) {
445,360✔
148
    infoData = createColumnInfoData(TSDB_DATA_TYPE_VARCHAR, DESCRIBE_RESULT_COPRESS_OPTION_LEN, 7);
445,360✔
149
    code = blockDataAppendColInfo(pBlock, &infoData);
445,360✔
150
  }
151
  if (TSDB_CODE_SUCCESS == code) {
445,360✔
152
    infoData = createColumnInfoData(TSDB_DATA_TYPE_VARCHAR, DESCRIBE_RESULT_COL_REF_LEN, 8);
445,360✔
153
    code = blockDataAppendColInfo(pBlock, &infoData);
445,360✔
154
  }
155
  if (TSDB_CODE_SUCCESS == code) {
445,360✔
156
    *pOutput = pBlock;
445,360✔
157
  } else {
158
    (void)blockDataDestroy(pBlock);
×
159
  }
160
  return code;
445,360✔
161
}
162

163
static int32_t setDescResultIntoDataBlock(bool sysInfoUser, SSDataBlock* pBlock, int32_t numOfRows, STableMeta* pMeta,
445,360✔
164
                                          int8_t biMode) {
165
  int32_t blockCap = (biMode != 0) ? numOfRows + 1 : numOfRows;
445,360✔
166
  QRY_ERR_RET(blockDataEnsureCapacity(pBlock, blockCap));
445,360✔
167
  pBlock->info.rows = 0;
445,360✔
168

169
  // field
170
  SColumnInfoData* pCol1 = taosArrayGet(pBlock->pDataBlock, 0);
445,360✔
171
  // Type
172
  SColumnInfoData* pCol2 = taosArrayGet(pBlock->pDataBlock, 1);
445,360✔
173
  // Length
174
  SColumnInfoData* pCol3 = taosArrayGet(pBlock->pDataBlock, 2);
445,360✔
175
  // Note
176
  SColumnInfoData* pCol4 = taosArrayGet(pBlock->pDataBlock, 3);
445,360✔
177
  // encode
178
  SColumnInfoData* pCol5 = NULL;
445,360✔
179
  // compress
180
  SColumnInfoData* pCol6 = NULL;
445,360✔
181
  // level
182
  SColumnInfoData* pCol7 = NULL;
445,360✔
183
  // colref
184
  SColumnInfoData* pCol8 = NULL;
445,360✔
185
  if (withColCompress(pMeta->tableType)) {
445,360✔
186
    pCol5 = taosArrayGet(pBlock->pDataBlock, 4);
427,226✔
187
    pCol6 = taosArrayGet(pBlock->pDataBlock, 5);
427,226✔
188
    pCol7 = taosArrayGet(pBlock->pDataBlock, 6);
427,226✔
189
  }
190

191
  if (hasRefCol(pMeta->tableType)) {
445,360✔
192
    pCol8 = taosArrayGet(pBlock->pDataBlock, 4);
7,473✔
193
  }
194

195
  int32_t fillTagCol = 0;
445,360✔
196
  char    buf[DESCRIBE_RESULT_FIELD_LEN] = {0};
445,360✔
197
  for (int32_t i = 0; i < numOfRows; ++i) {
64,374,359✔
198
    if (invisibleColumn(sysInfoUser, pMeta->tableType, pMeta->schema[i].flags)) {
63,928,999✔
199
      continue;
×
200
    }
201
    STR_TO_VARSTR(buf, pMeta->schema[i].name);
63,928,999✔
202
    COL_DATA_SET_VAL_AND_CHECK(pCol1, pBlock->info.rows, buf, false);
63,928,999✔
203

204
    if (IS_DECIMAL_TYPE(pMeta->schema[i].type) && withExtSchema(pMeta->tableType)) {
63,928,999✔
205
      uint8_t prec = 0, scale = 0;
279,692✔
206
      decimalFromTypeMod(pMeta->schemaExt[i].typeMod, &prec, &scale);
279,692✔
207
      size_t len = snprintf(buf + VARSTR_HEADER_SIZE, DESCRIBE_RESULT_FIELD_LEN - VARSTR_HEADER_SIZE, "%s(%hhu, %hhu)",
279,692✔
208
                            tDataTypes[pMeta->schema[i].type].name, prec, scale);
279,692✔
209
      varDataSetLen(buf, len);
279,692✔
210
    } else {
211
      STR_TO_VARSTR(buf, tDataTypes[pMeta->schema[i].type].name);
63,649,307✔
212
    }
213
    COL_DATA_SET_VAL_AND_CHECK(pCol2, pBlock->info.rows, buf, false);
63,928,999✔
214
    int32_t bytes = getSchemaBytes(pMeta->schema + i);
63,928,999✔
215
    COL_DATA_SET_VAL_AND_CHECK(pCol3, pBlock->info.rows, (const char*)&bytes, false);
63,928,999✔
216
    if (TSDB_VIEW_TABLE != pMeta->tableType) {
63,928,999✔
217
      if (i >= pMeta->tableInfo.numOfColumns) {
63,897,679✔
218
        STR_TO_VARSTR(buf, "TAG");
3,030,044✔
219
        fillTagCol = 1;
3,030,044✔
220
      } else if (i == 1 && pMeta->schema[i].flags & COL_IS_KEY) {
60,867,635✔
221
        STR_TO_VARSTR(buf, "COMPOSITE KEY")
11,011✔
222
      } else {
223
        STR_TO_VARSTR(buf, "");
60,856,624✔
224
      }
225
    } else {
226
      STR_TO_VARSTR(buf, "VIEW COL");
31,320✔
227
    }
228
    COL_DATA_SET_VAL_AND_CHECK(pCol4, pBlock->info.rows, buf, false);
63,928,999✔
229
    if (withColCompress(pMeta->tableType) && pMeta->schemaExt) {
63,928,999✔
230
      if (i < pMeta->tableInfo.numOfColumns) {
63,819,194✔
231
        STR_TO_VARSTR(buf, columnEncodeStr(COMPRESS_L1_TYPE_U32(pMeta->schemaExt[i].compress)));
60,797,352✔
232
        COL_DATA_SET_VAL_AND_CHECK(pCol5, pBlock->info.rows, buf, false);
60,797,352✔
233
        STR_TO_VARSTR(buf, columnCompressStr(COMPRESS_L2_TYPE_U32(pMeta->schemaExt[i].compress)));
60,797,352✔
234
        COL_DATA_SET_VAL_AND_CHECK(pCol6, pBlock->info.rows, buf, false);
60,797,352✔
235
        STR_TO_VARSTR(buf, columnLevelStr(COMPRESS_L2_TYPE_LEVEL_U32(pMeta->schemaExt[i].compress)));
60,797,352✔
236
        COL_DATA_SET_VAL_AND_CHECK(pCol7, pBlock->info.rows, buf, false);
60,797,352✔
237
      } else {
238
        STR_TO_VARSTR(buf, fillTagCol == 0 ? "" : "disabled");
3,021,842✔
239
        COL_DATA_SET_VAL_AND_CHECK(pCol5, pBlock->info.rows, buf, false);
3,021,842✔
240
        STR_TO_VARSTR(buf, fillTagCol == 0 ? "" : "disabled");
3,021,842✔
241
        COL_DATA_SET_VAL_AND_CHECK(pCol6, pBlock->info.rows, buf, false);
3,021,842✔
242
        STR_TO_VARSTR(buf, fillTagCol == 0 ? "" : "disabled");
3,021,842✔
243
        COL_DATA_SET_VAL_AND_CHECK(pCol7, pBlock->info.rows, buf, false);
3,021,842✔
244
      }
245
    } else if (hasRefCol(pMeta->tableType) && pMeta->colRef) {
109,805✔
246
      if (i < pMeta->numOfColRefs) {
60,653✔
247
        if (pMeta->colRef[i].hasRef) {
52,451✔
248
          char refColName[TSDB_DB_NAME_LEN + TSDB_NAME_DELIMITER_LEN + TSDB_COL_FNAME_LEN] = {0};
25,903✔
249

250
          TSlice strBuf = {0};
25,903✔
251
          sliceInit(&strBuf, refColName, sizeof(refColName));
25,903✔
252

253
          QRY_ERR_RET(sliceAppend(&strBuf, pMeta->colRef[i].refDbName, strlen(pMeta->colRef[i].refDbName)));
25,903✔
254
          QRY_ERR_RET(sliceAppend(&strBuf, ".", 1));
25,903✔
255
          QRY_ERR_RET(sliceAppend(&strBuf, pMeta->colRef[i].refTableName, strlen(pMeta->colRef[i].refTableName)));
25,903✔
256
          QRY_ERR_RET(sliceAppend(&strBuf, ".", 1));
25,903✔
257
          QRY_ERR_RET(sliceAppend(&strBuf, pMeta->colRef[i].refColName, strlen(pMeta->colRef[i].refColName)));
25,903✔
258
          STR_TO_VARSTR(buf, refColName);
25,903✔
259
        } else {
260
          STR_TO_VARSTR(buf, "");
26,548✔
261
        }
262
        COL_DATA_SET_VAL_AND_CHECK(pCol8, pBlock->info.rows, buf, false);
52,451✔
263
      } else {
264
        STR_TO_VARSTR(buf, "");
8,202✔
265
        COL_DATA_SET_VAL_AND_CHECK(pCol8, pBlock->info.rows, buf, false);
8,202✔
266
      }
267
    }
268

269
    fillTagCol = 0;
63,928,999✔
270

271
    ++(pBlock->info.rows);
63,928,999✔
272
  }
273
  if (pMeta->tableType == TSDB_SUPER_TABLE && biMode != 0) {
445,360✔
274
    STR_TO_VARSTR(buf, "tbname");
×
275
    COL_DATA_SET_VAL_AND_CHECK(pCol1, pBlock->info.rows, buf, false);
×
276
    STR_TO_VARSTR(buf, "VARCHAR");
×
277
    COL_DATA_SET_VAL_AND_CHECK(pCol2, pBlock->info.rows, buf, false);
×
278
    int32_t bytes = TSDB_TABLE_NAME_LEN - 1;
×
279
    COL_DATA_SET_VAL_AND_CHECK(pCol3, pBlock->info.rows, (const char*)&bytes, false);
×
280
    STR_TO_VARSTR(buf, "TAG");
×
281
    COL_DATA_SET_VAL_AND_CHECK(pCol4, pBlock->info.rows, buf, false);
×
282
    ++(pBlock->info.rows);
×
283
  }
284
  if (pBlock->info.rows <= 0) {
445,360✔
285
    qError("no permission to view any columns");
×
286
    return TSDB_CODE_PAR_PERMISSION_DENIED;
×
287
  }
288
  return TSDB_CODE_SUCCESS;
445,360✔
289
}
290

291
static int32_t execDescribe(bool sysInfoUser, SNode* pStmt, SRetrieveTableRsp** pRsp, int8_t biMode) {
445,360✔
292
  SDescribeStmt* pDesc = (SDescribeStmt*)pStmt;
445,360✔
293
  if (NULL == pDesc || NULL == pDesc->pMeta) {
445,360✔
294
    return TSDB_CODE_INVALID_PARA;
×
295
  }
296
  int32_t numOfRows = TABLE_TOTAL_COL_NUM(pDesc->pMeta);
445,360✔
297

298
  SSDataBlock* pBlock = NULL;
445,360✔
299
  int32_t      code = buildDescResultDataBlock(&pBlock);
445,360✔
300
  if (TSDB_CODE_SUCCESS == code) {
445,360✔
301
    code = setDescResultIntoDataBlock(sysInfoUser, pBlock, numOfRows, pDesc->pMeta, biMode);
445,360✔
302
  }
303
  if (TSDB_CODE_SUCCESS == code) {
445,360✔
304
    if (pDesc->pMeta) {
445,360✔
305
      if (hasRefCol(pDesc->pMeta->tableType)) {
445,360✔
306
        code = buildRetrieveTableRsp(pBlock, DESCRIBE_RESULT_COLS_REF, pRsp);
7,473✔
307
      } else if (withColCompress(pDesc->pMeta->tableType) && pDesc->pMeta->schemaExt) {
437,887✔
308
        code = buildRetrieveTableRsp(pBlock, DESCRIBE_RESULT_COLS_COMPRESS, pRsp);
427,226✔
309
      } else {
310
        code = buildRetrieveTableRsp(pBlock, DESCRIBE_RESULT_COLS, pRsp);
10,661✔
311
      }
312
    } else {
313
      code = buildRetrieveTableRsp(pBlock, DESCRIBE_RESULT_COLS, pRsp);
×
314
    }
315
  }
316
  (void)blockDataDestroy(pBlock);
445,323✔
317
  return code;
445,360✔
318
}
319

320
static int32_t execResetQueryCache() { return catalogClearCache(); }
2,167,670✔
321

322
static int32_t buildCreateDBResultDataBlock(SSDataBlock** pOutput) {
73,075✔
323
  QRY_PARAM_CHECK(pOutput);
73,075✔
324

325
  SSDataBlock* pBlock = NULL;
73,075✔
326
  int32_t      code = createDataBlock(&pBlock);
73,075✔
327
  if (code) {
73,075✔
328
    return code;
×
329
  }
330

331
  SColumnInfoData infoData = createColumnInfoData(TSDB_DATA_TYPE_VARCHAR, SHOW_CREATE_DB_RESULT_COLS, 1);
73,075✔
332
  code = blockDataAppendColInfo(pBlock, &infoData);
73,075✔
333
  if (TSDB_CODE_SUCCESS == code) {
73,075✔
334
    infoData = createColumnInfoData(TSDB_DATA_TYPE_VARCHAR, SHOW_CREATE_DB_RESULT_FIELD2_LEN, 2);
73,075✔
335
    code = blockDataAppendColInfo(pBlock, &infoData);
73,075✔
336
  }
337

338
  if (TSDB_CODE_SUCCESS == code) {
73,075✔
339
    *pOutput = pBlock;
73,075✔
340
  } else {
341
    (void)blockDataDestroy(pBlock);
×
342
  }
343
  return code;
73,075✔
344
}
345

346
int64_t getValOfDiffPrecision(int8_t unit, int64_t val) {
×
347
  int64_t v = 0;
×
348
  switch (unit) {
×
349
    case 's':
×
350
      v = val / 1000;
×
351
      break;
×
352
    case 'm':
×
353
      v = val / tsTickPerMin[TSDB_TIME_PRECISION_MILLI];
×
354
      break;
×
355
    case 'h':
×
356
      v = val / (tsTickPerMin[TSDB_TIME_PRECISION_MILLI] * 60);
×
357
      break;
×
358
    case 'd':
×
359
      v = val / (tsTickPerMin[TSDB_TIME_PRECISION_MILLI] * 24 * 60);
×
360
      break;
×
361
    case 'w':
×
362
      v = val / (tsTickPerMin[TSDB_TIME_PRECISION_MILLI] * 24 * 60 * 7);
×
363
      break;
×
364
    default:
×
365
      break;
×
366
  }
367

368
  return v;
×
369
}
370

371
static int32_t buildRetension(SArray* pRetension, char** ppRetentions) {
73,075✔
372
  size_t size = taosArrayGetSize(pRetension);
73,075✔
373
  if (size == 0) {
73,075✔
374
    *ppRetentions = NULL;
73,075✔
375
    return TSDB_CODE_SUCCESS;
73,075✔
376
  }
377

378
  const int lMaxLen = 128;
×
379
  char*     p1 = taosMemoryCalloc(1, lMaxLen);
×
380
  if (NULL == p1) {
×
381
    return terrno;
×
382
  }
383
  int32_t len = 0;
×
384

385
  for (int32_t i = 0; i < size; ++i) {
×
386
    SRetention* p = TARRAY_GET_ELEM(pRetension, i);
×
387
    int64_t     v1 = getValOfDiffPrecision(p->freqUnit, p->freq);
×
388
    int64_t     v2 = getValOfDiffPrecision(p->keepUnit, p->keep);
×
389
    if (i == 0) {
×
390
      len += snprintf(p1 + len, lMaxLen - len, "-:%" PRId64 "%c", v2, p->keepUnit);
×
391
    } else {
392
      len += snprintf(p1 + len, lMaxLen - len, "%" PRId64 "%c:%" PRId64 "%c", v1, p->freqUnit, v2, p->keepUnit);
×
393
    }
394

395
    if (i < size - 1) {
×
396
      len += snprintf(p1 + len, lMaxLen - len, ",");
×
397
    }
398
  }
399

400
  *ppRetentions = p1;
×
401
  return TSDB_CODE_SUCCESS;
×
402
}
403

404
static const char* cacheModelStr(int8_t cacheModel) {
72,703✔
405
  switch (cacheModel) {
72,703✔
406
    case TSDB_CACHE_MODEL_NONE:
72,703✔
407
      return TSDB_CACHE_MODEL_NONE_STR;
72,703✔
408
    case TSDB_CACHE_MODEL_LAST_ROW:
×
409
      return TSDB_CACHE_MODEL_LAST_ROW_STR;
×
410
    case TSDB_CACHE_MODEL_LAST_VALUE:
×
411
      return TSDB_CACHE_MODEL_LAST_VALUE_STR;
×
412
    case TSDB_CACHE_MODEL_BOTH:
×
413
      return TSDB_CACHE_MODEL_BOTH_STR;
×
414
    default:
×
415
      break;
×
416
  }
417
  return TSDB_CACHE_MODEL_NONE_STR;
×
418
}
419

420
static const char* encryptAlgorithmStr(int8_t encryptAlgorithm, char* algorithmsId) {
72,703✔
421
  if (algorithmsId[0] != '\0') {
72,703✔
422
    return algorithmsId;
×
423
  } else if (encryptAlgorithm != 0) {
72,703✔
424
    switch (encryptAlgorithm) {
×
425
      case TSDB_ENCRYPT_ALGO_NONE:
×
426
        return TSDB_ENCRYPT_ALGO_NONE_STR;
×
427
      case TSDB_ENCRYPT_ALGO_SM4:
×
428
        return TSDB_ENCRYPT_ALGO_SM4_STR;
×
429
      default:
×
430
        break;
×
431
    }
432
    return TSDB_CACHE_MODEL_NONE_STR;
×
433
  }
434

435
  return TSDB_CACHE_MODEL_NONE_STR;
72,703✔
436
}
437

438
int32_t formatDurationOrKeep(char* buffer, int64_t bufSize, int32_t timeInMinutes) {
4,656,085✔
439
  if (buffer == NULL || bufSize <= 0) {
4,656,085✔
440
    return 0;
×
441
  }
442
  int32_t len = 0;
4,656,085✔
443
  if (timeInMinutes % 1440 == 0) {
4,656,085✔
444
    int32_t days = timeInMinutes / 1440;
4,643,826✔
445
    len = snprintf(buffer, bufSize, "%dd", days);
4,643,826✔
446
  } else if (timeInMinutes % 60 == 0) {
12,259✔
447
    int32_t hours = timeInMinutes / 60;
2,102✔
448
    len = snprintf(buffer, bufSize, "%dh", hours);
2,102✔
449
  } else {
450
    len = snprintf(buffer, bufSize, "%dm", timeInMinutes);
10,157✔
451
  }
452
  return len;
4,656,085✔
453
}
454

455
static int32_t setCreateDBResultIntoDataBlock(SSDataBlock* pBlock, char* dbName, char* dbFName, SDbCfgInfo* pCfg) {
73,075✔
456
  QRY_ERR_RET(blockDataEnsureCapacity(pBlock, 1));
73,075✔
457
  pBlock->info.rows = 1;
73,075✔
458

459
  SColumnInfoData* pCol1 = taosArrayGet(pBlock->pDataBlock, 0);
73,075✔
460
  char             buf1[SHOW_CREATE_DB_RESULT_FIELD1_LEN] = {0};
73,075✔
461
  STR_TO_VARSTR(buf1, dbName);
73,075✔
462
  COL_DATA_SET_VAL_AND_CHECK(pCol1, 0, buf1, false);
73,075✔
463

464
  SColumnInfoData* pCol2 = taosArrayGet(pBlock->pDataBlock, 1);
73,075✔
465
  char             buf2[SHOW_CREATE_DB_RESULT_FIELD2_LEN] = {0};
73,075✔
466
  int32_t          len = 0;
73,075✔
467
  char*            prec = NULL;
73,075✔
468
  switch (pCfg->precision) {
73,075✔
469
    case TSDB_TIME_PRECISION_MILLI:
73,075✔
470
      prec = TSDB_TIME_PRECISION_MILLI_STR;
73,075✔
471
      break;
73,075✔
472
    case TSDB_TIME_PRECISION_MICRO:
×
473
      prec = TSDB_TIME_PRECISION_MICRO_STR;
×
474
      break;
×
475
    case TSDB_TIME_PRECISION_NANO:
×
476
      prec = TSDB_TIME_PRECISION_NANO_STR;
×
477
      break;
×
478
    default:
×
479
      prec = "none";
×
480
      break;
×
481
  }
482

483
  char* pRetentions = NULL;
73,075✔
484
  QRY_ERR_RET(buildRetension(pCfg->pRetensions, &pRetentions));
73,075✔
485
  int32_t dbFNameLen = strlen(dbFName);
73,075✔
486
  int32_t hashPrefix = 0;
73,075✔
487
  if (pCfg->hashPrefix > 0) {
73,075✔
488
    hashPrefix = pCfg->hashPrefix - dbFNameLen - 1;
1,540✔
489
  } else if (pCfg->hashPrefix < 0) {
71,535✔
490
    hashPrefix = pCfg->hashPrefix + dbFNameLen + 1;
2,310✔
491
  }
492
  char durationStr[128] = {0};
73,075✔
493
  char keep0Str[128] = {0};
73,075✔
494
  char keep1Str[128] = {0};
73,075✔
495
  char keep2Str[128] = {0};
73,075✔
496
  char compactIntervalStr[13] = {0};
73,075✔
497
  char compactStartTimeStr[13] = {0};
73,075✔
498
  char compactEndTimeStr[13] = {0};
73,075✔
499

500
  int32_t lenDuration = formatDurationOrKeep(durationStr, sizeof(durationStr), pCfg->daysPerFile);
73,075✔
501
  int32_t lenKeep0 = formatDurationOrKeep(keep0Str, sizeof(keep0Str), pCfg->daysToKeep0);
73,075✔
502
  int32_t lenKeep1 = formatDurationOrKeep(keep1Str, sizeof(keep1Str), pCfg->daysToKeep1);
73,075✔
503
  int32_t lenKeep2 = formatDurationOrKeep(keep2Str, sizeof(keep2Str), pCfg->daysToKeep2);
73,075✔
504
  UNUSED(formatDurationOrKeep(compactIntervalStr, sizeof(compactIntervalStr), pCfg->compactInterval));
73,075✔
505
  UNUSED(formatDurationOrKeep(compactStartTimeStr, sizeof(compactStartTimeStr), pCfg->compactStartTime));
73,075✔
506
  UNUSED(formatDurationOrKeep(compactEndTimeStr, sizeof(compactEndTimeStr), pCfg->compactEndTime));
73,075✔
507

508
  if (IS_SYS_DBNAME(dbName)) {
73,075✔
509
    len += snprintf(buf2 + VARSTR_HEADER_SIZE, SHOW_CREATE_DB_RESULT_FIELD2_LEN - VARSTR_HEADER_SIZE,
372✔
510
                    "CREATE DATABASE `%s`", dbName);
372✔
511
  } else {
512
    len += tsnprintf(buf2 + VARSTR_HEADER_SIZE, SHOW_CREATE_DB_RESULT_FIELD2_LEN - VARSTR_HEADER_SIZE,
508,921✔
513
                     "CREATE DATABASE `%s` BUFFER %d CACHESIZE %d CACHEMODEL '%s' CACHESHARDBITS %d COMP %d DURATION %s "
514
                     "WAL_FSYNC_PERIOD %d MAXROWS %d MINROWS %d STT_TRIGGER %d KEEP %s,%s,%s PAGES %d PAGESIZE %d "
515
                     "PRECISION '%s' REPLICA %d "
516
                     "WAL_LEVEL %d VGROUPS %d SINGLE_STABLE %d TABLE_PREFIX %d TABLE_SUFFIX %d TSDB_PAGESIZE %d "
517
                     "WAL_RETENTION_PERIOD %d WAL_RETENTION_SIZE %" PRId64
518
                     " KEEP_TIME_OFFSET %d ENCRYPT_ALGORITHM '%s' SS_CHUNKPAGES %d SS_KEEPLOCAL %dm SS_COMPACT %d "
519
                     "COMPACT_INTERVAL %s COMPACT_TIME_RANGE %s,%s COMPACT_TIME_OFFSET %" PRIi8 "h IS_AUDIT %d SECURE_DELETE %d",
520
                     dbName, pCfg->buffer, pCfg->cacheSize, cacheModelStr(pCfg->cacheLast), pCfg->cacheShardBits, pCfg->compression,
145,406✔
521
                     durationStr, pCfg->walFsyncPeriod, pCfg->maxRows, pCfg->minRows, pCfg->sstTrigger, keep0Str,
72,703✔
522
                     keep1Str, keep2Str, pCfg->pages, pCfg->pageSize, prec, pCfg->replications, pCfg->walLevel,
72,703✔
523
                     pCfg->numOfVgroups, 1 == pCfg->numOfStables, hashPrefix, pCfg->hashSuffix, pCfg->tsdbPageSize,
72,703✔
524
                     pCfg->walRetentionPeriod, pCfg->walRetentionSize, pCfg->keepTimeOffset,
525
                     encryptAlgorithmStr(pCfg->encryptAlgr, pCfg->algorithmsId), pCfg->ssChunkSize, pCfg->ssKeepLocal,
72,703✔
526
                     pCfg->ssCompact, compactIntervalStr, compactStartTimeStr, compactEndTimeStr,
72,703✔
527
                     pCfg->compactTimeOffset, pCfg->isAudit, pCfg->secureDelete);
72,703✔
528

529

530
    if (pRetentions) {
72,703✔
531
      len += snprintf(buf2 + VARSTR_HEADER_SIZE + len, SHOW_CREATE_DB_RESULT_FIELD2_LEN - VARSTR_HEADER_SIZE,
×
532
                      " RETENTIONS %s", pRetentions);
533
    }
534
  }
535

536
  taosMemoryFree(pRetentions);
73,075✔
537

538
  (varDataLen(buf2)) = len;
73,075✔
539

540
  COL_DATA_SET_VAL_AND_CHECK(pCol2, 0, buf2, false);
73,075✔
541

542
  return TSDB_CODE_SUCCESS;
73,075✔
543
}
544

545
static int32_t execShowCreateDatabase(SShowCreateDatabaseStmt* pStmt, SRetrieveTableRsp** pRsp) {
73,075✔
546
  SSDataBlock* pBlock = NULL;
73,075✔
547
  int32_t      code = buildCreateDBResultDataBlock(&pBlock);
73,075✔
548
  if (TSDB_CODE_SUCCESS == code) {
73,075✔
549
    code = setCreateDBResultIntoDataBlock(pBlock, pStmt->dbName, pStmt->dbFName, pStmt->pCfg);
73,075✔
550
  }
551
  if (TSDB_CODE_SUCCESS == code) {
73,075✔
552
    code = buildRetrieveTableRsp(pBlock, SHOW_CREATE_DB_RESULT_COLS, pRsp);
73,075✔
553
  }
554
  (void)blockDataDestroy(pBlock);
73,075✔
555
  return code;
73,075✔
556
}
557

558
static int32_t buildCreateTbResultDataBlock(SSDataBlock** pOutput) {
93,130✔
559
  QRY_PARAM_CHECK(pOutput);
93,130✔
560

561
  SSDataBlock* pBlock = NULL;
93,130✔
562
  int32_t      code = createDataBlock(&pBlock);
93,130✔
563
  if (code) {
93,130✔
564
    return code;
×
565
  }
566

567
  SColumnInfoData infoData = createColumnInfoData(TSDB_DATA_TYPE_VARCHAR, SHOW_CREATE_TB_RESULT_FIELD1_LEN, 1);
93,130✔
568
  code = blockDataAppendColInfo(pBlock, &infoData);
93,130✔
569
  if (TSDB_CODE_SUCCESS == code) {
93,130✔
570
    infoData = createColumnInfoData(TSDB_DATA_TYPE_VARCHAR, SHOW_CREATE_TB_RESULT_FIELD2_LEN, 2);
93,130✔
571
    code = blockDataAppendColInfo(pBlock, &infoData);
93,130✔
572
  }
573

574
  if (TSDB_CODE_SUCCESS == code) {
93,130✔
575
    *pOutput = pBlock;
93,130✔
576
  } else {
577
    (void)blockDataDestroy(pBlock);
×
578
  }
579
  return code;
93,130✔
580
}
581

582
static int32_t buildCreateViewResultDataBlock(SSDataBlock** pOutput) {
6,729✔
583
  QRY_PARAM_CHECK(pOutput);
6,729✔
584

585
  SSDataBlock* pBlock = NULL;
6,729✔
586
  int32_t      code = createDataBlock(&pBlock);
6,729✔
587
  if (code) {
6,729✔
588
    return code;
×
589
  }
590

591
  SColumnInfoData infoData = createColumnInfoData(TSDB_DATA_TYPE_VARCHAR, SHOW_CREATE_VIEW_RESULT_FIELD1_LEN, 1);
6,729✔
592
  code = blockDataAppendColInfo(pBlock, &infoData);
6,729✔
593
  if (TSDB_CODE_SUCCESS == code) {
6,729✔
594
    infoData = createColumnInfoData(TSDB_DATA_TYPE_VARCHAR, SHOW_CREATE_VIEW_RESULT_FIELD2_LEN, 2);
6,729✔
595
    code = blockDataAppendColInfo(pBlock, &infoData);
6,729✔
596
  }
597

598
  if (TSDB_CODE_SUCCESS == code) {
6,729✔
599
    *pOutput = pBlock;
6,729✔
600
  } else {
601
    (void)blockDataDestroy(pBlock);
×
602
  }
603
  return code;
6,729✔
604
}
605

606
static void appendColumnFields(char* buf, int32_t* len, STableCfg* pCfg) {
46,362✔
607
  char expandName[(SHOW_CREATE_TB_RESULT_FIELD1_LEN << 1) + 1] = {0};
46,362✔
608
  for (int32_t i = 0; i < pCfg->numOfColumns; ++i) {
283,992✔
609
    SSchema* pSchema = pCfg->pSchemas + i;
237,630✔
610
    SColRef* pRef = pCfg->pColRefs ? pCfg->pColRefs + i : NULL;
237,630✔
611
#define LTYPE_LEN                                    \
612
  (32 + 60 + TSDB_COL_FNAME_LEN + TSDB_DB_NAME_LEN + \
613
   10)  // 60 byte for compress info, TSDB_COL_FNAME_LEN + TSDB_DB_NAME_LEN for column ref
614
    char type[LTYPE_LEN];
237,630✔
615
    snprintf(type, LTYPE_LEN, "%s", tDataTypes[pSchema->type].name);
237,630✔
616
    int typeLen = strlen(type);
237,630✔
617
    if (TSDB_DATA_TYPE_VARCHAR == pSchema->type || TSDB_DATA_TYPE_VARBINARY == pSchema->type ||
237,630✔
618
        TSDB_DATA_TYPE_GEOMETRY == pSchema->type) {
210,655✔
619
      typeLen += snprintf(type + typeLen, LTYPE_LEN - typeLen, "(%d)", (int32_t)(pSchema->bytes - VARSTR_HEADER_SIZE));
28,413✔
620
    } else if (TSDB_DATA_TYPE_NCHAR == pSchema->type) {
209,217✔
621
      typeLen += snprintf(type + typeLen, LTYPE_LEN - typeLen, "(%d)",
8,705✔
622
                          (int32_t)((pSchema->bytes - VARSTR_HEADER_SIZE) / TSDB_NCHAR_SIZE));
8,705✔
623
    } else if (IS_DECIMAL_TYPE(pSchema->type)) {
200,512✔
624
      uint8_t precision = 0, scale = 0;
22,216✔
625
      if (pCfg->pSchemaExt) {
22,216✔
626
        decimalFromTypeMod(pCfg->pSchemaExt[i].typeMod, &precision, &scale);
22,216✔
NEW
627
      } else if ((((uint32_t)pSchema->bytes) >> 24) != 0) {
×
NEW
628
        int32_t bytes = pSchema->bytes;
×
NEW
629
        extractDecimalTypeInfoFromBytes(&bytes, &precision, &scale);
×
630
      }
631
      typeLen += snprintf(type + typeLen, LTYPE_LEN - typeLen, "(%d,%d)", precision, scale);
22,216✔
632
    }
633

634
    if (tsShowFullCreateTableColumn && pCfg->pSchemaExt && pCfg->pSchemaExt[i].compress != 0) {
237,630✔
635
      typeLen += snprintf(type + typeLen, LTYPE_LEN - typeLen, " ENCODE \'%s\'",
23,468✔
636
                          columnEncodeStr(COMPRESS_L1_TYPE_U32(pCfg->pSchemaExt[i].compress)));
23,468✔
637
      typeLen += snprintf(type + typeLen, LTYPE_LEN - typeLen, " COMPRESS \'%s\'",
23,468✔
638
                          columnCompressStr(COMPRESS_L2_TYPE_U32(pCfg->pSchemaExt[i].compress)));
23,468✔
639
      typeLen += snprintf(type + typeLen, LTYPE_LEN - typeLen, " LEVEL \'%s\'",
23,468✔
640
                          columnLevelStr(COMPRESS_L2_TYPE_LEVEL_U32(pCfg->pSchemaExt[i].compress)));
23,468✔
641
    }
642

643
    if (hasRefCol(pCfg->tableType) && pRef && pRef->hasRef) {
237,630✔
644
      typeLen += snprintf(type + typeLen, LTYPE_LEN - typeLen, " FROM `%s`", pRef->refDbName);
26,546✔
645
      typeLen += snprintf(type + typeLen, LTYPE_LEN - typeLen, ".");
26,546✔
646
      typeLen +=
26,546✔
647
          snprintf(type + typeLen, LTYPE_LEN - typeLen, "`%s`", expandIdentifier(pRef->refTableName, expandName));
26,546✔
648
      typeLen += snprintf(type + typeLen, LTYPE_LEN - typeLen, ".");
26,546✔
649
      typeLen += snprintf(type + typeLen, LTYPE_LEN - typeLen, "`%s`", expandIdentifier(pRef->refColName, expandName));
26,546✔
650
    }
651

652
    if (!(pSchema->flags & COL_IS_KEY)) {
237,630✔
653
      *len += snprintf(buf + VARSTR_HEADER_SIZE + *len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + *len),
228,056✔
654
                       "%s`%s` %s", ((i > 0) ? ", " : ""), expandIdentifier(pSchema->name, expandName), type);
228,056✔
655
    } else {
656
      char* pk = "COMPOSITE KEY";
9,574✔
657
      *len += snprintf(buf + VARSTR_HEADER_SIZE + *len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + *len),
9,574✔
658
                       "%s`%s` %s %s", ((i > 0) ? ", " : ""), expandIdentifier(pSchema->name, expandName), type, pk);
9,574✔
659
    }
660
  }
661
}
46,362✔
662

663
static void appendColRefFields(char* buf, int32_t* len, STableCfg* pCfg) {
5,634✔
664
  char expandName[(SHOW_CREATE_TB_RESULT_FIELD1_LEN << 1) + 1] = {0};
5,634✔
665
  bool firstRef = true;
5,634✔
666
  for (int32_t i = 1; i < pCfg->numOfColumns; ++i) {
63,031✔
667
    SSchema* pSchema = pCfg->pSchemas + i;
57,397✔
668
    SColRef* pRef = pCfg->pColRefs + i;
57,397✔
669
    char     type[TSDB_COL_NAME_LEN + 10 + TSDB_COL_FNAME_LEN + TSDB_DB_NAME_LEN];
57,397✔
670
    int      typeLen = 0;
57,397✔
671

672
    if (hasRefCol(pCfg->tableType) && pCfg->pColRefs && pRef->hasRef) {
57,397✔
673
      typeLen += snprintf(type + typeLen, sizeof(type) - typeLen, "FROM `%s`", pRef->refDbName);
34,731✔
674
      typeLen += snprintf(type + typeLen, sizeof(type) - typeLen, ".");
34,731✔
675
      typeLen +=
34,731✔
676
          snprintf(type + typeLen, sizeof(type) - typeLen, "`%s`", expandIdentifier(pRef->refTableName, expandName));
34,731✔
677
      typeLen += snprintf(type + typeLen, sizeof(type) - typeLen, ".");
34,731✔
678
      typeLen +=
34,731✔
679
          snprintf(type + typeLen, sizeof(type) - typeLen, "`%s`", expandIdentifier(pRef->refColName, expandName));
34,731✔
680
    } else {
681
      continue;
22,666✔
682
    }
683

684
    *len += tsnprintf(buf + VARSTR_HEADER_SIZE + *len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + *len),
34,731✔
685
                      "%s`%s` %s", (!firstRef ? ", " : " ("), expandIdentifier(pSchema->name, expandName), type);
34,731✔
686
    firstRef = false;
34,731✔
687
  }
688
  if (!firstRef) {
5,634✔
689
    *len += tsnprintf(buf + VARSTR_HEADER_SIZE + *len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + *len), ")");
4,998✔
690
  }
691
}
5,634✔
692

693
static void appendTagFields(char* buf, int32_t* len, STableCfg* pCfg) {
28,134✔
694
  char expandName[(TSDB_COL_NAME_LEN << 1) + 1] = {0};
28,134✔
695
  for (int32_t i = 0; i < pCfg->numOfTags; ++i) {
81,929✔
696
    SSchema* pSchema = pCfg->pSchemas + pCfg->numOfColumns + i;
53,795✔
697
    char     type[32];
53,795✔
698
    snprintf(type, sizeof(type), "%s", tDataTypes[pSchema->type].name);
53,795✔
699
    if (TSDB_DATA_TYPE_VARCHAR == pSchema->type || TSDB_DATA_TYPE_VARBINARY == pSchema->type ||
53,795✔
700
        TSDB_DATA_TYPE_GEOMETRY == pSchema->type) {
43,913✔
701
      snprintf(type + strlen(type), sizeof(type) - strlen(type), "(%d)",
9,936✔
702
               (int32_t)(pSchema->bytes - VARSTR_HEADER_SIZE));
9,936✔
703
    } else if (TSDB_DATA_TYPE_NCHAR == pSchema->type) {
43,859✔
704
      snprintf(type + strlen(type), sizeof(type) - strlen(type), "(%d)",
1,499✔
705
               (int32_t)((pSchema->bytes - VARSTR_HEADER_SIZE) / TSDB_NCHAR_SIZE));
1,499✔
706
    }
707

708
    *len += snprintf(buf + VARSTR_HEADER_SIZE + *len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + *len),
53,795✔
709
                     "%s`%s` %s", ((i > 0) ? ", " : ""), expandIdentifier(pSchema->name, expandName), type);
53,795✔
710
  }
711
}
28,134✔
712

713
static void appendTagNameFields(char* buf, int32_t* len, STableCfg* pCfg) {
39,227✔
714
  char expandName[(TSDB_COL_NAME_LEN << 1) + 1] = {0};
39,227✔
715
  for (int32_t i = 0; i < pCfg->numOfTags; ++i) {
108,030✔
716
    SSchema* pSchema = pCfg->pSchemas + pCfg->numOfColumns + i;
68,803✔
717
    *len += snprintf(buf + VARSTR_HEADER_SIZE + *len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + *len),
68,803✔
718
                     "%s`%s`", ((i > 0) ? ", " : ""), expandIdentifier(pSchema->name, expandName));
68,803✔
719
  }
720
}
39,227✔
721

722
static int32_t appendTagValues(char* buf, int32_t* len, STableCfg* pCfg, void* charsetCxt) {
39,227✔
723
  int32_t code = TSDB_CODE_SUCCESS;
39,227✔
724
  SArray* pTagVals = NULL;
39,227✔
725
  STag*   pTag = (STag*)pCfg->pTags;
39,227✔
726

727
  if (NULL == pCfg->pTags || pCfg->numOfTags <= 0) {
39,227✔
728
    qError("tag missed in table cfg, pointer:%p, numOfTags:%d", pCfg->pTags, pCfg->numOfTags);
×
729
    return TSDB_CODE_APP_ERROR;
×
730
  }
731

732
  if (tTagIsJson(pTag)) {
39,227✔
733
    char* pJson = NULL;
2,490✔
734
    parseTagDatatoJson(pTag, &pJson, charsetCxt);
2,490✔
735
    if (NULL == pJson) {
2,490✔
736
      qError("failed to parse tag to json, pJson is NULL");
×
737
      return terrno;
×
738
    }
739
    char* escapedJson = taosMemCalloc(sizeof(char), strlen(pJson) * 2 + 1);  // taosMemoryAlloc(strlen(pJson) * 2 + 1);
2,490✔
740
    if (escapedJson) {
2,490✔
741
      char* writer = escapedJson;
2,490✔
742
      for (char* reader = pJson; *reader; ++reader) {
49,800✔
743
        if (*reader == '\'') {
47,310✔
744
          *writer++ = '\'';  // Escape single quote by doubling it
498✔
745
        }
746
        *writer++ = *reader;
47,310✔
747
      }
748
      *writer = '\0';
2,490✔
749

750
      *len += snprintf(buf + VARSTR_HEADER_SIZE + *len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + *len),
2,490✔
751
                       "'%s'", escapedJson);
752
      taosMemoryFree(escapedJson);
2,490✔
753
    } else {
754
      taosMemoryFree(pJson);
×
755
      return terrno;
×
756
    }
757
    taosMemoryFree(pJson);
2,490✔
758

759
    return TSDB_CODE_SUCCESS;
2,490✔
760
  }
761

762
  QRY_ERR_RET(tTagToValArray((const STag*)pCfg->pTags, &pTagVals));
36,737✔
763
  int16_t valueNum = taosArrayGetSize(pTagVals);
36,737✔
764
  int32_t num = 0;
36,737✔
765
  int32_t j = 0;
36,737✔
766
  for (int32_t i = 0; i < pCfg->numOfTags; ++i) {
103,050✔
767
    SSchema* pSchema = pCfg->pSchemas + pCfg->numOfColumns + i;
66,313✔
768
    if (i > 0) {
66,313✔
769
      *len += snprintf(buf + VARSTR_HEADER_SIZE + *len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + *len),
29,576✔
770
                       ", ");
771
    }
772

773
    if (pCfg->pTagRefs && i < pCfg->numOfTagRefs) {
66,313✔
774
      SColRef* pTagRef = pCfg->pTagRefs + i;
×
775
      if (pTagRef->hasRef) {
×
776
        char expandRefTable[(SHOW_CREATE_TB_RESULT_FIELD1_LEN << 1) + 1] = {0};
×
777
        char expandRefCol[(SHOW_CREATE_TB_RESULT_FIELD1_LEN << 1) + 1] = {0};
×
778
        *len += snprintf(buf + VARSTR_HEADER_SIZE + *len,
×
779
                         SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + *len),
×
780
                         "FROM `%s`.`%s`.`%s`", pTagRef->refDbName,
×
781
                         expandIdentifier(pTagRef->refTableName, expandRefTable),
×
782
                         expandIdentifier(pTagRef->refColName, expandRefCol));
×
783
        continue;
×
784
      }
785
    }
786

787
    if (j >= valueNum) {
66,313✔
788
      *len += snprintf(buf + VARSTR_HEADER_SIZE + *len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + *len),
16,049✔
789
                       "NULL");
790
      continue;
16,049✔
791
    }
792

793
    STagVal* pTagVal = (STagVal*)taosArrayGet(pTagVals, j);
50,264✔
794
    if (pSchema->colId > pTagVal->cid) {
50,264✔
795
      qError("tag value and column mismatch, schemaId:%d, valId:%d", pSchema->colId, pTagVal->cid);
×
796
      code = TSDB_CODE_APP_ERROR;
×
797
      TAOS_CHECK_ERRNO(code);
×
798
    } else if (pSchema->colId == pTagVal->cid) {
50,264✔
799
      char    type = pTagVal->type;
48,670✔
800
      int32_t tlen = 0;
48,670✔
801

802
      int64_t leftSize = SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + *len);
48,670✔
803
      if (leftSize <= 0) {
48,670✔
804
        qError("no enough space to store tag value, leftSize:%" PRId64, leftSize);
×
805
        code = TSDB_CODE_APP_ERROR;
×
806
        TAOS_CHECK_ERRNO(code);
×
807
      }
808
      if (IS_VAR_DATA_TYPE(type)) {
48,670✔
809
        code = dataConverToStr(buf + VARSTR_HEADER_SIZE + *len, leftSize, type, pTagVal->pData, pTagVal->nData, &tlen);
12,670✔
810
        TAOS_CHECK_ERRNO(code);
12,670✔
811
      } else {
812
        code = dataConverToStr(buf + VARSTR_HEADER_SIZE + *len, leftSize, type, &pTagVal->i64, tDataTypes[type].bytes,
36,000✔
813
                               &tlen);
814
        TAOS_CHECK_ERRNO(code);
36,000✔
815
      }
816
      *len += tlen;
48,670✔
817
      j++;
48,670✔
818
    } else {
819
      *len += snprintf(buf + VARSTR_HEADER_SIZE + *len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + *len),
1,594✔
820
                       "NULL");
821
    }
822
  }
823
_exit:
36,737✔
824
  taosArrayDestroy(pTagVals);
36,737✔
825

826
  return code;
36,737✔
827
}
828

829
static void appendTableOptions(char* buf, int32_t* len, SDbCfgInfo* pDbCfg, STableCfg* pCfg) {
75,627✔
830
  if (pCfg->commentLen > 0) {
75,627✔
831
    *len += snprintf(buf + VARSTR_HEADER_SIZE + *len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + *len),
×
832
                     " COMMENT '%s'", pCfg->pComment);
833
  } else if (0 == pCfg->commentLen) {
75,627✔
834
    *len += snprintf(buf + VARSTR_HEADER_SIZE + *len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + *len),
1,692✔
835
                     " COMMENT ''");
836
  }
837

838
  if (NULL != pDbCfg->pRetensions && pCfg->watermark1 > 0) {
75,627✔
839
    *len += snprintf(buf + VARSTR_HEADER_SIZE + *len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + *len),
×
840
                     " WATERMARK %" PRId64 "a", pCfg->watermark1);
841
    if (pCfg->watermark2 > 0) {
×
842
      *len += snprintf(buf + VARSTR_HEADER_SIZE + *len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + *len),
×
843
                       ", %" PRId64 "a", pCfg->watermark2);
844
    }
845
  }
846

847
  if (NULL != pDbCfg->pRetensions && pCfg->delay1 > 0) {
75,627✔
848
    *len += snprintf(buf + VARSTR_HEADER_SIZE + *len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + *len),
×
849
                     " MAX_DELAY %" PRId64 "a", pCfg->delay1);
850
    if (pCfg->delay2 > 0) {
×
851
      *len += snprintf(buf + VARSTR_HEADER_SIZE + *len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + *len),
×
852
                       ", %" PRId64 "a", pCfg->delay2);
853
    }
854
  }
855

856
  int32_t funcNum = taosArrayGetSize(pCfg->pFuncs);
75,627✔
857
  if (NULL != pDbCfg->pRetensions && funcNum > 0) {
75,627✔
858
    *len += snprintf(buf + VARSTR_HEADER_SIZE + *len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + *len),
×
859
                     " ROLLUP(");
860
    for (int32_t i = 0; i < funcNum; ++i) {
×
861
      char* pFunc = taosArrayGet(pCfg->pFuncs, i);
×
862
      *len += snprintf(buf + VARSTR_HEADER_SIZE + *len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + *len),
×
863
                       "%s%s", ((i > 0) ? ", " : ""), pFunc);
864
    }
865
    *len +=
×
866
        snprintf(buf + VARSTR_HEADER_SIZE + *len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + *len), ")");
×
867
  }
868

869
  if (pCfg->ttl > 0) {
75,627✔
870
    *len += snprintf(buf + VARSTR_HEADER_SIZE + *len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + *len),
×
871
                     " TTL %d", pCfg->ttl);
872
  }
873

874
  if (pCfg->keep > 0) {
75,627✔
875
    *len += snprintf(buf + VARSTR_HEADER_SIZE + *len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + *len),
2,760✔
876
                     " KEEP %dm", pCfg->keep);
877
  }
878

879
  if (TSDB_SUPER_TABLE == pCfg->tableType || TSDB_NORMAL_TABLE == pCfg->tableType) {
75,627✔
880
    int32_t nSma = 0;
42,034✔
881
    for (int32_t i = 0; i < pCfg->numOfColumns; ++i) {
229,449✔
882
      if (IS_BSMA_ON(pCfg->pSchemas + i)) {
187,415✔
883
        ++nSma;
187,415✔
884
      }
885
    }
886

887
    if (nSma < pCfg->numOfColumns && nSma > 0) {
42,034✔
888
      bool smaOn = false;
×
889
      *len += snprintf(buf + VARSTR_HEADER_SIZE + *len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + *len),
×
890
                       " SMA(");
891
      for (int32_t i = 0; i < pCfg->numOfColumns; ++i) {
×
892
        if (IS_BSMA_ON(pCfg->pSchemas + i)) {
×
893
          if (smaOn) {
×
894
            *len += snprintf(buf + VARSTR_HEADER_SIZE + *len,
×
895
                             SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + *len), ",`%s`",
×
896
                             (pCfg->pSchemas + i)->name);
×
897
          } else {
898
            smaOn = true;
×
899
            *len += snprintf(buf + VARSTR_HEADER_SIZE + *len,
×
900
                             SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + *len), "`%s`",
×
901
                             (pCfg->pSchemas + i)->name);
×
902
          }
903
        }
904
      }
905
      *len += snprintf(buf + VARSTR_HEADER_SIZE + *len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - VARSTR_HEADER_SIZE, ")");
×
906
    }
907
  }
908

909
  if (pCfg->virtualStb) {
75,627✔
910
    *len += snprintf(buf + VARSTR_HEADER_SIZE + *len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + *len),
3,691✔
911
                     " VIRTUAL %d", pCfg->virtualStb);
3,691✔
912
  }
913

914
  if (TSDB_SUPER_TABLE == pCfg->tableType) {
75,627✔
915
    *len += tsnprintf(buf + VARSTR_HEADER_SIZE + *len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + *len),
28,134✔
916
                      " SECURE_DELETE %d", pCfg->secureDelete);
28,134✔
917
  }
918
}
75,627✔
919

920
static int32_t setCreateTBResultIntoDataBlock(SSDataBlock* pBlock, SDbCfgInfo* pDbCfg, char* tbName, STableCfg* pCfg,
91,169✔
921
                                              void* charsetCxt) {
922
  int32_t code = TSDB_CODE_SUCCESS;
91,169✔
923
  QRY_ERR_RET(blockDataEnsureCapacity(pBlock, 1));
91,169✔
924
  pBlock->info.rows = 1;
91,169✔
925

926
  SColumnInfoData* pCol1 = taosArrayGet(pBlock->pDataBlock, 0);
91,169✔
927
  char             buf1[(SHOW_CREATE_TB_RESULT_FIELD1_LEN << 1)] = {0};
91,169✔
928
  STR_TO_VARSTR(buf1, tbName);
91,169✔
929
  QRY_ERR_RET(colDataSetVal(pCol1, 0, buf1, false));
91,169✔
930

931
  SColumnInfoData* pCol2 = taosArrayGet(pBlock->pDataBlock, 1);
91,169✔
932
  char*            buf2 = taosMemoryMalloc(SHOW_CREATE_TB_RESULT_FIELD2_LEN);
91,169✔
933
  if (NULL == buf2) {
91,169✔
934
    QRY_ERR_RET(terrno);
×
935
  }
936

937
  int32_t len = 0;
91,169✔
938

939
  if (TSDB_SUPER_TABLE == pCfg->tableType) {
91,169✔
940
    len += snprintf(buf2 + VARSTR_HEADER_SIZE, SHOW_CREATE_TB_RESULT_FIELD2_LEN - VARSTR_HEADER_SIZE,
28,134✔
941
                    "CREATE STABLE `%s` (", expandIdentifier(tbName, buf1));
942
    appendColumnFields(buf2, &len, pCfg);
28,134✔
943
    len += snprintf(buf2 + VARSTR_HEADER_SIZE + len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + len),
28,134✔
944
                    ") TAGS (");
945
    appendTagFields(buf2, &len, pCfg);
28,134✔
946
    len +=
28,134✔
947
        snprintf(buf2 + VARSTR_HEADER_SIZE + len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + len), ")");
28,134✔
948
    appendTableOptions(buf2, &len, pDbCfg, pCfg);
28,134✔
949
  } else if (TSDB_CHILD_TABLE == pCfg->tableType) {
63,035✔
950
    len += snprintf(buf2 + VARSTR_HEADER_SIZE, SHOW_CREATE_TB_RESULT_FIELD2_LEN - VARSTR_HEADER_SIZE,
33,593✔
951
                    "CREATE TABLE `%s` ", expandIdentifier(tbName, buf1));
952
    len += snprintf(buf2 + VARSTR_HEADER_SIZE + len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + len),
33,593✔
953
                    "USING `%s` (", expandIdentifier(pCfg->stbName, buf1));
33,593✔
954
    appendTagNameFields(buf2, &len, pCfg);
33,593✔
955
    len += snprintf(buf2 + VARSTR_HEADER_SIZE + len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + len),
33,593✔
956
                    ") TAGS (");
957
    code = appendTagValues(buf2, &len, pCfg, charsetCxt);
33,593✔
958
    TAOS_CHECK_ERRNO(code);
33,593✔
959
    len +=
33,593✔
960
        snprintf(buf2 + VARSTR_HEADER_SIZE + len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + len), ")");
33,593✔
961
    appendTableOptions(buf2, &len, pDbCfg, pCfg);
33,593✔
962
  } else if (TSDB_NORMAL_TABLE == pCfg->tableType) {
29,442✔
963
    len += snprintf(buf2 + VARSTR_HEADER_SIZE, SHOW_CREATE_TB_RESULT_FIELD2_LEN - VARSTR_HEADER_SIZE,
13,900✔
964
                    "CREATE TABLE `%s` (", expandIdentifier(tbName, buf1));
965
    appendColumnFields(buf2, &len, pCfg);
13,900✔
966
    len +=
13,900✔
967
        snprintf(buf2 + VARSTR_HEADER_SIZE + len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + len), ")");
13,900✔
968
    appendTableOptions(buf2, &len, pDbCfg, pCfg);
13,900✔
969
  } else if (TSDB_VIRTUAL_NORMAL_TABLE == pCfg->tableType) {
15,542✔
970
    len += snprintf(buf2 + VARSTR_HEADER_SIZE, SHOW_CREATE_TB_RESULT_FIELD2_LEN - VARSTR_HEADER_SIZE,
4,328✔
971
                    "CREATE VTABLE `%s` (", expandIdentifier(tbName, buf1));
972
    appendColumnFields(buf2, &len, pCfg);
4,328✔
973
    len +=
4,328✔
974
        snprintf(buf2 + VARSTR_HEADER_SIZE + len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + len), ")");
4,328✔
975
  } else if (TSDB_VIRTUAL_CHILD_TABLE == pCfg->tableType) {
11,214✔
976
    len += tsnprintf(buf2 + VARSTR_HEADER_SIZE, SHOW_CREATE_TB_RESULT_FIELD2_LEN - VARSTR_HEADER_SIZE,
5,634✔
977
                     "CREATE VTABLE `%s`", expandIdentifier(tbName, buf1));
978
    appendColRefFields(buf2, &len, pCfg);
5,634✔
979
    len += snprintf(buf2 + VARSTR_HEADER_SIZE + len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + len),
5,634✔
980
                    " USING `%s` (", expandIdentifier(pCfg->stbName, buf1));
5,634✔
981
    appendTagNameFields(buf2, &len, pCfg);
5,634✔
982
    len += snprintf(buf2 + VARSTR_HEADER_SIZE + len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + len),
5,634✔
983
                    ") TAGS (");
984
    code = appendTagValues(buf2, &len, pCfg, charsetCxt);
5,634✔
985
    TAOS_CHECK_ERRNO(code);
5,634✔
986
    len +=
5,634✔
987
        snprintf(buf2 + VARSTR_HEADER_SIZE + len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + len), ")");
5,634✔
988
  }
989

990
  varDataLen(buf2) = (len > 65535) ? 65535 : len;
91,169✔
991

992
  code = colDataSetVal(pCol2, 0, buf2, false);
91,169✔
993
  TAOS_CHECK_ERRNO(code);
91,169✔
994

995
_exit:
91,169✔
996
  taosMemoryFree(buf2);
91,169✔
997

998
  return code;
91,169✔
999
}
1000

1001
static int32_t setCreateViewResultIntoDataBlock(SSDataBlock* pBlock, SShowCreateViewStmt* pStmt) {
6,729✔
1002
  int32_t code = 0;
6,729✔
1003
  QRY_ERR_RET(blockDataEnsureCapacity(pBlock, 1));
6,729✔
1004
  pBlock->info.rows = 1;
6,729✔
1005

1006
  SColumnInfoData* pCol1 = taosArrayGet(pBlock->pDataBlock, 0);
6,729✔
1007
  char             buf1[SHOW_CREATE_VIEW_RESULT_FIELD1_LEN + 1] = {0};
6,729✔
1008
  snprintf(varDataVal(buf1), TSDB_VIEW_FNAME_LEN + 4, "`%s`.`%s`", pStmt->dbName, pStmt->viewName);
6,729✔
1009
  varDataSetLen(buf1, strlen(varDataVal(buf1)));
6,729✔
1010
  QRY_ERR_RET(colDataSetVal(pCol1, 0, buf1, false));
6,729✔
1011

1012
  SColumnInfoData* pCol2 = taosArrayGet(pBlock->pDataBlock, 1);
6,729✔
1013
  char*            buf2 = taosMemoryMalloc(SHOW_CREATE_VIEW_RESULT_FIELD2_LEN);
6,729✔
1014
  if (NULL == buf2) {
6,729✔
1015
    return terrno;
×
1016
  }
1017

1018
  SViewMeta* pMeta = pStmt->pViewMeta;
6,729✔
1019
  if (NULL == pMeta) {
6,729✔
1020
    qError("exception: view meta is null");
×
1021
    taosMemoryFree(buf2);
×
1022
    return TSDB_CODE_APP_ERROR;
×
1023
  }
1024
  snprintf(varDataVal(buf2), SHOW_CREATE_VIEW_RESULT_FIELD2_LEN - VARSTR_HEADER_SIZE, "CREATE VIEW `%s`.`%s` AS %s",
6,729✔
1025
           pStmt->dbName, pStmt->viewName, pMeta->querySql);
6,729✔
1026
  int32_t len = strlen(varDataVal(buf2));
6,729✔
1027
  varDataLen(buf2) = (len > 65535) ? 65535 : len;
6,729✔
1028
  code = colDataSetVal(pCol2, 0, buf2, false);
6,729✔
1029
  taosMemoryFree(buf2);
6,729✔
1030

1031
  return code;
6,729✔
1032
}
1033

1034
extern const char* fmGetFuncName(int32_t funcId);
1035
static int32_t setCreateRsmaResultIntoDataBlock(SSDataBlock* pBlock, SShowCreateRsmaStmt* pStmt) {
1,961✔
1036
  int32_t       code = 0, lino = 0;
1,961✔
1037
  char*         buf2 = NULL;
1,961✔
1038
  SRsmaInfoRsp* pMeta = pStmt->pRsmaMeta;
1,961✔
1039

1040
  if (pMeta->nFuncs != pMeta->nColNames) {
1,961✔
1041
    qError("exception: rsma meta is invalid, nFuncs:%d != nColNames:%d", pMeta->nFuncs, pMeta->nColNames);
×
1042
    return TSDB_CODE_APP_ERROR;
×
1043
  }
1044

1045
  TAOS_CHECK_EXIT(blockDataEnsureCapacity(pBlock, 1));
1,961✔
1046
  pBlock->info.rows = 1;
1,961✔
1047

1048
  SColumnInfoData* pCol1 = taosArrayGet(pBlock->pDataBlock, 0);
1,961✔
1049
  char             buf1[SHOW_CREATE_TB_RESULT_FIELD1_LEN << 1] = {0};
1,961✔
1050
  snprintf(varDataVal(buf1), TSDB_TABLE_FNAME_LEN + 4, "`%s`", expandIdentifier(pStmt->rsmaName, buf1));
1,961✔
1051
  varDataSetLen(buf1, strlen(varDataVal(buf1)));
1,961✔
1052
  TAOS_CHECK_EXIT(colDataSetVal(pCol1, 0, buf1, false));
1,961✔
1053

1054
  SColumnInfoData* pCol2 = taosArrayGet(pBlock->pDataBlock, 1);
1,961✔
1055
  if (!(buf2 = taosMemoryMalloc(SHOW_CREATE_TB_RESULT_FIELD2_LEN))) {
1,961✔
1056
    return terrno;
×
1057
  }
1058

1059
  SName name = {0};
1,961✔
1060
  TAOS_CHECK_EXIT(tNameFromString(&name, pMeta->tbFName, T_NAME_ACCT | T_NAME_DB | T_NAME_TABLE));
1,961✔
1061

1062
  int32_t len = 0;
1,961✔
1063
  len += tsnprintf(varDataVal(buf2), SHOW_CREATE_TB_RESULT_FIELD2_LEN - VARSTR_HEADER_SIZE,
3,922✔
1064
                       "CREATE RSMA `%s` ON `%s`.`%s` FUNCTION(", expandIdentifier(pStmt->rsmaName, buf1),
1,961✔
1065
                       expandIdentifier(name.dbname, buf1), expandIdentifier(name.tname, buf1));
1066
  for (int32_t i = 0; i < pMeta->nFuncs; ++i) {
13,227✔
1067
    len += tsnprintf(varDataVal(buf2) + len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + len),
22,532✔
1068
                         "%s%s(`%s`)", (i > 0) ? "," : "", fmGetFuncName(pMeta->funcIds[i]),
11,266✔
1069
                         expandIdentifier(*(char**)TARRAY_GET_ELEM(pMeta->colNames, i), buf1));
11,266✔
1070
  }
1071
  len += tsnprintf(varDataVal(buf2) + len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + len),
1,961✔
1072
                       ") INTERVAL(%d%c", pMeta->interval[0], pMeta->intervalUnit);
1,961✔
1073
  if (pMeta->interval[1] > 0) {
1,961✔
1074
    len += tsnprintf(varDataVal(buf2) + len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + len), ",%d%c",
1,961✔
1075
                         pMeta->interval[1], pMeta->intervalUnit);
1,961✔
1076
  }
1077
  len += tsnprintf(varDataVal(buf2) + len, SHOW_CREATE_TB_RESULT_FIELD2_LEN - (VARSTR_HEADER_SIZE + len), ")");
1,961✔
1078
  varDataLen(buf2) = len;
1,961✔
1079
  code = colDataSetVal(pCol2, 0, buf2, false);
1,961✔
1080
_exit:
1,961✔
1081
  taosMemoryFree(buf2);
1,961✔
1082
  return code;
1,961✔
1083
}
1084

1085
static int32_t execShowCreateTable(SShowCreateTableStmt* pStmt, SRetrieveTableRsp** pRsp, void* charsetCxt) {
81,871✔
1086
  SSDataBlock* pBlock = NULL;
81,871✔
1087
  int32_t      code = buildCreateTbResultDataBlock(&pBlock);
81,871✔
1088
  if (TSDB_CODE_SUCCESS == code) {
81,871✔
1089
    code = setCreateTBResultIntoDataBlock(pBlock, pStmt->pDbCfg, pStmt->tableName, pStmt->pTableCfg, charsetCxt);
81,871✔
1090
  }
1091
  if (TSDB_CODE_SUCCESS == code) {
81,871✔
1092
    code = buildRetrieveTableRsp(pBlock, SHOW_CREATE_TB_RESULT_COLS, pRsp);
81,871✔
1093
  }
1094
  (void)blockDataDestroy(pBlock);
81,871✔
1095
  return code;
81,871✔
1096
}
1097

1098
static int32_t execShowCreateVTable(SShowCreateTableStmt* pStmt, SRetrieveTableRsp** pRsp, void* charsetCxt) {
9,298✔
1099
  SSDataBlock* pBlock = NULL;
9,298✔
1100
  int32_t      code = buildCreateTbResultDataBlock(&pBlock);
9,298✔
1101
  if (TSDB_CODE_SUCCESS == code) {
9,298✔
1102
    code = setCreateTBResultIntoDataBlock(pBlock, pStmt->pDbCfg, pStmt->tableName, pStmt->pTableCfg, charsetCxt);
9,298✔
1103
  }
1104
  if (TSDB_CODE_SUCCESS == code) {
9,298✔
1105
    code = buildRetrieveTableRsp(pBlock, SHOW_CREATE_TB_RESULT_COLS, pRsp);
9,298✔
1106
  }
1107
  (void)blockDataDestroy(pBlock);
9,298✔
1108
  return code;
9,298✔
1109
}
1110

1111
static int32_t execShowCreateSTable(SShowCreateTableStmt* pStmt, SRetrieveTableRsp** pRsp, void* charsetCxt) {
3,084✔
1112
  STableCfg* pCfg = (STableCfg*)pStmt->pTableCfg;
3,084✔
1113
  if (TSDB_SUPER_TABLE != pCfg->tableType) {
3,084✔
1114
    terrno = TSDB_CODE_TSC_NOT_STABLE_ERROR;
186✔
1115
    return terrno;
186✔
1116
  }
1117

1118
  return execShowCreateTable(pStmt, pRsp, charsetCxt);
2,898✔
1119
}
1120

1121
static int32_t execAlterCmd(char* cmd, char* value, bool* processed) {
485,863✔
1122
  int32_t code = 0;
485,863✔
1123

1124
  if (0 == strcasecmp(cmd, COMMAND_RESET_LOG)) {
485,863✔
1125
    taosResetLog();
43✔
1126
    cfgDumpCfg(tsCfg, 0, false);
43✔
1127
  } else if (0 == strcasecmp(cmd, COMMAND_SCHEDULE_POLICY)) {
485,820✔
1128
    int32_t tmp = 0;
2,668✔
1129
    code = taosStr2int32(value, &tmp);
2,668✔
1130
    if (code) {
2,668✔
1131
      qError("invalid value:%s, error:%s", value, tstrerror(code));
×
1132
      return code;
×
1133
    }
1134
    code = schedulerUpdatePolicy(tmp);
2,668✔
1135
  } else if (0 == strcasecmp(cmd, COMMAND_ENABLE_RESCHEDULE)) {
483,152✔
1136
    int32_t tmp = 0;
×
1137
    code = taosStr2int32(value, &tmp);
×
1138
    if (code) {
×
1139
      qError("invalid value:%s, error:%s", value, tstrerror(code));
×
1140
      return code;
×
1141
    }
1142
    code = schedulerEnableReSchedule(tmp != 0);
×
1143
  } else if (0 == strcasecmp(cmd, COMMAND_CATALOG_DEBUG)) {
483,152✔
1144
    code = ctgdHandleDbgCommand(value);
×
1145
  } else if (0 == strcasecmp(cmd, COMMAND_ENABLE_MEM_DEBUG)) {
483,152✔
1146
    code = taosMemoryDbgInit();
×
1147
    if (code) {
×
1148
      qError("failed to init memory dbg, error:%s", tstrerror(code));
×
1149
      return code;
×
1150
    }
1151
    tsAsyncLog = false;
×
1152
    qInfo("memory dbg enabled");
×
1153
  } else if (0 == strcasecmp(cmd, COMMAND_DISABLE_MEM_DEBUG)) {
483,152✔
1154
    code = taosMemoryDbgInitRestore();
×
1155
    if (code) {
×
1156
      qError("failed to restore from memory dbg, error:%s", tstrerror(code));
×
1157
      return code;
×
1158
    }
1159
    qInfo("memory dbg disabled");
×
1160
  } else {
1161
    goto _return;
483,152✔
1162
  }
1163

1164
  *processed = true;
2,711✔
1165

1166
_return:
485,863✔
1167

1168
  if (code) {
485,863✔
1169
    terrno = code;
×
1170
  }
1171

1172
  return code;
485,863✔
1173
}
1174

1175
static int32_t execAlterLocal(SAlterLocalStmt* pStmt) {
485,863✔
1176
  bool processed = false;
485,863✔
1177

1178
  if (execAlterCmd(pStmt->config, pStmt->value, &processed)) {
485,863✔
1179
    return terrno;
×
1180
  }
1181

1182
  if (processed) {
485,863✔
1183
    goto _return;
2,711✔
1184
  }
1185

1186
  if (cfgCheckRangeForDynUpdate(tsCfg, pStmt->config, pStmt->value, false, CFG_ALTER_LOCAL)) {
483,152✔
1187
    return terrno;
1,641✔
1188
  }
1189

1190
  if (cfgSetItem(tsCfg, pStmt->config, pStmt->value, CFG_STYPE_ALTER_CLIENT_CMD, true)) {
481,511✔
1191
    return terrno;
×
1192
  }
1193

1194
  TAOS_CHECK_RETURN(taosCfgDynamicOptions(tsCfg, pStmt->config, false));
481,511✔
1195

1196
_return:
484,222✔
1197

1198
  return TSDB_CODE_SUCCESS;
484,222✔
1199
}
1200

1201
static int32_t buildLocalVariablesResultDataBlock(SSDataBlock** pOutput) {
14,442✔
1202
  SSDataBlock* pBlock = taosMemoryCalloc(1, sizeof(SSDataBlock));
14,442✔
1203
  if (NULL == pBlock) {
14,442✔
1204
    return terrno;
×
1205
  }
1206

1207
  pBlock->info.hasVarCol = true;
14,442✔
1208

1209
  pBlock->pDataBlock = taosArrayInit(SHOW_LOCAL_VARIABLES_RESULT_COLS, sizeof(SColumnInfoData));
14,442✔
1210
  if (NULL == pBlock->pDataBlock) {
14,442✔
1211
    taosMemoryFree(pBlock);
×
1212
    return terrno;
×
1213
  }
1214

1215
  SColumnInfoData infoData = {0};
14,442✔
1216

1217
  infoData.info.type = TSDB_DATA_TYPE_VARCHAR;
14,442✔
1218
  infoData.info.bytes = SHOW_LOCAL_VARIABLES_RESULT_FIELD1_LEN;
14,442✔
1219
  if (taosArrayPush(pBlock->pDataBlock, &infoData) == NULL) {
28,884✔
1220
    goto _exit;
×
1221
  }
1222

1223
  infoData.info.type = TSDB_DATA_TYPE_VARCHAR;
14,442✔
1224
  infoData.info.bytes = SHOW_LOCAL_VARIABLES_RESULT_FIELD2_LEN;
14,442✔
1225
  if (taosArrayPush(pBlock->pDataBlock, &infoData) == NULL) {
28,884✔
1226
    goto _exit;
×
1227
  }
1228

1229
  infoData.info.type = TSDB_DATA_TYPE_VARCHAR;
14,442✔
1230
  infoData.info.bytes = SHOW_LOCAL_VARIABLES_RESULT_FIELD3_LEN;
14,442✔
1231
  if (taosArrayPush(pBlock->pDataBlock, &infoData) == NULL) {
28,884✔
1232
    goto _exit;
×
1233
  }
1234

1235
  infoData.info.type = TSDB_DATA_TYPE_VARCHAR;
14,442✔
1236
  infoData.info.bytes = SHOW_LOCAL_VARIABLES_RESULT_FIELD4_LEN;
14,442✔
1237
  if (taosArrayPush(pBlock->pDataBlock, &infoData) == NULL) {
28,884✔
1238
    goto _exit;
×
1239
  }
1240

1241
  infoData.info.type = TSDB_DATA_TYPE_VARCHAR;
14,442✔
1242
  infoData.info.bytes = SHOW_LOCAL_VARIABLES_RESULT_FIELD5_LEN;
14,442✔
1243
  if (taosArrayPush(pBlock->pDataBlock, &infoData) == NULL) {
28,884✔
1244
    goto _exit;
×
1245
  }
1246

1247
  *pOutput = pBlock;
14,442✔
1248

1249
_exit:
14,442✔
1250
  if (terrno != TSDB_CODE_SUCCESS) {
14,442✔
1251
    taosArrayDestroy(pBlock->pDataBlock);
×
1252
    taosMemoryFree(pBlock);
×
1253
  }
1254
  return terrno;
14,442✔
1255
}
1256

1257
static int32_t execShowLocalVariables(SShowStmt* pStmt, SRetrieveTableRsp** pRsp) {
14,442✔
1258
  SSDataBlock* pBlock = NULL;
14,442✔
1259
  char*        likePattern = NULL;
14,442✔
1260
  int32_t      code = buildLocalVariablesResultDataBlock(&pBlock);
14,442✔
1261
  if (TSDB_CODE_SUCCESS == code) {
14,442✔
1262
    if (pStmt->tableCondType == OP_TYPE_LIKE) {
14,442✔
1263
      likePattern = ((SValueNode*)pStmt->pTbName)->literal;
2,893✔
1264
    }
1265
  }
1266
  if (TSDB_CODE_SUCCESS == code) {
14,442✔
1267
    code = dumpConfToDataBlock(pBlock, 0, likePattern);
14,442✔
1268
  }
1269
  if (TSDB_CODE_SUCCESS == code) {
14,442✔
1270
    code = buildRetrieveTableRsp(pBlock, SHOW_LOCAL_VARIABLES_RESULT_COLS, pRsp);
14,442✔
1271
  }
1272
  (void)blockDataDestroy(pBlock);
14,442✔
1273
  return code;
14,442✔
1274
}
1275

1276
static int32_t createSelectResultDataBlock(SNodeList* pProjects, SSDataBlock** pOutput) {
2,696,483✔
1277
  QRY_PARAM_CHECK(pOutput);
2,696,483✔
1278

1279
  SSDataBlock* pBlock = NULL;
2,696,483✔
1280
  int32_t      code = createDataBlock(&pBlock);
2,696,483✔
1281
  if (code) {
2,696,483✔
1282
    return code;
×
1283
  }
1284

1285
  SNode* pProj = NULL;
2,696,483✔
1286
  FOREACH(pProj, pProjects) {
6,836,871✔
1287
    SExprNode*      pExpr = (SExprNode*)pProj;
4,140,388✔
1288
    SColumnInfoData infoData = {0};
4,140,388✔
1289
    if (TSDB_DATA_TYPE_NULL == pExpr->resType.type) {
4,140,388✔
1290
      infoData.info.type = TSDB_DATA_TYPE_VARCHAR;
×
1291
      infoData.info.bytes = 0;
×
1292
    } else {
1293
      infoData.info.type = pExpr->resType.type;
4,140,388✔
1294
      infoData.info.bytes = pExpr->resType.bytes;
4,140,388✔
1295
      infoData.info.precision = pExpr->resType.precision;
4,140,388✔
1296
      infoData.info.scale = pExpr->resType.scale;
4,140,388✔
1297
    }
1298
    QRY_ERR_RET(blockDataAppendColInfo(pBlock, &infoData));
4,140,388✔
1299
  }
1300

1301
  *pOutput = pBlock;
2,696,483✔
1302
  return code;
2,696,483✔
1303
}
1304

1305
static int32_t buildSelectResultDataBlock(SNodeList* pProjects, SSDataBlock* pBlock) {
2,696,483✔
1306
  QRY_ERR_RET(blockDataEnsureCapacity(pBlock, 1));
2,696,483✔
1307

1308
  int32_t index = 0;
2,696,483✔
1309
  SNode*  pProj = NULL;
2,696,483✔
1310
  FOREACH(pProj, pProjects) {
6,836,871✔
1311
    if (QUERY_NODE_VALUE != nodeType(pProj)) {
4,140,388✔
1312
      return TSDB_CODE_PAR_INVALID_SELECTED_EXPR;
×
1313
    } else {
1314
      if (((SValueNode*)pProj)->isNull) {
4,140,388✔
1315
        QRY_ERR_RET(colDataSetVal(taosArrayGet(pBlock->pDataBlock, index++), 0, NULL, true));
87,958✔
1316
      } else {
1317
        QRY_ERR_RET(colDataSetVal(taosArrayGet(pBlock->pDataBlock, index++), 0,
4,052,430✔
1318
                                  nodesGetValueFromNode((SValueNode*)pProj), false));
1319
      }
1320
    }
1321
  }
1322

1323
  pBlock->info.rows = 1;
2,696,483✔
1324
  return TSDB_CODE_SUCCESS;
2,696,483✔
1325
}
1326

1327
static int32_t execSelectWithoutFrom(SSelectStmt* pSelect, SRetrieveTableRsp** pRsp) {
2,696,483✔
1328
  SSDataBlock* pBlock = NULL;
2,696,483✔
1329
  int32_t      code = createSelectResultDataBlock(pSelect->pProjectionList, &pBlock);
2,696,483✔
1330
  if (TSDB_CODE_SUCCESS == code) {
2,696,483✔
1331
    code = buildSelectResultDataBlock(pSelect->pProjectionList, pBlock);
2,696,483✔
1332
  }
1333
  if (TSDB_CODE_SUCCESS == code) {
2,696,483✔
1334
    code = buildRetrieveTableRsp(pBlock, LIST_LENGTH(pSelect->pProjectionList), pRsp);
2,696,483✔
1335
  }
1336
  (void)blockDataDestroy(pBlock);
2,696,483✔
1337
  return code;
2,696,483✔
1338
}
1339

1340
static int32_t execShowCreateView(SShowCreateViewStmt* pStmt, SRetrieveTableRsp** pRsp) {
6,729✔
1341
  SSDataBlock* pBlock = NULL;
6,729✔
1342
  int32_t      code = buildCreateViewResultDataBlock(&pBlock);
6,729✔
1343
  if (TSDB_CODE_SUCCESS == code) {
6,729✔
1344
    code = setCreateViewResultIntoDataBlock(pBlock, pStmt);
6,729✔
1345
  }
1346
  if (TSDB_CODE_SUCCESS == code) {
6,729✔
1347
    code = buildRetrieveTableRsp(pBlock, SHOW_CREATE_VIEW_RESULT_COLS, pRsp);
6,729✔
1348
  }
1349
  (void)blockDataDestroy(pBlock);
6,729✔
1350
  return code;
6,729✔
1351
}
1352

1353
static int32_t execShowCreateRsma(SShowCreateRsmaStmt* pStmt, SRetrieveTableRsp** pRsp) {
1,961✔
1354
  SSDataBlock* pBlock = NULL;
1,961✔
1355
  int32_t      code = buildCreateTbResultDataBlock(&pBlock);
1,961✔
1356
  if (TSDB_CODE_SUCCESS == code) {
1,961✔
1357
    code = setCreateRsmaResultIntoDataBlock(pBlock, pStmt);
1,961✔
1358
  }
1359
  if (TSDB_CODE_SUCCESS == code) {
1,961✔
1360
    code = buildRetrieveTableRsp(pBlock, SHOW_CREATE_TB_RESULT_COLS, pRsp);
1,961✔
1361
  }
1362
  (void)blockDataDestroy(pBlock);
1,961✔
1363
  return code;
1,961✔
1364
}
1365

1366
int32_t qExecCommand(int64_t* pConnId, bool sysInfoUser, SNode* pStmt, SRetrieveTableRsp** pRsp, int8_t biMode,
5,982,938✔
1367
                     void* charsetCxt) {
1368
  switch (nodeType(pStmt)) {
5,982,938✔
1369
    case QUERY_NODE_DESCRIBE_STMT:
445,360✔
1370
      return execDescribe(sysInfoUser, pStmt, pRsp, biMode);
445,360✔
1371
    case QUERY_NODE_RESET_QUERY_CACHE_STMT:
2,167,670✔
1372
      return execResetQueryCache();
2,167,670✔
1373
    case QUERY_NODE_SHOW_CREATE_DATABASE_STMT:
73,075✔
1374
      return execShowCreateDatabase((SShowCreateDatabaseStmt*)pStmt, pRsp);
73,075✔
1375
    case QUERY_NODE_SHOW_CREATE_TABLE_STMT:
78,973✔
1376
      return execShowCreateTable((SShowCreateTableStmt*)pStmt, pRsp, charsetCxt);
78,973✔
1377
    case QUERY_NODE_SHOW_CREATE_VTABLE_STMT:
9,298✔
1378
      return execShowCreateVTable((SShowCreateTableStmt*)pStmt, pRsp, charsetCxt);
9,298✔
1379
    case QUERY_NODE_SHOW_CREATE_STABLE_STMT:
3,084✔
1380
      return execShowCreateSTable((SShowCreateTableStmt*)pStmt, pRsp, charsetCxt);
3,084✔
1381
    case QUERY_NODE_SHOW_CREATE_VIEW_STMT:
6,729✔
1382
      return execShowCreateView((SShowCreateViewStmt*)pStmt, pRsp);
6,729✔
1383
    case QUERY_NODE_SHOW_CREATE_RSMA_STMT:
1,961✔
1384
      return execShowCreateRsma((SShowCreateRsmaStmt*)pStmt, pRsp);
1,961✔
1385
    case QUERY_NODE_ALTER_LOCAL_STMT:
485,863✔
1386
      return execAlterLocal((SAlterLocalStmt*)pStmt);
485,863✔
1387
    case QUERY_NODE_SHOW_LOCAL_VARIABLES_STMT:
14,442✔
1388
      return execShowLocalVariables((SShowStmt*)pStmt, pRsp);
14,442✔
1389
    case QUERY_NODE_SELECT_STMT:
2,696,483✔
1390
      return execSelectWithoutFrom((SSelectStmt*)pStmt, pRsp);
2,696,483✔
1391
    default:
×
1392
      break;
×
1393
  }
1394
  return TSDB_CODE_FAILED;
×
1395
}
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