{ "query": "SELECT ALL MAX_STATEMENT_TIME = 10\n 1 + 2 AS result,\n @idx,\n id,\n test.`users`.username AS `name`\nFROM\n `test`.users, posts\n PARTITION (p1, p2)\nWHERE\n id > 0\nORDER BY\n username DESC,\n id\nLIMIT 3 OFFSET 2;", "lexer": { "@type": "PhpMyAdmin\\SqlParser\\Lexer", "str": "SELECT ALL MAX_STATEMENT_TIME = 10\n 1 + 2 AS result,\n @idx,\n id,\n test.`users`.username AS `name`\nFROM\n `test`.users, posts\n PARTITION (p1, p2)\nWHERE\n id > 0\nORDER BY\n username DESC,\n id\nLIMIT 3 OFFSET 2;", "len": 231, "last": 231, "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": "MAX_STATEMENT_TIME", "value": "MAX_STATEMENT_TIME", "keyword": "MAX_STATEMENT_TIME", "type": 1, "flags": 1, "position": 11 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 29 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 30 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 31 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "10", "value": 10, "keyword": null, "type": 6, "flags": 0, "position": 32 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 34 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "1", "value": 1, "keyword": null, "type": 6, "flags": 0, "position": 39 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 40 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "+", "value": "+", "keyword": null, "type": 2, "flags": 1, "position": 41 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 42 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "2", "value": 2, "keyword": null, "type": 6, "flags": 0, "position": 43 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 44 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AS", "value": "AS", "keyword": "AS", "type": 1, "flags": 3, "position": 45 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 47 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "result", "value": "result", "keyword": null, "type": 0, "flags": 0, "position": 48 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 54 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 55 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "@idx", "value": "idx", "keyword": null, "type": 8, "flags": 1, "position": 60 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 64 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 65 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "id", "value": "id", "keyword": null, "type": 0, "flags": 0, "position": 70 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 72 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 73 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "test", "value": "test", "keyword": null, "type": 0, "flags": 0, "position": 78 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 82 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`users`", "value": "users", "keyword": null, "type": 8, "flags": 2, "position": 83 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 90 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "username", "value": "username", "keyword": null, "type": 0, "flags": 0, "position": 91 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 99 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AS", "value": "AS", "keyword": "AS", "type": 1, "flags": 3, "position": 100 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 102 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`name`", "value": "name", "keyword": null, "type": 8, "flags": 2, "position": 103 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 109 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FROM", "value": "FROM", "keyword": "FROM", "type": 1, "flags": 3, "position": 110 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 114 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "`test`", "value": "test", "keyword": null, "type": 8, "flags": 2, "position": 119 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 125 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "users", "value": "users", "keyword": null, "type": 0, "flags": 0, "position": 126 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 131 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 132 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "posts", "value": "posts", "keyword": null, "type": 0, "flags": 0, "position": 133 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 138 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "PARTITION", "value": "PARTITION", "keyword": "PARTITION", "type": 1, "flags": 3, "position": 143 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 152 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 153 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "p1", "value": "p1", "keyword": null, "type": 0, "flags": 0, "position": 154 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 156 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 157 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "p2", "value": "p2", "keyword": null, "type": 0, "flags": 0, "position": 158 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 160 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 161 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "WHERE", "value": "WHERE", "keyword": "WHERE", "type": 1, "flags": 3, "position": 162 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 167 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "id", "value": "id", "keyword": null, "type": 0, "flags": 0, "position": 172 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 174 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ">", "value": ">", "keyword": null, "type": 2, "flags": 2, "position": 175 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 176 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "0", "value": 0, "keyword": null, "type": 6, "flags": 0, "position": 177 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 178 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "ORDER BY", "value": "ORDER BY", "keyword": "ORDER BY", "type": 1, "flags": 7, "position": 179 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 187 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "username", "value": "username", "keyword": null, "type": 0, "flags": 0, "position": 192 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 200 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DESC", "value": "DESC", "keyword": "DESC", "type": 1, "flags": 3, "position": 201 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 205 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 206 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "id", "value": "id", "keyword": null, "type": 0, "flags": 0, "position": 211 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 213 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "LIMIT", "value": "LIMIT", "keyword": "LIMIT", "type": 1, "flags": 3, "position": 214 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 219 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "3", "value": 3, "keyword": null, "type": 6, "flags": 0, "position": 220 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 221 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "OFFSET", "value": "OFFSET", "keyword": "OFFSET", "type": 1, "flags": 1, "position": 222 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 228 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "2", "value": 2, "keyword": null, "type": 6, "flags": 0, "position": 229 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 9, "flags": 0, "position": 230 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": null, "value": null, "keyword": null, "type": 9, "flags": 0, "position": null } ], "count": 81, "idx": 81 }, "delimiter": ";", "delimiterLen": 1, "strict": false, "errors": [] }, "parser": { "@type": "PhpMyAdmin\\SqlParser\\Parser", "list": { "@type": "@1" }, "statements": [ { "@type": "PhpMyAdmin\\SqlParser\\Statements\\SelectStatement", "expr": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": null, "column": null, "expr": "1 + 2", "alias": "result", "function": null, "subquery": null }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": null, "column": null, "expr": "@idx", "alias": null, "function": null, "subquery": null }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": null, "column": "id", "expr": "id", "alias": null, "function": null, "subquery": null }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": "test", "table": "users", "column": "username", "expr": "test.`users`.username", "alias": "name", "function": null, "subquery": null } ], "from": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": "test", "table": "users", "column": null, "expr": "`test`.users", "alias": null, "function": null, "subquery": null }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "posts", "column": null, "expr": "posts", "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", "identifiers": [ "id" ], "isOperator": false, "expr": "id > 0" } ], "group": null, "group_options": null, "having": null, "order": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\OrderKeyword", "expr": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "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", "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" } } }, "first": 0, "last": 78 } ], "brackets": 0, "strict": false, "errors": [] }, "errors": { "lexer": [], "parser": [] } }