View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0006276 | SymmetricDS | Bug | public | 2024-03-06 11:31 | 2024-03-06 18:34 |
Reporter | oks | Assigned To | |||
Priority | normal | ||||
Status | acknowledged | 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 | ||||