You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When I changed from LIKE to ILIKE I noticed I was getting a lot more parentheses in my queries. I would expect the precedence rules for both to be the same, therefore I'd expect the resulting parentheses to be the same.
#[test]fnselect_22(){use sea_query::extension::postgres::PgExpr;assert_eq!(Query::select().column(Char::Character).from(Char::Table).cond_where(Cond::all().add(Cond::any().add(Expr::col(Char::Character).ilike("C")).add(Expr::col(Char::Character).ilike("D").and(Expr::col(Char::Character).ilike("E")))).add(Expr::col(Char::Character).ilike("F").or(Expr::col(Char::Character).ilike("G")))).to_string(PostgresQueryBuilder),r#"SELECT "character" FROM "character" WHERE ("character" ILIKE 'C' OR ("character" ILIKE 'D' AND "character" ILIKE 'E')) AND ("character" ILIKE 'F' OR "character" ILIKE 'G')"#);}
Expected Behavior
SELECT "character" FROM "character" WHERE ("character" ILIKE 'C' OR ("character" ILIKE 'D' AND "character" ILIKE 'E')) AND ("character" ILIKE 'F' OR "character" ILIKE 'G')
Actual Behavior
SELECT "character" FROM "character" WHERE (("character" ILIKE 'C') OR (("character" ILIKE 'D') AND ("character" ILIKE 'E'))) AND (("character" ILIKE 'F') OR ("character" ILIKE 'G'))
Reproduces How Often
Yep
Versions
The postgres extension of v0.31.0-rc.5
The text was updated successfully, but these errors were encountered:
Description
When I changed from LIKE to ILIKE I noticed I was getting a lot more parentheses in my queries. I would expect the precedence rules for both to be the same, therefore I'd expect the resulting parentheses to be the same.
Steps to Reproduce
select_22
test to useilike
instead oflike
, like so:Expected Behavior
SELECT "character" FROM "character" WHERE ("character" ILIKE 'C' OR ("character" ILIKE 'D' AND "character" ILIKE 'E')) AND ("character" ILIKE 'F' OR "character" ILIKE 'G')
Actual Behavior
SELECT "character" FROM "character" WHERE (("character" ILIKE 'C') OR (("character" ILIKE 'D') AND ("character" ILIKE 'E'))) AND (("character" ILIKE 'F') OR ("character" ILIKE 'G'))
Reproduces How Often
Yep
Versions
The postgres extension of v0.31.0-rc.5
The text was updated successfully, but these errors were encountered: