View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006310 | SymmetricDS | Bug | public | 2024-03-19 15:23 | 2024-04-19 15:46 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.15.0 | ||||
| Target Version | 3.15.5 | Fixed in Version | 3.15.5 | ||
| Summary | 0006310: Sybase ASE 12 can only quote column names 28 characters or less | ||||
| Description | Sybase ASE 12 and earlier is limited to 30 character names for columns. If a column name is quoted, then it can only be 28 characters long. Therefore, column names should only be quoted if they are 28 characters or less. During any operation that reads the table definition, like running sync triggers, it will try to query the auto increment status of columns on the table, which results in a query error. [AseDdlReader] Failed to determine auto increment columns using this query: 'SELECT t."the_social_media_profile_nam" FROM mytest t WHERE 1 = 0'. This is probably not harmful, but should be fixed. java.sql.SQLException: The identifier that starts with '"pro_social_media_profile_nam' is too long. Maximum length is 28. at com.sybase.jdbc4.jdbc.SybConnection.getAllExceptions(SybConnection.java:2780) at com.sybase.jdbc4.jdbc.SybStatement.handleSQLE(SybStatement.java:2665) at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:295) at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:272) at com.sybase.jdbc4.jdbc.SybStatement.queryLoop(SybStatement.java:2409) at com.sybase.jdbc4.jdbc.SybStatement.executeQuery(SybStatement.java:2395) at com.sybase.jdbc4.jdbc.SybStatement.executeQuery(SybStatement.java:553) at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:329) at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:329) at org.jumpmind.db.platform.AbstractJdbcDdlReader.determineAutoIncrementFromResultSetMetaData(AbstractJdbcDdlReader.java:1348) at org.jumpmind.db.platform.AbstractJdbcDdlReader.determineAutoIncrementFromResultSetMetaData(AbstractJdbcDdlReader.java:1302) | ||||
| Tags | dialect: sybase | ||||
|
SymmetricDS: 3.15 6ce4a7c6 2024-03-19 15:24:36 Details Diff |
0006310: Sybase ASE 12 can only quote column names 28 characters or less |
Affected Issues 0006310 |
|
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/ase/AseDatabasePlatform.java | Diff File | ||
| mod - symmetric-jdbc/src/main/java/org/jumpmind/db/platform/ase/AseDdlReader.java | Diff File | ||
|
SymmetricDS: 3.15 182b0736 2024-04-03 13:21:18 Details Diff |
0006310: Sybase ASE 12 can only quote column names 28 characters or less |
Affected Issues 0006310 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractTriggerTemplate.java | Diff File | ||
|
SymmetricDS: 3.15 00559221 2024-04-05 20:05:05 Details Diff |
0006310: Sybase ASE 12 can only quote column names 28 characters or less |
Affected Issues 0006310 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/db/AbstractTriggerTemplate.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2024-03-19 15:23 | elong | New Issue | |
| 2024-03-19 15:23 | elong | Status | new => assigned |
| 2024-03-19 15:23 | elong | Assigned To | => elong |
| 2024-03-19 15:23 | elong | Tag Attached: dialect: sybase | |
| 2024-03-19 15:24 | elong | Status | assigned => resolved |
| 2024-03-19 15:24 | elong | Resolution | open => fixed |
| 2024-03-19 15:24 | elong | Fixed in Version | => 3.15.5 |
| 2024-04-19 15:46 | admin | Changeset attached | => SymmetricDS 3.15 00559221 |
| 2024-04-19 15:46 | admin | Changeset attached | => SymmetricDS 3.15 182b0736 |
| 2024-04-19 15:46 | admin | Changeset attached | => SymmetricDS 3.15 6ce4a7c6 |
| 2024-04-23 16:58 | admin | Status | resolved => closed |