File: /home/xedaptot/360.naniguide.com/services/vendor/phpmyadmin/sql-parser/tests/data/parser/parse.out
{
"query": "SELECT 1;",
"lexer": {
"@type": "PhpMyAdmin\\SqlParser\\Lexer",
"PARSER_METHODS": [
"parseDelimiter",
"parseWhitespace",
"parseNumber",
"parseComment",
"parseOperator",
"parseBool",
"parseString",
"parseSymbol",
"parseKeyword",
"parseLabel",
"parseUnknown"
],
"str": "SELECT 1;",
"len": 9,
"last": 9,
"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": "1",
"value": 1,
"keyword": null,
"type": 6,
"flags": 0,
"position": 7
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": ";",
"value": ";",
"keyword": null,
"type": 9,
"flags": 0,
"position": 8
},
{
"@type": "PhpMyAdmin\\SqlParser\\Token",
"token": null,
"value": null,
"keyword": null,
"type": 9,
"flags": 0,
"position": null
}
],
"count": 5,
"idx": 5
},
"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",
"alias": null,
"function": null,
"subquery": null
}
],
"from": [],
"index_hints": null,
"partition": null,
"where": null,
"group": 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": 2
}
],
"brackets": 0,
"strict": false,
"errors": []
},
"errors": {
"lexer": [],
"parser": []
}
}