parTokenizer.c 19.5 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
Haojun Liao 已提交
18
#include "thash.h"
H
hjxilinx 已提交
19
#include "taosdef.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;

S
slguan 已提交
29
// keywords in sql string
H
hzcheng 已提交
30
static SKeyword keywordTable[] = {
31
    {"ACCOUNT",       TK_ACCOUNT},
32 33 34
    {"ACCOUNTS",      TK_ACCOUNTS},
    {"ADD",           TK_ADD},
    {"AGGREGATE",     TK_AGGREGATE},
35
    {"ALL",           TK_ALL},
36
    {"ALTER",         TK_ALTER},
37
    {"ANALYZE",       TK_ANALYZE},
38
    {"AND",           TK_AND},
39
    {"APPS",          TK_APPS},
40 41 42 43 44 45
    {"AS",            TK_AS},
    {"ASC",           TK_ASC},
    {"BETWEEN",       TK_BETWEEN},
    {"BINARY",        TK_BINARY},
    {"BIGINT",        TK_BIGINT},
    {"BLOCKS",        TK_BLOCKS},
46 47
    {"BNODE",         TK_BNODE},
    {"BNODES",        TK_BNODES},
48
    {"BOOL",          TK_BOOL},
49
    {"BUFSIZE",       TK_BUFSIZE},
50 51 52
    {"BY",            TK_BY},
    {"CACHE",         TK_CACHE},
    {"CACHELAST",     TK_CACHELAST},
53
    {"COLUMN",        TK_COLUMN},
54 55
    {"COMMENT",       TK_COMMENT},
    {"COMP",          TK_COMP},
56 57 58 59
    {"COMPACT",       TK_COMPACT},
    {"CONNS",         TK_CONNS},
    {"CONNECTION",    TK_CONNECTION},
    {"CONNECTIONS",   TK_CONNECTIONS},
60 61 62 63
    {"CREATE",        TK_CREATE},
    {"DATABASE",      TK_DATABASE},
    {"DATABASES",     TK_DATABASES},
    {"DAYS",          TK_DAYS},
64
    {"DBS",           TK_DBS},
X
Xiaoyu Wang 已提交
65
    {"DELAY",         TK_DELAY},
66
    {"DESC",          TK_DESC},
67
    {"DESCRIBE",      TK_DESCRIBE},
68
    {"DISTINCT",      TK_DISTINCT},
69 70
    {"DNODE",         TK_DNODE},
    {"DNODES",        TK_DNODES},
71
    {"DOUBLE",        TK_DOUBLE},
72
    {"DROP",          TK_DROP},
73
    {"EXISTS",        TK_EXISTS},
74
    {"EXPLAIN",       TK_EXPLAIN},
X
Xiaoyu Wang 已提交
75
    {"FILE_FACTOR",   TK_FILE_FACTOR},
76
    {"FILL",          TK_FILL},
X
Xiaoyu Wang 已提交
77
    {"FIRST",         TK_FIRST},
78 79 80
    {"FLOAT",         TK_FLOAT},
    {"FROM",          TK_FROM},
    {"FSYNC",         TK_FSYNC},
X
Xiaoyu Wang 已提交
81
    {"FUNCTION",      TK_FUNCTION},
X
Xiaoyu Wang 已提交
82
    {"FUNCTIONS",     TK_FUNCTIONS},
83
    {"GRANTS",        TK_GRANTS},
84 85 86 87 88
    {"GROUP",         TK_GROUP},
    {"HAVING",        TK_HAVING},
    {"IF",            TK_IF},
    {"IMPORT",        TK_IMPORT},
    {"IN",            TK_IN},
X
Xiaoyu Wang 已提交
89
    {"INDEX",         TK_INDEX},
X
Xiaoyu Wang 已提交
90
    {"INDEXES",       TK_INDEXES},
91 92 93 94 95 96 97 98 99 100
    {"INNER",         TK_INNER},
    {"INT",           TK_INT},
    {"INSERT",        TK_INSERT},
    {"INTEGER",       TK_INTEGER},
    {"INTERVAL",      TK_INTERVAL},
    {"INTO",          TK_INTO},
    {"IS",            TK_IS},
    {"JOIN",          TK_JOIN},
    {"JSON",          TK_JSON},
    {"KEEP",          TK_KEEP},
101
    {"KILL",          TK_KILL},
X
Xiaoyu Wang 已提交
102
    {"LAST",          TK_LAST},
103
    {"LICENCE",       TK_LICENCE},
104 105 106
    {"LIKE",          TK_LIKE},
    {"LIMIT",         TK_LIMIT},
    {"LINEAR",        TK_LINEAR},
107
    {"LOCAL",         TK_LOCAL},
108 109 110 111
    {"MATCH",         TK_MATCH},
    {"MAXROWS",       TK_MAXROWS},
    {"MINROWS",       TK_MINROWS},
    {"MINUS",         TK_MINUS},
112
    {"MNODE",         TK_MNODE},
X
Xiaoyu Wang 已提交
113
    {"MNODES",        TK_MNODES},
114
    {"MODIFY",        TK_MODIFY},
X
Xiaoyu Wang 已提交
115
    {"MODULES",       TK_MODULES},
116 117 118 119 120 121
    {"NCHAR",         TK_NCHAR},
    {"NMATCH",        TK_NMATCH},
    {"NONE",          TK_NONE},
    {"NOT",           TK_NOT},
    {"NOW",           TK_NOW},
    {"NULL",          TK_NULL},
X
Xiaoyu Wang 已提交
122
    {"NULLS",         TK_NULLS},
123 124 125 126
    {"OFFSET",        TK_OFFSET},
    {"ON",            TK_ON},
    {"OR",            TK_OR},
    {"ORDER",         TK_ORDER},
127
    {"OUTPUTTYPE",    TK_OUTPUTTYPE},
128
    {"PARTITION",     TK_PARTITION},
129 130
    {"PASS",          TK_PASS},
    {"PORT",          TK_PORT},
131
    {"PPS",           TK_PPS},
132 133 134
    {"PRECISION",     TK_PRECISION},
    {"PRIVILEGE",     TK_PRIVILEGE},
    {"PREV",          TK_PREV},
135
    {"_QENDTS",       TK_QENDTS},
X
Xiaoyu Wang 已提交
136
    {"QNODE",         TK_QNODE},
X
Xiaoyu Wang 已提交
137
    {"QNODES",        TK_QNODES},
138
    {"_QSTARTTS",     TK_QSTARTTS},
139 140
    {"QTIME",         TK_QTIME},
    {"QUERIES",       TK_QUERIES},
141
    {"QUERY",         TK_QUERY},
142
    {"QUORUM",        TK_QUORUM},
143
    {"RATIO",         TK_RATIO},
144
    {"REPLICA",       TK_REPLICA},
145
    {"RESET",         TK_RESET},
X
Xiaoyu Wang 已提交
146 147
    {"RETENTIONS",    TK_RETENTIONS},
    {"ROLLUP",        TK_ROLLUP},
148
    {"_ROWTS",        TK_ROWTS},
149
    {"SCORES",        TK_SCORES},
150 151
    {"SELECT",        TK_SELECT},
    {"SESSION",       TK_SESSION},
152
    {"SET",           TK_SET},
153 154 155 156 157 158
    {"SHOW",          TK_SHOW},
    {"SINGLE_STABLE", TK_SINGLE_STABLE},
    {"SLIDING",       TK_SLIDING},
    {"SLIMIT",        TK_SLIMIT},
    {"SMA",           TK_SMA},
    {"SMALLINT",      TK_SMALLINT},
159 160
    {"SNODE",         TK_SNODE},
    {"SNODES",        TK_SNODES},
161
    {"SOFFSET",       TK_SOFFSET},
162
    {"STABLE",        TK_STABLE},
163
    {"STABLES",       TK_STABLES},
164
    {"STATE",         TK_STATE},
165
    {"STATE_WINDOW",  TK_STATE_WINDOW},
166
    {"STORAGE",       TK_STORAGE},
167
    {"STREAM",        TK_STREAM},
X
Xiaoyu Wang 已提交
168
    {"STREAMS",       TK_STREAMS},
169
    {"STREAM_MODE",   TK_STREAM_MODE},
170
    {"SYNCDB",        TK_SYNCDB},
171 172
    {"TABLE",         TK_TABLE},
    {"TABLES",        TK_TABLES},
173
    {"TAG",           TK_TAG},
174
    {"TAGS",          TK_TAGS},
175
    {"TBNAME",        TK_TBNAME},
176 177
    {"TIMESTAMP",     TK_TIMESTAMP},
    {"TINYINT",       TK_TINYINT},
178
    {"TODAY",         TK_TODAY},
179
    {"TOPIC",         TK_TOPIC},
180 181
    {"TOPICS",        TK_TOPICS},
    {"TSERIES",       TK_TSERIES},
182 183 184 185
    {"TTL",           TK_TTL},
    {"UNION",         TK_UNION},
    {"UNSIGNED",      TK_UNSIGNED},
    {"USE",           TK_USE},
186 187
    {"USER",          TK_USER},
    {"USERS",         TK_USERS},
188
    {"USING",         TK_USING},
X
Xiaoyu Wang 已提交
189
    {"VALUE",         TK_VALUE},
190 191
    {"VALUES",        TK_VALUES},
    {"VARCHAR",       TK_VARCHAR},
192
    {"VARIABLES",     TK_VARIABLES},
193
    {"VERBOSE",       TK_VERBOSE},
194
    {"VGROUPS",       TK_VGROUPS},
195
    {"VNODES",        TK_VNODES},
196
    {"WAL",           TK_WAL},
197 198
    {"_WDURATION",    TK_WDURATION},
    {"_WENDTS",       TK_WENDTS},
199
    {"WHERE",         TK_WHERE},
X
Xiaoyu Wang 已提交
200
    {"_WSTARTTS",     TK_WSTARTTS},
201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265
    // {"ID",           TK_ID},
    // {"STRING",       TK_STRING},
    // {"EQ",           TK_EQ},
    // {"NE",           TK_NE},
    // {"ISNULL",       TK_ISNULL},
    // {"NOTNULL",      TK_NOTNULL},
    // {"GLOB",         TK_GLOB},
    // {"GT",           TK_GT},
    // {"GE",           TK_GE},
    // {"LT",           TK_LT},
    // {"LE",           TK_LE},
    // {"BITAND",       TK_BITAND},
    // {"BITOR",        TK_BITOR},
    // {"LSHIFT",       TK_LSHIFT},
    // {"RSHIFT",       TK_RSHIFT},
    // {"PLUS",         TK_PLUS},
    // {"DIVIDE",       TK_DIVIDE},
    // {"TIMES",        TK_TIMES},
    // {"STAR",         TK_STAR},
    // {"SLASH",        TK_SLASH},
    // {"REM ",         TK_REM},
    // {"||",           TK_CONCAT},
    // {"UMINUS",       TK_UMINUS},
    // {"UPLUS",        TK_UPLUS},
    // {"BITNOT",       TK_BITNOT},
    // {"DOT",          TK_DOT},
    // {"CTIME",        TK_CTIME},
    // {"LP",           TK_LP},
    // {"RP",           TK_RP},
    // {"COMMA",        TK_COMMA},
    // {"EVERY",        TK_EVERY},
    // {"VARIABLE",     TK_VARIABLE},
    // {"UPDATE",       TK_UPDATE},
    // {"CHANGE",       TK_CHANGE},
    // {"COLON",        TK_COLON},
    // {"ABORT",        TK_ABORT},
    // {"AFTER",        TK_AFTER},
    // {"ATTACH",       TK_ATTACH},
    // {"BEFORE",       TK_BEFORE},
    // {"BEGIN",        TK_BEGIN},
    // {"CASCADE",      TK_CASCADE},
    // {"CLUSTER",      TK_CLUSTER},
    // {"CONFLICT",     TK_CONFLICT},
    // {"COPY",         TK_COPY},
    // {"DEFERRED",     TK_DEFERRED},
    // {"DELIMITERS",   TK_DELIMITERS},
    // {"DETACH",       TK_DETACH},
    // {"EACH",         TK_EACH},
    // {"END",          TK_END},
    // {"FAIL",         TK_FAIL},
    // {"FOR",          TK_FOR},
    // {"IGNORE",       TK_IGNORE},
    // {"IMMEDIATE",    TK_IMMEDIATE},
    // {"INITIALLY",    TK_INITIALLY},
    // {"INSTEAD",      TK_INSTEAD},
    // {"KEY",          TK_KEY},
    // {"OF",           TK_OF},
    // {"RAISE",        TK_RAISE},
    // {"REPLACE",      TK_REPLACE},
    // {"RESTRICT",     TK_RESTRICT},
    // {"ROW",          TK_ROW},
    // {"STATEMENT",    TK_STATEMENT},
    // {"TRIGGER",      TK_TRIGGER},
    // {"VIEW",         TK_VIEW},
    // {"SEMI",         TK_SEMI},
266
    // {"PARTITIONS",   TK_PARTITIONS},
267
    // {"MODE",         TK_MODE},
H
hzcheng 已提交
268 269 270 271 272 273 274 275 276 277 278 279 280 281
};

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 已提交
282
static void* keywordHashTable = NULL;
H
hzcheng 已提交
283

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

wafwerar's avatar
wafwerar 已提交
295
static TdThreadOnce keywordsHashTableInit = PTHREAD_ONCE_INIT;
296

297
static int32_t tKeywordCode(const char* z, int n) {
wafwerar's avatar
wafwerar 已提交
298
  taosThreadOnce(&keywordsHashTableInit, doInitKeywordsTable);
H
hjxilinx 已提交
299 300
  
  char key[512] = {0};
301
  if (n > tListLen(key)) { // too long token, can not be any other token type
302
    return TK_NK_ID;
303
  }
H
hjxilinx 已提交
304
  
H
hzcheng 已提交
305 306
  for (int32_t j = 0; j < n; ++j) {
    if (z[j] >= 'a' && z[j] <= 'z') {
307
      key[j] = (char)(z[j] & 0xDF);  // to uppercase and set the null-terminated
H
hzcheng 已提交
308 309 310 311 312
    } else {
      key[j] = z[j];
    }
  }

D
dapan1121 已提交
313
  if (keywordHashTable == NULL) {
314
    return TK_NK_ILLEGAL;
D
dapan1121 已提交
315
  }
H
Haojun Liao 已提交
316

H
Haojun Liao 已提交
317
  SKeyword** pKey = (SKeyword**)taosHashGet(keywordHashTable, key, n);
318
  return (pKey != NULL)? (*pKey)->type:TK_NK_ID;
H
hzcheng 已提交
319 320
}

H
huili 已提交
321
/*
322 323 324
 * Return the length of the token that begins at z[0].
 * Store the token type in *type before returning.
 */
325
uint32_t tGetToken(const char* z, uint32_t* tokenId) {
326
  uint32_t i;
H
hzcheng 已提交
327 328 329 330 331 332 333 334
  switch (*z) {
    case ' ':
    case '\t':
    case '\n':
    case '\f':
    case '\r': {
      for (i = 1; isspace(z[i]); i++) {
      }
335
      *tokenId = TK_NK_SPACE;
H
hzcheng 已提交
336 337 338
      return i;
    }
    case ':': {
339
      *tokenId = TK_NK_COLON;
H
hzcheng 已提交
340 341 342 343 344 345
      return 1;
    }
    case '-': {
      if (z[1] == '-') {
        for (i = 2; z[i] && z[i] != '\n'; i++) {
        }
346
        *tokenId = TK_NK_COMMENT;
H
hzcheng 已提交
347 348
        return i;
      }
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++) {
H
Haojun Liao 已提交
458
        if (z[i] == '\\') {   // ignore the escaped character that follows this backslash
L
[1292]  
lihui 已提交
459 460 461 462
          i++;
          continue;
        }
        
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;
          }
        }
      }
L
[1292]  
lihui 已提交
472
      
H
hzcheng 已提交
473
      if (z[i]) i++;
H
huili 已提交
474

S
slguan 已提交
475
      if (strEnd) {
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 511
        return 1;
      }
    }

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

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

        if (i == 2) {
          break;
        }

        return i;
      } 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 */
547
      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' ||
H
Haojun Liao 已提交
548
           z[i] == 'y' || z[i] == 'w' ||
549
           z[i] == 'B' || z[i] == 'U' || z[i] == 'A' || z[i] == 'S' || z[i] == 'M' || z[i] == 'H' || z[i] == 'D' || z[i] == 'N' ||
H
Haojun Liao 已提交
550
           z[i] == 'Y' || z[i] == 'W') &&
H
hjxilinx 已提交
551
          (isIdChar[(uint8_t)z[i + 1]] == 0)) {
552
        *tokenId = TK_NK_VARIABLE;
H
hzcheng 已提交
553 554 555 556 557 558 559 560 561 562
        i += 1;
        return i;
      }

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

      if (seg == 4) {  // ip address
568
        *tokenId = TK_NK_IPTOKEN;
H
hzcheng 已提交
569 570 571 572 573 574 575 576 577
        return 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++;
        }
578
        *tokenId = TK_NK_FLOAT;
H
hzcheng 已提交
579 580 581 582 583 584
      }
      return i;
    }
    case '[': {
      for (i = 1; z[i] && z[i - 1] != ']'; i++) {
      }
585
      *tokenId = TK_NK_ID;
H
hzcheng 已提交
586 587 588 589 590 591
      return i;
    }
    case 'T':
    case 't':
    case 'F':
    case 'f': {
H
hjxilinx 已提交
592
      for (i = 1; ((z[i] & 0x80) == 0) && isIdChar[(uint8_t) z[i]]; i++) {
H
hzcheng 已提交
593 594 595
      }

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

611
  *tokenId = TK_NK_ILLEGAL;
H
hzcheng 已提交
612 613 614
  return 0;
}

H
Haojun Liao 已提交
615
SToken tscReplaceStrToken(char **str, SToken *token, const char* newToken) {
D
dapan1121 已提交
616
  char *src = *str;
D
dapan1121 已提交
617 618 619
  size_t nsize = strlen(newToken);
  int32_t size = (int32_t)strlen(*str) - token->n + (int32_t)nsize + 1;
  int32_t bsize = (int32_t)((uint64_t)token->z - (uint64_t)src);
H
Haojun Liao 已提交
620
  SToken ntoken;
D
dapan1121 已提交
621

wafwerar's avatar
wafwerar 已提交
622
  *str = taosMemoryCalloc(1, size);
D
dapan1121 已提交
623 624

  strncpy(*str, src, bsize);
H
Haojun Liao 已提交
625
  strcat(*str, newToken);
D
dapan1121 已提交
626 627
  strcat(*str, token->z + token->n);

D
dapan1121 已提交
628
  ntoken.n = (uint32_t)nsize;
D
dapan1121 已提交
629 630
  ntoken.z = *str + bsize;

wafwerar's avatar
wafwerar 已提交
631
  taosMemoryFreeClear(src);
D
dapan1121 已提交
632 633 634 635

  return ntoken;
}

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

H
hzcheng 已提交
639 640
  // here we reach the end of sql string, null-terminated string
  if (str[*i] == 0) {
S
slguan 已提交
641 642
    t0.n = 0;
    return t0;
H
hzcheng 已提交
643 644
  }

645
  // IGNORE TK_NK_SPACE, TK_NK_COMMA, and specified tokens
S
slguan 已提交
646 647 648
  while (1) {
    *i += t0.n;

H
Haojun Liao 已提交
649 650 651 652 653 654
    int32_t numOfComma = 0;
    char t = str[*i];
    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 已提交
655
      }
H
Haojun Liao 已提交
656
    
H
Haojun Liao 已提交
657
      t = str[++(*i)];
S
slguan 已提交
658
    }
H
hzcheng 已提交
659

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

H
Haojun Liao 已提交
663 664
    // not support user specfied ignored symbol list
#if 0
H
Haojun Liao 已提交
665
    bool ignore = false;
S
slguan 已提交
666 667
    for (uint32_t k = 0; k < numOfIgnoreToken; k++) {
      if (t0.type == ignoreTokenTypes[k]) {
H
Haojun Liao 已提交
668
        ignore = true;
S
slguan 已提交
669 670 671 672
        break;
      }
    }

H
Haojun Liao 已提交
673
    if (!ignore) {
S
slguan 已提交
674 675
      break;
    }
H
Haojun Liao 已提交
676
#endif
H
hzcheng 已提交
677 678
  }

679
  if (t0.type == TK_NK_SEMI) {
S
slguan 已提交
680 681 682 683 684 685 686 687 688
    t0.n = 0;
    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]) {
689
    len = tGetToken(&str[*i + t0.n + 1], &type);
S
slguan 已提交
690 691

    // only id and string are valid
692
    if ((TK_NK_STRING != t0.type) && (TK_NK_ID != t0.type)) {
693
      t0.type = TK_NK_ILLEGAL;
S
slguan 已提交
694 695 696 697 698 699 700 701 702
      t0.n = 0;

      return t0;
    }

    t0.n += len + 1;

  } else {
    // support parse the -/+number format
X
Xiaoyu Wang 已提交
703
    if ((isPrevOptr) && (t0.type == TK_NK_MINUS || t0.type == TK_NK_PLUS)) {
704
      len = tGetToken(&str[*i + t0.n], &type);
705
      if (type == TK_NK_INTEGER || type == TK_NK_FLOAT) {
S
slguan 已提交
706 707 708
        t0.type = type;
        t0.n += len;
      }
H
hzcheng 已提交
709 710 711
    }
  }

712
  t0.z = (char*) str + (*i);
S
slguan 已提交
713 714 715
  *i += t0.n;

  return t0;
H
hzcheng 已提交
716 717
}

718
bool taosIsKeyWordToken(const char* z, int32_t len) {
719
  return (tKeywordCode((char*)z, len) != TK_NK_ID);
720
}
H
Haojun Liao 已提交
721 722

void taosCleanupKeywordsTable() {
H
Haojun Liao 已提交
723 724 725 726
  void* m = keywordHashTable;
  if (m != NULL && atomic_val_compare_exchange_ptr(&keywordHashTable, m, 0) == m) {
    taosHashCleanup(m);
  }
Y
yihaoDeng 已提交
727
}
728

H
Haojun Liao 已提交
729
SToken taosTokenDup(SToken* pToken, char* buf, int32_t len) {
730 731 732 733 734
  assert(pToken != NULL && buf != NULL && len > pToken->n);
  
  strncpy(buf, pToken->z, pToken->n);
  buf[pToken->n] = 0;

H
Haojun Liao 已提交
735
  SToken token = *pToken;
736 737 738
  token.z = buf;
  return token;
}