View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004298 | SymmetricDS | Bug | public | 2020-03-04 11:52 | 2022-07-27 18:59 |
| Reporter | matej.vehar@easy.bi | Assigned To | elong | ||
| Priority | high | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.11.5 | ||||
| Target Version | 3.14.0 | Fixed in Version | 3.14.0 | ||
| Summary | 0004298: Sycing schemas from MSSQL with column type CHAR(400) to MySQL fails | ||||
| Description | MSSQL has max lenght of CHAR type = 8000, but MySQL/MariaDB has max lenght of CHAR type = 255. I would suggest mapping on MySQL side to VARCHAR(X) e.g. MSSQL has column CHAR(X) MySQL mapps to column VARCHAR(X) If possible this conversion can be done only if X (length) exceeds 255. | ||||
| Steps To Reproduce | Create MSSQL table with column of type CHAR(400) and perform initial load/schame sync to MySQL database | ||||
| Tags | ddl/schema | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-03-04 11:52 | matej.vehar@easy.bi | New Issue | |
| 2020-03-04 13:08 | elong | Project | SymmetricDS Pro => SymmetricDS |
| 2020-03-04 13:09 | elong | Tag Attached: ddl/schema | |
| 2022-05-27 16:18 | elong | Relationship added | related to 0003963 |
| 2022-05-27 16:18 | elong | Assigned To | => elong |
| 2022-05-27 16:18 | elong | Status | new => resolved |
| 2022-05-27 16:18 | elong | Resolution | open => fixed |
| 2022-05-27 16:18 | elong | Fixed in Version | => 3.14.0 |
| 2022-05-27 16:18 | elong | Target Version | => 3.14.0 |
| 2022-07-27 18:59 | admin | Status | resolved => closed |