LoadUpdateData with value=NUMERIC quoting values

Description

created a regression when inserting using type="NUMERIC". The generated insert statement is now quoting numeric values (e.g. inserting 0/1 into a bit column):

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 <createTable tableName="CurrencySettlementDetail"> <column name="currency" type="varchar(255)"> <constraints nullable="false" primaryKey="true" primaryKeyName="CurrencySettlPK"/> </column> <column name="businessDays" type="varchar(255)"/> <column name="ignorePreSettlementHolidays" type="bit"/> <column name="crossCurrency" type="varchar(255)"/> <column name="rollTimeZoneId" type="varchar(255)"/> <column name="rollHour" type="integer"/> <column name="daysToSettlement" type="integer"/> </createTable> <changeSet id="201310240001" runOnChange="true"> <loadUpdateData tableName="CurrencySettlementDetail" file="migrations/settlementcalendar2.csv" primaryKey="currency"> <column header="currency" type="STRING"/> <column header="businessDays" type="STRING"/> <column header="ignorePreSettlementHolidays" type="NUMERIC"/> <column header="crossCurrency" type="STRING"/> <column header="rollTimeZoneId" type="STRING"/> <column header="rollHour" type="NUMERIC"/> <column header="daysToSettlement" type="NUMERIC"/> </loadUpdateData> </changeSet>

Example CSV:

1 2 3 currency,businessDays,ignorePreSettlementHolidays,crossCurrency,rollTimeZoneId,rollHour,daysToSettlement AED,YYYYYNN,0,USD,America/New_York,17,2 ARS,YYYYYNN,1,USD,America/New_York,17,2

Environment

All

Status

Assignee

Unassigned

Reporter

Nathan Voxland

Labels

None

Fix versions

Affects versions

3.3.0

Priority

Major