Function ilike_is_case_insensitive

nodedb-sql/src/resolver/expr/tests.rs:247–260

()

#[test]
fn ilike_is_case_insensitive() {
    let expr = where_sql_expr("SELECT * FROM t WHERE name ILIKE 'foo%'");
    match expr {
        SqlExpr::Like {
            negated,
            case_insensitive,
            ..
        } => {
            assert!(!negated, "ILIKE should not be negated");
            assert!(case_insensitive, "ILIKE should be case-insensitive");
        }
        other => panic!("expected SqlExpr::Like, got {other:?}"),
    }
}

#[test]
fn not_like_is_negated_case_sensitive() {