{ "query": "CREATE TABLE ts(id INT, purchased DATE)\nPARTITION BY /* comment */ RANGE(YEAR(purchased))\nPARTITIONS 3\nSUBPARTITION BY HASH(TO_DAYS(purchased))\nSUBPARTITIONS 2(\nPARTITION p0\nVALUES LESS THAN(1990)(\n SUBPARTITION s0,\n SUBPARTITION s1\n),\nPARTITION p1\nVALUES LESS THAN(2000)(\n SUBPARTITION s2,\n SUBPARTITION s3\n),\nPARTITION p2\nVALUES LESS THAN MAXVALUE(\n SUBPARTITION s4,\n SUBPARTITION s5\n)\n);", "lexer": { "@type": "PhpMyAdmin\\SqlParser\\Lexer", "str": "CREATE TABLE ts(id INT, purchased DATE)\nPARTITION BY /* comment */ RANGE(YEAR(purchased))\nPARTITIONS 3\nSUBPARTITION BY HASH(TO_DAYS(purchased))\nSUBPARTITIONS 2(\nPARTITION p0\nVALUES LESS THAN(1990)(\n SUBPARTITION s0,\n SUBPARTITION s1\n),\nPARTITION p1\nVALUES LESS THAN(2000)(\n SUBPARTITION s2,\n SUBPARTITION s3\n),\nPARTITION p2\nVALUES LESS THAN MAXVALUE(\n SUBPARTITION s4,\n SUBPARTITION s5\n)\n);", "len": 408, "last": 408, "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": "ts", "value": "ts", "keyword": null, "type": 0, "flags": 0, "position": 13 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 15 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "id", "value": "id", "keyword": null, "type": 0, "flags": 0, "position": 16 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 18 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "INT", "value": "INT", "keyword": "INT", "type": 1, "flags": 11, "position": 19 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 22 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 23 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "purchased", "value": "purchased", "keyword": null, "type": 0, "flags": 0, "position": 24 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 33 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "DATE", "value": "DATE", "keyword": "DATE", "type": 1, "flags": 41, "position": 34 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 38 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 39 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "PARTITION BY", "value": "PARTITION BY", "keyword": "PARTITION BY", "type": 1, "flags": 7, "position": 40 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 52 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "/* comment */", "value": "/* comment */", "keyword": null, "type": 4, "flags": 2, "position": 53 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 66 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "RANGE", "value": "RANGE", "keyword": "RANGE", "type": 1, "flags": 3, "position": 67 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 72 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "YEAR", "value": "YEAR", "keyword": "YEAR", "type": 1, "flags": 41, "position": 73 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 77 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "purchased", "value": "purchased", "keyword": null, "type": 0, "flags": 0, "position": 78 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 87 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 88 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 89 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "PARTITIONS", "value": "PARTITIONS", "keyword": "PARTITIONS", "type": 1, "flags": 1, "position": 90 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 100 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "3", "value": 3, "keyword": null, "type": 6, "flags": 0, "position": 101 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 102 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SUBPARTITION BY", "value": "SUBPARTITION BY", "keyword": "SUBPARTITION BY", "type": 1, "flags": 7, "position": 103 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 118 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "HASH", "value": "HASH", "keyword": "HASH", "type": 1, "flags": 1, "position": 119 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 123 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "TO_DAYS", "value": "TO_DAYS", "keyword": "TO_DAYS", "type": 1, "flags": 33, "position": 124 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 131 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "purchased", "value": "purchased", "keyword": null, "type": 0, "flags": 0, "position": 132 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 141 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 142 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 143 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SUBPARTITIONS", "value": "SUBPARTITIONS", "keyword": "SUBPARTITIONS", "type": 1, "flags": 1, "position": 144 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 157 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "2", "value": 2, "keyword": null, "type": 6, "flags": 0, "position": 158 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 159 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 160 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "PARTITION", "value": "PARTITION", "keyword": "PARTITION", "type": 1, "flags": 3, "position": 161 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 170 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "p0", "value": "p0", "keyword": null, "type": 0, "flags": 0, "position": 171 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 173 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "VALUES", "value": "VALUES", "keyword": "VALUES", "type": 1, "flags": 35, "position": 174 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 180 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "LESS THAN", "value": "LESS THAN", "keyword": "LESS THAN", "type": 1, "flags": 7, "position": 181 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 190 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "1990", "value": 1990, "keyword": null, "type": 6, "flags": 0, "position": 191 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 195 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 196 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 197 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SUBPARTITION", "value": "SUBPARTITION", "keyword": "SUBPARTITION", "type": 1, "flags": 1, "position": 202 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 214 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "s0", "value": "s0", "keyword": null, "type": 0, "flags": 0, "position": 215 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 217 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 218 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SUBPARTITION", "value": "SUBPARTITION", "keyword": "SUBPARTITION", "type": 1, "flags": 1, "position": 223 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 235 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "s1", "value": "s1", "keyword": null, "type": 0, "flags": 0, "position": 236 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 238 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 239 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 240 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 241 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "PARTITION", "value": "PARTITION", "keyword": "PARTITION", "type": 1, "flags": 3, "position": 242 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 251 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "p1", "value": "p1", "keyword": null, "type": 0, "flags": 0, "position": 252 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 254 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "VALUES", "value": "VALUES", "keyword": "VALUES", "type": 1, "flags": 35, "position": 255 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 261 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "LESS THAN", "value": "LESS THAN", "keyword": "LESS THAN", "type": 1, "flags": 7, "position": 262 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 271 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "2000", "value": 2000, "keyword": null, "type": 6, "flags": 0, "position": 272 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 276 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 277 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 278 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SUBPARTITION", "value": "SUBPARTITION", "keyword": "SUBPARTITION", "type": 1, "flags": 1, "position": 283 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 295 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "s2", "value": "s2", "keyword": null, "type": 0, "flags": 0, "position": 296 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 298 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 299 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SUBPARTITION", "value": "SUBPARTITION", "keyword": "SUBPARTITION", "type": 1, "flags": 1, "position": 304 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 316 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "s3", "value": "s3", "keyword": null, "type": 0, "flags": 0, "position": 317 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 319 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 320 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 321 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 322 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "PARTITION", "value": "PARTITION", "keyword": "PARTITION", "type": 1, "flags": 3, "position": 323 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 332 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "p2", "value": "p2", "keyword": null, "type": 0, "flags": 0, "position": 333 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 335 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "VALUES", "value": "VALUES", "keyword": "VALUES", "type": 1, "flags": 35, "position": 336 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 342 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "LESS THAN", "value": "LESS THAN", "keyword": "LESS THAN", "type": 1, "flags": 7, "position": 343 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 352 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "MAXVALUE", "value": "MAXVALUE", "keyword": "MAXVALUE", "type": 1, "flags": 3, "position": 353 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 361 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 362 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SUBPARTITION", "value": "SUBPARTITION", "keyword": "SUBPARTITION", "type": 1, "flags": 1, "position": 367 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 379 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "s4", "value": "s4", "keyword": null, "type": 0, "flags": 0, "position": 380 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 382 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 383 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SUBPARTITION", "value": "SUBPARTITION", "keyword": "SUBPARTITION", "type": 1, "flags": 1, "position": 388 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 400 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "s5", "value": "s5", "keyword": null, "type": 0, "flags": 0, "position": 401 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 403 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 404 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "\n", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 405 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 406 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ";", "value": ";", "keyword": null, "type": 9, "flags": 0, "position": 407 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": null, "value": null, "keyword": null, "type": 9, "flags": 0, "position": null } ], "count": 120, "idx": 120 }, "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": "ts", "column": null, "expr": "ts", "alias": null, "function": null, "subquery": null }, "entityOptions": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] }, "fields": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition", "name": "id", "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": [] } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\CreateDefinition", "name": "purchased", "isConstraint": null, "type": { "@type": "PhpMyAdmin\\SqlParser\\Components\\DataType", "name": "DATE", "parameters": [], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } }, "key": null, "references": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } } ], "with": null, "select": null, "like": null, "partitionBy": "RANGE(YEAR(purchased))", "partitionsNum": 3, "subpartitionBy": "HASH(TO_DAYS(purchased))", "subpartitionsNum": 2, "partitions": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\PartitionDefinition", "isSubpartition": false, "name": "p0", "type": "LESS THAN", "expr": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": null, "column": null, "expr": "(1990)", "alias": null, "function": null, "subquery": null }, "subpartitions": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\PartitionDefinition", "isSubpartition": true, "name": "s0", "type": null, "expr": null, "subpartitions": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\PartitionDefinition", "isSubpartition": true, "name": "s1", "type": null, "expr": null, "subpartitions": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } } ], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\PartitionDefinition", "isSubpartition": false, "name": "p1", "type": "LESS THAN", "expr": { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": null, "column": null, "expr": "(2000)", "alias": null, "function": null, "subquery": null }, "subpartitions": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\PartitionDefinition", "isSubpartition": true, "name": "s2", "type": null, "expr": null, "subpartitions": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\PartitionDefinition", "isSubpartition": true, "name": "s3", "type": null, "expr": null, "subpartitions": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } } ], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\PartitionDefinition", "isSubpartition": false, "name": "p2", "type": "LESS THAN", "expr": "MAXVALUE", "subpartitions": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\PartitionDefinition", "isSubpartition": true, "name": "s4", "type": null, "expr": null, "subpartitions": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\PartitionDefinition", "isSubpartition": true, "name": "s5", "type": null, "expr": null, "subpartitions": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } } ], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] } } ], "table": null, "return": null, "parameters": null, "body": [], "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": { "6": "TABLE" } }, "first": 0, "last": 117 } ], "brackets": 0, "strict": false, "errors": [] }, "errors": { "lexer": [], "parser": [] } }