quoting error in table creation

Description

– 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

Environment

sql server,

Activity

Show:

Nathan Voxland July 27, 2015 at 6:18 PM

Fixed in 3.4.1

Fixed

Details

Reporter

Fix versions

Affects versions

Priority

Created July 13, 2015 at 5:35 AM
Updated July 27, 2015 at 6:18 PM
Resolved July 27, 2015 at 6:18 PM