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
where e.full_name ILIKE ANY ($1)
or j.title ILIKE ANY ($1)
or ppl.name ILIKE ANY($1)
or spl.name ILIKE ANY ($1)
or co.name ILIKE ANY ($1)
or i.name ILIKE ANY ($1)
My $1 parameter is this ARRAY["'%' || United States || '%'"]
Using this gives me the error
Err(Database(PgDatabaseError { severity: Error, code: "42809", message: "op ANY/ALL (array) requires array on right side", detail: None, hint: None, position: Some(Original(1362)), where: None, schema: None, table: None, column: None, data_type: None, constraint: None, file: Some("parse_oper.c"), line: Some(814), routine: Some("make_scalar_array_op") }))
thread 'common::repository::jobs::test_jobs::test_create_two_distinct_jobs_and_run_search_on_them_to_get_correct_results' panicked at server/tests/common/repository/jobs/test_jobs.rs:385:32:
called Result::unwrap() on an Err value: Database(PgDatabaseError { severity: Error, code: "42809", message: "op ANY/ALL (array) requires array on right side", detail: None, hint: None, position: Some(Original(1362)), where: None, schema: None, table: None, column: None, data_type: None, constraint: None, file: Some("parse_oper.c"), line: Some(814), routine: Some("make_scalar_array_op") })
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
I have a where filter that looks like this
My $1 parameter is this
ARRAY["'%' || United States || '%'"]
Using this gives me the error
Err(Database(PgDatabaseError { severity: Error, code: "42809", message: "op ANY/ALL (array) requires array on right side", detail: None, hint: None, position: Some(Original(1362)), where: None, schema: None, table: None, column: None, data_type: None, constraint: None, file: Some("parse_oper.c"), line: Some(814), routine: Some("make_scalar_array_op") }))
thread 'common::repository::jobs::test_jobs::test_create_two_distinct_jobs_and_run_search_on_them_to_get_correct_results' panicked at server/tests/common/repository/jobs/test_jobs.rs:385:32:
called
Result::unwrap()
on anErr
value: Database(PgDatabaseError { severity: Error, code: "42809", message: "op ANY/ALL (array) requires array on right side", detail: None, hint: None, position: Some(Original(1362)), where: None, schema: None, table: None, column: None, data_type: None, constraint: None, file: Some("parse_oper.c"), line: Some(814), routine: Some("make_scalar_array_op") })Beta Was this translation helpful? Give feedback.
All reactions