{
    "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": []
    }
}