Skip to:
– create table statement generated by generateChangeLog{{ <changeSet author="hilland (generated)" id="1436508812562-111"><createTable tableName="FactCountries"><column name="ISO2" type="VARCHAR(2)"><constraints nullable="false"/></column><column name="ISO3" type="VARCHAR(3)"><constraints nullable="false"/></column><column name="ISO-Numeric" type="SMALLINT"><constraints nullable="false"/></column><column name="fips" type="VARCHAR(2)"/><column name="Country" type="VARCHAR(100)"/><column name="Capital" type="VARCHAR(100)"/><column name="Area(in sq km)" type="INT"/><column name="Population" type="INT"/><column name="Continent" type="VARCHAR(2)"/><column name="tld" type="VARCHAR(6)"/><column name="CurrencyCode" type="VARCHAR(3)"/><column name="CurrencyName" type="VARCHAR(40)"/><column name="Phone" type="VARCHAR(32)"/><column name="Postal Code Format" type="VARCHAR(200)"/><column name="Postal Code Regex" type="VARCHAR(250)"/><column name="Languages" type="VARCHAR(200)"/><column name="geonameid" type="INT"/><column name="neighbours" type="VARCHAR(200)"/><column name="EquivalentFipsCode" type="VARCHAR(2)"/><column name="bestName" type="VARCHAR(200)"/></createTable></changeSet>}}
generates (note invalid syntax, no brackets around [Area(in sq km)] ! ):
{{-- Changeset changesets/02-tables/FactCountries.xml::FactCountries::hillandCREATE TABLE [FactCountries] ([ISO2] VARCHAR(2) NOT NULL, [ISO3] VARCHAR(3) NOT NULL, [ISO-Numeric] SMALLINT NOT NULL, [fips] VARCHAR(2), [Country] VARCHAR(100), [Capital] VARCHAR(100), Area(in sq km) INT, [Population] INT, [Continent] VARCHAR(2), [tld] VARCHAR(6), [CurrencyCode] VARCHAR(3), [CurrencyName] VARCHAR(40), [Phone] VARCHAR(32), [Postal Code Format] VARCHAR(200), [Postal Code Regex] VARCHAR(250), [Languages] VARCHAR(200), [geonameid] INT, [neighbours] VARCHAR(200), [EquivalentFipsCode] VARCHAR(2), [bestName] VARCHAR(200))GO}}
--------- edit: second example is a different bug ... moved to new jira
sql server,
Fixed in 3.4.1
– create table statement generated by generateChangeLog
{{ <changeSet author="hilland (generated)" id="1436508812562-111">
<createTable tableName="FactCountries">
<column name="ISO2" type="VARCHAR(2)">
<constraints nullable="false"/>
</column>
<column name="ISO3" type="VARCHAR(3)">
<constraints nullable="false"/>
</column>
<column name="ISO-Numeric" type="SMALLINT">
<constraints nullable="false"/>
</column>
<column name="fips" type="VARCHAR(2)"/>
<column name="Country" type="VARCHAR(100)"/>
<column name="Capital" type="VARCHAR(100)"/>
<column name="Area(in sq km)" type="INT"/>
<column name="Population" type="INT"/>
<column name="Continent" type="VARCHAR(2)"/>
<column name="tld" type="VARCHAR(6)"/>
<column name="CurrencyCode" type="VARCHAR(3)"/>
<column name="CurrencyName" type="VARCHAR(40)"/>
<column name="Phone" type="VARCHAR(32)"/>
<column name="Postal Code Format" type="VARCHAR(200)"/>
<column name="Postal Code Regex" type="VARCHAR(250)"/>
<column name="Languages" type="VARCHAR(200)"/>
<column name="geonameid" type="INT"/>
<column name="neighbours" type="VARCHAR(200)"/>
<column name="EquivalentFipsCode" type="VARCHAR(2)"/>
<column name="bestName" type="VARCHAR(200)"/>
</createTable>
</changeSet>}}
generates (note invalid syntax, no brackets around [Area(in sq km)] ! ):
{{-- Changeset changesets/02-tables/FactCountries.xml::FactCountries::hilland
CREATE TABLE [FactCountries] ([ISO2] VARCHAR(2) NOT NULL, [ISO3] VARCHAR(3) NOT NULL, [ISO-Numeric] SMALLINT NOT NULL, [fips] VARCHAR(2), [Country] VARCHAR(100), [Capital] VARCHAR(100), Area(in sq km) INT, [Population] INT, [Continent] VARCHAR(2), [tld] VARCHAR(6), [CurrencyCode] VARCHAR(3), [CurrencyName] VARCHAR(40), [Phone] VARCHAR(32), [Postal Code Format] VARCHAR(200), [Postal Code Regex] VARCHAR(250), [Languages] VARCHAR(200), [geonameid] INT, [neighbours] VARCHAR(200), [EquivalentFipsCode] VARCHAR(2), [bestName] VARCHAR(200))
GO}}
---------
edit: second example is a different bug ... moved to new jira