View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005834 | SymmetricDS | Bug | public | 2023-05-16 15:08 | 2023-10-03 23:00 |
| Reporter | JishLong | Assigned To | JishLong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.14.0 | ||||
| Target Version | 3.14.8 | Fixed in Version | 3.14.8 | ||
| Summary | 0005834: Unnamed constraint causes alter table error | ||||
| Description | Tried sending an initial load from a sqlite source to a sqlite target, the table was created successfully (without constraints) and the data was loaded successfully, but an error arises when the constraints get added afterwards - constraint was named "null" in the XML and the SQL tried to use "null" as a constraint name | ||||
| Steps To Reproduce | if you change the "null" for the foreign key's name to an empty string, the issue gets resolved "<?xml version=\"1.0\"?> <!DOCTYPE database SYSTEM \"http://db.apache.org/torque/dtd/database\"> <database name=\"dataextractor\"> <table name=\"MediaInstance\"> <column name=\"CallNumber\" primaryKey=\"true\" primaryKeySeq=\"0\" required=\"true\" type=\"VARCHAR\"/> <column name=\"Digital/Physical\" required=\"true\" type=\"VARCHAR\"/> <column name=\"IsAvailable\" required=\"true\" type=\"VARCHAR\"/> <column name=\"Location\" required=\"true\" type=\"VARCHAR\"/> <column name=\"MediaID\" required=\"true\" type=\"VARCHAR\"/> <foreign-key name=\"null\" foreignTable=\"Media\" foreignTableCatalog=\"\" foreignTableSchema=\"\"> <reference local=\"MediaID\" foreign=\"MediaID\"/> </foreign-key> </table> </database>" | ||||
| Tags | ddl/schema, dialect: sqlite | ||||
|
SymmetricDS: 3.14 84a1a957 2023-05-16 15:17:41 Details Diff |
0005834: Unnamed constraint causes alter table error |
Affected Issues 0005834 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/io/DatabaseXmlUtil.java | Diff File | ||
|
SymmetricDS: 3.15 a02a5afe 2023-05-16 15:17:41 Details Diff |
0005834: Unnamed constraint causes alter table error |
Affected Issues 0005834 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/io/DatabaseXmlUtil.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2023-05-16 15:08 | JishLong | New Issue | |
| 2023-05-16 15:08 | JishLong | Status | new => assigned |
| 2023-05-16 15:08 | JishLong | Assigned To | => JishLong |
| 2023-05-16 15:08 | JishLong | Tag Attached: ddl/schema | |
| 2023-05-16 15:08 | JishLong | Tag Attached: dialect: sqlite | |
| 2023-05-16 15:08 | JishLong | File Added: image.png | |
| 2023-05-16 15:19 | JishLong | Status | assigned => resolved |
| 2023-05-16 15:19 | JishLong | Resolution | open => fixed |
| 2023-05-16 15:19 | JishLong | Fixed in Version | => 3.14.8 |
| 2023-05-16 16:00 | JishLong | Changeset attached | => SymmetricDS 3.14 84a1a957 |
| 2023-07-19 12:58 | admin | Status | resolved => closed |
| 2023-10-03 23:00 | JishLong | Changeset attached | => SymmetricDS 3.15 a02a5afe |