fix(migrations): select column as {name}

MSSQL throws exception when unambiguous is paased to order by clause ref https://connect.microsoft.com/SQLServer/feedback/details/644134/order-by-clause-incorrectly-produces-ambiguous-column-name Closes #82
adonisjs · Jul 16, 2017 · 7bda1b8 · 7bda1b8
1 parent 5f083d2
commit 7bda1b8
Showing 1 changed file with 1 addition and 1 deletion.
diff --git a/src/Migrations/Mixins/Migrate.js b/src/Migrations/Mixins/Migrate.js
@@ -244,7 +244,7 @@ Migrate._mapMigrationsToActions = function (migrationsList, direction) {
  * @private
  */
 Migrate._getMigratedFiles = function () {
-  return this.database.select('name').from(this.migrationsTable).orderBy('name').pluck('name')
+  return this.database.select('name as name').from(this.migrationsTable).orderBy('name').pluck('name')
 }
 
 /**