github.com/matrixorigin/matrixone@v0.7.0/pkg/sql/parsers/dialect/mysql/keywords.go (about) 1 // Copyright 2021 Matrix Origin 2 // 3 // Licensed under the Apache License, Version 2.0 (the "License"); 4 // you may not use this file except in compliance with the License. 5 // You may obtain a copy of the License at 6 // 7 // http://www.apache.org/licenses/LICENSE-2.0 8 // 9 // Unless required by applicable law or agreed to in writing, software 10 // distributed under the License is distributed on an "AS IS" BASIS, 11 // WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 12 // See the License for the specific language governing permissions and 13 // limitations under the License. 14 15 package mysql 16 17 var keywords map[string]int 18 19 func init() { 20 keywords = map[string]int{ 21 "accessible": UNUSED, 22 "account": ACCOUNT, 23 "accounts": ACCOUNTS, 24 "add": ADD, 25 "action": ACTION, 26 "against": AGAINST, 27 "all": ALL, 28 "alter": ALTER, 29 "algorithm": ALGORITHM, 30 "analyze": ANALYZE, 31 "and": AND, 32 "any": ANY, 33 "as": AS, 34 "asc": ASC, 35 "ascii": ASCII, 36 "asensitive": UNUSED, 37 "auto_increment": AUTO_INCREMENT, 38 "auto_random": AUTO_RANDOM, 39 "avg_row_length": AVG_ROW_LENGTH, 40 "avg": AVG, 41 "bsi": BSI, 42 "before": UNUSED, 43 "begin": BEGIN, 44 "between": BETWEEN, 45 "bigint": BIGINT, 46 "bindings": BINDINGS, 47 "binary": BINARY, 48 "_binary": UNDERSCORE_BINARY, 49 "bit": BIT, 50 "blob": BLOB, 51 "bool": BOOL, 52 "boolean": BOOLEAN, 53 "both": BOTH, 54 "by": BY, 55 "btree": BTREE, 56 "bit_or": BIT_OR, 57 "bit_and": BIT_AND, 58 "call": UNUSED, 59 "cascade": CASCADE, 60 "case": CASE, 61 "cast": CAST, 62 "change": UNUSED, 63 "char": CHAR, 64 "character": CHARACTER, 65 "charset": CHARSET, 66 "check": CHECK, 67 "checksum": CHECKSUM, 68 "coalesce": COALESCE, 69 "compressed": COMPRESSED, 70 "compression": COMPRESSION, 71 "collate": COLLATE, 72 "collation": COLLATION, 73 "column": COLUMN, 74 "columns": COLUMNS, 75 "column_format": COLUMN_FORMAT, 76 "comment": COMMENT_KEYWORD, 77 "committed": COMMITTED, 78 "commit": COMMIT, 79 "compact": COMPACT, 80 "condition": UNUSED, 81 "constraint": CONSTRAINT, 82 "consistent": CONSISTENT, 83 "continue": UNUSED, 84 "connection": CONNECTION, 85 "connect": CONNECT, 86 "convert": CONVERT, 87 "config": CONFIG, 88 "cipher": CIPHER, 89 "chain": CHAIN, 90 "client": CLIENT, 91 "san": SAN, 92 "substr": SUBSTR, 93 "substring": SUBSTRING, 94 "subject": SUBJECT, 95 "subpartition": SUBPARTITION, 96 "subpartitions": SUBPARTITIONS, 97 "snapshot": SNAPSHOT, 98 "sysdate": SYSDATE, 99 "create": CREATE, 100 "cluster": CLUSTER, 101 "cross": CROSS, 102 "current_date": CURRENT_DATE, 103 "current_time": CURRENT_TIME, 104 "current_timestamp": CURRENT_TIMESTAMP, 105 "current_user": CURRENT_USER, 106 "current_role": CURRENT_ROLE, 107 "curtime": CURTIME, 108 "cursor": UNUSED, 109 "database": DATABASE, 110 "databases": DATABASES, 111 "day": DAY, 112 "date": DATE, 113 "data": DATA, 114 "datetime": DATETIME, 115 "dec": UNUSED, 116 "decimal": DECIMAL, 117 "declare": DECLARE, 118 "default": DEFAULT, 119 "delayed": DELAYED, 120 "delete": DELETE, 121 "desc": DESC, 122 "describe": DESCRIBE, 123 "deterministic": UNUSED, 124 "distinct": DISTINCT, 125 "distinctrow": UNUSED, 126 "disk": DISK, 127 "div": DIV, 128 "directory": DIRECTORY, 129 "double": DOUBLE, 130 "do": DO, 131 "drop": DROP, 132 "dynamic": DYNAMIC, 133 "duplicate": DUPLICATE, 134 "drainer": DRAINER, 135 "each": UNUSED, 136 "else": ELSE, 137 "elseif": UNUSED, 138 "enclosed": ENCLOSED, 139 "encryption": ENCRYPTION, 140 "engine": ENGINE, 141 "end": END, 142 "enum": ENUM, 143 "enforced": ENFORCED, 144 "escape": ESCAPE, 145 "escaped": ESCAPED, 146 "exists": EXISTS, 147 "exit": UNUSED, 148 "explain": EXPLAIN, 149 "expansion": EXPANSION, 150 "extended": EXTENDED, 151 "expire": EXPIRE, 152 "except": EXCEPT, 153 "execute": EXECUTE, 154 "errors": ERRORS, 155 "event": EVENT, 156 "events": EVENTS, 157 "engines": ENGINES, 158 "false": FALSE, 159 "fetch": UNUSED, 160 "first": FIRST, 161 "float": FLOAT_TYPE, 162 "float4": UNUSED, 163 "float8": UNUSED, 164 "for": FOR, 165 "force": FORCE, 166 "foreign": FOREIGN, 167 "format": FORMAT, 168 "from": FROM, 169 "full": FULL, 170 "fulltext": FULLTEXT, 171 "function": FUNCTION, 172 "fields": FIELDS, 173 "file": FILE, 174 "fixed": FIXED, 175 "generated": UNUSED, 176 "geometry": GEOMETRY, 177 "geometrycollection": GEOMETRYCOLLECTION, 178 "get": UNUSED, 179 "global": GLOBAL, 180 "grant": GRANT, 181 "grants": GRANTS, 182 "group": GROUP, 183 "group_concat": GROUP_CONCAT, 184 "having": HAVING, 185 "hash": HASH, 186 "high_priority": HIGH_PRIORITY, 187 "hour": HOUR, 188 "identified": IDENTIFIED, 189 "if": IF, 190 "ignore": IGNORE, 191 "in": IN, 192 "index": INDEX, 193 "indexes": INDEXES, 194 "infile": INFILE, 195 "inout": UNUSED, 196 "inner": INNER, 197 "insensitive": UNUSED, 198 "insert": INSERT, 199 "int": INT, 200 "int1": INT1, 201 "int2": INT2, 202 "int3": INT3, 203 "int4": INT4, 204 "int8": INT8, 205 "s3option": S3OPTION, 206 "integer": INTEGER, 207 "interval": INTERVAL, 208 "into": INTO, 209 "invisible": INVISIBLE, 210 "io_after_gtids": UNUSED, 211 "is": IS, 212 "issuer": ISSUER, 213 "isolation": ISOLATION, 214 "iterate": UNUSED, 215 "join": JOIN, 216 "json": JSON, 217 "uuid": UUID, 218 "key": KEY, 219 "keys": KEYS, 220 "key_block_size": KEY_BLOCK_SIZE, 221 "kill": KILL, 222 "language": LANGUAGE, 223 "last": LAST, 224 "leading": LEADING, 225 "leave": UNUSED, 226 "left": LEFT, 227 "less": LESS, 228 "level": LEVEL, 229 "like": LIKE, 230 "ilike": ILIKE, 231 "list": LIST, 232 "limit": LIMIT, 233 "linear": LINEAR, 234 "lines": LINES, 235 "rows": ROWS, 236 "linestring": LINESTRING, 237 "load": LOAD, 238 "import": IMPORT, 239 "localtime": LOCALTIME, 240 "localtimestamp": LOCALTIMESTAMP, 241 "lock": LOCK, 242 "locks": LOCKS, 243 "long": UNUSED, 244 "longblob": LONGBLOB, 245 "longtext": LONGTEXT, 246 "loop": UNUSED, 247 "low_priority": LOW_PRIORITY, 248 "local": LOCAL, 249 "master_bind": UNUSED, 250 "match": MATCH, 251 "maxvalue": MAXVALUE, 252 "manage": MANAGE, 253 "mediumblob": MEDIUMBLOB, 254 "mediumint": MEDIUMINT, 255 "mediumtext": MEDIUMTEXT, 256 "middleint": UNUSED, 257 "minute": MINUTE, 258 "microsecond": MICROSECOND, 259 "mod": MOD, 260 "month": MONTH, 261 "mode": MODE, 262 "memory": MEMORY, 263 "modifies": UNUSED, 264 "multilinestring": MULTILINESTRING, 265 "multipoint": MULTIPOINT, 266 "multipolygon": MULTIPOLYGON, 267 "max_queries_per_hour": MAX_QUERIES_PER_HOUR, 268 "max_update_per_hour": MAX_UPDATES_PER_HOUR, 269 "max_connections_per_hour": MAX_CONNECTIONS_PER_HOUR, 270 "max_user_connections": MAX_USER_CONNECTIONS, 271 "max_rows": MAX_ROWS, 272 "min_rows": MIN_ROWS, 273 "names": NAMES, 274 "natural": NATURAL, 275 "nchar": NCHAR, 276 "next": NEXT, 277 "never": NEVER, 278 "not": NOT, 279 "no": NO, 280 "node": NODE, 281 "no_write_to_binlog": UNUSED, 282 "null": NULL, 283 "nulls": NULLS, 284 "numeric": NUMERIC, 285 "none": NONE, 286 "offset": OFFSET, 287 "on": ON, 288 "only": ONLY, 289 "optimize": OPTIMIZE, 290 "optimizer_costs": UNUSED, 291 "option": OPTION, 292 "optionally": OPTIONALLY, 293 "open": OPEN, 294 "or": OR, 295 "order": ORDER, 296 "out": UNUSED, 297 "outer": OUTER, 298 "over": OVER, 299 "outfile": OUTFILE, 300 "ownership": OWNERSHIP, 301 "header": HEADER, 302 "parallel": PARALLEL, 303 "max_file_size": MAX_FILE_SIZE, 304 "force_quote": FORCE_QUOTE, 305 "external": EXTERNAL, 306 "url": URL, 307 "parser": PARSER, 308 "partition": PARTITION, 309 "partitions": PARTITIONS, 310 "partial": PARTIAL, 311 "password": PASSWORD, 312 "pack_keys": PACK_KEYS, 313 "point": POINT, 314 "polygon": POLYGON, 315 "precision": UNUSED, 316 "primary": PRIMARY, 317 "processlist": PROCESSLIST, 318 "procedure": PROCEDURE, 319 "proxy": PROXY, 320 "properties": PROPERTIES, 321 "privileges": PRIVILEGES, 322 "plugins": PLUGINS, 323 "query": QUERY, 324 "quarter": QUARTER, 325 "quick": QUICK, 326 "range": RANGE, 327 "read": READ, 328 "reads": UNUSED, 329 "redundant": REDUNDANT, 330 "read_write": UNUSED, 331 "real": REAL, 332 "references": REFERENCES, 333 "regexp": REGEXP, 334 "release": RELEASE, 335 "rename": RENAME, 336 "reorganize": REORGANIZE, 337 "repair": REPAIR, 338 "repeat": REPEAT, 339 "repeatable": REPEATABLE, 340 "replace": REPLACE, 341 "replication": REPLICATION, 342 "require": REQUIRE, 343 "resignal": UNUSED, 344 "restrict": RESTRICT, 345 "return": UNUSED, 346 "revoke": REVOKE, 347 "reverse": REVERSE, 348 "reload": RELOAD, 349 "right": RIGHT, 350 "rlike": REGEXP, 351 "rollback": ROLLBACK, 352 "role": ROLE, 353 "routine": ROUTINE, 354 "row": ROW, 355 "row_format": ROW_FORMAT, 356 "row_count": ROW_COUNT, 357 "rtree": RTREE, 358 "schema": SCHEMA, 359 "schemas": SCHEMAS, 360 "second": SECOND, 361 "select": SELECT, 362 "sensitive": UNUSED, 363 "separator": SEPARATOR, 364 "serializable": SERIALIZABLE, 365 "session": SESSION, 366 "set": SET, 367 "share": SHARE, 368 "show": SHOW, 369 "shutdown": SHUTDOWN, 370 "signal": UNUSED, 371 "signed": SIGNED, 372 "simple": SIMPLE, 373 "smallint": SMALLINT, 374 "spatial": SPATIAL, 375 "specific": UNUSED, 376 "sql": UNUSED, 377 "sqlexception": UNUSED, 378 "sqlstate": UNUSED, 379 "sqlwarning": UNUSED, 380 "sql_big_result": SQL_BIG_RESULT, 381 "sql_cache": SQL_CACHE, 382 "sql_calc_found_rows": UNUSED, 383 "sql_no_cache": SQL_NO_CACHE, 384 "sql_small_result": SQL_SMALL_RESULT, 385 "sql_buffer_result": SQL_BUFFER_RESULT, 386 "ssl": SSL, 387 "slave": SLAVE, 388 "start": START, 389 "starting": STARTING, 390 "status": STATUS, 391 "stats_auto_recalc": STATS_AUTO_RECALC, 392 "stats_persistent": STATS_PERSISTENT, 393 "stats_sample_pages": STATS_SAMPLE_PAGES, 394 "stored": UNUSED, 395 "storage": STORAGE, 396 "straight_join": STRAIGHT_JOIN, 397 "stream": STREAM, 398 "super": SUPER, 399 "table": TABLE, 400 "tables": TABLES, 401 "tablespace": TABLESPACE, 402 "terminated": TERMINATED, 403 "text": TEXT, 404 "temporary": TEMPORARY, 405 "than": THAN, 406 "then": THEN, 407 "time": TIME, 408 "timestamp": TIMESTAMP, 409 "timestampdiff": TIMESTAMPDIFF, 410 "tinyblob": TINYBLOB, 411 "tinyint": TINYINT, 412 "tinytext": TINYTEXT, 413 "to": TO, 414 "trailing": TRAILING, 415 "transaction": TRANSACTION, 416 "trigger": TRIGGER, 417 "triggers": TRIGGERS, 418 "true": TRUE, 419 "truncate": TRUNCATE, 420 "uncommitted": UNCOMMITTED, 421 "undo": UNUSED, 422 "unknown": UNKNOWN, 423 "union": UNION, 424 "unique": UNIQUE, 425 "unlock": UNLOCK, 426 "unsigned": UNSIGNED, 427 "update": UPDATE, 428 "usage": USAGE, 429 "use": USE, 430 "user": USER, 431 "using": USING, 432 "utc_date": UTC_DATE, 433 "utc_time": UTC_TIME, 434 "utc_timestamp": UTC_TIMESTAMP, 435 "values": VALUES, 436 "variables": VARIABLES, 437 "varbinary": VARBINARY, 438 "varchar": VARCHAR, 439 "varcharacter": UNUSED, 440 "varying": UNUSED, 441 "virtual": UNUSED, 442 "view": VIEW, 443 "visible": VISIBLE, 444 "week": WEEK, 445 "when": WHEN, 446 "where": WHERE, 447 "while": UNUSED, 448 "with": WITH, 449 "write": WRITE, 450 "warnings": WARNINGS, 451 "work": WORK, 452 "xor": XOR, 453 "x509": X509, 454 "year": YEAR, 455 "zerofill": ZEROFILL, 456 "zonemap": ZONEMAP, 457 "adddate": ADDDATE, 458 "count": COUNT, 459 "approx_count_distinct": APPROX_COUNT_DISTINCT, 460 "approx_percentile": APPROX_PERCENTILE, 461 "curdate": CURDATE, 462 "date_add": DATE_ADD, 463 "date_sub": DATE_SUB, 464 "extract": EXTRACT, 465 "max": MAX, 466 "median": MEDIAN, 467 "mid": MID, 468 "now": NOW, 469 "position": POSITION, 470 "pump": PUMP, 471 "profiles": PROFILES, 472 "session_user": SESSION_USER, 473 "std": STD, 474 "stddev": STDDEV, 475 "stddev_pop": STDDEV_POP, 476 "stddev_samp": STDDEV_SAMP, 477 "subdate": SUBDATE, 478 "sum": SUM, 479 "system_user": SYSTEM_USER, 480 "some": SOME, 481 "translate": TRANSLATE, 482 "trim": TRIM, 483 "variance": VARIANCE, 484 "var_pop": VAR_POP, 485 "var_samp": VAR_SAMP, 486 "type": TYPE, 487 "verbose": VERBOSE, 488 "sql_tsi_minute": SQL_TSI_MINUTE, 489 "sql_tsi_second": SQL_TSI_SECOND, 490 "sql_tsi_year": SQL_TSI_YEAR, 491 "sql_tsi_quarter": SQL_TSI_QUARTER, 492 "sql_tsi_month": SQL_TSI_MONTH, 493 "sql_tsi_week": SQL_TSI_WEEK, 494 "sql_tsi_day": SQL_TSI_DAY, 495 "sql_tsi_hour": SQL_TSI_HOUR, 496 "year_month": YEAR_MONTH, 497 "day_hour": DAY_HOUR, 498 "day_minute": DAY_MINUTE, 499 "day_second": DAY_SECOND, 500 "day_microsecond": DAY_MICROSECOND, 501 "hour_minute": HOUR_MINUTE, 502 "hour_second": HOUR_SECOND, 503 "hour_microsecond": HOUR_MICROSECOND, 504 "minute_second": MINUTE_SECOND, 505 "minute_microsecond": MINUTE_MICROSECOND, 506 "min": MIN, 507 "second_microsecond": SECOND_MICROSECOND, 508 "prepare": PREPARE, 509 "deallocate": DEALLOCATE, 510 "reset": RESET, 511 "intersect": INTERSECT, 512 "minus": MINUS, 513 "admin_name": ADMIN_NAME, 514 "random": RANDOM, 515 "suspend": SUSPEND, 516 "attribute": ATTRIBUTE, 517 "history": HISTORY, 518 "reuse": REUSE, 519 "current": CURRENT, 520 "optional": OPTIONAL, 521 "failed_login_attempts": FAILED_LOGIN_ATTEMPTS, 522 "password_lock_time": PASSWORD_LOCK_TIME, 523 "unbounded": UNBOUNDED, 524 "secondary": SECONDARY, 525 "reference": REFERENCE, 526 "modump": MODUMP, 527 "low_cardinality": LOW_CARDINALITY, 528 "preceding": PRECEDING, 529 "following": FOLLOWING, 530 "groups": GROUPS, 531 "table_number": TABLE_NUMBER, 532 "table_values": TABLE_VALUES, 533 "column_number": COLUMN_NUMBER, 534 "returns": RETURNS, 535 "extension": EXTENSION, 536 "query_result": QUERY_RESULT, 537 "mysql_compatbility_mode": MYSQL_COMPATBILITY_MODE, 538 } 539 }