{
    "query": "-- Query from https://github.com/phpmyadmin/sql-parser/issues/578\n-- Issue was that Lexer detected \".e1\" as number token.\n\nLOAD DATA LOCAL INFILE '/home/user/myloadfile.csv'\nIGNORE INTO TABLE erp.e1_table\nFIELDS TERMINATED BY '\\t'\nLINES TERMINATED BY '\\n'\nIGNORE 0 LINES;\n",
    "lexer": {
        "@type": "PhpMyAdmin\\SqlParser\\Lexer",
        "str": "-- Query from https://github.com/phpmyadmin/sql-parser/issues/578\n-- Issue was that Lexer detected \".e1\" as number token.\n\nLOAD DATA LOCAL INFILE '/home/user/myloadfile.csv'\nIGNORE INTO TABLE erp.e1_table\nFIELDS TERMINATED BY '\\t'\nLINES TERMINATED BY '\\n'\nIGNORE 0 LINES;\n",
        "len": 272,
        "last": 272,
        "list": {
            "@type": "PhpMyAdmin\\SqlParser\\TokensList",
            "tokens": [
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "-- Query from https://github.com/phpmyadmin/sql-parser/issues/578",
                    "value": "-- Query from https://github.com/phpmyadmin/sql-parser/issues/578",
                    "keyword": null,
                    "type": 4,
                    "flags": 4,
                    "position": 0
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 65
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "-- Issue was that Lexer detected \".e1\" as number token.",
                    "value": "-- Issue was that Lexer detected \".e1\" as number token.",
                    "keyword": null,
                    "type": 4,
                    "flags": 4,
                    "position": 66
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 121
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "LOAD DATA",
                    "value": "LOAD DATA",
                    "keyword": "LOAD DATA",
                    "type": 1,
                    "flags": 7,
                    "position": 123
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 132
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "LOCAL",
                    "value": "LOCAL",
                    "keyword": "LOCAL",
                    "type": 1,
                    "flags": 1,
                    "position": 133
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 138
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "INFILE",
                    "value": "INFILE",
                    "keyword": "INFILE",
                    "type": 1,
                    "flags": 3,
                    "position": 139
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 145
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "'/home/user/myloadfile.csv'",
                    "value": "/home/user/myloadfile.csv",
                    "keyword": null,
                    "type": 7,
                    "flags": 1,
                    "position": 146
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 173
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "IGNORE",
                    "value": "IGNORE",
                    "keyword": "IGNORE",
                    "type": 1,
                    "flags": 3,
                    "position": 174
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 180
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "INTO",
                    "value": "INTO",
                    "keyword": "INTO",
                    "type": 1,
                    "flags": 3,
                    "position": 181
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 185
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "TABLE",
                    "value": "TABLE",
                    "keyword": "TABLE",
                    "type": 1,
                    "flags": 3,
                    "position": 186
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 191
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "erp",
                    "value": "erp",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 192
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 195
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "e1_table",
                    "value": "e1_table",
                    "keyword": null,
                    "type": 0,
                    "flags": 0,
                    "position": 196
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 204
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "FIELDS",
                    "value": "FIELDS",
                    "keyword": "FIELDS",
                    "type": 1,
                    "flags": 1,
                    "position": 205
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 211
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "TERMINATED BY",
                    "value": "TERMINATED BY",
                    "keyword": "TERMINATED BY",
                    "type": 1,
                    "flags": 7,
                    "position": 212
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 225
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "'\\t'",
                    "value": "\t",
                    "keyword": null,
                    "type": 7,
                    "flags": 1,
                    "position": 226
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 230
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "LINES",
                    "value": "LINES",
                    "keyword": "LINES",
                    "type": 1,
                    "flags": 3,
                    "position": 231
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 236
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "TERMINATED BY",
                    "value": "TERMINATED BY",
                    "keyword": "TERMINATED BY",
                    "type": 1,
                    "flags": 7,
                    "position": 237
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 250
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "'\\n'",
                    "value": "\n",
                    "keyword": null,
                    "type": 7,
                    "flags": 1,
                    "position": 251
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 255
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "IGNORE",
                    "value": "IGNORE",
                    "keyword": "IGNORE",
                    "type": 1,
                    "flags": 3,
                    "position": 256
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 262
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "0",
                    "value": 0,
                    "keyword": null,
                    "type": 6,
                    "flags": 0,
                    "position": 263
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 264
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "LINES",
                    "value": "LINES",
                    "keyword": "LINES",
                    "type": 1,
                    "flags": 3,
                    "position": 265
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ";",
                    "value": ";",
                    "keyword": null,
                    "type": 9,
                    "flags": 0,
                    "position": 270
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 271
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": null,
                    "value": null,
                    "keyword": null,
                    "type": 9,
                    "flags": 0,
                    "position": null
                }
            ],
            "count": 42,
            "idx": 42
        },
        "delimiter": ";",
        "delimiterLen": 1,
        "strict": false,
        "errors": []
    },
    "parser": {
        "@type": "PhpMyAdmin\\SqlParser\\Parser",
        "list": {
            "@type": "@1"
        },
        "statements": [
            {
                "@type": "PhpMyAdmin\\SqlParser\\Statements\\LoadStatement",
                "file_name": {
                    "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                    "database": null,
                    "table": null,
                    "column": null,
                    "expr": "'/home/user/myloadfile.csv'",
                    "alias": null,
                    "function": null,
                    "subquery": null,
                    "file": "/home/user/myloadfile.csv"
                },
                "table": {
                    "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                    "database": "erp",
                    "table": "e1_table",
                    "column": null,
                    "expr": "erp.e1_table",
                    "alias": null,
                    "function": null,
                    "subquery": null
                },
                "partition": null,
                "charset_name": null,
                "fields_options": {
                    "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                    "options": {
                        "1": {
                            "name": "TERMINATED BY",
                            "equals": false,
                            "expr": {
                                "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                                "database": null,
                                "table": null,
                                "column": "\t",
                                "expr": "'\\t'",
                                "alias": null,
                                "function": null,
                                "subquery": null
                            },
                            "value": "'\\t'"
                        }
                    }
                },
                "fields_keyword": "FIELDS",
                "lines_options": {
                    "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                    "options": {
                        "2": {
                            "name": "TERMINATED BY",
                            "equals": false,
                            "expr": {
                                "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                                "database": null,
                                "table": null,
                                "column": "\n",
                                "expr": "'\\n'",
                                "alias": null,
                                "function": null,
                                "subquery": null
                            },
                            "value": "'\\n'"
                        }
                    }
                },
                "col_name_or_user_var": null,
                "set": null,
                "ignore_number": {
                    "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                    "database": null,
                    "table": null,
                    "column": null,
                    "expr": "0",
                    "alias": null,
                    "function": null,
                    "subquery": null
                },
                "replace_ignore": "IGNORE",
                "lines_rows": "LINES",
                "options": {
                    "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                    "options": {
                        "2": "LOCAL"
                    }
                },
                "first": 0,
                "last": 40
            }
        ],
        "brackets": 0,
        "strict": false,
        "errors": []
    },
    "errors": {
        "lexer": [],
        "parser": []
    }
}