View Issue Details

IDProjectCategoryView StatusLast Update
0006310SymmetricDSBugpublic2024-03-19 15:24
Reporterelong Assigned Toelong  
Prioritynormal 
Status resolvedResolutionfixed 
Product Version3.15.0 
Target Version3.15.5Fixed in Version3.15.5 
Summary0006310: Sybase ASE 12 can only quote column names 28 characters or less
DescriptionSybase 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)
Tagsdialect: sybase

Activities

There are no notes attached to this issue.

Issue History

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