use super::super::render::normalize_check_expression;
#[test]
fn mysql_metadata_decorations_do_not_break_check_idempotency() {
assert_eq!(
normalize_check_expression("(`status` in (_utf8mb4\\'active\\',_utf8mb4\\'disabled\\'))"),
normalize_check_expression("`status` IN ('active', 'disabled')")
);
}
#[test]
fn internal_parentheses_remain_semantically_significant() {
assert_ne!(
normalize_check_expression("`a` AND (`b` OR `c`)"),
normalize_check_expression("(`a` AND `b`) OR `c`")
);
}
#[test]
fn multi_layer_backslash_escapes_converge() {
let declared = normalize_check_expression(
"regexp_like(`permission`, '^[a-z][a-z0-9_]*(\\\\.[a-z][a-z0-9_]*)+$')",
);
let read_back_4 = normalize_check_expression(
"regexp_like(`permission`,_utf8mb4\\'^[a-z][a-z0-9_]*(\\\\\\\\.[a-z][a-z0-9_]*)+$\\')",
);
let read_back_8 = normalize_check_expression(
"regexp_like(`permission`,_utf8mb4\\\\'^[a-z][a-z0-9_]*(\\\\\\\\\\\\\\\\.[a-z][a-z0-9_]*)+$\\\\')",
);
assert_eq!(declared, read_back_4);
assert_eq!(declared, read_back_8);
}
#[test]
fn string_literal_content_is_not_normalized() {
assert_ne!(
normalize_check_expression("`a` <> ' '"),
normalize_check_expression("`a` <> ''")
);
assert_ne!(
normalize_check_expression("`a` = 'x y'"),
normalize_check_expression("`a` = 'xy'")
);
assert_ne!(
normalize_check_expression("regexp_like(`p`, '^a b$')"),
normalize_check_expression("regexp_like(`p`, '^ab$')")
);
}