let table_name = ObjectName(vec![Ident::new("mytable")]);

assert_eq!(

mysql_and_generic().verified_stmt("SHOW COLUMNS FROM mytable"),

Statement::ShowColumns {

extended: false,

full: false,

table_name: table_name.clone(),

filter: None,

}

);

assert_eq!(

mysql_and_generic().verified_stmt("SHOW COLUMNS FROM mydb.mytable"),

Statement::ShowColumns {

extended: false,

full: false,

table_name: ObjectName(vec![Ident::new("mydb"), Ident::new("mytable")]),

filter: None,

}

);

assert_eq!(

mysql_and_generic().verified_stmt("SHOW EXTENDED COLUMNS FROM mytable"),

Statement::ShowColumns {

extended: true,

full: false,

table_name: table_name.clone(),

filter: None,

}

);

assert_eq!(

mysql_and_generic().verified_stmt("SHOW FULL COLUMNS FROM mytable"),

Statement::ShowColumns {

extended: false,

full: true,

table_name: table_name.clone(),

filter: None,

}

);

assert_eq!(

mysql_and_generic().verified_stmt("SHOW COLUMNS FROM mytable LIKE 'pattern'"),

Statement::ShowColumns {

extended: false,

full: false,

table_name: table_name.clone(),

filter: Some(ShowStatementFilter::Like("pattern".into())),

}

);

assert_eq!(

mysql_and_generic().verified_stmt("SHOW COLUMNS FROM mytable WHERE 1 = 2"),

Statement::ShowColumns {

extended: false,

full: false,

table_name,

filter: Some(ShowStatementFilter::Where(

mysql_and_generic().verified_expr("1 = 2")

)),

}

);

mysql_and_generic()

.one_statement_parses_to("SHOW FIELDS FROM mytable", "SHOW COLUMNS FROM mytable");

mysql_and_generic()

.one_statement_parses_to("SHOW COLUMNS IN mytable", "SHOW COLUMNS FROM mytable");

mysql_and_generic()

.one_statement_parses_to("SHOW FIELDS IN mytable", "SHOW COLUMNS FROM mytable");

// unhandled things are truly unhandled

match mysql_and_generic().parse_sql_statements("SHOW COLUMNS FROM mytable FROM mydb") {

Err(_) => {}

Ok(val) => panic!("unexpected successful parse: {:?}", val),

}

TestedDialects {

dialects: vec![Box::new(MySqlDialect {})],

}

TestedDialects {

dialects: vec![Box::new(MySqlDialect {}), Box::new(GenericDialect {})],

}