Skip to content

Failed to parse ALTER TABLE statement in MySQL with error Expected end of statement, found: AFTER #1172

@xring

Description

@xring

evnrionmrnt

sqlparser version: 0.44.0
rust version: 1.76.0

codes

use sqlparser::dialect::MySqlDialect;
use sqlparser::parser::Parser;

fn main() {
    let sql = "ALTER TABLE demo ADD name VARCHAR(128) NULL DEFAULT NULL AFTER age";
    let ast = Parser::parse_sql(&MySqlDialect {}, sql);
    println!("{:?}", ast)
}

error

Err(ParserError("Expected end of statement, found: AFTER at Line: 1, Column 58"))

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions