{ "query": "select (SELECT name FROM mysql.help_category WHERE help_category_id = 1) as name,\ntest=case 1 /* */ when 1 then \"Some\" when 2 then \"Other\" end /* */ AS /* */ foo FROM a;", "lexer": { "@type": "PhpMyAdmin\\SqlParser\\Lexer", "str": "select (SELECT name FROM mysql.help_category WHERE help_category_id = 1) as name,\ntest=case 1 /* */ when 1 then \"Some\" when 2 then \"Other\" end /* */ AS /* */ foo FROM a;", "len": 169, "last": 169, "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": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 7 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SELECT", "value": "SELECT", "keyword": "SELECT", "type": 1, "flags": 3, "position": 8 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 14 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "name", "value": "name", "keyword": "NAME", "type": 1, "flags": 1, "position": 15 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 19 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FROM", "value": "FROM", "keyword": "FROM", "type": 1, "flags": 3, "position": 20 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 24 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "mysql", "value": "mysql", "keyword": null, "type": 0, "flags": 0, "position": 25 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 30 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "help_category", "value": "help_category", "keyword": null, "type": 0, "flags": 0, "position": 31 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 44 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "WHERE", "value": "WHERE", "keyword": "WHERE", "type": 1, "flags": 3, "position": 45 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 50 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "help_category_id", "value": "help_category_id", "keyword": null, "type": 0, "flags": 0, "position": 51 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 67 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 68 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 69 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "1", "value": 1, "keyword": null, "type": 6, "flags": 0, "position": 70 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 71 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 72 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "as", "value": "AS", "keyword": "AS", "type": 1, "flags": 3, "position": 73 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 75 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "name", "value": "name", "keyword": "NAME", "type": 1, "flags": 1, "position": 76 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 80 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 81 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "test", "value": "test", "keyword": null, "type": 0, "flags": 0, "position": 82 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 86 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "case", "value": "CASE", "keyword": "CASE", "type": 1, "flags": 3, "position": 87 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 91 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "1", "value": 1, "keyword": null, "type": 6, "flags": 0, "position": 92 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 93 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "/* */", "value": "/* */", "keyword": null, "type": 4, "flags": 2, "position": 94 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 99 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "when", "value": "WHEN", "keyword": "WHEN", "type": 1, "flags": 3, "position": 100 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 104 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "1", "value": 1, "keyword": null, "type": 6, "flags": 0, "position": 105 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 106 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "then", "value": "THEN", "keyword": "THEN", "type": 1, "flags": 3, "position": 107 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 111 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\"Some\"", "value": "Some", "keyword": null, "type": 7, "flags": 2, "position": 112 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 118 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "when", "value": "WHEN", "keyword": "WHEN", "type": 1, "flags": 3, "position": 119 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 123 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "2", "value": 2, "keyword": null, "type": 6, "flags": 0, "position": 124 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 125 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "then", "value": "THEN", "keyword": "THEN", "type": 1, "flags": 3, "position": 126 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 130 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\"Other\"", "value": "Other", "keyword": null, "type": 7, "flags": 2, "position": 131 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 138 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "end", "value": "end", "keyword": "END", "type": 1, "flags": 1, "position": 139 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 142 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "/* */", "value": "/* */", "keyword": null, "type": 4, "flags": 2, "position": 143 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 148 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AS", "value": "AS", "keyword": "AS", "type": 1, "flags": 3, "position": 149 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 151 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "/* */", "value": "/* */", "keyword": null, "type": 4, "flags": 2, "position": 152 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 157 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "foo", "value": "foo", "keyword": null, "type": 0, "flags": 0, "position": 158 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 161 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FROM", "value": "FROM", "keyword": "FROM", "type": 1, "flags": 3, "position": 162 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 166 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "a", "value": "a", "keyword": null, "type": 0, "flags": 0, "position": 167 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 9, "flags": 0, "position": 168 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": null, "value": null, "keyword": null, "type": 9, "flags": 0, "position": null } ], "count": 66, "idx": 66 }, "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": "(SELECT name FROM mysql.help_category WHERE help_category_id = 1)", "alias": "name", "function": null, "subquery": "SELECT" }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": null, "column": "test", "expr": "test=CASE 1 /* */ WHEN 1 THEN \"Some\" WHEN 2 THEN \"Other\" END AS `foo`", "alias": null, "function": null, "subquery": null } ], "from": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "a", "column": null, "expr": "a", "alias": null, "function": null, "subquery": null } ], "index_hints": null, "partition": null, "where": null, "group": null, "group_options": null, "having": null, "order": null, "limit": null, "procedure": null, "into": null, "join": null, "union": [], "end_options": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] }, "first": 0, "last": 63 } ], "brackets": 0, "strict": false, "errors": [] }, "errors": { "lexer": [], "parser": [] } }