{
    "query": "ALTER TABLE d PARTITION BY RANGE (MONTH(departure_date))\n(\nPARTITION p01 VALUES LESS THAN (02) ,\nPARTITION pmaxval VALUES LESS THAN MAXVALUE\n);\n",
    "lexer": {
        "@type": "PhpMyAdmin\\SqlParser\\Lexer",
        "str": "ALTER TABLE d PARTITION BY RANGE (MONTH(departure_date))\n(\nPARTITION p01 VALUES LESS THAN (02) ,\nPARTITION pmaxval VALUES LESS THAN MAXVALUE\n);\n",
        "len": 144,
        "last": 144,
        "list": {
            "@type": "PhpMyAdmin\\SqlParser\\TokensList",
            "tokens": [
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "ALTER",
                    "value": "ALTER",
                    "keyword": "ALTER",
                    "type": 1,
                    "flags": 3,
                    "position": 0
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 5
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "TABLE",
                    "value": "TABLE",
                    "keyword": "TABLE",
                    "type": 1,
                    "flags": 3,
                    "position": 6
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 11
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "d",
                    "value": "d",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 12
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 13
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "PARTITION BY",
                    "value": "PARTITION BY",
                    "keyword": "PARTITION BY",
                    "type": 1,
                    "flags": 7,
                    "position": 14
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 26
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "RANGE",
                    "value": "RANGE",
                    "keyword": "RANGE",
                    "type": 1,
                    "flags": 3,
                    "position": 27
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 32
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 33
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "MONTH",
                    "value": "MONTH",
                    "keyword": "MONTH",
                    "type": 1,
                    "flags": 33,
                    "position": 34
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 39
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "departure_date",
                    "value": "departure_date",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 40
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 54
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 55
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 56
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 57
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 58
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "PARTITION",
                    "value": "PARTITION",
                    "keyword": "PARTITION",
                    "type": 1,
                    "flags": 3,
                    "position": 59
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 68
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "p01",
                    "value": "p01",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 69
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 72
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "VALUES",
                    "value": "VALUES",
                    "keyword": "VALUES",
                    "type": 1,
                    "flags": 35,
                    "position": 73
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 79
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "LESS THAN",
                    "value": "LESS THAN",
                    "keyword": "LESS THAN",
                    "type": 1,
                    "flags": 7,
                    "position": 80
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 89
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "(",
                    "value": "(",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 90
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "02",
                    "value": 2,
                    "keyword": null,
                    "type": 6,
                    "flags": 0,
                    "position": 91
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 93
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 94
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ",",
                    "value": ",",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 95
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 96
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "PARTITION",
                    "value": "PARTITION",
                    "keyword": "PARTITION",
                    "type": 1,
                    "flags": 3,
                    "position": 97
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 106
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "pmaxval",
                    "value": "pmaxval",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 107
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 114
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "VALUES",
                    "value": "VALUES",
                    "keyword": "VALUES",
                    "type": 1,
                    "flags": 35,
                    "position": 115
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 121
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "LESS THAN",
                    "value": "LESS THAN",
                    "keyword": "LESS THAN",
                    "type": 1,
                    "flags": 7,
                    "position": 122
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 131
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "MAXVALUE",
                    "value": "MAXVALUE",
                    "keyword": "MAXVALUE",
                    "type": 1,
                    "flags": 3,
                    "position": 132
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 140
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ")",
                    "value": ")",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 141
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ";",
                    "value": ";",
                    "keyword": null,
                    "type": 9,
                    "flags": 0,
                    "position": 142
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 143
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": null,
                    "value": null,
                    "keyword": null,
                    "type": 9,
                    "flags": 0,
                    "position": null
                }
            ],
            "count": 47,
            "idx": 47
        },
        "delimiter": ";",
        "delimiterLen": 1,
        "strict": false,
        "errors": []
    },
    "parser": {
        "@type": "PhpMyAdmin\\SqlParser\\Parser",
        "list": {
            "@type": "@1"
        },
        "statements": [
            {
                "@type": "PhpMyAdmin\\SqlParser\\Statements\\AlterStatement",
                "table": {
                    "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                    "database": null,
                    "table": "d",
                    "column": null,
                    "expr": "d",
                    "alias": null,
                    "function": null,
                    "subquery": null
                },
                "altered": [
                    {
                        "@type": "PhpMyAdmin\\SqlParser\\Components\\AlterOperation",
                        "options": {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                            "options": {
                                "2": "PARTITION BY"
                            }
                        },
                        "field": " RANGE (MONTH(departure_date)) ",
                        "partitions": [
                            {
                                "@type": "PhpMyAdmin\\SqlParser\\Components\\PartitionDefinition",
                                "isSubpartition": false,
                                "name": "p01",
                                "type": "LESS THAN",
                                "expr": {
                                    "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                                    "database": null,
                                    "table": null,
                                    "column": null,
                                    "expr": "(02)",
                                    "alias": null,
                                    "function": null,
                                    "subquery": null
                                },
                                "subpartitions": null,
                                "options": {
                                    "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                                    "options": []
                                }
                            },
                            {
                                "@type": "PhpMyAdmin\\SqlParser\\Components\\PartitionDefinition",
                                "isSubpartition": false,
                                "name": "pmaxval",
                                "type": "LESS THAN",
                                "expr": "MAXVALUE",
                                "subpartitions": null,
                                "options": {
                                    "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                                    "options": []
                                }
                            }
                        ],
                        "unknown": []
                    }
                ],
                "options": {
                    "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                    "options": {
                        "3": "TABLE"
                    }
                },
                "first": 0,
                "last": 44
            }
        ],
        "brackets": 0,
        "strict": false,
        "errors": []
    },
    "errors": {
        "lexer": [],
        "parser": []
    }
}