View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005313 | SymmetricDS | Bug | public | 2022-05-27 15:10 | 2022-06-06 12:37 |
| Reporter | emiller | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.8.0 | ||||
| Target Version | 3.13.5 | Fixed in Version | 3.13.5 | ||
| Summary | 0005313: Null default values become string values when replicating tables from Oracle to MariaDB | ||||
| Description | When replicating tables from Oracle to MariaDB, default values that are set to (null) in the Oracle database show up as '(null)' string values in the MariaDB database. | ||||
| Steps To Reproduce | Oracle: create table mytest (id integer primary key, name varchar(30) default (null)); Replicate table to MySQL create table mytest (id integer primary key, name varchar(30) default '(null)'); <database xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" name="dbexport" encoding="UTF-8"> <table name="MYNULLTEST"> <column name="ID" primaryKey="true" primaryKeySeq="1" required="true" type="NUMERIC" size="38"> <platform-column name="oracle" type="NUMBER" size="38"/> </column> <column name="NAME" type="VARCHAR" size="30" default="(null)"> <platform-column name="oracle" type="VARCHAR2" size="30" default="(null)"/> </column> </table> </database> CREATE TABLE MYNULLTEST( ID NUMBER(38,0) NOT NULL, NAME VARCHAR2(30) DEFAULT 'null' ); ALTER TABLE MYNULLTEST ADD CONSTRAINT MYNULLTEST_PK PRIMARY KEY (ID); | ||||
| Tags | ddl/schema | ||||
|
SymmetricDS: 3.13 735214ff 2022-05-31 12:39:59 Details Diff |
0005313: detect null default value on Oracle |
Affected Issues 0005313 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDdlBuilder.java | Diff File | ||
|
SymmetricDS: 3.14 39e8293e 2022-05-31 12:39:59 Details Diff |
0005313: detect null default value on Oracle |
Affected Issues 0005313 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDdlBuilder.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2022-05-27 15:10 | emiller | New Issue | |
| 2022-05-27 15:10 | emiller | Tag Attached: ddl/schema | |
| 2022-05-27 20:29 | elong | Assigned To | => elong |
| 2022-05-27 20:29 | elong | Status | new => assigned |
| 2022-05-27 20:29 | elong | Product Version | 3.13.0 => 3.8.0 |
| 2022-05-27 20:29 | elong | Steps to Reproduce Updated | View Revisions |
| 2022-05-31 12:41 | elong | Status | assigned => resolved |
| 2022-05-31 12:41 | elong | Resolution | open => fixed |
| 2022-05-31 12:41 | elong | Fixed in Version | => 3.13.5 |
| 2022-05-31 13:00 | admin | Changeset attached | => SymmetricDS 3.13 735214ff |
| 2022-05-31 13:00 | admin | Changeset attached | => SymmetricDS 3.14 39e8293e |
| 2022-06-06 12:37 | admin | Status | resolved => closed |