View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006812 | SymmetricDS | Bug | public | 2025-04-09 17:10 | 2025-04-09 17:38 |
| Reporter | pbelov | Assigned To | |||
| Priority | normal | ||||
| Status | acknowledged | Resolution | open | ||
| Product Version | 3.16.0 | ||||
| Summary | 0006812: incorrect mapping from of NUMBER in Oracle to decimal(10,0) in MySQL | ||||
| Description | When sending tables from an Oracle database to a MySQL/Mariadb database during a reload, SymmetricDS crashes. The column TCX02_PRIOR is defined as NUMBER on Oracle. The column TCX02_PRIOR is created as decimal(10,0) on MySQL - incorrectly. | ||||
| Steps To Reproduce | CREATE TABLE T_CX02" ( "TCX02_TIPORIC" CHAR(4) NOT NULL ENABLE, "TCX02_RIC" CHAR(2) NOT NULL ENABLE, "TCX02_PRIOR" NUMBER NOT NULL ENABLE, "TCX02_CMPLIST" NUMBER(2,0), "TCX02_CMPRIG" NUMBER(2,0), "TCX02_FCONF" CHAR(1) NOT NULL ENABLE, "TCX02_FLAV" CHAR(1) NOT NULL ENABLE, "TCX02_OPZIONI" CHAR(10) Symmetricds created on the fly this table on mariadb CREATE TABLE t_cx02 ( tcx02_tiporic char(4) NOT NULL, tcx02_ric char(2) NOT NULL, tcx02_prior decimal(10,0) NOT NULL, tcx02_cmplist decimal(2,0) DEFAULT NULL, tcx02_cmprig decimal(2,0) DEFAULT NULL, tcx02_fconf char(1) NOT NULL, tcx02_flav char(1) NOT NULL, tcx02_opzioni char(10) DEFAULT NULL, PRIMARY KEY (tcx02_tiporic,tcx02_ric,tcx02_prior) ) | ||||
| Tags | ddl/schema, dialect: mysql/mariadb | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2025-04-09 17:10 | pbelov | New Issue | |
| 2025-04-09 17:14 | pbelov | Status | new => acknowledged |
| 2025-04-09 17:14 | pbelov | Description Updated | View Revisions |
| 2025-04-09 17:14 | pbelov | Steps to Reproduce Updated | View Revisions |
| 2025-04-09 17:38 | pbelov | Tag Attached: dialect: mysql/mariadb | |
| 2025-04-09 17:38 | pbelov | Tag Attached: ddl/schema |