View Issue Details

IDProjectCategoryView StatusLast Update
0003868SymmetricDSBugpublic2019-01-30 07:22
ReportergislikAssigned To 
Prioritylow 
Status newResolutionopen 
Product Version3.9.16 
Target VersionFixed in Version 
Summary0003868: SymmetricDS fails to create SQLITE3 tables on initial load if table name conflicts with reserved SQL keywords.
DescriptionAfter triggering the creation of a SQLITE3 table (with table name "limit") on the target side SymmetricDB throws the following errors:

[SQLITE_ERROR] SQL error or missing database (near "limit": syntax error)

and

org.jumpmind.db.sql.SqlException: Failed to execute sql: pragma table_info(limit)

Steps To ReproduceCreate the following SQLITE3 table on the source:

CREATE TABLE IF NOT EXISTS "limit" (
   "id" varchar(36),
   "created_at" datetime,
   "updated_at" datetime,
   "deleted_at" datetime,
   "kind" varchar(255) NOT NULL,
   "volume" real,
   "set_by" varchar(36) ,
   PRIMARY KEY ("id")
);

And try to sync to a target.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2019-01-30 07:22 gislik New Issue