From 42560780177e74347c9e00200b64dd15f4f72449 Mon Sep 17 00:00:00 2001 From: Olivier Paroz Date: Tue, 17 Mar 2015 11:05:51 +0100 Subject: Make repairmimetypes compatible with case sensitive SQL backends Change for #14132 Just a word of warning, ILIKE seems to be a Doctrine only clause. The statements are thus not portable. --- lib/repair/repairmimetypes.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/lib/repair/repairmimetypes.php b/lib/repair/repairmimetypes.php index ad55c63c21a..721464f923d 100644 --- a/lib/repair/repairmimetypes.php +++ b/lib/repair/repairmimetypes.php @@ -66,7 +66,7 @@ class RepairMimeTypes extends BasicEmitter implements \OC\RepairStep { SELECT `id` FROM `*PREFIX*mimetypes` WHERE `mimetype` = ? - ) WHERE `name` LIKE ? + ) WHERE `name` ILIKE ? '); } -- cgit v1.2.3 From bd91546db8b0f9e4a31dc983a4e18988353dc13a Mon Sep 17 00:00:00 2001 From: Olivier Paroz Date: Tue, 17 Mar 2015 13:25:39 +0100 Subject: Adding test cases where the extension is using capital letters --- tests/lib/repair/repairmimetypes.php | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) diff --git a/tests/lib/repair/repairmimetypes.php b/tests/lib/repair/repairmimetypes.php index 839a4723ecd..f9f214370cc 100644 --- a/tests/lib/repair/repairmimetypes.php +++ b/tests/lib/repair/repairmimetypes.php @@ -192,7 +192,7 @@ class TestRepairMimeTypes extends \Test\TestCase { } /** - * Test renaming the postscript mime types + * Test renaming the Raw mime types */ public function testRenameRawMimeType() { $this->addEntries( @@ -214,6 +214,7 @@ class TestRepairMimeTypes extends \Test\TestCase { array('test.srf', 'application/octet-stream'), array('test.sr2', 'application/octet-stream'), array('test.xrf', 'application/octet-stream'), + array('CapitalExtension.DNG', 'application/octet-stream'), ) ); @@ -242,6 +243,7 @@ class TestRepairMimeTypes extends \Test\TestCase { array('test.srf', 'image/x-dcraw'), array('test.sr2', 'image/x-dcraw'), array('test.xrf', 'image/x-dcraw'), + array('CapitalExtension.DNG', 'image/x-dcraw'), ) ); } @@ -373,6 +375,7 @@ class TestRepairMimeTypes extends \Test\TestCase { array('test.srf', 'image/x-dcraw'), array('test.sr2', 'image/x-dcraw'), array('test.xrf', 'image/x-dcraw'), + array('test.DNG', 'image/x-dcraw'), ) ); @@ -413,6 +416,7 @@ class TestRepairMimeTypes extends \Test\TestCase { array('test.srf', 'image/x-dcraw'), array('test.sr2', 'image/x-dcraw'), array('test.xrf', 'image/x-dcraw'), + array('test.DNG', 'image/x-dcraw'), ) ); } -- cgit v1.2.3