parTokenizer.c 20.7 KB
Newer Older
H
hzcheng 已提交
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
/*
 * Copyright (c) 2019 TAOS Data, Inc. <jhtao@taosdata.com>
 *
 * This program is free software: you can use, redistribute, and/or modify
 * it under the terms of the GNU Affero General Public License, version 3
 * or later ("AGPL"), as published by the Free Software Foundation.
 *
 * This program is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
 * FITNESS FOR A PARTICULAR PURPOSE.
 *
 * You should have received a copy of the GNU Affero General Public License
 * along with this program. If not, see <http://www.gnu.org/licenses/>.
 */

H
hjxilinx 已提交
16
#include "os.h"
X
Xiaoyu Wang 已提交
17
#include "parToken.h"
H
hjxilinx 已提交
18
#include "taosdef.h"
X
Xiaoyu Wang 已提交
19
#include "thash.h"
20
#include "ttokendef.h"
H
hzcheng 已提交
21

S
slguan 已提交
22
// All the keywords of the SQL language are stored in a hash table
H
hzcheng 已提交
23
typedef struct SKeyword {
S
slguan 已提交
24
  const char* name;  // The keyword name
H
Haojun Liao 已提交
25
  uint16_t    type;  // type
S
slguan 已提交
26
  uint8_t     len;   // length
H
hzcheng 已提交
27 28
} SKeyword;

X
Xiaoyu Wang 已提交
29
// clang-format off
S
slguan 已提交
30
// keywords in sql string
H
hzcheng 已提交
31
static SKeyword keywordTable[] = {
X
Xiaoyu Wang 已提交
32 33 34 35 36 37 38 39 40 41 42 43 44 45 46
    {"ACCOUNT",              TK_ACCOUNT},
    {"ACCOUNTS",             TK_ACCOUNTS},
    {"ADD",                  TK_ADD},
    {"AGGREGATE",            TK_AGGREGATE},
    {"ALL",                  TK_ALL},
    {"ALTER",                TK_ALTER},
    {"ANALYZE",              TK_ANALYZE},
    {"AND",                  TK_AND},
    {"APPS",                 TK_APPS},
    {"AS",                   TK_AS},
    {"ASC",                  TK_ASC},
    {"AT_ONCE",              TK_AT_ONCE},
    {"BALANCE",              TK_BALANCE},
    {"BETWEEN",              TK_BETWEEN},
    {"BIGINT",               TK_BIGINT},
X
Xiaoyu Wang 已提交
47
    {"BINARY",               TK_BINARY},
X
Xiaoyu Wang 已提交
48 49 50 51 52 53 54 55 56
    {"BNODE",                TK_BNODE},
    {"BNODES",               TK_BNODES},
    {"BOOL",                 TK_BOOL},
    {"BUFFER",               TK_BUFFER},
    {"BUFSIZE",              TK_BUFSIZE},
    {"BY",                   TK_BY},
    {"CACHE",                TK_CACHE},
    {"CACHEMODEL",           TK_CACHEMODEL},
    {"CACHESIZE",            TK_CACHESIZE},
X
Xiaoyu Wang 已提交
57
    {"CASE",                 TK_CASE},
X
Xiaoyu Wang 已提交
58 59 60 61 62 63 64 65
    {"CAST",                 TK_CAST},
    {"CLIENT_VERSION",       TK_CLIENT_VERSION},
    {"CLUSTER",              TK_CLUSTER},
    {"COLUMN",               TK_COLUMN},
    {"COMMENT",              TK_COMMENT},
    {"COMP",                 TK_COMP},
    {"CONNECTION",           TK_CONNECTION},
    {"CONNECTIONS",          TK_CONNECTIONS},
X
Xiaoyu Wang 已提交
66
    {"CONNS",                TK_CONNS},
X
Xiaoyu Wang 已提交
67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85
    {"CONSUMER",             TK_CONSUMER},
    {"CONSUMERS",            TK_CONSUMERS},
    {"CONTAINS",             TK_CONTAINS},
    {"COUNT",                TK_COUNT},
    {"CREATE",               TK_CREATE},
    {"CURRENT_USER",         TK_CURRENT_USER},
    {"DATABASE",             TK_DATABASE},
    {"DATABASES",            TK_DATABASES},
    {"DBS",                  TK_DBS},
    {"DELETE",               TK_DELETE},
    {"DESC",                 TK_DESC},
    {"DESCRIBE",             TK_DESCRIBE},
    {"DISTINCT",             TK_DISTINCT},
    {"DISTRIBUTED",          TK_DISTRIBUTED},
    {"DNODE",                TK_DNODE},
    {"DNODES",               TK_DNODES},
    {"DOUBLE",               TK_DOUBLE},
    {"DROP",                 TK_DROP},
    {"DURATION",             TK_DURATION},
X
Xiaoyu Wang 已提交
86
    {"ELSE",                 TK_ELSE},
X
Xiaoyu Wang 已提交
87
    {"ENABLE",               TK_ENABLE},
X
Xiaoyu Wang 已提交
88
    {"END",                  TK_END},
X
Xiaoyu Wang 已提交
89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
    {"EXISTS",               TK_EXISTS},
    {"EXPIRED",              TK_EXPIRED},
    {"EXPLAIN",              TK_EXPLAIN},
    {"EVERY",                TK_EVERY},
    {"FILE",                 TK_FILE},
    {"FILL",                 TK_FILL},
    {"FIRST",                TK_FIRST},
    {"FLOAT",                TK_FLOAT},
    {"FLUSH",                TK_FLUSH},
    {"FROM",                 TK_FROM},
    {"FUNCTION",             TK_FUNCTION},
    {"FUNCTIONS",            TK_FUNCTIONS},
    {"GRANT",                TK_GRANT},
    {"GRANTS",               TK_GRANTS},
    {"GROUP",                TK_GROUP},
    {"HAVING",               TK_HAVING},
    {"IF",                   TK_IF},
    {"IGNORE",               TK_IGNORE},
    {"IMPORT",               TK_IMPORT},
    {"IN",                   TK_IN},
    {"INDEX",                TK_INDEX},
    {"INDEXES",              TK_INDEXES},
    {"INNER",                TK_INNER},
    {"INSERT",               TK_INSERT},
X
Xiaoyu Wang 已提交
113
    {"INT",                  TK_INT},
X
Xiaoyu Wang 已提交
114 115 116 117 118 119 120 121 122 123
    {"INTEGER",              TK_INTEGER},
    {"INTERVAL",             TK_INTERVAL},
    {"INTO",                 TK_INTO},
    {"IS",                   TK_IS},
    {"JOIN",                 TK_JOIN},
    {"JSON",                 TK_JSON},
    {"KEEP",                 TK_KEEP},
    {"KILL",                 TK_KILL},
    {"LAST",                 TK_LAST},
    {"LAST_ROW",             TK_LAST_ROW},
X
Xiaoyu Wang 已提交
124
    {"LICENCES",             TK_LICENCES},
X
Xiaoyu Wang 已提交
125 126 127 128 129 130 131
    {"LIKE",                 TK_LIKE},
    {"LIMIT",                TK_LIMIT},
    {"LINEAR",               TK_LINEAR},
    {"LOCAL",                TK_LOCAL},
    {"MATCH",                TK_MATCH},
    {"MAXROWS",              TK_MAXROWS},
    {"MAX_DELAY",            TK_MAX_DELAY},
132
    {"MAX_SPEED",            TK_MAX_SPEED},
X
Xiaoyu Wang 已提交
133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155
    {"MERGE",                TK_MERGE},
    {"META",                 TK_META},
    {"MINROWS",              TK_MINROWS},
    {"MINUS",                TK_MINUS},
    {"MNODE",                TK_MNODE},
    {"MNODES",               TK_MNODES},
    {"MODIFY",               TK_MODIFY},
    {"MODULES",              TK_MODULES},
    {"NCHAR",                TK_NCHAR},
    {"NEXT",                 TK_NEXT},
    {"NMATCH",               TK_NMATCH},
    {"NONE",                 TK_NONE},
    {"NOT",                  TK_NOT},
    {"NOW",                  TK_NOW},
    {"NULL",                 TK_NULL},
    {"NULLS",                TK_NULLS},
    {"OFFSET",               TK_OFFSET},
    {"ON",                   TK_ON},
    {"OR",                   TK_OR},
    {"ORDER",                TK_ORDER},
    {"OUTPUTTYPE",           TK_OUTPUTTYPE},
    {"PAGES",                TK_PAGES},
    {"PAGESIZE",             TK_PAGESIZE},
X
Xiaoyu Wang 已提交
156 157
    {"PARTITION",            TK_PARTITION},
    {"PASS",                 TK_PASS},
X
Xiaoyu Wang 已提交
158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193
    {"PORT",                 TK_PORT},
    {"PPS",                  TK_PPS},
    {"PRECISION",            TK_PRECISION},
    {"PREV",                 TK_PREV},
    {"QNODE",                TK_QNODE},
    {"QNODES",               TK_QNODES},
    {"QTIME",                TK_QTIME},
    {"QUERIES",              TK_QUERIES},
    {"QUERY",                TK_QUERY},
    {"RANGE",                TK_RANGE},
    {"RATIO",                TK_RATIO},
    {"READ",                 TK_READ},
    {"REDISTRIBUTE",         TK_REDISTRIBUTE},
    {"RENAME",               TK_RENAME},
    {"REPLICA",              TK_REPLICA},
    {"RESET",                TK_RESET},
    {"RETENTIONS",           TK_RETENTIONS},
    {"REVOKE",               TK_REVOKE},
    {"ROLLUP",               TK_ROLLUP},
    {"SCHEMALESS",           TK_SCHEMALESS},
    {"SCORES",               TK_SCORES},
    {"SELECT",               TK_SELECT},
    {"SERVER_STATUS",        TK_SERVER_STATUS},
    {"SERVER_VERSION",       TK_SERVER_VERSION},
    {"SESSION",              TK_SESSION},
    {"SET",                  TK_SET},
    {"SHOW",                 TK_SHOW},
    {"SINGLE_STABLE",        TK_SINGLE_STABLE},
    {"SLIDING",              TK_SLIDING},
    {"SLIMIT",               TK_SLIMIT},
    {"SMA",                  TK_SMA},
    {"SMALLINT",             TK_SMALLINT},
    {"SNODE",                TK_SNODE},
    {"SNODES",               TK_SNODES},
    {"SOFFSET",              TK_SOFFSET},
    {"SPLIT",                TK_SPLIT},
194
    {"STT_TRIGGER",          TK_STT_TRIGGER},
X
Xiaoyu Wang 已提交
195 196 197 198 199 200 201 202 203
    {"STABLE",               TK_STABLE},
    {"STABLES",              TK_STABLES},
    {"STATE",                TK_STATE},
    {"STATE_WINDOW",         TK_STATE_WINDOW},
    {"STORAGE",              TK_STORAGE},
    {"STREAM",               TK_STREAM},
    {"STREAMS",              TK_STREAMS},
    {"STRICT",               TK_STRICT},
    {"SUBSCRIPTIONS",        TK_SUBSCRIPTIONS},
204
    {"SUBTABLE",             TK_SUBTABLE},
X
Xiaoyu Wang 已提交
205 206 207
    {"SYSINFO",              TK_SYSINFO},
    {"TABLE",                TK_TABLE},
    {"TABLES",               TK_TABLES},
208 209
    {"TABLE_PREFIX",         TK_TABLE_PREFIX},
    {"TABLE_SUFFIX",         TK_TABLE_SUFFIX},
X
Xiaoyu Wang 已提交
210 211 212
    {"TAG",                  TK_TAG},
    {"TAGS",                 TK_TAGS},
    {"TBNAME",               TK_TBNAME},
X
Xiaoyu Wang 已提交
213
    {"THEN",                 TK_THEN},
X
Xiaoyu Wang 已提交
214 215 216 217 218 219 220 221 222 223 224
    {"TIMESTAMP",            TK_TIMESTAMP},
    {"TIMEZONE",             TK_TIMEZONE},
    {"TINYINT",              TK_TINYINT},
    {"TO",                   TK_TO},
    {"TODAY",                TK_TODAY},
    {"TOPIC",                TK_TOPIC},
    {"TOPICS",               TK_TOPICS},
    {"TRANSACTION",          TK_TRANSACTION},
    {"TRANSACTIONS",         TK_TRANSACTIONS},
    {"TRIGGER",              TK_TRIGGER},
    {"TRIM",                 TK_TRIM},
225
    {"TSDB_PAGESIZE",        TK_TSDB_PAGESIZE},
X
Xiaoyu Wang 已提交
226 227 228 229 230 231 232 233 234 235 236 237 238 239 240
    {"TSERIES",              TK_TSERIES},
    {"TTL",                  TK_TTL},
    {"UNION",                TK_UNION},
    {"UNSIGNED",             TK_UNSIGNED},
    {"USE",                  TK_USE},
    {"USER",                 TK_USER},
    {"USERS",                TK_USERS},
    {"USING",                TK_USING},
    {"VALUE",                TK_VALUE},
    {"VALUES",               TK_VALUES},
    {"VARCHAR",              TK_VARCHAR},
    {"VARIABLES",            TK_VARIABLES},
    {"VERBOSE",              TK_VERBOSE},
    {"VGROUP",               TK_VGROUP},
    {"VGROUPS",              TK_VGROUPS},
241
    {"VNODES",               TK_VNODES},
X
Xiaoyu Wang 已提交
242 243
    {"WAL_FSYNC_PERIOD",     TK_WAL_FSYNC_PERIOD},
    {"WAL_LEVEL",            TK_WAL_LEVEL},
X
Xiaoyu Wang 已提交
244 245 246 247
    {"WAL_RETENTION_PERIOD", TK_WAL_RETENTION_PERIOD},
    {"WAL_RETENTION_SIZE",   TK_WAL_RETENTION_SIZE},
    {"WAL_ROLL_PERIOD",      TK_WAL_ROLL_PERIOD},
    {"WAL_SEGMENT_SIZE",     TK_WAL_SEGMENT_SIZE},
X
Xiaoyu Wang 已提交
248
    {"WATERMARK",            TK_WATERMARK},
X
Xiaoyu Wang 已提交
249
    {"WHEN",                 TK_WHEN},
X
Xiaoyu Wang 已提交
250 251 252 253 254
    {"WHERE",                TK_WHERE},
    {"WINDOW_CLOSE",         TK_WINDOW_CLOSE},
    {"WITH",                 TK_WITH},
    {"WRITE",                TK_WRITE},
    {"_C0",                  TK_ROWTS},
255
    {"_IROWTS",              TK_IROWTS},
X
Xiaoyu Wang 已提交
256 257 258 259
    {"_QDURATION",           TK_QDURATION},
    {"_QEND",                TK_QEND},
    {"_QSTART",              TK_QSTART},
    {"_ROWTS",               TK_ROWTS},
260
    {"_TAGS",                TK_QTAGS},
X
Xiaoyu Wang 已提交
261 262 263
    {"_WDURATION",           TK_WDURATION},
    {"_WEND",                TK_WEND},
    {"_WSTART",              TK_WSTART},
H
hzcheng 已提交
264
};
X
Xiaoyu Wang 已提交
265
// clang-format on
H
hzcheng 已提交
266 267 268 269 270 271 272 273 274 275 276 277 278

static const char isIdChar[] = {
    /* x0 x1 x2 x3 x4 x5 x6 x7 x8 x9 xA xB xC xD xE xF */
    0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, /* 0x */
    0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, /* 1x */
    0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, /* 2x */
    1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, /* 3x */
    0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, /* 4x */
    1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 1, /* 5x */
    0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, /* 6x */
    1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, /* 7x */
};

H
Haojun Liao 已提交
279
static void* keywordHashTable = NULL;
H
hzcheng 已提交
280

S
TD-1057  
Shengliang Guan 已提交
281
static void doInitKeywordsTable(void) {
282
  int numOfEntries = tListLen(keywordTable);
X
Xiaoyu Wang 已提交
283

H
Haojun Liao 已提交
284
  keywordHashTable = taosHashInit(numOfEntries, MurmurHash3_32, true, false);
285
  for (int32_t i = 0; i < numOfEntries; i++) {
S
TD-1057  
Shengliang Guan 已提交
286
    keywordTable[i].len = (uint8_t)strlen(keywordTable[i].name);
287
    void* ptr = &keywordTable[i];
H
Haojun Liao 已提交
288
    taosHashPut(keywordHashTable, keywordTable[i].name, keywordTable[i].len, (void*)&ptr, POINTER_BYTES);
H
hzcheng 已提交
289
  }
290 291
}

wafwerar's avatar
wafwerar 已提交
292
static TdThreadOnce keywordsHashTableInit = PTHREAD_ONCE_INIT;
293

294
static int32_t tKeywordCode(const char* z, int n) {
wafwerar's avatar
wafwerar 已提交
295
  taosThreadOnce(&keywordsHashTableInit, doInitKeywordsTable);
X
Xiaoyu Wang 已提交
296

H
hjxilinx 已提交
297
  char key[512] = {0};
X
Xiaoyu Wang 已提交
298
  if (n > tListLen(key)) {  // too long token, can not be any other token type
299
    return TK_NK_ID;
300
  }
X
Xiaoyu Wang 已提交
301

H
hzcheng 已提交
302 303
  for (int32_t j = 0; j < n; ++j) {
    if (z[j] >= 'a' && z[j] <= 'z') {
304
      key[j] = (char)(z[j] & 0xDF);  // to uppercase and set the null-terminated
H
hzcheng 已提交
305 306 307 308 309
    } else {
      key[j] = z[j];
    }
  }

D
dapan1121 已提交
310
  if (keywordHashTable == NULL) {
311
    return TK_NK_ILLEGAL;
D
dapan1121 已提交
312
  }
H
Haojun Liao 已提交
313

H
Haojun Liao 已提交
314
  SKeyword** pKey = (SKeyword**)taosHashGet(keywordHashTable, key, n);
X
Xiaoyu Wang 已提交
315
  return (pKey != NULL) ? (*pKey)->type : TK_NK_ID;
H
hzcheng 已提交
316 317
}

H
huili 已提交
318
/*
319 320 321
 * Return the length of the token that begins at z[0].
 * Store the token type in *type before returning.
 */
322
uint32_t tGetToken(const char* z, uint32_t* tokenId) {
323
  uint32_t i;
H
hzcheng 已提交
324 325 326 327 328 329 330 331
  switch (*z) {
    case ' ':
    case '\t':
    case '\n':
    case '\f':
    case '\r': {
      for (i = 1; isspace(z[i]); i++) {
      }
332
      *tokenId = TK_NK_SPACE;
H
hzcheng 已提交
333 334 335
      return i;
    }
    case ':': {
336
      *tokenId = TK_NK_COLON;
H
hzcheng 已提交
337 338 339 340 341 342
      return 1;
    }
    case '-': {
      if (z[1] == '-') {
        for (i = 2; z[i] && z[i] != '\n'; i++) {
        }
343
        *tokenId = TK_NK_COMMENT;
H
hzcheng 已提交
344
        return i;
345 346 347
      } else if (z[1] == '>') {
        *tokenId = TK_NK_ARROW;
        return 2;
H
hzcheng 已提交
348
      }
X
Xiaoyu Wang 已提交
349
      *tokenId = TK_NK_MINUS;
H
hzcheng 已提交
350 351 352
      return 1;
    }
    case '(': {
353
      *tokenId = TK_NK_LP;
H
hzcheng 已提交
354 355 356
      return 1;
    }
    case ')': {
357
      *tokenId = TK_NK_RP;
H
hzcheng 已提交
358 359 360
      return 1;
    }
    case ';': {
361
      *tokenId = TK_NK_SEMI;
H
hzcheng 已提交
362 363 364
      return 1;
    }
    case '+': {
365
      *tokenId = TK_NK_PLUS;
H
hzcheng 已提交
366 367 368
      return 1;
    }
    case '*': {
369
      *tokenId = TK_NK_STAR;
H
hzcheng 已提交
370 371 372 373
      return 1;
    }
    case '/': {
      if (z[1] != '*' || z[2] == 0) {
374
        *tokenId = TK_NK_SLASH;
H
hzcheng 已提交
375 376 377 378 379
        return 1;
      }
      for (i = 3; z[i] && (z[i] != '/' || z[i - 1] != '*'); i++) {
      }
      if (z[i]) i++;
380
      *tokenId = TK_NK_COMMENT;
H
hzcheng 已提交
381 382 383
      return i;
    }
    case '%': {
384
      *tokenId = TK_NK_REM;
H
hzcheng 已提交
385 386 387
      return 1;
    }
    case '=': {
388
      *tokenId = TK_NK_EQ;
H
hzcheng 已提交
389 390 391 392
      return 1 + (z[1] == '=');
    }
    case '<': {
      if (z[1] == '=') {
393
        *tokenId = TK_NK_LE;
H
hzcheng 已提交
394 395
        return 2;
      } else if (z[1] == '>') {
396
        *tokenId = TK_NK_NE;
H
hzcheng 已提交
397 398
        return 2;
      } else if (z[1] == '<') {
399
        *tokenId = TK_NK_LSHIFT;
H
hzcheng 已提交
400 401
        return 2;
      } else {
402
        *tokenId = TK_NK_LT;
H
hzcheng 已提交
403 404 405 406 407
        return 1;
      }
    }
    case '>': {
      if (z[1] == '=') {
408
        *tokenId = TK_NK_GE;
H
hzcheng 已提交
409 410
        return 2;
      } else if (z[1] == '>') {
411
        *tokenId = TK_NK_RSHIFT;
H
hzcheng 已提交
412 413
        return 2;
      } else {
414
        *tokenId = TK_NK_GT;
H
hzcheng 已提交
415 416 417 418 419
        return 1;
      }
    }
    case '!': {
      if (z[1] != '=') {
420
        *tokenId = TK_NK_ILLEGAL;
H
hzcheng 已提交
421 422
        return 2;
      } else {
423
        *tokenId = TK_NK_NE;
H
hzcheng 已提交
424 425 426 427 428
        return 2;
      }
    }
    case '|': {
      if (z[1] != '|') {
429
        *tokenId = TK_NK_BITOR;
H
hzcheng 已提交
430 431
        return 1;
      } else {
432
        *tokenId = TK_NK_CONCAT;
H
hzcheng 已提交
433 434 435 436
        return 2;
      }
    }
    case ',': {
437
      *tokenId = TK_NK_COMMA;
H
hzcheng 已提交
438 439 440
      return 1;
    }
    case '&': {
441
      *tokenId = TK_NK_BITAND;
H
hzcheng 已提交
442 443 444
      return 1;
    }
    case '~': {
445
      *tokenId = TK_NK_BITNOT;
H
hzcheng 已提交
446 447
      return 1;
    }
S
slguan 已提交
448
    case '?': {
449
      *tokenId = TK_NK_QUESTION;
S
slguan 已提交
450 451
      return 1;
    }
452
    case '`':
H
hzcheng 已提交
453 454
    case '\'':
    case '"': {
S
slguan 已提交
455 456
      int  delim = z[0];
      bool strEnd = false;
H
hzcheng 已提交
457
      for (i = 1; z[i]; i++) {
458
        if (delim != '`' && z[i] == '\\') {  // ignore the escaped character that follows this backslash
L
[1292]  
lihui 已提交
459 460 461
          i++;
          continue;
        }
X
Xiaoyu Wang 已提交
462

463
        if (z[i] == delim) {
H
hzcheng 已提交
464 465 466
          if (z[i + 1] == delim) {
            i++;
          } else {
H
huili 已提交
467
            strEnd = true;
H
hzcheng 已提交
468 469 470 471
            break;
          }
        }
      }
X
Xiaoyu Wang 已提交
472

H
hzcheng 已提交
473
      if (z[i]) i++;
H
huili 已提交
474

S
slguan 已提交
475
      if (strEnd) {
X
Xiaoyu Wang 已提交
476
        *tokenId = (delim == '`') ? TK_NK_ID : TK_NK_STRING;
S
slguan 已提交
477 478
        return i;
      }
H
huili 已提交
479

S
slguan 已提交
480
      break;
H
hzcheng 已提交
481 482
    }
    case '.': {
S
slguan 已提交
483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499
      /*
       * handle the the float number with out integer part
       * .123
       * .123e4
       */
      if (isdigit(z[1])) {
        for (i = 2; isdigit(z[i]); i++) {
        }

        if ((z[i] == 'e' || z[i] == 'E') &&
            (isdigit(z[i + 1]) || ((z[i + 1] == '+' || z[i + 1] == '-') && isdigit(z[i + 2])))) {
          i += 2;
          while (isdigit(z[i])) {
            i++;
          }
        }

500
        *tokenId = TK_NK_FLOAT;
S
slguan 已提交
501 502
        return i;
      } else {
503
        *tokenId = TK_NK_DOT;
S
slguan 已提交
504 505 506 507 508 509 510
        return 1;
      }
    }

    case '0': {
      char next = z[1];

X
Xiaoyu Wang 已提交
511
      if (next == 'b') {  // bin number
512
        *tokenId = TK_NK_BIN;
S
slguan 已提交
513 514 515 516 517 518 519 520
        for (i = 2; (z[i] == '0' || z[i] == '1'); ++i) {
        }

        if (i == 2) {
          break;
        }

        return i;
X
Xiaoyu Wang 已提交
521
      } else if (next == 'x') {  // hex number
522
        *tokenId = TK_NK_HEX;
S
slguan 已提交
523 524 525 526 527 528 529 530 531
        for (i = 2; isdigit(z[i]) || (z[i] >= 'a' && z[i] <= 'f') || (z[i] >= 'A' && z[i] <= 'F'); ++i) {
        }

        if (i == 2) {
          break;
        }

        return i;
      }
H
hzcheng 已提交
532 533 534 535 536 537 538 539 540 541
    }
    case '1':
    case '2':
    case '3':
    case '4':
    case '5':
    case '6':
    case '7':
    case '8':
    case '9': {
542
      *tokenId = TK_NK_INTEGER;
H
hzcheng 已提交
543 544 545
      for (i = 1; isdigit(z[i]); i++) {
      }

H
Haojun Liao 已提交
546
      /* here is the 1u/1a/2s/3m/9y */
X
Xiaoyu Wang 已提交
547 548 549
      if ((z[i] == 'b' || z[i] == 'u' || z[i] == 'a' || z[i] == 's' || z[i] == 'm' || z[i] == 'h' || z[i] == 'd' ||
           z[i] == 'n' || z[i] == 'y' || z[i] == 'w' || z[i] == 'B' || z[i] == 'U' || z[i] == 'A' || z[i] == 'S' ||
           z[i] == 'M' || z[i] == 'H' || z[i] == 'D' || z[i] == 'N' || z[i] == 'Y' || z[i] == 'W') &&
H
hjxilinx 已提交
550
          (isIdChar[(uint8_t)z[i + 1]] == 0)) {
551
        *tokenId = TK_NK_VARIABLE;
H
hzcheng 已提交
552 553 554 555 556 557 558 559 560 561
        i += 1;
        return i;
      }

      int32_t seg = 1;
      while (z[i] == '.' && isdigit(z[i + 1])) {
        i += 2;
        while (isdigit(z[i])) {
          i++;
        }
562
        *tokenId = TK_NK_FLOAT;
H
hzcheng 已提交
563 564 565 566
        seg++;
      }

      if (seg == 4) {  // ip address
567
        *tokenId = TK_NK_IPTOKEN;
H
hzcheng 已提交
568
        return i;
X
Xiaoyu Wang 已提交
569 570
      } else if (seg > 2) {
        break;
H
hzcheng 已提交
571 572 573 574 575 576 577 578
      }

      if ((z[i] == 'e' || z[i] == 'E') &&
          (isdigit(z[i + 1]) || ((z[i + 1] == '+' || z[i + 1] == '-') && isdigit(z[i + 2])))) {
        i += 2;
        while (isdigit(z[i])) {
          i++;
        }
579
        *tokenId = TK_NK_FLOAT;
H
hzcheng 已提交
580 581 582
      }
      return i;
    }
X
Xiaoyu Wang 已提交
583 584 585 586 587 588
    // case '[': {
    //   for (i = 1; z[i] && z[i - 1] != ']'; i++) {
    //   }
    //   *tokenId = TK_NK_ID;
    //   return i;
    // }
H
hzcheng 已提交
589 590 591 592
    case 'T':
    case 't':
    case 'F':
    case 'f': {
X
Xiaoyu Wang 已提交
593
      for (i = 1; ((z[i] & 0x80) == 0) && isIdChar[(uint8_t)z[i]]; i++) {
H
hzcheng 已提交
594 595 596
      }

      if ((i == 4 && strncasecmp(z, "true", 4) == 0) || (i == 5 && strncasecmp(z, "false", 5) == 0)) {
597
        *tokenId = TK_NK_BOOL;
H
hzcheng 已提交
598 599
        return i;
      }
X
Xiaoyu Wang 已提交
600 601
      *tokenId = tKeywordCode(z, i);
      return i;
H
hzcheng 已提交
602 603
    }
    default: {
X
Xiaoyu Wang 已提交
604
      if (((*z & 0x80) != 0) || !isIdChar[(uint8_t)*z]) {
H
hzcheng 已提交
605 606
        break;
      }
X
Xiaoyu Wang 已提交
607
      for (i = 1; ((z[i] & 0x80) == 0) && isIdChar[(uint8_t)z[i]]; i++) {
H
hzcheng 已提交
608
      }
609
      *tokenId = tKeywordCode(z, i);
H
hzcheng 已提交
610 611 612 613
      return i;
    }
  }

614
  *tokenId = TK_NK_ILLEGAL;
H
hzcheng 已提交
615 616 617
  return 0;
}

618
SToken tStrGetToken(const char* str, int32_t* i, bool isPrevOptr) {
H
Haojun Liao 已提交
619
  SToken t0 = {0};
S
slguan 已提交
620

H
hzcheng 已提交
621 622
  // here we reach the end of sql string, null-terminated string
  if (str[*i] == 0) {
S
slguan 已提交
623 624
    t0.n = 0;
    return t0;
H
hzcheng 已提交
625 626
  }

627
  // IGNORE TK_NK_SPACE, TK_NK_COMMA, and specified tokens
S
slguan 已提交
628 629 630
  while (1) {
    *i += t0.n;

H
Haojun Liao 已提交
631
    int32_t numOfComma = 0;
X
Xiaoyu Wang 已提交
632
    char    t = str[*i];
H
Haojun Liao 已提交
633 634 635 636
    while (t == ' ' || t == '\n' || t == '\r' || t == '\t' || t == '\f' || t == ',') {
      if (t == ',' && (++numOfComma > 1)) {  // comma only allowed once
        t0.n = 0;
        return t0;
S
slguan 已提交
637
      }
X
Xiaoyu Wang 已提交
638

H
Haojun Liao 已提交
639
      t = str[++(*i)];
S
slguan 已提交
640
    }
H
hzcheng 已提交
641

642
    t0.n = tGetToken(&str[*i], &t0.type);
H
Haojun Liao 已提交
643
    break;
S
slguan 已提交
644

H
Haojun Liao 已提交
645 646
    // not support user specfied ignored symbol list
#if 0
H
Haojun Liao 已提交
647
    bool ignore = false;
S
slguan 已提交
648 649
    for (uint32_t k = 0; k < numOfIgnoreToken; k++) {
      if (t0.type == ignoreTokenTypes[k]) {
H
Haojun Liao 已提交
650
        ignore = true;
S
slguan 已提交
651 652 653 654
        break;
      }
    }

H
Haojun Liao 已提交
655
    if (!ignore) {
S
slguan 已提交
656 657
      break;
    }
H
Haojun Liao 已提交
658
#endif
H
hzcheng 已提交
659 660
  }

661
  if (t0.type == TK_NK_SEMI) {
S
slguan 已提交
662
    t0.n = 0;
D
dapan1121 已提交
663
    t0.type = 0;
S
slguan 已提交
664 665 666 667 668 669 670 671
    return t0;
  }

  uint32_t type = 0;
  int32_t  len;

  // support parse the 'db.tbl' format, notes: There should be no space on either side of the dot!
  if ('.' == str[*i + t0.n]) {
672
    len = tGetToken(&str[*i + t0.n + 1], &type);
S
slguan 已提交
673 674

    // only id and string are valid
675
    if ((TK_NK_STRING != t0.type) && (TK_NK_ID != t0.type)) {
676
      t0.type = TK_NK_ILLEGAL;
S
slguan 已提交
677 678 679 680 681 682 683 684 685
      t0.n = 0;

      return t0;
    }

    t0.n += len + 1;

  } else {
    // support parse the -/+number format
X
Xiaoyu Wang 已提交
686
    if ((isPrevOptr) && (t0.type == TK_NK_MINUS || t0.type == TK_NK_PLUS)) {
687
      len = tGetToken(&str[*i + t0.n], &type);
688
      if (type == TK_NK_INTEGER || type == TK_NK_FLOAT) {
S
slguan 已提交
689 690 691
        t0.type = type;
        t0.n += len;
      }
H
hzcheng 已提交
692 693 694
    }
  }

X
Xiaoyu Wang 已提交
695
  t0.z = (char*)str + (*i);
S
slguan 已提交
696 697 698
  *i += t0.n;

  return t0;
H
hzcheng 已提交
699 700
}

X
Xiaoyu Wang 已提交
701
bool taosIsKeyWordToken(const char* z, int32_t len) { return (tKeywordCode((char*)z, len) != TK_NK_ID); }
H
Haojun Liao 已提交
702 703

void taosCleanupKeywordsTable() {
H
Haojun Liao 已提交
704 705 706 707
  void* m = keywordHashTable;
  if (m != NULL && atomic_val_compare_exchange_ptr(&keywordHashTable, m, 0) == m) {
    taosHashCleanup(m);
  }
Y
yihaoDeng 已提交
708
}
709

H
Haojun Liao 已提交
710
SToken taosTokenDup(SToken* pToken, char* buf, int32_t len) {
711
  assert(pToken != NULL && buf != NULL && len > pToken->n);
X
Xiaoyu Wang 已提交
712

713 714 715
  strncpy(buf, pToken->z, pToken->n);
  buf[pToken->n] = 0;

H
Haojun Liao 已提交
716
  SToken token = *pToken;
717 718 719
  token.z = buf;
  return token;
}