From 16c184e2cb1110797935107987d0fc9536031df8 Mon Sep 17 00:00:00 2001 From: Robin Appelman Date: Fri, 19 Jul 2024 18:03:54 +0200 Subject: fix: cast to bigint on postgresql Signed-off-by: Robin Appelman --- .../DB/QueryBuilder/ExpressionBuilder/PgSqlExpressionBuilder.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'lib/private/DB/QueryBuilder') diff --git a/lib/private/DB/QueryBuilder/ExpressionBuilder/PgSqlExpressionBuilder.php b/lib/private/DB/QueryBuilder/ExpressionBuilder/PgSqlExpressionBuilder.php index 1a162f04a49..53a566a7eb6 100644 --- a/lib/private/DB/QueryBuilder/ExpressionBuilder/PgSqlExpressionBuilder.php +++ b/lib/private/DB/QueryBuilder/ExpressionBuilder/PgSqlExpressionBuilder.php @@ -23,7 +23,7 @@ class PgSqlExpressionBuilder extends ExpressionBuilder { public function castColumn($column, $type): IQueryFunction { switch ($type) { case IQueryBuilder::PARAM_INT: - return new QueryFunction('CAST(' . $this->helper->quoteColumnName($column) . ' AS INT)'); + return new QueryFunction('CAST(' . $this->helper->quoteColumnName($column) . ' AS BIGINT)'); case IQueryBuilder::PARAM_STR: return new QueryFunction('CAST(' . $this->helper->quoteColumnName($column) . ' AS TEXT)'); default: -- cgit v1.2.3