View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006078 | SymmetricDS Pro | Bug | public | 2023-11-01 14:47 | 2023-11-01 16:00 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.15.0 | ||||
| Target Version | 3.15.1 | Fixed in Version | 3.15.1 | ||
| Summary | 0006078: db.init.sql parsing needs to allow values to contain semicolons, specified as 2 semicolons in the value | ||||
| Description | db.init.sql=SET TEMPORARY OPTION CONNECTION_AUTHENTICATION='Company=<value>;Application=<value>;Signature=<value>';SET SECOND OPTION Two statements, delimited by a semicolon: SET TEMPORARY OPTION CONNECTION_AUTHENTICATION='Company=<value>;Application=<value>;Signature=<value>' SET SECOND OPTION But in order for the single semicolons in the value portion of the statement to not be removed, we need to allow them to be specified as 2 semicolons: db.init.sql=SET TEMPORARY OPTION CONNECTION_AUTHENTICATION='Company=<value>;;Application=<value>;;Signature=<value>';SET SECOND OPTION Notice 2 semicolons in the value portion of the first statement. This will allow us to change the parsing to allow us to keep the double semicolons, replacing them with single semicolons in the value Need to also document this. | ||||
| Steps To Reproduce | 1. Set db.init.sql with a value that contains single semicolons: db.init.sql=SET TEMPORARY OPTION CONNECTION_AUTHENTICATION='Company=<value>;Application=<value>;Signature=<value>'; 2. The list of commands will be parsed into the following list and sent to the database server, causing syntax problems: SET TEMPORARY OPTION CONNECTION_AUTHENTICATION='Company=<value> Application=<value> Signature=<value> | ||||
| Tags | configuration | ||||
|
SymmetricDS: 3.15 a84b2690 2023-11-01 15:32:27 Details Diff |
0006078: db.init.sql parsing needs to allow values to contain semicolons, specified as 2 semicolons in the value |
Affected Issues 0006078 |
|
| mod - symmetric-core/src/main/resources/symmetric-default.properties | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/util/BasicDataSourceFactory.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2023-11-01 14:47 | pmarzullo | New Issue | |
| 2023-11-01 14:47 | pmarzullo | Status | new => assigned |
| 2023-11-01 14:47 | pmarzullo | Assigned To | => pmarzullo |
| 2023-11-01 14:47 | pmarzullo | Tag Attached: configuration | |
| 2023-11-01 15:42 | pmarzullo | Status | assigned => resolved |
| 2023-11-01 15:42 | pmarzullo | Resolution | open => fixed |
| 2023-11-01 15:42 | pmarzullo | Fixed in Version | => 3.15.1 |
| 2023-11-01 15:42 | pmarzullo | Note Added: 0002394 | |
| 2023-11-01 16:00 | pmarzullo | Changeset attached | => SymmetricDS 3.15 a84b2690 |
| 2023-11-14 21:10 | admin | Status | resolved => closed |