diff options
| author | Robin Appelman <robin@icewind.nl> | 2025-03-13 23:05:00 +0100 |
|---|---|---|
| committer | Robin Appelman <robin@icewind.nl> | 2025-03-14 14:05:51 +0100 |
| commit | a39f3c57620a8366cb4e63802d583e4cd863d578 (patch) | |
| tree | 53b77d6c5cc8e38918d98b428087415c9bc84a09 | |
| parent | b6b90e8fde5de82b892dea6e0b54747d1147761b (diff) | |
| download | nextcloud-server-fetch-mount-memory.tar.gz nextcloud-server-fetch-mount-memory.zip | |
fix: fix oci string length with empty stringsfetch-mount-memory
Signed-off-by: Robin Appelman <robin@icewind.nl>
| -rw-r--r-- | lib/private/DB/QueryBuilder/FunctionBuilder/OCIFunctionBuilder.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/lib/private/DB/QueryBuilder/FunctionBuilder/OCIFunctionBuilder.php b/lib/private/DB/QueryBuilder/FunctionBuilder/OCIFunctionBuilder.php index 6791430b1b0..3e0cb28e3eb 100644 --- a/lib/private/DB/QueryBuilder/FunctionBuilder/OCIFunctionBuilder.php +++ b/lib/private/DB/QueryBuilder/FunctionBuilder/OCIFunctionBuilder.php @@ -80,12 +80,12 @@ class OCIFunctionBuilder extends FunctionBuilder { public function octetLength($field, $alias = ''): IQueryFunction { $alias = $alias ? (' AS ' . $this->helper->quoteColumnName($alias)) : ''; $quotedName = $this->helper->quoteColumnName($field); - return new QueryFunction('LENGTHB(' . $quotedName . ')' . $alias); + return new QueryFunction('COALESCE(LENGTHB(' . $quotedName . '), 0)' . $alias); } public function charLength($field, $alias = ''): IQueryFunction { $alias = $alias ? (' AS ' . $this->helper->quoteColumnName($alias)) : ''; $quotedName = $this->helper->quoteColumnName($field); - return new QueryFunction('LENGTH(' . $quotedName . ')' . $alias); + return new QueryFunction('COALESCE(LENGTH(' . $quotedName . '), 0)' . $alias); } } |