View Issue Details

IDProjectCategoryView StatusLast Update
0006276SymmetricDSBugpublic2024-06-19 17:26
Reporteroks Assigned Tomdrouard  
Prioritynormal 
Status assignedResolutionopen 
Product Version3.15.3 
Summary0006276: SQLite index name is not quoted
DescriptionWhen 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 ReproduceCreate an index named "A+B" and run bin/sym.
Tagsdialect: sqlite

Activities

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.

Issue History

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