Issue 418 in flyway: locations overrides not working correctly

[fly...@googlecode.com]

Status: New
Owner: ----
Labels: Type-Defect Priority-Medium

New issue 418 by sel...@gmail.com: locations overrides not working correctly
http://code.google.com/p/flyway/issues/detail?id=418

I'm using Flyway through the maven plugin. I'd like to use profile-based
locations so that particular migration scripts are run for particular
environments, however, I can't seem to get the locations settings to work.

If I set one location
(<locations><location>db/migrations/common</location></locations>), it is
ignored entirely.

If I set more than one location
(<locations><location>db/migrations/dev</location><location>db/migrations/common</location></locations>),
only the last location, alphabetically, is honored.
Am I doing something wrong or is this a bug?

[fly...@googlecode.com]

Comment #1 on issue 418 by sel...@gmail.com: locations overrides not
working correctly
http://code.google.com/p/flyway/issues/detail?id=418

This is Flyway 2.0.3 and Maven 3.0.3 btw.

[fly...@googlecode.com]

Comment #2 on issue 418 by axel.fontai...@gmail.com: locations

overrides not working correctly
http://code.google.com/p/flyway/issues/detail?id=418

Hi Selah,

Thanks for reporting this. Could you attach your pom and a debug output
from the plugin execution?

Cheers
Axel

[fly...@googlecode.com]

Comment #3 on issue 418 by axel.fontai...@gmail.com: locations

overrides not working correctly
http://code.google.com/p/flyway/issues/detail?id=418

any news?

[fly...@googlecode.com]

Comment #4 on issue 418 by sel...@gmail.com: locations overrides not
working correctly
http://code.google.com/p/flyway/issues/detail?id=418

My intention is to have run-everywhere migrations in "db/migration/common"
and production only in "db/migration/prod". Then adjust "locations"
depending on environment. My common-only config looks like this:

<plugin>
<groupId>com.googlecode.flyway</groupId>
<artifactId>flyway-maven-plugin</artifactId>
<version>2.0.3</version>
<dependencies>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.22</version>
</dependency>
</dependencies>
<configuration>
<driver>com.mysql.jdbc.Driver</driver>
<url>jdbc:mysql://localhost:3306</url>
<schemas>
<schema>test</schema>
</schemas>
<locations>
<location>common</location>
</locations>
</configuration>
</plugin>

However, any migrations under the "db" directory are found regardless of
the locations setting. This was only a problem when I put my migrations in
the default "db/migration" location. I changed the location to
"sql/migration" and locations worked as expected.

Here is the debug output from maven:

Apache Maven 3.0.3 (r1075438; 2011-02-28 11:31:09-0600)
Maven home: /usr/share/maven
Java version: 1.6.0_37, vendor: Apple Inc.
Java home: /System/Library/Java/JavaVirtualMachines/1.6.0.jdk/Contents/Home
Default locale: en_US, platform encoding: MacRoman
OS name: "mac os x", version: "10.8.2", arch: "x86_64", family: "mac"
[INFO] Error stacktraces are turned on.
[DEBUG] Reading global settings from /usr/share/maven/conf/settings.xml
[DEBUG] Reading user settings from /Users/selah/.m2/settings.xml
[DEBUG] Using local repository at /Users/selah/.m2/repository
[DEBUG] Using manager EnhancedLocalRepositoryManager with priority 10 for
/Users/selah/.m2/repository
[INFO] Scanning for projects...
[DEBUG] Extension realms for project
com.atherapy:atherapy-base-pom:pom:1.0.0-BUILD-SNAPSHOT: (none)
[DEBUG] Looking up lifecyle mappings for packaging pom from
ClassRealm[plexus.core, parent: null]
[WARNING]
[WARNING] Some problems were encountered while building the effective model
for com.atherapy:atherapy-base-pom:pom:1.0.0-BUILD-SNAPSHOT
[WARNING] 'build.plugins.plugin.version' for
org.zeroturnaround:jrebel-maven-plugin is missing. @ line 116, column 12
[WARNING]
[WARNING] It is highly recommended to fix these problems because they
threaten the stability of your build.
[WARNING]
[WARNING] For this reason, future Maven versions might no longer support
building such malformed projects.
[WARNING]
[DEBUG] Resolving plugin version for org.zeroturnaround:jrebel-maven-plugin
[DEBUG] Could not find metadata
org.zeroturnaround:jrebel-maven-plugin/maven-metadata.xml in local
(/Users/selah/.m2/repository)
[DEBUG] Skipped remote update check for
org.zeroturnaround:jrebel-maven-plugin/maven-metadata.xml, locally cached
metadata up-to-date.
[DEBUG] Resolved plugin version for org.zeroturnaround:jrebel-maven-plugin
to 1.1.3 from repository central (http://repo1.maven.org/maven2, releases)
[DEBUG] Resolving plugin prefix flyway from [org.apache.maven.plugins,
org.codehaus.mojo]
[DEBUG] Resolved plugin prefix flyway to
com.googlecode.flyway:flyway-maven-plugin from POM
com.atherapy:atherapy-base-pom:pom:1.0.0-BUILD-SNAPSHOT
[DEBUG] === REACTOR BUILD PLAN
================================================
[DEBUG] Project: com.atherapy:atherapy-base-pom:pom:1.0.0-BUILD-SNAPSHOT
[DEBUG] Tasks: [flyway:info]
[DEBUG] Style: Regular
[DEBUG]
=======================================================================
[INFO]

[INFO]
------------------------------------------------------------------------
[INFO] Building atherapy-base-pom 1.0.0-BUILD-SNAPSHOT
[INFO]
------------------------------------------------------------------------
[DEBUG] Resolving plugin prefix flyway from [org.apache.maven.plugins,
org.codehaus.mojo]
[DEBUG] Resolved plugin prefix flyway to
com.googlecode.flyway:flyway-maven-plugin from POM
com.atherapy:atherapy-base-pom:pom:1.0.0-BUILD-SNAPSHOT
[DEBUG] Lifecycle default -> [validate, initialize, generate-sources,
process-sources, generate-resources, process-resources, compile,
process-classes, generate-test-sources, process-test-sources,
generate-test-resources, process-test-resources, test-compile,
process-test-classes, test, prepare-package, package, pre-integration-test,
integration-test, post-integration-test, verify, install, deploy]
[DEBUG] Lifecycle clean -> [pre-clean, clean, post-clean]
[DEBUG] Lifecycle site -> [pre-site, site, post-site, site-deploy]
[DEBUG] === PROJECT BUILD PLAN
================================================
[DEBUG] Project: com.atherapy:atherapy-base-pom:1.0.0-BUILD-SNAPSHOT
[DEBUG] Dependencies (collect): []
[DEBUG] Dependencies (resolve): [compile]
[DEBUG] Repositories (dependencies): [central
(http://repo1.maven.org/maven2,
releases)]
[DEBUG] Repositories (plugins) : [central
(http://repo1.maven.org/maven2,
releases)]
[DEBUG]
-----------------------------------------------------------------------
[DEBUG] Goal: com.googlecode.flyway:flyway-maven-plugin:2.0.3:info
(default-cli)
[DEBUG] Style: Regular
[DEBUG] Configuration: <?xml version="1.0" encoding="UTF-8"?>
<configuration>
<baseDir>${flyway.baseDir}</baseDir>
<basePackage>${flyway.basePackage}</basePackage>

<cleanOnValidationError>${flyway.cleanOnValidationError}</cleanOnValidationError>
<driver>com.mysql.jdbc.Driver</driver>
<encoding>${flyway.encoding}</encoding>
<initialDescription>${flyway.initialDescription}</initialDescription>
<initialVersion>${flyway.initialVersion}</initialVersion>
<locations>
<location>common</location>
</locations>
<mavenProject>${project}</mavenProject>
<outOfOrder>${flyway.outOfOrder}</outOfOrder>
<schemas>
<schema>test</schema>${flyway.schemas}</schemas>
<serverId>${flyway.serverId}</serverId>
<settings>${settings}</settings>
<sqlMigrationPrefix>${flyway.sqlMigrationPrefix}</sqlMigrationPrefix>
<sqlMigrationSuffix>${flyway.sqlMigrationSuffix}</sqlMigrationSuffix>
<table>${flyway.table}</table>
<target>${flyway.target}</target>
<url>jdbc:mysql://localhost:3306</url>
<user>dba_user</user>
<validationErrorMode>${flyway.validationErrorMode}</validationErrorMode>
</configuration>
[DEBUG]
=======================================================================
[DEBUG] com.atherapy:atherapy-base-pom:pom:1.0.0-BUILD-SNAPSHOT
[DEBUG] org.springframework:spring-core:jar:3.1.2.RELEASE:compile
[DEBUG] org.springframework:spring-asm:jar:3.1.2.RELEASE:compile
[DEBUG] commons-logging:commons-logging:jar:1.1.1:compile
[DEBUG] org.springframework:spring-context:jar:3.1.2.RELEASE:compile
[DEBUG] org.springframework:spring-beans:jar:3.1.2.RELEASE:compile
[DEBUG] org.springframework:spring-aop:jar:3.1.2.RELEASE:compile
[DEBUG] aopalliance:aopalliance:jar:1.0:compile
[DEBUG] org.springframework:spring-expression:jar:3.1.2.RELEASE:compile
[DEBUG] org.springframework:spring-oxm:jar:3.1.2.RELEASE:compile
[DEBUG] commons-lang:commons-lang:jar:2.5:compile
[DEBUG]
org.springframework:spring-context-support:jar:3.1.2.RELEASE:compile
[DEBUG] org.aspectj:aspectjrt:jar:1.7.0:compile
[DEBUG] org.aspectj:aspectjweaver:jar:1.7.0:compile
[DEBUG] org.springframework:spring-test:jar:3.1.2.RELEASE:test
[DEBUG] junit:junit:jar:4.10:test
[DEBUG] org.hamcrest:hamcrest-core:jar:1.1:test
[DEBUG] log4j:log4j:jar:1.2.16:compile
[INFO]
[INFO] --- flyway-maven-plugin:2.0.3:info (default-cli) @ atherapy-base-pom
---
[DEBUG] Created new class realm maven.api
[DEBUG] Importing foreign packages into class realm maven.api
[DEBUG] Imported: org.apache.maven.wagon.events < plexus.core
[DEBUG] Imported: org.sonatype.aether.transfer < plexus.core
[DEBUG] Imported: org.apache.maven.exception < plexus.core
[DEBUG] Imported: org.sonatype.aether.metadata < plexus.core
[DEBUG] Imported: org.codehaus.plexus.util.xml.Xpp3Dom < plexus.core
[DEBUG] Imported: org.sonatype.aether.collection < plexus.core
[DEBUG] Imported: org.sonatype.aether.version < plexus.core
[DEBUG] Imported: org.apache.maven.monitor < plexus.core
[DEBUG] Imported: org.apache.maven.wagon.repository < plexus.core
[DEBUG] Imported: org.apache.maven.repository < plexus.core
[DEBUG] Imported: org.apache.maven.wagon.resource < plexus.core
[DEBUG] Imported: org.codehaus.plexus.logging < plexus.core
[DEBUG] Imported: org.apache.maven.profiles < plexus.core
[DEBUG] Imported: org.sonatype.aether.repository < plexus.core
[DEBUG] Imported: org.apache.maven.classrealm < plexus.core
[DEBUG] Imported: org.apache.maven.execution < plexus.core
[DEBUG] Imported: org.sonatype.aether.artifact < plexus.core
[DEBUG] Imported: org.sonatype.aether.spi < plexus.core
[DEBUG] Imported: org.apache.maven.reporting < plexus.core
[DEBUG] Imported: org.apache.maven.usability < plexus.core
[DEBUG] Imported: org.codehaus.plexus.container < plexus.core
[DEBUG] Imported: org.codehaus.plexus.component < plexus.core
[DEBUG] Imported: org.codehaus.plexus.util.xml.pull.XmlSerializer <
plexus.core
[DEBUG] Imported: org.apache.maven.wagon.authentication < plexus.core
[DEBUG] Imported: org.apache.maven.lifecycle < plexus.core
[DEBUG] Imported: org.codehaus.plexus.classworlds < plexus.core
[DEBUG] Imported: org.sonatype.aether.graph < plexus.core
[DEBUG] Imported: org.sonatype.aether.* < plexus.core
[DEBUG] Imported: org.apache.maven.settings < plexus.core
[DEBUG] Imported: org.codehaus.classworlds < plexus.core
[DEBUG] Imported: org.sonatype.aether.impl < plexus.core
[DEBUG] Imported: org.apache.maven.wagon.* < plexus.core
[DEBUG] Imported: org.apache.maven.toolchain < plexus.core
[DEBUG] Imported: org.sonatype.aether.deployment < plexus.core
[DEBUG] Imported: org.apache.maven.wagon.observers < plexus.core
[DEBUG] Imported:
org.codehaus.plexus.util.xml.pull.XmlPullParserException < plexus.core
[DEBUG] Imported: org.codehaus.plexus.util.xml.pull.XmlPullParser <
plexus.core
[DEBUG] Imported: org.apache.maven.configuration < plexus.core
[DEBUG] Imported: org.apache.maven.cli < plexus.core
[DEBUG] Imported: org.sonatype.aether.installation < plexus.core
[DEBUG] Imported: org.codehaus.plexus.context < plexus.core
[DEBUG] Imported: org.apache.maven.wagon.authorization < plexus.core
[DEBUG] Imported: org.apache.maven.project < plexus.core
[DEBUG] Imported: org.apache.maven.rtinfo < plexus.core
[DEBUG] Imported: org.codehaus.plexus.lifecycle < plexus.core
[DEBUG] Imported: org.codehaus.plexus.configuration < plexus.core
[DEBUG] Imported: org.apache.maven.artifact < plexus.core
[DEBUG] Imported: org.apache.maven.model < plexus.core
[DEBUG] Imported: org.apache.maven.* < plexus.core
[DEBUG] Imported: org.apache.maven.wagon.proxy < plexus.core
[DEBUG] Imported: org.sonatype.aether.resolution < plexus.core
[DEBUG] Imported: org.apache.maven.plugin < plexus.core
[DEBUG] Imported: org.codehaus.plexus.* < plexus.core
[DEBUG] Imported: org.codehaus.plexus.personality < plexus.core
[DEBUG] Populating class realm maven.api
[DEBUG] com.googlecode.flyway:flyway-maven-plugin:jar:2.0.3:
[DEBUG] mysql:mysql-connector-java:jar:5.1.22:runtime
[DEBUG] org.apache.maven:maven-plugin-api:jar:2.2.1:compile
[DEBUG] org.apache.maven:maven-artifact:jar:2.2.1:compile
[DEBUG] org.codehaus.plexus:plexus-utils:jar:1.5.15:compile
[DEBUG] org.apache.maven:maven-project:jar:2.2.1:compile
[DEBUG] org.apache.maven:maven-settings:jar:2.2.1:compile
[DEBUG] org.apache.maven:maven-profile:jar:2.2.1:compile
[DEBUG] org.apache.maven:maven-artifact-manager:jar:2.2.1:compile
[DEBUG]
backport-util-concurrent:backport-util-concurrent:jar:3.1:compile
[DEBUG] org.apache.maven:maven-plugin-registry:jar:2.2.1:compile
[DEBUG] org.codehaus.plexus:plexus-interpolation:jar:1.11:compile
[DEBUG]
org.codehaus.plexus:plexus-container-default:jar:1.0-alpha-9-stable-1:compile
[DEBUG] junit:junit:jar:4.10:test (scope managed from compile)
(version managed from 3.8.1)
[DEBUG] org.hamcrest:hamcrest-core:jar:1.1:test
[DEBUG] org.apache.maven:maven-model:jar:2.2.1:compile
[DEBUG] org.apache.maven:maven-core:jar:2.2.1:compile
[DEBUG]
org.apache.maven:maven-plugin-parameter-documenter:jar:2.2.1:compile
[DEBUG] org.slf4j:slf4j-jdk14:jar:1.5.6:runtime
[DEBUG] org.slf4j:slf4j-api:jar:1.5.6:runtime
[DEBUG] org.slf4j:jcl-over-slf4j:jar:1.5.6:runtime
[DEBUG]
org.apache.maven.reporting:maven-reporting-api:jar:2.2.1:compile
[DEBUG] org.apache.maven.doxia:doxia-sink-api:jar:1.1:compile
[DEBUG] org.apache.maven.doxia:doxia-logging-api:jar:1.1:compile
[DEBUG] org.apache.maven:maven-repository-metadata:jar:2.2.1:compile
[DEBUG] org.apache.maven:maven-error-diagnostics:jar:2.2.1:compile
[DEBUG] commons-cli:commons-cli:jar:1.2:compile
[DEBUG] org.apache.maven:maven-plugin-descriptor:jar:2.2.1:compile
[DEBUG]
org.codehaus.plexus:plexus-interactivity-api:jar:1.0-alpha-4:compile
[DEBUG] org.apache.maven:maven-monitor:jar:2.2.1:compile
[DEBUG] classworlds:classworlds:jar:1.1:compile
[DEBUG] org.sonatype.plexus:plexus-sec-dispatcher:jar:1.3:compile
[DEBUG] org.sonatype.plexus:plexus-cipher:jar:1.4:compile
[DEBUG] com.googlecode.flyway:flyway-core:jar:2.0.3:compile
[DEBUG] Created new class realm
plugin>com.googlecode.flyway:flyway-maven-plugin:2.0.3
[DEBUG] Importing foreign packages into class realm
plugin>com.googlecode.flyway:flyway-maven-plugin:2.0.3
[DEBUG] Imported: < maven.api
[DEBUG] Populating class realm
plugin>com.googlecode.flyway:flyway-maven-plugin:2.0.3
[DEBUG] Included: com.googlecode.flyway:flyway-maven-plugin:jar:2.0.3
[DEBUG] Included: mysql:mysql-connector-java:jar:5.1.22
[DEBUG] Included: org.codehaus.plexus:plexus-utils:jar:1.5.15
[DEBUG] Included:
backport-util-concurrent:backport-util-concurrent:jar:3.1
[DEBUG] Included: org.codehaus.plexus:plexus-interpolation:jar:1.11
[DEBUG] Included: org.slf4j:slf4j-jdk14:jar:1.5.6
[DEBUG] Included: org.slf4j:slf4j-api:jar:1.5.6
[DEBUG] Included: org.slf4j:jcl-over-slf4j:jar:1.5.6
[DEBUG] Included: org.apache.maven.reporting:maven-reporting-api:jar:2.2.1
[DEBUG] Included: org.apache.maven.doxia:doxia-sink-api:jar:1.1
[DEBUG] Included: org.apache.maven.doxia:doxia-logging-api:jar:1.1
[DEBUG] Included: commons-cli:commons-cli:jar:1.2
[DEBUG] Included:
org.codehaus.plexus:plexus-interactivity-api:jar:1.0-alpha-4
[DEBUG] Included: org.sonatype.plexus:plexus-sec-dispatcher:jar:1.3
[DEBUG] Included: org.sonatype.plexus:plexus-cipher:jar:1.4
[DEBUG] Included: com.googlecode.flyway:flyway-core:jar:2.0.3
[DEBUG] Excluded: org.apache.maven:maven-plugin-api:jar:2.2.1
[DEBUG] Excluded: org.apache.maven:maven-artifact:jar:2.2.1
[DEBUG] Excluded: org.apache.maven:maven-project:jar:2.2.1
[DEBUG] Excluded: org.apache.maven:maven-settings:jar:2.2.1
[DEBUG] Excluded: org.apache.maven:maven-profile:jar:2.2.1
[DEBUG] Excluded: org.apache.maven:maven-artifact-manager:jar:2.2.1
[DEBUG] Excluded: org.apache.maven:maven-plugin-registry:jar:2.2.1
[DEBUG] Excluded:
org.codehaus.plexus:plexus-container-default:jar:1.0-alpha-9-stable-1
[DEBUG] Excluded: junit:junit:jar:4.10
[DEBUG] Excluded: org.hamcrest:hamcrest-core:jar:1.1
[DEBUG] Excluded: org.apache.maven:maven-model:jar:2.2.1
[DEBUG] Excluded: org.apache.maven:maven-core:jar:2.2.1
[DEBUG] Excluded:
org.apache.maven:maven-plugin-parameter-documenter:jar:2.2.1
[DEBUG] Excluded: org.apache.maven:maven-repository-metadata:jar:2.2.1
[DEBUG] Excluded: org.apache.maven:maven-error-diagnostics:jar:2.2.1
[DEBUG] Excluded: org.apache.maven:maven-plugin-descriptor:jar:2.2.1
[DEBUG] Excluded: org.apache.maven:maven-monitor:jar:2.2.1
[DEBUG] Excluded: classworlds:classworlds:jar:1.1
[DEBUG] Configuring mojo
com.googlecode.flyway:flyway-maven-plugin:2.0.3:info from plugin realm
ClassRealm[plugin>com.googlecode.flyway:flyway-maven-plugin:2.0.3, parent:
sun.misc.Launcher$AppClassLoader@69cd2e5f]
[DEBUG] Configuring mojo
'com.googlecode.flyway:flyway-maven-plugin:2.0.3:info' with
include-project-dependencies configurator -->
[DEBUG] (f) driver = com.mysql.jdbc.Driver
[DEBUG] (f) locations = [common]
[DEBUG] (f) mavenProject = MavenProject:
com.atherapy:atherapy-base-pom:1.0.0-BUILD-SNAPSHOT @
/Users/selah/Documents/workspace/parent_repo/Parent/pom.xml
[DEBUG] (f) password = ...
[DEBUG] (f) schemas = [test]
[DEBUG] (f) settings = org.apache.maven.execution.SettingsAdapter@698f352
[DEBUG] (f) url = jdbc:mysql://localhost:3306
[DEBUG] (f) user = dba_user
[DEBUG] -- end configuration --
[DEBUG] Database: MySQL 5.5
[DEBUG] DDL Transactions Supported: false
[DEBUG] Database: MySQL 5.5
[DEBUG] Schema: test
[DEBUG] No metadata table upgrade to the Flyway 2.0 format necessary
[DEBUG] No metadata table upgrade to the Flyway 2.0.2 format necessary
[DEBUG] Spring Jdbc available: false
[DEBUG] Scanning for resources at 'common' (Prefix: 'V', Suffix: '.sql')
[DEBUG] Unable to determine URL for classpath location: common
(ClassLoader:
ClassRealm[plugin>com.googlecode.flyway:flyway-maven-plugin:2.0.3, parent:
sun.misc.Launcher$AppClassLoader@69cd2e5f])
[DEBUG] Scanning for classes at 'common' (Implementing:
'com.googlecode.flyway.core.api.migration.jdbc.JdbcMigration')
[DEBUG] Unable to determine URL for classpath location: common
(ClassLoader:
ClassRealm[plugin>com.googlecode.flyway:flyway-maven-plugin:2.0.3, parent:
sun.misc.Launcher$AppClassLoader@69cd2e5f])
[DEBUG] Scanning for resources at 'db/migration' (Prefix: 'V', Suffix:
'.sql')
[DEBUG] Scanning URL:
file:/Users/selah/Documents/workspace/parent_repo/Parent/target/classes/db/migration
[DEBUG] JBoss VFS v2 available: false
[DEBUG] Scanning starting at classpath root in filesystem:
/Users/selah/Documents/workspace/parent_repo/Parent/target/classes/
[DEBUG] Scanning for resources in path:
/Users/selah/Documents/workspace/parent_repo/Parent/target/classes/db/migration
(classpath location: db/migration)
[DEBUG] Scanning for resources in path:
/Users/selah/Documents/workspace/parent_repo/Parent/target/classes/db/migration/common
(classpath location: db/migration)
[DEBUG] Scanning for resources in path:
/Users/selah/Documents/workspace/parent_repo/Parent/target/classes/db/migration/prod
(classpath location: db/migration)
[DEBUG] Found resource: db/migration/common/V1__common.sql
[DEBUG] Found resource: db/migration/prod/V2__prod.sql
[DEBUG] Scanning for classes at 'db/migration' (Implementing:
'com.googlecode.flyway.core.api.migration.jdbc.JdbcMigration')
[DEBUG] Scanning URL:
file:/Users/selah/Documents/workspace/parent_repo/Parent/target/classes/db/migration
[DEBUG] Scanning starting at classpath root in filesystem:
/Users/selah/Documents/workspace/parent_repo/Parent/target/classes/
[DEBUG] Scanning for resources in path:
/Users/selah/Documents/workspace/parent_repo/Parent/target/classes/db/migration
(classpath location: db/migration)
[DEBUG] Scanning for resources in path:
/Users/selah/Documents/workspace/parent_repo/Parent/target/classes/db/migration/common
(classpath location: db/migration)
[DEBUG] Scanning for resources in path:
/Users/selah/Documents/workspace/parent_repo/Parent/target/classes/db/migration/prod
(classpath location: db/migration)
[DEBUG] Filtering out resource: db/migration/common/V1__common.sql
(filename: V1__common.sql)
[DEBUG] Filtering out resource: db/migration/prod/V2__prod.sql (filename:
V2__prod.sql)
[INFO]
+----------------+----------------------------+---------------------+---------+
| Version | Description | Installed on | State
|
+----------------+----------------------------+---------------------+---------+
| 1 | common | |
Pending |
| 2 | prod | |
Pending |
+----------------+----------------------------+---------------------+---------+
[INFO]
------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO]

[fly...@googlecode.com]

Updates:
Status: Duplicate
Mergedinto: 381

Comment #5 on issue 418 by axel.fontai...@gmail.com: locations

overrides not working correctly
http://code.google.com/p/flyway/issues/detail?id=418

OK, thanks for the details.

You've hit an unfortunate side-effect of a compatibility workaround I kept
in 2.0.

This is fixed in SCM.

You can either
- wait for 2.1
- build from source
- temporarily rename your folders to something that doesn't start with
db/migration. Ex.: db1/migration . They can they be renamed back once the
2.1 release is out.

Sorry for the inconvenience,
Axel