From 990bb0700239c8dab1000f21ac05d186fc4acede Mon Sep 17 00:00:00 2001 From: Joas Schilling Date: Fri, 6 Nov 2020 13:32:14 +0100 Subject: [PATCH] Cast bool things to numbers as that is how they are stored in the database Signed-off-by: Joas Schilling --- .../DB/QueryBuilder/ExpressionBuilder/OCIExpressionBuilder.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/lib/private/DB/QueryBuilder/ExpressionBuilder/OCIExpressionBuilder.php b/lib/private/DB/QueryBuilder/ExpressionBuilder/OCIExpressionBuilder.php index e8e436ba5bd..c3715074685 100644 --- a/lib/private/DB/QueryBuilder/ExpressionBuilder/OCIExpressionBuilder.php +++ b/lib/private/DB/QueryBuilder/ExpressionBuilder/OCIExpressionBuilder.php @@ -170,7 +170,7 @@ class OCIExpressionBuilder extends ExpressionBuilder { $column = $this->helper->quoteColumnName($column); return new QueryFunction('to_char(' . $column . ')'); } - if ($type === IQueryBuilder::PARAM_INT) { + if ($type === IQueryBuilder::PARAM_INT || $type === IQueryBuilder::PARAM_BOOL) { $column = $this->helper->quoteColumnName($column); return new QueryFunction('to_number(to_char(' . $column . '))'); } -- 2.39.5