From b37f7938587515078aa9671ddef46f99b71f4da9 Mon Sep 17 00:00:00 2001 From: Côme Chilliet Date: Mon, 18 Nov 2024 16:31:07 +0100 Subject: fix: Fix integer casting on Sqlite MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Signed-off-by: Côme Chilliet --- .../DB/QueryBuilder/ExpressionBuilder/SqliteExpressionBuilder.php | 3 +++ 1 file changed, 3 insertions(+) diff --git a/lib/private/DB/QueryBuilder/ExpressionBuilder/SqliteExpressionBuilder.php b/lib/private/DB/QueryBuilder/ExpressionBuilder/SqliteExpressionBuilder.php index 559c29df208..394d54d0464 100644 --- a/lib/private/DB/QueryBuilder/ExpressionBuilder/SqliteExpressionBuilder.php +++ b/lib/private/DB/QueryBuilder/ExpressionBuilder/SqliteExpressionBuilder.php @@ -63,6 +63,9 @@ class SqliteExpressionBuilder extends ExpressionBuilder { case IQueryBuilder::PARAM_TIME_IMMUTABLE: $column = $this->helper->quoteColumnName($column); return new QueryFunction('TIME(' . $column . ')'); + case IQueryBuilder::PARAM_INT: + $column = $this->helper->quoteColumnName($column); + return new QueryFunction('CAST(' . $column . ' AS INTEGER)'); } return parent::castColumn($column, $type); -- cgit v1.2.3