{ "query": "SELECT ALL DISTINCT MAX_STATEMENT_TIME = 10\n 1 + 2 AS result,\n @idx,\n id,\n test.`users`.username AS\nFROM\n `test`.users\n PARTITION (p1, p2)\nWHERE\n id > 0\nORDER BY\n username DESC,\n id\nLIMIT 2, 3;", "lexer": { "@type": "PhpMyAdmin\\SqlParser\\Lexer", "PARSER_METHODS": [ "parseDelimiter", "parseWhitespace", "parseNumber", "parseComment", "parseOperator", "parseBool", "parseString", "parseSymbol", "parseKeyword", "parseLabel", "parseUnknown" ], "str": "SELECT ALL DISTINCT MAX_STATEMENT_TIME = 10\n 1 + 2 AS result,\n @idx,\n id,\n test.`users`.username AS\nFROM\n `test`.users\n PARTITION (p1, p2)\nWHERE\n id > 0\nORDER BY\n username DESC,\n id\nLIMIT 2, 3;", "len": 220, "last": 220, "list": { "@type": "PhpMyAdmin\\SqlParser\\TokensList", "tokens": [ { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SELECT", "value": "SELECT", "keyword": "SELECT", "type": 1, "flags": 3, "position": 0 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 6 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "ALL", "value": "ALL", "keyword": "ALL", "type": 1, "flags": 3, "position": 7 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 10 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DISTINCT", "value": "DISTINCT", "keyword": "DISTINCT", "type": 1, "flags": 3, "position": 11 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 19 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "MAX_STATEMENT_TIME", "value": "MAX_STATEMENT_TIME", "keyword": "MAX_STATEMENT_TIME", "type": 1, "flags": 1, "position": 20 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 38 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 39 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 40 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "10", "value": 10, "keyword": null, "type": 6, "flags": 0, "position": 41 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 43 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "1", "value": 1, "keyword": null, "type": 6, "flags": 0, "position": 48 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 49 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "+", "value": "+", "keyword": null, "type": 2, "flags": 1, "position": 50 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 51 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "2", "value": 2, "keyword": null, "type": 6, "flags": 0, "position": 52 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 53 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AS", "value": "AS", "keyword": "AS", "type": 1, "flags": 3, "position": 54 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 56 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "result", "value": "result", "keyword": null, "type": 0, "flags": 0, "position": 57 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 63 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 64 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "@idx", "value": "idx", "keyword": null, "type": 8, "flags": 1, "position": 69 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 73 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 74 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "id", "value": "id", "keyword": null, "type": 0, "flags": 0, "position": 79 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 81 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 82 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "test", "value": "test", "keyword": null, "type": 0, "flags": 0, "position": 87 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 91 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`users`", "value": "users", "keyword": null, "type": 8, "flags": 2, "position": 92 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 99 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "username", "value": "username", "keyword": null, "type": 0, "flags": 0, "position": 100 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 108 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AS", "value": "AS", "keyword": "AS", "type": 1, "flags": 3, "position": 109 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 111 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FROM", "value": "FROM", "keyword": "FROM", "type": 1, "flags": 3, "position": 112 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 116 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`test`", "value": "test", "keyword": null, "type": 8, "flags": 2, "position": 121 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 127 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "users", "value": "users", "keyword": null, "type": 0, "flags": 0, "position": 128 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 133 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "PARTITION", "value": "PARTITION", "keyword": "PARTITION", "type": 1, "flags": 3, "position": 138 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 147 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 148 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "p1", "value": "p1", "keyword": null, "type": 0, "flags": 0, "position": 149 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 151 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 152 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "p2", "value": "p2", "keyword": null, "type": 0, "flags": 0, "position": 153 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 155 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 156 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "WHERE", "value": "WHERE", "keyword": "WHERE", "type": 1, "flags": 3, "position": 157 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 162 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "id", "value": "id", "keyword": null, "type": 0, "flags": 0, "position": 167 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 169 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ">", "value": ">", "keyword": null, "type": 2, "flags": 2, "position": 170 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 171 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "0", "value": 0, "keyword": null, "type": 6, "flags": 0, "position": 172 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 173 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "ORDER BY", "value": "ORDER BY", "keyword": "ORDER BY", "type": 1, "flags": 7, "position": 174 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 182 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "username", "value": "username", "keyword": null, "type": 0, "flags": 0, "position": 187 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 195 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DESC", "value": "DESC", "keyword": "DESC", "type": 1, "flags": 3, "position": 196 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 200 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 201 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "id", "value": "id", "keyword": null, "type": 0, "flags": 0, "position": 206 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 208 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "LIMIT", "value": "LIMIT", "keyword": "LIMIT", "type": 1, "flags": 3, "position": 209 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 214 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "2", "value": 2, "keyword": null, "type": 6, "flags": 0, "position": 215 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 216 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 217 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "3", "value": 3, "keyword": null, "type": 6, "flags": 0, "position": 218 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 9, "flags": 0, "position": 219 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": null, "value": null, "keyword": null, "type": 9, "flags": 0, "position": null } ], "count": 77, "idx": 77 }, "DEFAULT_DELIMITER": ";", "delimiter": ";", "delimiterLen": 1, "strict": false, "errors": [] }, "parser": { "@type": "PhpMyAdmin\\SqlParser\\Parser", "STATEMENT_PARSERS": { "DESCRIBE": "PhpMyAdmin\\SqlParser\\Statements\\ExplainStatement", "DESC": "PhpMyAdmin\\SqlParser\\Statements\\ExplainStatement", "EXPLAIN": "PhpMyAdmin\\SqlParser\\Statements\\ExplainStatement", "FLUSH": "", "GRANT": "", "HELP": "", "SET PASSWORD": "", "STATUS": "", "USE": "", "ANALYZE": "PhpMyAdmin\\SqlParser\\Statements\\AnalyzeStatement", "BACKUP": "PhpMyAdmin\\SqlParser\\Statements\\BackupStatement", "CHECK": "PhpMyAdmin\\SqlParser\\Statements\\CheckStatement", "CHECKSUM": "PhpMyAdmin\\SqlParser\\Statements\\ChecksumStatement", "OPTIMIZE": "PhpMyAdmin\\SqlParser\\Statements\\OptimizeStatement", "REPAIR": "PhpMyAdmin\\SqlParser\\Statements\\RepairStatement", "RESTORE": "PhpMyAdmin\\SqlParser\\Statements\\RestoreStatement", "SET": "PhpMyAdmin\\SqlParser\\Statements\\SetStatement", "SHOW": "PhpMyAdmin\\SqlParser\\Statements\\ShowStatement", "ALTER": "PhpMyAdmin\\SqlParser\\Statements\\AlterStatement", "CREATE": "PhpMyAdmin\\SqlParser\\Statements\\CreateStatement", "DROP": "PhpMyAdmin\\SqlParser\\Statements\\DropStatement", "RENAME": "PhpMyAdmin\\SqlParser\\Statements\\RenameStatement", "TRUNCATE": "PhpMyAdmin\\SqlParser\\Statements\\TruncateStatement", "CALL": "PhpMyAdmin\\SqlParser\\Statements\\CallStatement", "DELETE": "PhpMyAdmin\\SqlParser\\Statements\\DeleteStatement", "DO": "", "HANDLER": "", "INSERT": "PhpMyAdmin\\SqlParser\\Statements\\InsertStatement", "LOAD DATA": "PhpMyAdmin\\SqlParser\\Statements\\LoadStatement", "REPLACE": "PhpMyAdmin\\SqlParser\\Statements\\ReplaceStatement", "SELECT": "PhpMyAdmin\\SqlParser\\Statements\\SelectStatement", "UPDATE": "PhpMyAdmin\\SqlParser\\Statements\\UpdateStatement", "WITH": "PhpMyAdmin\\SqlParser\\Statements\\WithStatement", "DEALLOCATE": "", "EXECUTE": "", "PREPARE": "", "BEGIN": "PhpMyAdmin\\SqlParser\\Statements\\TransactionStatement", "COMMIT": "PhpMyAdmin\\SqlParser\\Statements\\TransactionStatement", "ROLLBACK": "PhpMyAdmin\\SqlParser\\Statements\\TransactionStatement", "START TRANSACTION": "PhpMyAdmin\\SqlParser\\Statements\\TransactionStatement", "PURGE": "PhpMyAdmin\\SqlParser\\Statements\\PurgeStatement", "LOCK": "PhpMyAdmin\\SqlParser\\Statements\\LockStatement", "UNLOCK": "PhpMyAdmin\\SqlParser\\Statements\\LockStatement" }, "KEYWORD_PARSERS": { "PARTITION BY": [], "SUBPARTITION BY": [], "_OPTIONS": { "class": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "field": "options" }, "_END_OPTIONS": { "class": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "field": "end_options" }, "INTERSECT": { "class": "PhpMyAdmin\\SqlParser\\Components\\UnionKeyword", "field": "union" }, "EXCEPT": { "class": "PhpMyAdmin\\SqlParser\\Components\\UnionKeyword", "field": "union" }, "UNION": { "class": "PhpMyAdmin\\SqlParser\\Components\\UnionKeyword", "field": "union" }, "UNION ALL": { "class": "PhpMyAdmin\\SqlParser\\Components\\UnionKeyword", "field": "union" }, "UNION DISTINCT": { "class": "PhpMyAdmin\\SqlParser\\Components\\UnionKeyword", "field": "union" }, "ALTER": { "class": "PhpMyAdmin\\SqlParser\\Components\\Expression", "field": "table", "options": { "parseField": "table" } }, "ANALYZE": { "class": "PhpMyAdmin\\SqlParser\\Components\\ExpressionArray", "field": "tables", "options": { "parseField": "table" } }, "BACKUP": { "class": "PhpMyAdmin\\SqlParser\\Components\\ExpressionArray", "field": "tables", "options": { "parseField": "table" } }, "CALL": { "class": "PhpMyAdmin\\SqlParser\\Components\\FunctionCall", "field": "call" }, "CHECK": { "class": "PhpMyAdmin\\SqlParser\\Components\\ExpressionArray", "field": "tables", "options": { "parseField": "table" } }, "CHECKSUM": { "class": "PhpMyAdmin\\SqlParser\\Components\\ExpressionArray", "field": "tables", "options": { "parseField": "table" } }, "CROSS JOIN": { "class": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "field": "join" }, "DROP": { "class": "PhpMyAdmin\\SqlParser\\Components\\ExpressionArray", "field": "fields", "options": { "parseField": "table" } }, "FORCE": { "class": "PhpMyAdmin\\SqlParser\\Components\\IndexHint", "field": "index_hints" }, "FROM": { "class": "PhpMyAdmin\\SqlParser\\Components\\ExpressionArray", "field": "from", "options": { "field": "table" } }, "GROUP BY": { "class": "PhpMyAdmin\\SqlParser\\Components\\GroupKeyword", "field": "group" }, "HAVING": { "class": "PhpMyAdmin\\SqlParser\\Components\\Condition", "field": "having" }, "IGNORE": { "class": "PhpMyAdmin\\SqlParser\\Components\\IndexHint", "field": "index_hints" }, "INTO": { "class": "PhpMyAdmin\\SqlParser\\Components\\IntoKeyword", "field": "into" }, "JOIN": { "class": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "field": "join" }, "LEFT JOIN": { "class": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "field": "join" }, "LEFT OUTER JOIN": { "class": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "field": "join" }, "ON": { "class": "PhpMyAdmin\\SqlParser\\Components\\Expression", "field": "table", "options": { "parseField": "table" } }, "RIGHT JOIN": { "class": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "field": "join" }, "RIGHT OUTER JOIN": { "class": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "field": "join" }, "INNER JOIN": { "class": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "field": "join" }, "FULL JOIN": { "class": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "field": "join" }, "FULL OUTER JOIN": { "class": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "field": "join" }, "NATURAL JOIN": { "class": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "field": "join" }, "NATURAL LEFT JOIN": { "class": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "field": "join" }, "NATURAL RIGHT JOIN": { "class": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "field": "join" }, "NATURAL LEFT OUTER JOIN": { "class": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "field": "join" }, "NATURAL RIGHT OUTER JOIN": { "class": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "field": "join" }, "STRAIGHT_JOIN": { "class": "PhpMyAdmin\\SqlParser\\Components\\JoinKeyword", "field": "join" }, "LIMIT": { "class": "PhpMyAdmin\\SqlParser\\Components\\Limit", "field": "limit" }, "OPTIMIZE": { "class": "PhpMyAdmin\\SqlParser\\Components\\ExpressionArray", "field": "tables", "options": { "parseField": "table" } }, "ORDER BY": { "class": "PhpMyAdmin\\SqlParser\\Components\\OrderKeyword", "field": "order" }, "PARTITION": { "class": "PhpMyAdmin\\SqlParser\\Components\\ArrayObj", "field": "partition" }, "PROCEDURE": { "class": "PhpMyAdmin\\SqlParser\\Components\\FunctionCall", "field": "procedure" }, "RENAME": { "class": "PhpMyAdmin\\SqlParser\\Components\\RenameOperation", "field": "renames" }, "REPAIR": { "class": "PhpMyAdmin\\SqlParser\\Components\\ExpressionArray", "field": "tables", "options": { "parseField": "table" } }, "RESTORE": { "class": "PhpMyAdmin\\SqlParser\\Components\\ExpressionArray", "field": "tables", "options": { "parseField": "table" } }, "SET": { "class": "PhpMyAdmin\\SqlParser\\Components\\SetOperation", "field": "set" }, "SELECT": { "class": "PhpMyAdmin\\SqlParser\\Components\\ExpressionArray", "field": "expr" }, "TRUNCATE": { "class": "PhpMyAdmin\\SqlParser\\Components\\Expression", "field": "table", "options": { "parseField": "table" } }, "UPDATE": { "class": "PhpMyAdmin\\SqlParser\\Components\\ExpressionArray", "field": "tables", "options": { "parseField": "table" } }, "USE": { "class": "PhpMyAdmin\\SqlParser\\Components\\IndexHint", "field": "index_hints" }, "VALUE": { "class": "PhpMyAdmin\\SqlParser\\Components\\Array2d", "field": "values" }, "VALUES": { "class": "PhpMyAdmin\\SqlParser\\Components\\Array2d", "field": "values" }, "WHERE": { "class": "PhpMyAdmin\\SqlParser\\Components\\Condition", "field": "where" } }, "list": { "@type": "@1" }, "statements": [ { "@type": "PhpMyAdmin\\SqlParser\\Statements\\SelectStatement", "OPTIONS": { "ALL": 1, "DISTINCT": 1, "DISTINCTROW": 1, "HIGH_PRIORITY": 2, "MAX_STATEMENT_TIME": [ 3, "var=" ], "STRAIGHT_JOIN": 4, "SQL_SMALL_RESULT": 5, "SQL_BIG_RESULT": 6, "SQL_BUFFER_RESULT": 7, "SQL_CACHE": 8, "SQL_NO_CACHE": 8, "SQL_CALC_FOUND_ROWS": 9 }, "END_OPTIONS": { "FOR UPDATE": 1, "LOCK IN SHARE MODE": 1 }, "CLAUSES": { "SELECT": [ "SELECT", 2 ], "_OPTIONS": [ "_OPTIONS", 1 ], "_SELECT": [ "SELECT", 1 ], "INTO": [ "INTO", 3 ], "FROM": [ "FROM", 3 ], "FORCE": [ "FORCE", 1 ], "USE": [ "USE", 1 ], "IGNORE": [ "IGNORE", 3 ], "PARTITION": [ "PARTITION", 3 ], "JOIN": [ "JOIN", 1 ], "FULL JOIN": [ "FULL JOIN", 1 ], "INNER JOIN": [ "INNER JOIN", 1 ], "LEFT JOIN": [ "LEFT JOIN", 1 ], "LEFT OUTER JOIN": [ "LEFT OUTER JOIN", 1 ], "RIGHT JOIN": [ "RIGHT JOIN", 1 ], "RIGHT OUTER JOIN": [ "RIGHT OUTER JOIN", 1 ], "NATURAL JOIN": [ "NATURAL JOIN", 1 ], "NATURAL LEFT JOIN": [ "NATURAL LEFT JOIN", 1 ], "NATURAL RIGHT JOIN": [ "NATURAL RIGHT JOIN", 1 ], "NATURAL LEFT OUTER JOIN": [ "NATURAL LEFT OUTER JOIN", 1 ], "NATURAL RIGHT OUTER JOIN": [ "NATURAL RIGHT JOIN", 1 ], "WHERE": [ "WHERE", 3 ], "GROUP BY": [ "GROUP BY", 3 ], "HAVING": [ "HAVING", 3 ], "ORDER BY": [ "ORDER BY", 3 ], "LIMIT": [ "LIMIT", 3 ], "PROCEDURE": [ "PROCEDURE", 3 ], "UNION": [ "UNION", 1 ], "EXCEPT": [ "EXCEPT", 1 ], "INTERSECT": [ "INTERSECT", 1 ], "_END_OPTIONS": [ "_END_OPTIONS", 1 ] }, "expr": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "ALLOWED_KEYWORDS": { "AS": 1, "DUAL": 1, "NULL": 1, "REGEXP": 1, "CASE": 1, "DIV": 1, "AND": 1, "OR": 1, "XOR": 1, "NOT": 1, "MOD": 1 }, "database": null, "table": null, "column": null, "expr": "1 + 2", "alias": "result", "function": null, "subquery": null }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "ALLOWED_KEYWORDS": { "AS": 1, "DUAL": 1, "NULL": 1, "REGEXP": 1, "CASE": 1, "DIV": 1, "AND": 1, "OR": 1, "XOR": 1, "NOT": 1, "MOD": 1 }, "database": null, "table": null, "column": null, "expr": "@idx", "alias": null, "function": null, "subquery": null }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "ALLOWED_KEYWORDS": { "AS": 1, "DUAL": 1, "NULL": 1, "REGEXP": 1, "CASE": 1, "DIV": 1, "AND": 1, "OR": 1, "XOR": 1, "NOT": 1, "MOD": 1 }, "database": null, "table": null, "column": "id", "expr": "id", "alias": null, "function": null, "subquery": null }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "ALLOWED_KEYWORDS": { "AS": 1, "DUAL": 1, "NULL": 1, "REGEXP": 1, "CASE": 1, "DIV": 1, "AND": 1, "OR": 1, "XOR": 1, "NOT": 1, "MOD": 1 }, "database": "test", "table": "users", "column": "username", "expr": "test.`users`.username", "alias": null, "function": null, "subquery": null } ], "from": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "ALLOWED_KEYWORDS": { "AS": 1, "DUAL": 1, "NULL": 1, "REGEXP": 1, "CASE": 1, "DIV": 1, "AND": 1, "OR": 1, "XOR": 1, "NOT": 1, "MOD": 1 }, "database": "test", "table": "users", "column": null, "expr": "`test`.users", "alias": null, "function": null, "subquery": null } ], "index_hints": null, "partition": { "@type": "PhpMyAdmin\\SqlParser\\Components\\ArrayObj", "raw": [ "p1", "p2" ], "values": [ "p1", "p2" ] }, "where": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Condition", "DELIMITERS": [ "&&", "||", "AND", "OR", "XOR" ], "ALLOWED_KEYWORDS": { "ALL": 1, "AND": 1, "BETWEEN": 1, "EXISTS": 1, "IF": 1, "IN": 1, "INTERVAL": 1, "IS": 1, "LIKE": 1, "MATCH": 1, "NOT IN": 1, "NOT NULL": 1, "NOT": 1, "NULL": 1, "OR": 1, "REGEXP": 1, "RLIKE": 1, "SOUNDS": 1, "XOR": 1 }, "identifiers": [ "id" ], "isOperator": false, "expr": "id > 0" } ], "group": null, "having": null, "order": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\OrderKeyword", "expr": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "ALLOWED_KEYWORDS": { "AS": 1, "DUAL": 1, "NULL": 1, "REGEXP": 1, "CASE": 1, "DIV": 1, "AND": 1, "OR": 1, "XOR": 1, "NOT": 1, "MOD": 1 }, "database": null, "table": null, "column": "username", "expr": "username", "alias": null, "function": null, "subquery": null }, "type": "DESC" }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\OrderKeyword", "expr": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "ALLOWED_KEYWORDS": { "AS": 1, "DUAL": 1, "NULL": 1, "REGEXP": 1, "CASE": 1, "DIV": 1, "AND": 1, "OR": 1, "XOR": 1, "NOT": 1, "MOD": 1 }, "database": null, "table": null, "column": "id", "expr": "id", "alias": null, "function": null, "subquery": null }, "type": "ASC" } ], "limit": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Limit", "offset": 2, "rowCount": 3 }, "procedure": null, "into": null, "join": null, "union": [], "end_options": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "1": "ALL", "3": { "name": "MAX_STATEMENT_TIME", "equals": true, "expr": "10", "value": "10" }, "13": "DISTINCT" } }, "first": 0, "last": 74 } ], "brackets": 0, "strict": false, "errors": [] }, "errors": { "lexer": [], "parser": [ [ "This option conflicts with \"ALL\".", { "@type": "@6" }, 0 ], [ "An alias was expected.", { "@type": "@38" }, 0 ] ] } }