View Issue Details

Related ChangesetsJump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0005835SymmetricDSBugpublic2023-05-16 15:322023-10-03 23:00
ReporterJishLong Assigned ToJishLong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.14.0 
Target Version3.15.0Fixed in Version3.15.0 
Summary0005835: column name containing a "/" causes error
Descriptionusing a "/" in a column name with a sqlite database causes a SQL syntax error when putting triggers on table
Steps To ReproduceUsing the following SQL statement will reproduce the error when adding tables for capturing:

CREATE TABLE Audio (
AudioID CHAR(9) NOT NULL,
[Album/Audiobook] CHAR(1) NOT NULL
CHECK ([Album/Audiobook] = 'a' OR [Album/Audiobook] = 'b'),
PRIMARY KEY (AudioID),
FOREIGN KEY (AudioID) REFERENCES Media(MediaID)
ON DELETE CASCADE
);
Tagsdialect: sqlite, trigger

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.15 b7f9175d

2023-05-16 15:39:18

JishLong

Details Diff 		0005835: column name containing a "/" causes error Affected Issues
0005835
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/sqlite/SqliteTriggerTemplate.java Diff File

Issue History

Date Modified Username Field Change
2023-05-16 15:32 JishLong New Issue
2023-05-16 15:32 JishLong Status new => assigned
2023-05-16 15:32 JishLong Assigned To => JishLong
2023-05-16 15:32 JishLong Tag Attached: dialect: sqlite
2023-05-16 15:32 JishLong Tag Attached: trigger
2023-05-16 15:33 JishLong Status assigned => resolved
2023-05-16 15:33 JishLong Resolution open => fixed
2023-05-16 15:33 JishLong Fixed in Version => 3.15.0
2023-10-01 23:46 admin Status resolved => closed
2023-10-03 23:00 JishLong Changeset attached => SymmetricDS 3.15 b7f9175d