Tidb.php
77 lines
| 1 | <?php |
| 2 | |
| 3 | /** |
| 4 | * Matomo - free/libre analytics platform |
| 5 | * |
| 6 | * @link https://matomo.org |
| 7 | * @license https://www.gnu.org/licenses/gpl-3.0.html GPL v3 or later |
| 8 | */ |
| 9 | namespace Piwik\Db\Schema; |
| 10 | |
| 11 | /** |
| 12 | * Mariadb schema |
| 13 | */ |
| 14 | class Tidb extends \Piwik\Db\Schema\Mysql |
| 15 | { |
| 16 | /** |
| 17 | * TiDB performs a sanity check before performing e.g. ALTER TABLE statements. If any of the used columns does not |
| 18 | * exist before the query fails. This also happens if the column would be added in the same query. |
| 19 | * |
| 20 | * @return bool |
| 21 | */ |
| 22 | public function supportsComplexColumnUpdates() : bool |
| 23 | { |
| 24 | return \false; |
| 25 | } |
| 26 | public function getDefaultCollationForCharset(string $charset) : string |
| 27 | { |
| 28 | $collation = parent::getDefaultCollationForCharset($charset); |
| 29 | if ('utf8mb4' === $charset && 'utf8mb4_bin' === $collation) { |
| 30 | // replace the TiDB default "utf8mb4_bin" with a better default |
| 31 | return 'utf8mb4_0900_ai_ci'; |
| 32 | } |
| 33 | return $collation; |
| 34 | } |
| 35 | public function getDefaultPort() : int |
| 36 | { |
| 37 | return 4000; |
| 38 | } |
| 39 | public function getTableCreateOptions() : string |
| 40 | { |
| 41 | $engine = $this->getTableEngine(); |
| 42 | $charset = $this->getUsedCharset(); |
| 43 | $collation = $this->getUsedCollation(); |
| 44 | $rowFormat = $this->getTableRowFormat(); |
| 45 | if ('utf8mb4' === $charset && '' === $collation) { |
| 46 | $collation = 'utf8mb4_0900_ai_ci'; |
| 47 | } |
| 48 | $options = "ENGINE={$engine} DEFAULT CHARSET={$charset}"; |
| 49 | if ('' !== $collation) { |
| 50 | $options .= " COLLATE={$collation}"; |
| 51 | } |
| 52 | if ('' !== $rowFormat) { |
| 53 | $options .= " {$rowFormat}"; |
| 54 | } |
| 55 | return $options; |
| 56 | } |
| 57 | public function isOptimizeInnoDBSupported() : bool |
| 58 | { |
| 59 | return \false; |
| 60 | } |
| 61 | public function optimizeTables(array $tables, bool $force = \false) : bool |
| 62 | { |
| 63 | // OPTIMIZE TABLE not supported for TiDb |
| 64 | return \false; |
| 65 | } |
| 66 | public function supportsSortingInSubquery() : bool |
| 67 | { |
| 68 | // TiDb optimizer removes all sorting from subqueries |
| 69 | return \false; |
| 70 | } |
| 71 | public function getSupportedReadIsolationTransactionLevel() : string |
| 72 | { |
| 73 | // TiDB doesn't support READ UNCOMMITTED |
| 74 | return 'READ COMMITTED'; |
| 75 | } |
| 76 | } |
| 77 |