[BUGFIX] Invalid check for NULL with ISNULL 72/39072/2
authorXavier Perseguers <xavier@typo3.org>
Thu, 30 Apr 2015 08:56:40 +0000 (10:56 +0200)
committerXavier Perseguers <xavier@typo3.org>
Thu, 30 Apr 2015 12:06:28 +0000 (14:06 +0200)
MySQL's ISNULL() function cannot be used when EXT:dbal is loaded.

Resolves: #66676
Releases: 6.2
Change-Id: I335c4b53d39d903d1fc9c93a61d15da2db523db8
Reviewed-on: http://review.typo3.org/39072
Reviewed-by: Stephan GroƟberndt <stephan@grossberndt.de>
Reviewed-by: Andreas Fernandez <andreas.fernandez@aspedia.de>
Tested-by: Andreas Fernandez <andreas.fernandez@aspedia.de>
Reviewed-by: Xavier Perseguers <xavier@typo3.org>
Tested-by: Xavier Perseguers <xavier@typo3.org>
typo3/sysext/install/Classes/Updates/FilePermissionUpdate.php

index 7ec4613..b3cfe59 100644 (file)
@@ -218,7 +218,7 @@ class FilePermissionUpdate extends AbstractUpdate {
         * @return string
         */
        protected function getWhereClause() {
-               return 'fileoper_perms>0 AND ISNULL(file_permissions)';
+               return 'fileoper_perms>0 AND file_permissions IS NULL';
        }
 
 }