View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002426 | SymmetricDS | Bug | public | 2015-10-27 14:06 | 2019-04-23 20:14 |
| Reporter | lonsiera | Assigned To | josh-a-hicks | ||
| Priority | high | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.7.25 | ||||
| Target Version | 3.10.0 | Fixed in Version | 3.10.0 | ||
| Summary | 0002426: Sym server create Primary Keys for all fields in table without PK | ||||
| Description | This issue happenned on all tables without Primary Keys. For example table with no Primary Keys on MS SQL Server: CREATE TABLE `item`( `item_id` INTEGER NOT NULL, `name` VARCHAR(100) NULL, `description` VARCHAR(1000) NULL, `age` INTEGER, `datebirth` VARCHAR(10) NULL ); If use dbexport we get same table structure # ../bin/dbexport --engine corp-000 --format=sql --compatible=mysql --catalog corp --no-data item > item.sql But if use ../bin/sym, we get this error: [store-001] - JdbcSqlTemplate - Specified key was too long; max key length is 767 bytes. Failed to execute: CREATE TABLE `item`( `item_id` INTEGER NOT NULL, `name` VARCHAR(100) NULL, `description` VARCHAR(1000) NULL, `age` INTEGER, `datebirth` VARCHAR(10) NULL, PRIMARY KEY (`item_id`, `name`, `description`, `age`, `datebirth`) ) | ||||
| Tags | No tags attached. | ||||
| related to | 0003521 | closed | josh-a-hicks | Create Table First is creating table with all columns as primary key instead of none |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2015-10-27 14:06 | lonsiera | New Issue | |
| 2015-10-29 00:37 | chenson | Target Version | => 3.7.26 |
| 2015-10-30 19:01 | chenson | Target Version | 3.7.26 => 3.7.27 |
| 2015-11-17 21:23 | lonsiera | Note Added: 0000730 | |
| 2015-11-17 21:27 | chenson | Target Version | 3.7.27 => 3.7.28 |
| 2015-12-15 16:15 | admin | Target Version | 3.7.28 => 3.7.29 |
| 2019-04-23 20:13 | elong | Relationship added | related to 0003521 |
| 2019-04-23 20:13 | elong | Assigned To | => josh-a-hicks |
| 2019-04-23 20:13 | elong | Status | new => closed |
| 2019-04-23 20:13 | elong | Resolution | open => fixed |
| 2019-04-23 20:13 | elong | Fixed in Version | => 3.10.0 |
| 2019-04-23 20:14 | elong | Target Version | 3.7.29 => |