View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000765 | SymmetricDS | Improvement | public | 2012-08-09 19:45 | 2024-10-07 13:16 |
| Reporter | Assigned To | emiller | |||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Target Version | 3.14.2 | Fixed in Version | 3.14.2 | ||
| Summary | 0000765: Create table DDL and dbexport / dbimport should support generated / calculated / computed / virtual columns | ||||
| Description | An example of the way it current behaves on export: <column name="UPR_LN_CNCT" type="VARCHAR" size="120" default="UPPER("LN_CNCT")"/> An example of how it could detect a generated column: <column name="UPR_LN_CNCT" type="VARCHAR" size="120" generated="true" default="UPPER("LN_CNCT")"/> | ||||
| Tags | dbimport/dbexport, ddl/schema | ||||
|
SymmetricDS: 3.14 729e2e68 2022-09-23 17:47:51 evan-miller-jumpmind Details Diff |
0000765: Added support for generated column ddl for most db platforms |
Affected Issues 0000765 |
|
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/derby/DerbySymmetricDialect.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mariadb/MariaDBSymmetricDialect.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/mysql/MySqlSymmetricDialect.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/oracle/OracleSymmetricDialect.java | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/postgresql/PostgreSqlSymmetricDialect.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/sqlite/SqliteSymmetricDialect.java | Diff File | ||
| add - symmetric-db/src/main/java/org/jumpmind/db/alter/ColumnGeneratedChange.java | Diff File | ||
| add - symmetric-db/src/main/java/org/jumpmind/db/alter/GeneratedColumnDefinitionChange.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/alter/ModelComparator.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/io/DatabaseXmlUtil.java | Diff File | ||
| 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 | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/DatabaseInfo.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/ase/AseDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/derby/DerbyDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/firebird/FirebirdDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/h2/H2DdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/hsqldb2/HsqlDb2DdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/mssql/MsSql2000DdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/postgresql/PostgreSqlDdlBuilder.java | Diff File | ||
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/sqlite/SqliteDdlReader.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/AbstractJdbcDdlReader.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/ase/AseDdlReader.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/derby/DerbyDdlReader.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/firebird/FirebirdDdlReader.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/h2/H2DdlReader.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/hsqldb2/HsqlDb2DdlReader.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mssql/MsSqlDdlReader.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mysql/MySqlDdlReader.java | Diff File | ||
|
SymmetricDS: 3.14 7b509833 2022-09-26 15:52:35 evan-miller-jumpmind Details Diff |
0000765: Fixed some MySQL columns being incorrectly flagged as generated |
Affected Issues 0000765 |
|
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mysql/MySqlDdlReader.java | Diff File | ||
|
SymmetricDS: 3.14 88a15537 2022-09-26 18:12:50 evan-miller-jumpmind Details Diff |
0000765: Added catalog to information_schema.columns query |
Affected Issues 0000765 |
|
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/mysql/MySqlDdlReader.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2012-08-09 19:45 |
|
New Issue | |
| 2012-08-15 14:09 | chenson | Project | SymmetricDS Pro => SymmetricDS |
| 2019-04-12 17:38 | admin | Tag Attached: dbimport/dbexport | |
| 2022-09-23 17:48 | emiller | Assigned To | => emiller |
| 2022-09-23 17:48 | emiller | Status | new => resolved |
| 2022-09-23 17:48 | emiller | Resolution | open => fixed |
| 2022-09-23 17:48 | emiller | Fixed in Version | => 3.14.2 |
| 2022-09-23 18:00 | Changeset attached | => SymmetricDS 3.14 729e2e68 | |
| 2022-09-26 16:00 | Changeset attached | => SymmetricDS 3.14 7b509833 | |
| 2022-09-26 19:00 | Changeset attached | => SymmetricDS 3.14 88a15537 | |
| 2022-10-04 15:15 | admin | Status | resolved => closed |
| 2024-07-11 14:30 | elong | Summary | dbexport / dbimport should support oracle virtual columns => Create table DDL and dbexport / dbimport should support generated / calculated / computed / virtual columns |
| 2024-07-11 14:30 | elong | Description Updated | View Revisions |
| 2024-07-11 14:30 | elong | Tag Attached: ddl/schema | |
| 2024-10-07 13:16 | elong | Relationship added | related to 0006612 |