View Issue Details

IDProjectCategoryView StatusLast Update
0005834SymmetricDSBugpublic2023-05-16 16:00
ReporterJishLong Assigned ToJishLong  
Status resolvedResolutionfixed 
Product Version3.14.0 
Target Version3.14.8Fixed in Version3.14.8 
Summary0005834: Unnamed constraint causes alter table error
DescriptionTried 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 Reproduceif 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 \"\">
<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\"/>
Tagsddl/schema, dialect: sqlite



2023-05-16 15:08


image.png (786 bytes)   
image.png (786 bytes)   

Related Changesets

SymmetricDS: 3.14 84a1a957

2023-05-16 15:17:41


Details Diff
0005834: Unnamed constraint causes alter table error Affected Issues
mod - symmetric-db/src/main/java/org/jumpmind/db/io/ Diff File

Issue History

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