{ "query": "CREATE TABLE table1 (\n a INT NOT NULL,\n b VARCHAR(32),\n c INT AS (a mod 10) VIRTUAL,\n d VARCHAR(5) AS (left(b,5)) PERSISTENT\n);", "lexer": { "@type": "PhpMyAdmin\\SqlParser\\Lexer", "str": "CREATE TABLE table1 (\n a INT NOT NULL,\n b VARCHAR(32),\n c INT AS (a mod 10) VIRTUAL,\n d VARCHAR(5) AS (left(b,5)) PERSISTENT\n);", "len": 139, "last": 139, "list": { "@type": "PhpMyAdmin\\SqlParser\\TokensList", "tokens": [ { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "CREATE", "value": "CREATE", "keyword": "CREATE", "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": "TABLE", "value": "TABLE", "keyword": "TABLE", "type": 1, "flags": 3, "position": 7 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 12 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "table1", "value": "table1", "keyword": null, "type": 0, "flags": 0, "position": 13 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 19 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 20 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 21 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "a", "value": "a", "keyword": null, "type": 0, "flags": 0, "position": 26 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 27 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "INT", "value": "INT", "keyword": "INT", "type": 1, "flags": 11, "position": 28 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 31 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "NOT NULL", "value": "NOT NULL", "keyword": "NOT NULL", "type": 1, "flags": 7, "position": 32 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 40 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 41 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "b", "value": "b", "keyword": null, "type": 0, "flags": 0, "position": 46 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 47 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "VARCHAR", "value": "VARCHAR", "keyword": "VARCHAR", "type": 1, "flags": 11, "position": 48 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 55 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "32", "value": 32, "keyword": null, "type": 6, "flags": 0, "position": 56 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 58 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 59 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 60 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "c", "value": "c", "keyword": null, "type": 0, "flags": 0, "position": 65 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 66 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "INT", "value": "INT", "keyword": "INT", "type": 1, "flags": 11, "position": 67 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 70 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AS", "value": "AS", "keyword": "AS", "type": 1, "flags": 3, "position": 71 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 73 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 74 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "a", "value": "a", "keyword": null, "type": 0, "flags": 0, "position": 75 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 76 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "mod", "value": "MOD", "keyword": "MOD", "type": 1, "flags": 35, "position": 77 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 80 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "10", "value": 10, "keyword": null, "type": 6, "flags": 0, "position": 81 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 83 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 84 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "VIRTUAL", "value": "VIRTUAL", "keyword": "VIRTUAL", "type": 1, "flags": 3, "position": 85 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 92 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 93 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "d", "value": "d", "keyword": null, "type": 0, "flags": 0, "position": 98 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 99 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "VARCHAR", "value": "VARCHAR", "keyword": "VARCHAR", "type": 1, "flags": 11, "position": 100 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 107 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "5", "value": 5, "keyword": null, "type": 6, "flags": 0, "position": 108 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 109 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 110 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AS", "value": "AS", "keyword": "AS", "type": 1, "flags": 3, "position": 111 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 113 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 114 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "left", "value": "LEFT", "keyword": "LEFT", "type": 1, "flags": 35, "position": 115 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 119 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "b", "value": "b", "keyword": null, "type": 0, "flags": 0, "position": 120 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 121 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "5", "value": 5, "keyword": null, "type": 6, "flags": 0, "position": 122 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 123 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 124 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 125 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "PERSISTENT", "value": "PERSISTENT", "keyword": "PERSISTENT", "type": 1, "flags": 1, "position": 126 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 136 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 137 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 9, "flags": 0, "position": 138 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": null, "value": null, "keyword": null, "type": 9, "flags": 0, "position": null } ], "count": 63, "idx": 63 }, "delimiter": ";", "delimiterLen": 1, "strict": false, "errors": [] }, "parser": { "@type": "PhpMyAdmin\\SqlParser\\Parser", "list": { "@type": "@1" }, "statements": [ { "@type": "PhpMyAdmin\\SqlParser\\Statements\\CreateStatement", "name": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "table1", "column": null, "expr": "table1", "alias": null, "function": null, "subquery": null }, "entityOptions": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] }, "fields": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition", "name": "a", "isConstraint": null, "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "INT", "parameters": [], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } }, "key": null, "references": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "1": "NOT NULL" } } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition", "name": "b", "isConstraint": null, "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "VARCHAR", "parameters": [ "32" ], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } }, "key": null, "references": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition", "name": "c", "isConstraint": null, "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "INT", "parameters": [], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } }, "key": null, "references": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "9": { "name": "AS", "equals": false, "expr": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": null, "column": null, "expr": "(a mod 10)", "alias": null, "function": null, "subquery": null }, "value": "(a mod 10)" }, "10": "VIRTUAL" } } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition", "name": "d", "isConstraint": null, "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "VARCHAR", "parameters": [ "5" ], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } }, "key": null, "references": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "9": { "name": "AS", "equals": false, "expr": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": null, "column": null, "expr": "(left(b,5))", "alias": null, "function": "LEFT", "subquery": null }, "value": "(left(b,5))" }, "11": "PERSISTENT" } } } ], "with": null, "select": null, "like": null, "partitionBy": null, "partitionsNum": null, "subpartitionBy": null, "subpartitionsNum": null, "partitions": null, "table": null, "return": null, "parameters": null, "body": [], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "6": "TABLE" } }, "first": 0, "last": 61 } ], "brackets": 0, "strict": false, "errors": [] }, "errors": { "lexer": [], "parser": [] } }