0006276: SQLite index name is not quoted - SymmetricDS

ID	Project	Category	View Status	Date Submitted	Last Update

0006276	SymmetricDS	Bug	public	2024-03-06 11:31	2024-06-19 17:26

Reporter	oks	Assigned To	mdrouard
Priority	normal
Status	assigned	Resolution	open
Product Version	3.15.3

Summary	0006276: SQLite index name is not quoted
Description	When using an index with a name containing a symbol like '+', an exception is thrown: Caused by: org.jumpmind.db.sql.SqlException: Failed to execute sql: pragma index_info(A+B) Caused by: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (near "+": syntax error) It seems that the problem is in SqliteDdlReader.java: Original: "pragma index_info(" + index.getName() + ")" Possible fix: "pragma index_info(" + quote(index.getName()) + ")"
Steps To Reproduce	Create an index named "A+B" and run bin/sym.
Tags	dialect: sqlite

Date Modified	Username	Field	Change
2024-03-06 11:31	oks	New Issue
2024-03-06 11:31	oks	Tag Attached: dialect: sqlite
2024-03-06 18:34	jvanmeter	Status	new => acknowledged
2024-03-06 18:34	jvanmeter	Note Added: 0002418
2024-06-19 17:26	emiller	Assigned To	=> mdrouard
2024-06-19 17:26	emiller	Status	acknowledged => assigned

jvanmeter 2024-03-06 18:34 developer ~0002418	This looks like a valid issue and will be addressed. As a work around you could avoid putting special characters in the index name for the time being.