[DMIG-23] Doctrine migrations MySQL only? Created: 14/Jul/11  Updated: 17/Nov/11  Resolved: 17/Nov/11

Status: Resolved
Project: Doctrine Migrations
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Yaroslav Zenin Assignee: Benjamin Eberlei
Resolution: Fixed Votes: 0
Labels: None


Today I have started with implemention migrations in my project.
But I found that only MySQL supported.

 * Returns the current migrated version from the versions table.
 * @return bool $currentVersion
  public function getCurrentVersion()

      $result = $this->connection->fetchColumn("SELECT version FROM " . $this->migrationsTableName . " ORDER BY version DESC LIMIT 1");
      return $result !== false ? (string) $result : '0';

In my project I use MSSQL db.
Do you plan to use platform independent solution?

Comment by Kim Hemsø [ 16/Nov/11 ]

Seem this is already been fixed:

$sql = "SELECT version FROM " . $this->migrationsTableName . " ORDER BY version DESC";
$sql = $this->connection->getDatabasePlatform()->modifyLimitQuery($sql, 1);
$result = $this->connection->fetchColumn($sql);
return $result !== false ? (string) $result : '0';

You can skip my PR-52, if you want since. My plan was to fix it with the query builder

Comment by Benjamin Eberlei [ 17/Nov/11 ]

Was already fixed

Generated at Tue Sep 01 16:29:57 EDT 2015 using JIRA 6.4.10#64025-sha1:5b8b74079161cd76a20ab66dda52747ee6701bd6.