Merge pull request #7464 from piwik/7462_optimize_tables_mariadb

Fixes #7462, optimize InnoDB tables if MariaDB v10.1.1 or greater is used.

1 files changed, 39 insertions, 0 deletions

diff --git a/tests/PHPUnit/Unit/DbTest.php b/tests/PHPUnit/Unit/DbTest.php
new file mode 100644
index 0000000000..70b4338866
--- /dev/null
+++ b/tests/PHPUnit/Unit/DbTest.php
@@ -0,0 +1,39 @@
+<?php
+/**
+ * Piwik - free/libre analytics platform
+ *
+ * @link http://piwik.org
+ * @license http://www.gnu.org/licenses/gpl-3.0.html GPL v3 or later
+ */
+namespace Piwik\Tests\Unit\Db;
+
+use Piwik\Db;
+
+class DbTest extends \PHPUnit_Framework_TestCase
+{
+    /**
+    * @dataProvider getIsOptimizeInnoDBTestData
+    */
+    public function test_isOptimizeInnoDBSupported_ReturnsCorrectResult($version, $expectedResult)
+    {
+        $result = Db::isOptimizeInnoDBSupported($version);
+        $this->assertEquals($expectedResult, $result);
+    }
+
+    public function getIsOptimizeInnoDBTestData()
+    {
+        return array(
+            array("10.0.17-MariaDB-1~trusty", false),
+            array("10.1.1-MariaDB-1~trusty", true),
+            array("10.2.0-MariaDB-1~trusty", true),
+            array("10.6.19-0ubuntu0.14.04.1", false),
+
+            // for sanity. maybe not ours.
+            array("", false),
+            array(0, false),
+            array(false, false),
+            array("slkdf(@*#lkesjfMariaDB", false),
+            array("slkdfjq3rujlkv", false),
+        );
+    }
+}
\ No newline at end of file