diff options
| author | Julius Härtl <jus@bitgrid.net> | 2020-11-06 11:39:48 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-11-06 11:39:48 +0100 |
| commit | 3f4fb9dc89016e701678d6310281705a92fbe3e6 (patch) | |
| tree | d5788a159a9c1bd6f7747f1c8ae72c26d79dc56a | |
| parent | 2c6bbe783a6ab0f75f9ad85d66d9b4511a7543be (diff) | |
| parent | cfc35fa49aeb7b491bd4e89513b6f054e05ed458 (diff) | |
| download | nextcloud-server-3f4fb9dc89016e701678d6310281705a92fbe3e6.tar.gz nextcloud-server-3f4fb9dc89016e701678d6310281705a92fbe3e6.zip | |
Merge pull request #23921 from nextcloud/techdebt/oci/fix-casting-to-integer
Fix casting to integer on Oracle
| -rw-r--r-- | lib/private/DB/QueryBuilder/ExpressionBuilder/OCIExpressionBuilder.php | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/lib/private/DB/QueryBuilder/ExpressionBuilder/OCIExpressionBuilder.php b/lib/private/DB/QueryBuilder/ExpressionBuilder/OCIExpressionBuilder.php index 2aa007dba04..e8e436ba5bd 100644 --- a/lib/private/DB/QueryBuilder/ExpressionBuilder/OCIExpressionBuilder.php +++ b/lib/private/DB/QueryBuilder/ExpressionBuilder/OCIExpressionBuilder.php @@ -170,6 +170,10 @@ class OCIExpressionBuilder extends ExpressionBuilder { $column = $this->helper->quoteColumnName($column); return new QueryFunction('to_char(' . $column . ')'); } + if ($type === IQueryBuilder::PARAM_INT) { + $column = $this->helper->quoteColumnName($column); + return new QueryFunction('to_number(to_char(' . $column . '))'); + } return parent::castColumn($column, $type); } |