diff options
| author | Joas Schilling <coding@schilljs.com> | 2024-07-19 12:54:40 +0200 |
|---|---|---|
| committer | Joas Schilling <coding@schilljs.com> | 2024-07-19 14:13:56 +0200 |
| commit | b656edc47c50376140971e11d1325147cb1e49c9 (patch) | |
| tree | c6ed85e0619d3eabfcf00fa0ae281ed4b40d2f8b /lib/private/DB/QueryBuilder/FunctionBuilder/OCIFunctionBuilder.php | |
| parent | 817ca0045a4271af6737884a3424587ba29948cb (diff) | |
| download | nextcloud-server-b656edc47c50376140971e11d1325147cb1e49c9.tar.gz nextcloud-server-b656edc47c50376140971e11d1325147cb1e49c9.zip | |
fix(db): Fix md5 for oracle >= 20
Signed-off-by: Joas Schilling <coding@schilljs.com>
Diffstat (limited to 'lib/private/DB/QueryBuilder/FunctionBuilder/OCIFunctionBuilder.php')
| -rw-r--r-- | lib/private/DB/QueryBuilder/FunctionBuilder/OCIFunctionBuilder.php | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/lib/private/DB/QueryBuilder/FunctionBuilder/OCIFunctionBuilder.php b/lib/private/DB/QueryBuilder/FunctionBuilder/OCIFunctionBuilder.php index d0258eafea8..a8dc4d8cf14 100644 --- a/lib/private/DB/QueryBuilder/FunctionBuilder/OCIFunctionBuilder.php +++ b/lib/private/DB/QueryBuilder/FunctionBuilder/OCIFunctionBuilder.php @@ -12,6 +12,9 @@ use OCP\DB\QueryBuilder\IQueryFunction; class OCIFunctionBuilder extends FunctionBuilder { public function md5($input): IQueryFunction { + if (version_compare($this->connection->getServerVersion(), '20', '>=')) { + return new QueryFunction('LOWER(STANDARD_HASH(' . $this->helper->quoteColumnName($input) . ", 'MD5'))"); + } return new QueryFunction('LOWER(DBMS_OBFUSCATION_TOOLKIT.md5 (input => UTL_RAW.cast_to_raw(' . $this->helper->quoteColumnName($input) .')))'); } |