View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0001546 | SymmetricDS | Bug | public | 2014-01-24 13:43 | 2014-02-05 15:08 |
Reporter | erico | Assigned To | chenson | ||
Priority | normal | ||||
Status | closed | Resolution | fixed | ||
Product Version | 3.5.15 | ||||
Target Version | 3.5.16 | Fixed in Version | 3.5.16 | ||
Summary | 0001546: Table definition does not update correctly (postgresql) | ||||
Description | Changes on size (not type) of column does not reflect on nodes | ||||
Steps To Reproduce | 1. Change data type of some table from numeric(1) to numeric(8) 2. call ./symadmin sync-triggers ... 3. call ./symadmin send-schema --node 001 tablex | ||||
Additional Information | pay attention for: send: <column name="teste" type="NUMERIC" size="8"> but: ALTER COLUMN "teste" TYPE numeric(1,0); log: [loja_001] - DatabaseWriter - About to create table using the following definition: <?xml version="1.0"?> <!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database"> <database name="public"> <table name="produto"> <column name="id" primaryKey="true" required="true" type="VARCHAR" size="8"> <platform-column name="postgres" type="varchar" size="8"/> </column> <column name="nome" type="VARCHAR" size="255"> <platform-column name="postgres" type="varchar" size="255"/> </column> <column name="teste" type="NUMERIC" size="8"> <platform-column name="postgres" type="numeric" size="8"/> </column> </table> </database> [loja_001] - PostgreSqlDatabasePlatform - Running alter sql: ALTER TABLE "produto" ALTER COLUMN "teste" TYPE numeric(1,0); [loja_001] - PullService - Pull data received from matriz:matriz:matriz. 1 rows and 1 batches were processed | ||||
Tags | No tags attached. | ||||
SymmetricDS: master 9968dbc5 2014-01-25 10:42:25 Details Diff |
0001546: Table definition does not update correctly (postgresql) |
Affected Issues 0001546 |
|
mod - symmetric-db/src/main/java/org/jumpmind/db/model/Column.java | Diff File | ||
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDdlBuilder.java | Diff File |
Date Modified | Username | Field | Change |
---|---|---|---|
2014-01-24 13:43 | erico | New Issue | |
2014-01-25 15:40 | chenson | Assigned To | => chenson |
2014-01-25 15:40 | chenson | Status | new => assigned |
2014-01-25 15:40 | chenson | Fixed in Version | => 3.5.16 |
2014-01-25 15:40 | chenson | Target Version | => 3.5.16 |
2014-01-25 15:42 | chenson | Status | assigned => resolved |
2014-01-25 15:42 | chenson | Resolution | open => fixed |
2014-02-03 01:53 | Changeset attached | => SymmetricDS trunk r7891 | |
2014-02-05 15:08 | chenson | Status | resolved => closed |
2015-07-31 01:49 | chenson | Changeset attached | => SymmetricDS master 9968dbc5 |